我将从cls1
插入任何数据到SQL Server (Nvarchar(50)
列)。这里显示的代码是来自我的项目
请帮帮我
感谢class Cls1
{
public static string projectid;
public static string projectname;
}
using (SqlCommand cmdInsert = con.CreateCommand())
{
cmdInsert.CommandType = CommandType.Text;
cmdInsert.CommandText = string.Format(@"INSERT INTO total(projectid)" +
"values(@projectid)");
cmdInsert.Parameters.AddWithValue("@projectid", (ClsPQR1. projectid));
}
您需要执行以下命令:
using (SqlCommand cmdInsert = con.CreateCommand())
{
cmdInsert.CommandType = CommandType.Text;
cmdInsert.CommandText = string.Format(@"INSERT INTO total(projectid)" +
"values(@projectid)");
cmdInsert.Parameters.AddWithValue("@projectid", (ClsPQR1. projectid));
cmdInsert.ExecuteNonQuery();
}
关于SqlCommand的更多信息。ExecuteNonQuery