如何使用c＃在按钮单击时将数据更新到数据库？ [英] How to update data to the database on button click using c#?

问题描述

大家好



我必须通过按下按钮来更新数据网格视图中显示的两个不同表格中的所有行。当我在下面尝试我的查询时，我收到一条错误消息，暗示语法不正确=



这是我的代码，我希望有人可以帮助我。谢谢提前。

Hi guys

I have to update all the rows from two different table that was displayed in my datagridview by pressing the button. When i tried my query below, I got an error message implying "Incorrect syntax near "="

Here is my code and I hope anyone can help me. Thanks in advance.

  private void button2_Click(object sender, EventArgs e)
        {
            conn = new SqlConnection(connec.GetServer());
            conn.Open();
            string questas = "SELECT  TOP 50 Percent * from tblStudentInformation Where GradeLevel ='" + label2.Text + "' and Result >= 85  and SectionName IS NULL";
            SqlCommand dc = new SqlCommand(questas,conn);
            SqlDataReader sq = dc.ExecuteReader();
            sq.Close();
            
            string que = "UPATE tblStudentInformation SET SectionName=@sect, ShiftSched=@sched Where GradeLevel=@lb2 AND Result >= 85  AND SectionName IS NULL";
            SqlCommand disc = new SqlCommand(que, conn);
            disc.Parameters.AddWithValue("@lb2",label2.Text);
            disc.Parameters.AddWithValue("@sect", textBox1.Text);
            disc.Parameters.AddWithValue("@shed", comboBox1.SelectedItem);
            SqlDataReader far = disc.ExecuteReader();

            MessageBox.Show("Student Information has been Updated");
            far.Close();

            string ques = "UPATE tblClass SET SectionName = @sects, ShiftSched = @scheds Where GradeLevel =@lb2s and Result >= 85  and SectionName IS NULL";
            SqlCommand discs = new SqlCommand(ques, conn);
            discs.Parameters.AddWithValue("@lb2s", label2.Text);
            discs.Parameters.AddWithValue("@sects", textBox1.Text);
            discs.Parameters.AddWithValue("@sheds", comboBox1.SelectedItem);
            SqlDataReader fars = discs.ExecuteReader();
            MessageBox.Show("Class has been Updated");
            fars.Close();
}

推荐答案

string que =UPATE tblStudentInformation SET SectionName ='+ @ sect +'，ShiftSched =' + @sched +'WhereLevel ='+ @ lb2 +'AND结果> = 85 AND SectionName IS NULL;

SqlCommand disc = new SqlCommand（que，conn）;

disc.Parameters.AddWithValue（@ lb2，label2.Text）;

disc.Parameters.AddWithValue（@ sect，textBox1.Text）;

disc.Parameters.AddWithValue（@ shed，comboBox1.SelectedItem）;

SqlDataReader far = disc.ExecuteReader（）;



MessageBox.Show（学生信息已更新）;

far.Close（）;



string ques =UPATE tblClass SET SectionName ='+ @ sects +'，ShiftSched ='+ @ scheds +'Where GradeLevel ='+ @ lb2s +''且Result> = 85且SectionName IS NULL;

SqlCommand disc = new SqlCommand（ques，conn）;

discs.Parameters.AddWithValue（@ lb2s，label2.Text）;

disc .Parameters.AddWithValue（@ sects，textBox1.Text）;

discs.Parameters.AddWithValue（@ sheds，comboBox1.SelectedItem）;

SqlDataReader fars = discs.ExecuteReader（）;

MessageBox.Show（类已被更新）;

fars.Close（）;

string que = "UPATE tblStudentInformation SET SectionName='"+@sect+"', ShiftSched='"+@sched +"' Where GradeLevel='"+@lb2+"' AND Result >= 85 AND SectionName IS NULL";
SqlCommand disc = new SqlCommand(que, conn);
disc.Parameters.AddWithValue("@lb2",label2.Text);
disc.Parameters.AddWithValue("@sect", textBox1.Text);
disc.Parameters.AddWithValue("@shed", comboBox1.SelectedItem);
SqlDataReader far = disc.ExecuteReader();

MessageBox.Show("Student Information has been Updated");
far.Close();

string ques = "UPATE tblClass SET SectionName = '"+@sects+"', ShiftSched = '"+@scheds+"' Where GradeLevel ='"+@lb2s+'' and Result >= 85 and SectionName IS NULL";
SqlCommand discs = new SqlCommand(ques, conn);
discs.Parameters.AddWithValue("@lb2s", label2.Text);
discs.Parameters.AddWithValue("@sects", textBox1.Text);
discs.Parameters.AddWithValue("@sheds", comboBox1.SelectedItem);
SqlDataReader fars = discs.ExecuteReader();
MessageBox.Show("Class has been Updated");
fars.Close();

 private void button2_Click(object sender, EventArgs e)
        {
            conn = new SqlConnection(connec.GetServer());
            conn.Open();
            string questas = "SELECT  TOP 50 Percent * from tblStudentInformation Where GradeLevel ='" + label2.Text + "' and Result >= 85  and SectionName IS NULL";
            SqlCommand dc = new SqlCommand(questas,conn);
            SqlDataReader sq = dc.ExecuteReader();
            sq.Close();
            
            string que = "UPDATE tblStudentInformation SET SectionName=@sect, ShiftSched=@sched Where GradeLevel=@lb2 AND Result >= 85  AND SectionName IS NULL";
            SqlCommand disc = new SqlCommand(que, conn);
            disc.Parameters.AddWithValue("@lb2",label2.Text);
            disc.Parameters.AddWithValue("@sect", textBox1.Text);
            disc.Parameters.AddWithValue("@sched", comboBox1.SelectedItem);
            SqlDataReader far = disc.ExecuteReader();
 
            MessageBox.Show("Student Information has been Updated");
            far.Close();
 
            string ques = "UPDATE tblClass SET SectionName = @sects, ShiftSched = @scheds Where GradeLevel =@lb2s and Result >= 85  and SectionName IS NULL";
            SqlCommand discs = new SqlCommand(ques, conn);
            discs.Parameters.AddWithValue("@lb2s", label2.Text);
            discs.Parameters.AddWithValue("@sects", textBox1.Text);
            discs.Parameters.AddWithValue("@scheds", comboBox1.SelectedItem);
            SqlDataReader fars = discs.ExecuteReader();
            MessageBox.Show("Class has been Updated");
            fars.Close();
}

>>这只是拼写错误：）

>> It's just typo error :)

这篇关于如何使用c＃在按钮单击时将数据更新到数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！