insert data

Posted by Parag under ASP.NET on 9/17/2008 | Views : 2334 | Status : [Member] | Replies : 5

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

how to insert data using button click from grid to database ?
i mean to say , i have one grid and two button one add new and save
when i click on add new then new row could be added in grid and when i click on save button then
i want to save all those data which are added in new row will be added in database

note : i used BO /custom entitty classes not dataset

parag barot

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Jayakumars on: 9/30/2012 [Member] [MVP] Bronze | Points: 25

0	hi refer this http://www.codeproject.com/Articles/417693/Insert-Update-Delete-in-ASP-NET-Gridview-DataSourc http://www.codeproject.com/Articles/24085/Insert-Update-Delete-with-Gridview-Simple-Way Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Parag, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jayakumars on: 9/30/2012 [Member] [MVP] Bronze | Points: 25

0	hi Please mark as answer if it helpful to you. Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Parag, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Majith on: 9/17/2008 [Member] Starter

0	Hi Parag, For New Button Click DataTable datatable = ds.Tables[0]; DataRow dr = dt.DefaultView.Table.NewRow(); datatable .Rows.InsertAt(dr, 0); For Saving Data find the text box controls TextBox txtname = (TextBox)GridView1.Rows[i].FindControl("txtName"); Row["Name"] = txtname; DataTable dt = new DataTable(); DataColumn dclm = new DataColumn(); dTable.Columns.Add(dclm ); DataRow dr = dTable.NewRow(); GridView1.DataSource=dt; GridView1.DataBind(); try this Parag, if this helps please login to Mark As Answer. \| Alert Moderator

Hi Parag,

For New Button Click

DataTable datatable = ds.Tables[0];
DataRow dr = dt.DefaultView.Table.NewRow();
datatable .Rows.InsertAt(dr, 0);

For Saving Data

find the text box controls
TextBox txtname = (TextBox)GridView1.Rows[i].FindControl("txtName");
Row["Name"] = txtname;
DataTable dt = new DataTable();
DataColumn dclm = new DataColumn();
dTable.Columns.Add(dclm );
DataRow dr = dTable.NewRow();
GridView1.DataSource=dt;
GridView1.DataBind();

try this

Parag, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Siya on: 9/17/2008 [Member] Starter

0	i used ultrawebgrid in my project so how to find out that newley added row data in save button click Parag, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Vuyiswamb on: 9/18/2008 [Member] [MVP] [Administrator] NotApplicable

0	hi , i have Writen Articles on CodeProject about Searching , Updatating and Deleteting in a Datagrid. What you can do is to add the Delete command. look at it here http://www.codeproject.com/KB/cs/N-Tier22.aspx Hope it Helps Thank you for posting at Dotnetfunda [Administrator] Parag, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts