Update GridView Data to SQL

Question

0.00/5 (No votes)

See more:

Hi Friends,
I am using C# Windows Application.I am displaying SQL data into grid view using for loop Condition.Now, I want to update data(which is display in datagridview) into SQL Database...But it didn't display the newly added data...
here is my sample code Display data in Grid....

C#

comm = "select Name,Rate,Qty,TotalAmount from SALESENTRY where PENo = '" + txt_VocherNo.Text + "'";

                SqlCommand sqlcom = new SqlCommand(comm, sqlcon);
                SqlDataReader read = sqlcom.ExecuteReader();
                if (read.HasRows)
                {
                    int k = 0;
                    while (read.Read())
                    {
                        dgv_Entry.Rows[k].Cells["ColumnName"].Value = read.GetString(0);
                        dgv_Entry.Rows[k].Cells["ColumnRate"].Value = read.GetString(1);
                        dgv_Entry.Rows[k].Cells["ColumnRQty"].Value = read.GetString(2);
                        dgv_Entry.Rows[k].Cells["ColumnTotal"].Value = Total;
                        k++;
                    }
                }
                sqlcon.Close();

And its MY Update Code..

C#

if (btn_save.Text.Trim() == "&Update")
                        {                                                         
               for (int no = 0; no <= dgv_Entry.Rows.Count - 1; no++)
                {
                    if (dgv_Entry.Rows[no].Cells["ColumnName"].Value.ToString() == "" || dgv_Entry.Rows[no].Cells["ColumnName"].Value.ToString() == null)
                    { break; }
                    else
                    {
                        VNo = txt_VocherNo.Text;                        
                        Name = dgv_Entry.Rows[no].Cells["ColumnName"].Value.ToString();
                       SRate = dgv_Entry.Rows[no].Cells["ColumnRate"].Value.ToString();
                       RQty = dgv_Entry.Rows[no].Cells["ColumnRQty"].Value.ToString();
                       Total = dgv_Entry.Rows[no].Cells["ColumnTotal"].Value.ToString();
                      Cmmd = "Update SALESENTRY Set Name = '" + Name + "',SRate ='" + Rate + "',RQty='" + Qty + "',Total='" + TotalAmount + "' Where Vno = '"+Vno+"'
            DbCon.SetDataBase(Cmmd);
                    }
                }
                                MessageBox.Show("Record Updated", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);

Now How can i update Newly Added record Instead of Old
For Example.,I have Already 4 Records, now i want to Add one More Record using Update Button..How can i update?..
Please Suggest...

Posted 28-Jun-13 21:51pm

MichealRay

Updated 29-Jun-13 21:47pm

v2

Add a Solution

Comments

Software Engineer 892 30-Jun-13 5:57am

my dear friend,

for Adding a new record. you should use add button and also Use INSERT Query.

So, New record will be Inserted. using INSERT QUERY.

Code must be written in Gridview RowCommand event.

I think you have understood.

1 solution

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)

Parag Kotekar · Answer 1 · 2013-06-30T01:14:00

Hey there,

See i get that you want Insert & Update to performed at the same time(on 1 click event),
So i will just explain the logical ways to do it. as below

1) Before you INSERT or UPDATE check for the existence of Primary (INDEX) of the row
(in your grid view)

If (Your row ID exists<using select=""> )
Execute UPDATE_SQL_QUERY
else
Execute INSERT_SQL_QUERY

---------
Example for Students_Table
Check if (Students_Table.Roll is present)
Update Name = 'Jim carry'
Else
Insert Student with name new 'Tom Cruise'