How to update data to the database on button click using c#?

Question

0.00/5 (No votes)

See more:

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();
}

Posted 18-Jan-15 22:48pm

DarkDreamer08

Add a Solution

Comments

Herman<T>.Instance 19-Jan-15 4:50am

at which line the error occurs?
did you debug?

DarkDreamer08 19-Jan-15 4:54am

Yes, the error occurs at line SQLDataReader far = disc.ExecuteReader();

RAHUL(10217975) 19-Jan-15 4:57am

Is control values are correct ? Means Combobox1.SelectedItem and other controls value
?

DarkDreamer08 19-Jan-15 5:00am

I solved it now, Typo error on word UPDATE and @sched

2 solutions

Solution 1

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();

Posted 18-Jan-15 23:02pm

jaimin85

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DarkDreamer08 · Accepted Answer · 2015-01-19T00:03:00

 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 :)