ds.Tables[0].Constraints.Add("pk_sid", ds.Tables[0].Columns[0],

How to add Primary key in DataSet

Question Posted / gopi

Answer Posted / gopi

ds.Tables[0].Constraints.Add("pk_sid",
ds.Tables[0].Columns[0], true);

Is This Answer Correct ?

29 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is difference between datatable and dataset?

1069

How can we add relation between tables in a dataset?

1001

What is ole db query?

992

Can we do database operations without using any of the ado.net objects?

1000

What is the meaning of executenonquery?

1071

What is ole2 format?

909

What is ado code?

959

Why is it important to close an ado.net application?

1028

What is a non query?

942

What is ole used for?

948

What is DataRowCollection?

1115

Define Execute Scalar?

1024

What is execute scalar in ado.net?

969

What is the difference between Optimistic and Pessimistic locking?

992

Which is faster sqldataadapter and sqldatareader?

931