c#新增一条数据记录代码怎么写

我用的是.Net2003,SQL server请知道的写下代码谢谢
2025-03-02 14:22:49
推荐回答(2个)
回答1:

string strSqlCommand = string.Format("Insert into Users(UserID,Name,Age) values ('{0}','{1}','{2}')",Guid.NewGuid().ToString(),"张三","27")
SqlConnection v_SqlConnection = new SqlConnection("server=Jebel;database=TestDB;uid=sa;pwd=sa");
v_SqlConnection.Open();
SqlCommand v_SqlCommand = new SqlCommand(strSqlCommand,v_SqlConnection);

try
{
v_SqlCommand.ExecuteNonQuery();

}
catch(SqlException se)
{
MessageBox.Show(se.Message);
}
finally
{
v_SqlConnection.Close();
}

回答2:

insert into 表名 (字段1,字段2,.....) values (值1,值2,......)