Hello friends,

I have a table in the database with 2 columns and also 2 textbox in the form. Whenever the user clicks the save button in the from the new row should be added in the table.
Can anybody help me.

I m using this code but its not working:

//code

 SqlConnection con = new SqlConnection("Server='****';Database=*****");

                //open sql conection

                con.Open();

                SqlDataAdapter ad = new SqlDataAdapter("Select * From Supplier_Master", con);
                DataSet ds = new DataSet();
                ad.Fill(ds);
                DataRow dr=new DataRow();
                dr.Table.NewRow();

                //dr=this.ds.Tables(0).NewRow;
                dr.ItemArray[0] =textbox1.Text;
                dr.ItemArray[1] = textbox2.text;

                ad.Update(ds.Tables);
                MessageBox.Show("Success");

//code



JAININ

__________________
JAININ

By default a SqlDataAdapter does not have any code to generate an insert command. Also, calling NewRow() doesn't add the row to the table.

Check out the documentation here:

http://msdn2.microsoft.com/en-us/lib...rtcommand.aspx

Also, if you make your variable names cslightly longer it will be easier to read your code:

SqlDataAdapter adapter = new SqlDataAdapter("Select * From Supplier_Master", con);
DataSet dataset = new DataSet();
adapter.Fill(dataset);
DataTable table = dataset.Tables[0];

DataRow row = table.NewRow();

row.ItemArray[0] =textbox1.Text;
row.ItemArray[1] = textbox2.text;

table.Rows.Add(row);

adapter.Update(dataset);

/- Sam Judson : Wrox Technical Editor -/