how to store the datagridview values into database table please help...

Question

Satyapriya Nayak · Answer

Hi backiyalakshmi Try this... Normal 0 @ Page Language =C# AutoEventWireup =true CodeBehind =Default.aspx.cs Inherits =Insert_data_from_Gridview_database._Default %> DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd> html xmlns =http://www.w3.org/1999/xhtml > head runat =server> title > Untitled Page title > head > body > form id =form1 runat =server> div > asp : Label ID =Label1 runat =server Text => asp : Label > asp : GridView ID =GridView1 runat =server> asp : GridView > asp : Button ID =btn_insert runat =server onclick =btn_insert_Click Text =Insert Records /> asp : Button ID =btn_show runat =server onclick =btn_show_Click style = height : 26px Text =Show Records /> div > form > body > html > using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Insert_data_from_Gridview_database { public partial class _Default : System.Web.UI. Page { string connStr = ConfigurationManager .ConnectionStrings[ ConnectionString ].ConnectionString; SqlCommand com; protected void btn_show_Click( object sender EventArgs e) { DataSet reportData = new DataSet (); reportData.ReadXml(Server.MapPath( student.xml )); GridView1.DataSource = reportData; GridView1.DataBind(); } protected void btn_insert_Click( object sender EventArgs e) { foreach ( GridViewRow g1 in GridView1.Rows) { SqlConnection con = new SqlConnection (connStr); com = new SqlCommand ( insert into student(sidsnamesmarkssaddress) values (' + g1.Cells[0].Text + '' + g1.Cells[1].Text + '' + g1.Cells[2].Text + '' + g1.Cells[3].Text + ')  con); con.Open(); com.ExecuteNonQuery(); con.Close(); } Label1.Text = Records inserted successfully ; } } } Thanks If this post helps you mark it as answer

Muthu Kumaran · Answer

If you are getting the dataset then you have to fill the dataset into the datasource of the datagridview.If you want tosave the datagrid value to the database table write the foreach and then form the insert query and then execute the query.