How retrieve data from a Data Gridview

Question

How do you retrieve data from a gridview and save into database?

Satyapriya Nayak · Answer

Hi Andile Here is your solution Untitled Page DataKeyNames=sid AllowPaging=True CellPadding=3 OnPageIndexChanging=ResultGridView_PageIndexChanging PageSize=5 BackColor=#DEBA84 BorderColor=#DEBA84 BorderStyle=None BorderWidth=1px CellSpacing=2 OnRowCommand=ResultGridView_RowCommand> ReadOnly=True SortExpression=sid /> '> '> '> '> using System; 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; public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; SqlDataAdapter ad = new SqlDataAdapter(); SqlCommand cmd = new SqlCommand(); DataTable dataTable; protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { FillstudentGrid(); } } private void FillstudentGrid() { SqlConnection conn = new SqlConnection(connStr); dataTable = new DataTable(); cmd.Connection = conn; cmd.CommandText = SELECT * FROM student; ad = new SqlDataAdapter(cmd); ad.Fill(dataTable); ResultGridView.DataSource = dataTable; ResultGridView.DataBind(); } protected void ResultGridView_PageIndexChanging(object sender GridViewPageEventArgs e) { ResultGridView.PageIndex = e.NewPageIndex; FillstudentGrid(); } protected void ResultGridView_RowCommand(object sender GridViewCommandEventArgs e) { if (e.CommandName.Equals(AddNew)) { TextBox txtFName = (TextBox)ResultGridView.FooterRow.FindControl(txtFName1); TextBox txtLName = (TextBox)ResultGridView.FooterRow.FindControl(txtLName1); SqlConnection conn = new SqlConnection(connStr); cmd.Connection = conn; cmd.CommandText = INSERT INTO student(firstnamelastname) Values(' + txtFName.Text + ' ' + txtLName.Text + '); conn.Open(); cmd.ExecuteNonQuery(); FillstudentGrid(); conn.Close(); } } } Thanks If this post helps you mark it as answer

Andile Choko · Answer

Hi dipal I wanted to save contacts that i have imported from gmail which i displayed on a gridview to database.

Dipal Choksi · Answer

Hey Andile The previous posters have provided very helpful solutions while I considered what you were looking for was wondering what was the requirement/objective - could you share some details on that? the best approach can be determined based on what you really need to do..

Mayur Dighe · Answer

if you want to save updated data of GridView or or want to copy all data from GridView  Then You do this by putting GridView's DataSource into DataTable and then using DataSet's UpdateCommand() method you can save this data into DataBase .

Vijay Yadav · Answer

You can use the foreach loop to get the gridview rows and with the help of that you can save it into the database. :)