insert records in database from datagridview.

ashwini bhingole

Insert Records in Database from datagridview. my code is--

SqlDataAdapter da = new SqlDataAdapter("select * from GradeDGV", con);
da.InsertCommand = new SqlCommand("insert into GradeDGV (Proportions,Percentage,Quantity) values(@Proportions, @Percentage, @Quantity)", con);
da.InsertCommand.Parameters.Add("@Proportions", SqlDbType.VarChar, 10, "Proportions");
da.InsertCommand.Parameters.Add("@Percentage", SqlDbType.Decimal, 10, "Percentage");
da.InsertCommand.Parameters.Add("@Quantity", SqlDbType.Decimal, 10, "Quantity");

DataSet ds = new DataSet();
da.Fill(ds);
DGV_grade.DataSource = ds;

tell me solution as soon as possible.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pravin Ghadge14y ago
Accepted answer
Hi,

da = new SqlDataAdapter();
                DataRow vDr;
                da.SelectCommand = new SqlCommand();

                da.SelectCommand.CommandType = CommandType.Text;
                vCmBld = new SqlCommandBuilder(da);
                da.SelectCommand.Connection = con;
                da.SelectCommand.CommandText = "Select * from GradeDGV";
                da.Fill(vDs, "GradeDGV");

                for (int i = 0; i < dataGridView1.Rows.Count-1; i++)
                {
                        vDr = vDs.Tables["GradeDGV_PAYMENT"].NewRow();

                        vDr["SrNo"] = dataGridView1.Rows[i].Cells["SrNo"].Value;
                          //specifed ur column name

                        vDs.Tables["GradeDGV"].Rows.Add(vDr);
                    }
                }

                da.Update(vDs, "GradeDGV");
                vDs.Dispose();
                da.Dispose();
Pravin Ghadge14y ago
Hi,
try this
SqlDataAdapter da = new SqlDataAdapter();
DataRow vDr;
da.SelectCommand = new SqlCommand();

da.SelectCommand.CommandType = CommandType.Text;
SqlCommandBuilder vCmBld = new SqlCommandBuilder(da);
da.SelectCommand.Connection = con;
da.SelectCommand.CommandText = "Select * from GradeDGV";
da.Fill(vDs, "GradeDGV");

for (int i = 0; i < dataGridView1.Rows.Count-1; i++)
{
vDr = vDs.Tables["GradeDGV_PAYMENT"].NewRow();

vDr["SrNo"] = dataGridView1.Rows[i].Cells["SrNo"].Value;
//specifed ur column name

vDs.Tables["GradeDGV"].Rows.Add(vDr);
}
}

da.Update(vDs, "GradeDGV");
vDs.Dispose();
da.Dispose();
ashwini bhingole14y ago
Thanks for help.

but in my code some error occured.

error--object reference not set to an instance of an object.

my code is--

da = new SqlDataAdapter();
DataRow vDr;
da.SelectCommand = new SqlCommand();

da.SelectCommand.CommandType = CommandType.Text;
vCmBld = new SqlCommandBuilder(da);
da.SelectCommand.Connection = con;
da.SelectCommand.CommandText = "Select * from GradeDGV";
da.Fill(vDs, "GradeDGV");

for (int i = 0; i < dataGridView1.Rows.Count-1; i++)
{
vDr = vDs.Tables["GradeDGV_PAYMENT"].NewRow();

vDr["SrNo"] = dataGridView1.Rows[i].Cells["SrNo"].Value;
//specifed ur column name

vDs.Tables["GradeDGV"].Rows.Add(vDr);
}
}

da.Update(vDs, "GradeDGV");
vDs.Dispose();
da.Dispose();
Manoj Singh Panwar14y ago
refer to this hope it will help you

http://www.aspdotnetfaq.com/Faq/How-to-insert-row-in-GridView-with-SqlDataSource.aspx

Accept the answer as correct if it helps you.