7,765
社区成员
发帖
与我相关
我的任务
分享
static void Main()
{
string connectionString = "Data Source=192.168.20.14;Initial Catalog=YHTEST;User ID=sa;Password=lingan";
// Provide the query string with a parameter placeholder.
string queryString = "SELECT * from dbo.Table1 ";
// Specify the parameter value.
int i = 10;
string s1 = "Amy", s2 = "female";
using (SqlConnection connection = new SqlConnection(connectionString))
{
// Create the Command and Parameter objects.
SqlCommand command = new SqlCommand(queryString, connection);
try
{
connection.Open();
Console.WriteLine("Hello World");
SqlCommand sqlcom = new SqlCommand("insert into info(id,name,sex) values(" + i + "," + s1 + "," + s2 + ")");
sqlcom.ExecuteNonQuery();
// MessageBox.Show("添加成功!", "啊");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
Console.ReadLine();
}
}
提示说sqlcom.ExecuteNonQuery()没有初始化