![]()
Code
public static int UpdateOrInsert()
{
string strSQL=" insert into user_age (id,name,age) values('030','wang',24)";//要执行的insert或者Update语句
string strConnectionString="Data Source=10.0.3.25;Initial Catalog=user;User ID=sa;Password=123456";//数据库连接
int i = 0;
using (SqlConnection MySqlConn = new SqlConnection(strConnectionString))
{
MySqlConn.Open(); //打开数据库
try
{
SqlCommand com = new SqlCommand(strSQL, MySqlConn);
i = com.ExecuteNonQuery(); //执行操作
}
catch (Exception ex)
{
throw ex;
}
}
return i;
}