gridview

Question

how to add rows dynamically to a gridview????

Lalit M · Answer

In Vb.net Private orderTotal As Decimal = 0.0D Private tax As Decimal = 0.0D Protected Sub gvOrderDetail_RowDataBound(sender As Object, e As GridViewRowEventArgs) 'TODO: Calculate the orderTotal and the tax when RowType = DataRow If e.Row.RowType = DataControlRowType.Footer Then 'Create the Row Dim row As New GridViewRow(-1, -1, DataControlRowType.DataRow, DataControlRowState.Normal) 'Add the two Columns row.Cells.AddRange(CreateCells()) 'get a reference to the table that holds this row Dim tbl As Table = (TryCast(e.Row.Parent, Table)) 'Add the row at the end of the list, but before the footer. tbl.Rows.AddAt(gvOrderDetail.Rows.Count + 1, row) 'Don't forget to account for any changes in the footer. Since we added a row to show the tax, 'that tax must also be accounted for in our footer. Calculating the orderTotal and the tax 'is an exercise for the reader. Dim lbl As Label lbl = DirectCast(e.Row.FindControl("lblTotal"), Label) lbl.Text = [String].Format("{0:C}", (orderTotal + tax)) End If End Sub Private Function CreateCells() As TableCell() Dim cells As TableCell() = New TableCell(2) {} Dim cell As TableCell Dim lbl As Label 'The order item column cell = New TableCell() lbl = New Label() lbl.Text = "Sales Tax" cell.Controls.Add(lbl) cells(0) = cell 'The price column cell = New TableCell() lbl = New Label() lbl.Font.Bold = True lbl.Text = tax.ToString("C") cell.HorizontalAlign = HorizontalAlign.Right cell.Controls.Add(lbl) cells(1) = cell Return cells End Function more sample in C# Check here

Lalit M · Answer

try this code sample decim a l order To t a l = 0.0m; decim a l t a x = 0.0m; protected void gvOrderDet a il_RowD a t a Bound( object sender, GridView RowEvent A rgs e) { // TO DO: C a lcul a te the order To t a l a nd the t a x when RowType = D a t a Row if (e.Row.RowType == D a t a ControlRowType.Footer) { //Cre a te the Row GridView Row row = new GridView Row(-1, -1, D a t a ControlRowType.D a t a Row, D a t a Control RowS t a te.Norm a l); // Add the two Columns row.Cells. Add R a nge(Cre a teCells()); //get a reference to the t a ble th a t holds this row T a ble tbl = (e.Row.P a rent a s T a ble); // Add the row a t the end of the list, but before the footer. tbl. Rows . Add A t(gvOrderDet a il. Rows .Count + 1, row); //Don't forget to a ccount for a ny ch a nges in the footer. Since we add ed a row to show the t a x, //th a t t a x must a lso be a ccounted for in our footer. C a lcul a ting the order To t a l a nd the t a x //is a n exercise for the re a der. L a bel lbl; lbl = (L a bel)e.Row.FindControl( "lbl To t a l" ); lbl.Text = String.Form a t( "{0:C}" , (order To t a l + t a x)); } } priv a te T a bleCell[] Cre a teCells() { T a bleCell[] cells = new T a bleCell[2]; T a bleCell cell; L a bel lbl; //The order item column cell = new T a bleCell(); lbl = new L a bel(); lbl.Text = "S a les T a x" ; cell.Controls. Add (lbl); cells[0] = cell; //The price column cell = new T a bleCell(); lbl = new L a bel(); lbl.Font.Bold = true ; lbl.Text = t a x. To String( "C" ); cell.Horizont a l A lign = Horizont a l A lign.Right; cell.Controls. Add (lbl); cells[1] = cell; return cells; } for reference more info http://www.c-sharpcorner.com/UploadFile/Art%20Scott/GridViewInsertANewRow09012006165053PM/GridViewInsertANewRow.aspx Adding Dynamic Rows in GridView with TextBoxes