C# how to save changes in datagridview to sql?

Question

0.00/5 (No votes)

See more:

Hi, how do I save changes been made on datagridview. Bellow is the code have I have so far.

C#

private void refreshInvoice() //Load all Invoice result.
{
    SqlDataAdapter dataAdapter = new SqlDataAdapter("select ID_Invoice, Description_Invoice, Amount_Invoice, Invoice_Date_Invoice, Invoice_Note, Invoice_Number_Invoice, Invoice_Status, Paid_Invoice_Number, Supplier_Invoice, Upload_Date_Invoice  from StoringSystemInvoiceTable", connectionString);
    SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);
    //new data table
    DataTable table = new DataTable();
    table.Locale = CultureInfo.InvariantCulture;
    dataAdapter.Fill(table);
    storingSystemContractTableBindingSource.DataSource = table;
    //resize the DataGridView columns to fit newly loaded content.
    storingSystemContractTableDataGridView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.ColumnHeader);

    //user can resize column and add rows
    storingSystemContractTableDataGridView.AllowUserToResizeColumns = true;
    storingSystemContractTableDataGridView.AllowUserToAddRows = true;
    //storingSystemContractTableBindingNavigator.BindingSource();
    storingSystemContractTableDataGridView.DataSource = storingSystemContractTableBindingSource;
}

Posted 22-Oct-12 21:29pm

mrjohnk

Add a Solution

Comments

Herman<T>.Instance 23-Oct-12 3:38am

this is a seelct statement not an insert. I guess wrong part of code?

2 solutions

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)

Tushar22Patel · Answer 1 · 2012-10-23T00:56:00

Hi

Step - 1 Take Dataset
Step - 2 Fill Dataset using appropriate select statment
Step - 3 Assgin dataset to Gridview(AllowAddNewRow Property to True)

Update Existing Data
if you update existing data then use Update() method of sqladapter object.

Insert new data
First Add new Record in datatable then Call Method (UPDATE())

Samsani.v.s.Durga Prasad · Answer 2 · 2012-10-23T00:35:00

Hi Initially you will get the by using below code

DataSet ds = new DataSet();

    static SqlConnection con = new SqlConnection("user id=sa;password=just4fun;database=sdp;data source=sitt244");

    static SqlCommand cmd = new SqlCommand("select * from employee ", con);

SqlDataAdapter da = new SqlDataAdapter(cmd);

C#

private void GetData()
       {
           dataGridView1.Visible = true;
           da.Fill(ds,"e");
           dataGridView1.DataSource = ds.Tables["e"];
           MessageBox.Show("You got the data");
       }


       private void button1_Click(object sender, EventArgs e)
       {
           GetData();
           
       }

If you want to insert data or save changes then write the below code in "Savechanges" button click

C#

SqlCommandBuilder cmd = new SqlCommandBuilder(da);
           try
           {
               da.Update(ds, "e");
               MessageBox.Show("Saved");


           }
           catch (Exception ee)
           {
               MessageBox.Show(ee.Message);
           }

C# how to save changes in datagridview to sql?

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0