Hi,

I have a table which doesnt have a primary key. Now I created a dtaset by querying this table. Now I added a primary constraint to this Datasets Datatable. Now I want to update my table using commandbuilder. Is there anyway I can write my added constraint also to the datasource ?

if u r using DataAdapter i dont think that it'll couse a problem! does it?! can u tell more.

Always:),
Hovik Melkomian.

I am using a dataadapter only. In the datatable the constraints are there. But Update command only inserts data. Not the constraints. Should I do anything else to make it work ?

// there is no rows in the table now.
SqlDataAdapter adapter = new SqlAdapter("SELECT * FROM EMPLOYEES", connection);
DataSet dataSet = new DataSet("Employees");
adapter.Fill(dataSet);
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
DataRow newrow = dataSet.Tables[0].NewRow;
// filling the new row with values...
...
..
DataColumn[] primaryKey = {dataSet.Tables[0].Coulmn[0]};
dataSet.Tables[0].PrimaryKey = primaryKey;
adapter.Update(dataSet);

---Row is inserted..but no primary key...

If want to [u]update ur Primary field </u>in table, ur problem is in DataBase not in ur code. Make sure ur primary field is set toIDENTITY.
keep in touch.

Always:),
Hovik Melkomian.