Here i will show you how to create custom Data grid view and calculating total per entire column.For this i will go for create a data grid view control for accepting Products info and storing products write into Text file
code behind:
This requires "Cell Enter" event of DataGridView control,This event will provide current row index and column index
Change Grid view width Dynamically:
code behind:
Imports System.IO //form load event DataGridView.RowCount=3 DataGridView.ColumnCount=3 DataGridView.Columns(0).HeaderText="desc" DataGridView.Columns(1).HeaderText="Price" DataGridView.Columns(2).HeaderText="Quantity" DataGridView.Columns(3).HeaderText="Total" End Sub//calculating total Based on price,quantity
This requires "Cell Enter" event of DataGridView control,This event will provide current row index and column index
//This will executes when focus comes to cell Private Sub dataGridView1_CellEnter(ByVal sender As Object, _ ByVal e As DataGridViewCellEventArgs) _ Handles dataGridView1.CellEnter msgbox("row;"&e.RowIndex&&"col:"e.ColumnIndex) if(e.ColumnIndex=3)Then With DataGridView1.Rows(e.RowIndex).cells(3).Value=Val(cells(2).Value)*val(cells(1).Value ) End With total=quantity*price with and end with will avoid repetition of DataGridiew.rows(e.RowIndex) //logic for store into text file private sub Button1_click(--) Dim s As string For i As Byte=0 to DataGridView1.Rows.Count-2 With DataGridView1.Rows(i) s=s&DataGridView1.cells[0].Value&""&DataGridView1.cells[1].Value&""&DataGridView1.cells[2].Value&""&DataGridView1.cells[3].Value& End With Next Dim sw As StreamWriter sw=File.CreateText("Transinfo.txt) sw.writeline("transeinfo "&vbCrLf&" "&"&vbCrLf&"&5 vbCrLf is visual basic carriage to return line feed[new line] sw.Close() End Sub
Change Grid view width Dynamically:
if (e.Row.RowType == DataControlRowType.Header) { for (i = 0; i <= e.Row.Cells.Count - 1; i++) { TableCell cell5 = e.Row.Cells(i); cell5.Width = new Unit("175px"); } }
No comments:
Post a Comment