how to add data...

avilarmannellaa · Apr 28, 2012

okie people... here is another killer question. i want to add a new blank row to my datagrid or datalist.... whichever you people think is best. when i click the "Add new row" button, a textbox will appear at the last row of the datagrid... which means if my datagrid has 5 rows of information, by clicking "add new row" i should get 6 row.. 5 rows of information and 1 row which is the textbox. i dont save anything back to the database, untill i click the "save" button. i can continue to add new rows .. as many as i wish.. untill the "save" button is click then all information is posted to the database for inserting. can anyone out there help me with this? i'm very new to asp.net sorry for the spelling folks. Simon, Here is a demo that should get you started. It creates a dataset on page_load, preserves it as an xml string in ViewState between post events. You can add blank rows, make entries in the blank row, edit any previous entries. All of this is off-line independent of the source database. When you are ready, you can update the source by clicking the Save_All button. The Save_All button is shown, but the code to drive changes back to your database is up to you. Copy and paste this code, then give it a try.......... Good Luck, TT <%@ Page Language="VB" Debug = "True" %> <%@ Import NameSpace="System.Data" %> <%@ Import NameSpace="System.Xml" %> <SCRIPT RUNAT="SERVER"> ' =============================================== ' CREATE DATASET, PRESERVE IN VIEWSTATE, ' ADD BLANK ROWS, BIND TO DATAGRID, ' EDIT DATAGRID, PRESERVE EDITS. ' POST EDITS BACK TO DATABASE WITH BUTTON CLICK. ' =============================================== 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) With objDataSet.Tables("xmlTestTable") .Columns.Add("FName", System.Type.GetType("System.String")) .Columns.Add("LName", System.Type.GetType("System.String")) End With If Not Page.IsPostBack Then SaveIt() End If End Sub ' =========================== Sub SaveIt() strXML = objDataSet.GetXml() ViewState("strData")=strXML End Sub ' =========================== Sub GetIt() If Not ViewState("strData") Is Nothing then strXML = ViewState("strData").ToString() Dim strReader As New System.IO.StringReader(strXML) objDataSet.Readxml(strReader) End If End Sub ' =========================== Sub AddRow(obj as Object, e as EventArgs) GetIt() Dim AddaRow As DataRow = objDataSet.Tables ("xmlTestTable").NewRow() AddaRow.Item("FName") = txtFName.Text AddaRow.Item("LName") = txtLName.Text objDataSet.Tables("xmlTestTable").Rows.Add(AddaRow) SaveIt() BindIt() txtFName.Text = "" txtLName.Text = "" End Sub ' =========================== Sub BindIt() objDGrid.DataSource = objDataSet.Tables("xmlTestTable") objDGrid.DataBind() End Sub ' =========================== Sub EditGrid(obj as object, e as DataGridCommandEventArgs) GetIt() objDGrid.EditItemIndex = e.Item.ItemIndex SaveIt() BindIt() End Sub ' =========================== Sub CancelGrid(obj as object, e as DataGridCommandEventArgs) GetIt() objDGrid.EditItemIndex = -1 SaveIt() BindIt() End Sub ' =========================== 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 SaveAll(obj as Object, e as EventArgs) Response.Write("Your DataBase Update Sub Would Run Now") End Sub </SCRIPT> ' =========================== <HTML><BODY> <FORM Runat="Server" EnableViewState = "True" > <ASP:Label id="lblMessage" runat="server" /> First Name: <ASP:TextBox id="txtFName" Width="114" Runat="Server" /> Last Name: <ASP:TextBox id="txtLName" Width="114" Runat="Server" /> <ASP:Button ID="btnSubmit" Text="Add New Row" Runat="Server" OnClick="AddRow" /> <ASP:Button ID="btnSave" Text="Save All" Runat="Server" OnClick="SaveAll" /> <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 add data...

avilarmannellaa

New Member