Datagrid Help

[Jamie Sutherland]

Hi,
I have a windows form using vb.net that has 5 text boxes, 1 button and a
datagrid.
txtProdID
txtDesc
txtQty
txtUnit
txtTotal
dgProducts
btnAddtoDataGrid

When the user has entered the info into the textboxes and then click
btnAddtoDataGrid then I want the data added to the datagrid.
Question - How do I do this? - I am not sure on creating the rows in the
datagrid.

Thanks
Jamie

 

[Alex Passos]

You will need to create the data in an object that is compatible with
DataGrid.DataSource such as DataTable or DataSet.

Here is a quick example of a DataTable:

DataTable dt = new DataTable("Products");
dt.Columns.Add(new DataColumn("txtProdID", typeof(string));
dt.Columns.Add(new DataColumn("txtDesc", typeof(string));
dt.Columns.Add(new DataColumn("txtQty", typeof(int));
dt.Columns.Add(new DataColumn("txtUnit", typeof(double));
dt.Columns.Add(new DataColumn("txtTotal", typeof(double));

DataRow dr = dt.NewRow();
dr["txtProdID"] = txtProdID.Text;
dr["txtDesc"] = txtDesc.Text;
dr["txtQty"] = System.Convert.ToInt32(txtQty.Text); // this could throw a
NumberFormat exception

....

dt.Rows.Add(dr);

then go back to DataRow and add another row when the button gets pressed
again.

when finished setting up your table:

datagrid.DataSource = dt;

Alex