Adding rows to DataTable

[maverick786us]

I have created a DataTable like this

DataTable dtTable;
.....................................
.....................................
dtTable = new DataTable();
.....................................
.....................................

DataColumn dcColumn = new DataColumn("PRIMARY_KEY");

dcColumn.AllowDBNull = false;
dcColumn.AutoIncrement = true;
dcColumn.AutoIncrementSeed = 0;
dcColumn.AutoIncrementStep = 1;
dcColumn.DataType = typeof(Int32);
dcColumn.Unique = true;

dtTable.Columns.Add(dcColumn);
dtTable.Columns.Add("Product Name", Type.GetType("System.String"));
dtTable.Columns.Add("Description", Type.GetType("System.String"));
dtTable.Columns.Add("Unit Type", Type.GetType("System.String"));
dtTable.Columns.Add("Supplier", Type.GetType("System.String"));
dtTable.Columns.Add("Product Type", Type.GetType("System.String"));
dtTable.Columns.Add("Supply Stock", Type.GetType("System.String"));
dtTable.Columns.Add("Unit Package", Type.GetType("System.String"));

Now while adding records into this table thing thing....

dtTable.Rows.Add(txtProduct.Text, txtDesc.Text, 
cmbUnitType.SelectedItem.ToString(),
cmbSupplier.SelectedItem.ToString(),
cmbProductType.SelectedItem.ToString(),
txtSupplyStock.Text, txtUnitPackage.Text);

Does'nt work because of primary key
So how can I specify only selected in which I want to add records?

[hensa22]

Hi
you can use NewRow method from DataTable class.

dim objdtRow as DataRow
objdtRow =dttable.newrow
objdtRow ("field1")=value1
objdtRow ("field2")=value2
objdtRow ("field3")=value3
...
..
.
dttable.rows.add(dtrow)

I hope it is useful.