How to place new empty row in Data grid

ZwaqarS · Apr 28, 2012

Hi friends, I am developing a site using asp.net. I need to display a Data grid having 4 columns. In addition I will be having edit/ update/cancel column. At the footer I will be having the new row link(hyperlink button). When the user clicks on the new row. he should get a new empty row on the top of all the rows. Can any one help me in this area. Thankyou in advance. chandra sekhar.The following is a working example you can use. Just pull out the pieces you need. TomTT <%@ Page Language="VB" Debug = "True" %> <%@ Import NameSpace="System.Data" %> <%@ Import NameSpace="System.Xml" %> <SCRIPT RUNAT="SERVER"> Dim objDataSet As New DataSet("objDataSet") Dim xmlTestTable As DataTable = objDataSet.Tables.Add("xmlTestTable") Dim strXML As String Sub Page_Load(obj as Object, e as EventArgs) ' === SPECIFY COLUMNS SINCE A BLANK ROW CAN BE ADDED. With objDataSet.Tables("xmlTestTable") .Columns.Add("FName", System.Type.GetType("System.String")) .Columns.Add("LName", System.Type.GetType("System.String")) End With ' === FIRST TIME THRU, SAVE A COPY OF DATASET TO VIEWSTATE. If Not Page.IsPostBack Then FirstRow() objDGrid.EditItemIndex = 0 BindIt() End If GetIt() ' GET DATA FROM VIEWSTATE. End Sub ' === SaveIt SUB CONVERTS DATASET TO XML STRING, PUTS IN VIEWSTATE. Sub SaveIt() strXML = objDataSet.GetXml() ViewState("strData")=strXML End Sub ' === GetIt SUB GETS XMLSTRING AND RECREATES DATASET. Sub GetIt() If Not ViewState("strData") Is Nothing then objDataSet.Clear() strXML = ViewState("strData").ToString() Dim strReader As New System.IO.StringReader(strXML) objDataSet.Readxml(strReader) End If End Sub ' === ADD A NEW ROW WHEN PAGE IS FIRST LOADED. Sub FirstRow() GetIt() Dim AddaRow As DataRow = objDataSet.Tables("xmlTestTable").NewRow() AddaRow.Item("FName") = " " AddaRow.Item("LName") = " " objDataSet.Tables("xmlTestTable").Rows.Add(AddaRow) SaveIt() End Sub ' === ADD A NEW ROW TO DATASET. BLANK ROW ENTRY IS OK. Sub AddRow(obj as Object, e as EventArgs) GetIt() Dim AddaRow As DataRow = objDataSet.Tables("xmlTestTable").NewRow() AddaRow.Item("FName") = " " AddaRow.Item("LName") = " " objDataSet.Tables("xmlTestTable").Rows.Add(AddaRow) SaveIt() ' SAVE REVISED DS TO VIEWSTATE. BindIt() ' REBIND REVISED DS TO GRID. End Sub ' === STANDARD SUB FOR BINDING DATASET TO DATAGRID. Sub BindIt() objDGrid.DataSource = objDataSet.Tables("xmlTestTable") objDGrid.DataBind() End Sub ' === EDIT LINK CLICKED ON DATAGRID. PUTS GRID IN EDIT MODE. Sub EditGrid(obj as object, e as DataGridCommandEventArgs) GetIt() objDGrid.EditItemIndex = e.Item.ItemIndex SaveIt() BindIt() End Sub ' === CANCEL LINK CLICKED ON DATAGRID. Sub CancelGrid(obj as object, e as DataGridCommandEventArgs) GetIt() objDGrid.EditItemIndex = -1 SaveIt() BindIt() End Sub ' === UPDATE LINK CLICKED ON DATAGRID. UPDATE DATASET WITH DATAGRID EDITS. Sub UpDateGrid(obj As object, e As DataGridCommandEventArgs) Dim gRow As Integer = objDGrid.EditItemIndex Dim txtFName As TextBox = e.Item.Cells(0).Controls(0) Dim txtLName As TextBox = e.Item.Cells(1).Controls(0) GetIt() objDataSet.Tables("xmlTestTable").Rows(gRow)(0) = txtFName.text objDataSet.Tables("xmlTestTable").Rows(gRow)(1) = txtLName.text objDGrid.EditItemIndex = -1 SaveIt() BindIt() End Sub ' === SUB TO SAVE DATASET CHANGES BACK TO SOURCE DATABASE. Sub SaveAll(obj as Object, e as EventArgs) Response.Write("Your DataBase Update Sub Runs At Here.") End Sub </SCRIPT> <HTML><BODY> <FORM Runat="Server" EnableViewState = "True" > <ASP:Button ID="btnSubmit" Text="Add New Row" Runat="Server" OnClick="AddRow" /> <ASP

ataGrid ID="objDGrid" Runat="Server" OnEditCommand = "EditGrid" OnCancelCommand = "CancelGrid" OnUpdateCommand = "UpdateGrid" Width = "350" AutoGenerateColumns = "False"> <Columns> <ASP:BoundColumn HeaderText = "First Name" DataField = "FName"> <ItemStyle Width = "150"/> </ASP:BoundColumn> <ASP:BoundColumn HeaderText = "Last Name" DataField = "LName"> <ItemStyle Width = "150"/> </ASP:BoundColumn> <ASP:EditCommandColumn EditText = "Add/Edit" CancelText = "Cancel" UpdateText = "Enter" ItemStyle-Wrap = "False" HeaderText = "Add/Edit" > <ItemStyle Font-Size = "8"/> </ASP:EditCommandColumn> </Columns> </ASP

ataGrid> </FORM> </BODY></HTML>

How to place new empty row in Data grid

ZwaqarS

New Member