如何使用C#将插入查询写入windows表单应用程序
问题描述:
private void button2_Click(object sender, EventArgs e)
{
string con = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Ravi\Documents\OnlineBanking.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
SqlConnection conn = new SqlConnection(con);
conn.Open();
SqlCommand chk = new SqlCommand("Insert into Registration(Name)values(@Name)",conn);
chk.Parameters.AddWithValue("@Name", textBox1.Text);
chk.ExecuteNonQuery();
MessageBox.Show("Account created successfully!!!");
}
我的尝试:
我无法将值插入数据库.. plz纠正我的错误。
What I have tried:
I am unable to insert value into database.. plz rectify my error.
答
您好,试试这个代码
Hello, Try this code
private void button2_Click(object sender, EventArgs e)
{
string con = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Ravi\Documents\OnlineBanking.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
SqlConnection conn = new SqlConnection(con);
SqlCommand chk = new SqlCommand("Insert into Registration(Name)values(@Name)",conn);
chk .CommandType = CommandType.Text;
chk .CommandText = sqlQuery;
chk .Parameters.Add("@Name", textBox1.Text);
chk .Open();
chk .ExecuteNonQuery();
chk .Close();
MessageBox.Show("Account created successfully!!!");
}