How to add Primary key in DataSet

Categories >> Software >> Microsoft Related >> ADO.NET
Suggest New Category

Question Posted / hydwhitehouse

6 Answers
40273 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to add Primary key in DataSet..

Answer / kamalakannan.a

If we use c#

DataTable dt=new DataTable();

DataColumn Dc1 = new DataColumn("No", Type.GetType
("System.Int32"));

dt.Columns.Add(Dc1);

//Set Primary key
DataColumn[] dc = new DataColumn[1];
dc[0] = dt.Columns["No"];
dt.PrimaryKey = dc;

Kamal..

Is This Answer Correct ?

34 Yes

7 No

How to add Primary key in DataSet..

Answer / gopi

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

Is This Answer Correct ?

29 Yes

4 No

How to add Primary key in DataSet..

Answer / shahil singh

dim col() as new dt.datacolumn
col(0)=dt.column(1)
dt.primarykey=col

Is This Answer Correct ?

30 Yes

8 No

How to add Primary key in DataSet..

Answer / r.prajapati

In eidt dataset designer right click on column name which u
want as primary key and set it as pk

Is This Answer Correct ?

19 Yes

14 No

How to add Primary key in DataSet..

Answer / tamilan

This is answer is great. its help me lot.

In eidt dataset designer right click on column name which u
want as primary key and set it as pk

Is This Answer Correct ?

6 Yes

5 No

How to add Primary key in DataSet..

Answer / rajesh bhawsar

dt.PrimaryKey = {dt.Columns(0)}

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More ADO.NET Interview Questions

What is executequery?

0 Answers

What are the differences between RAW, AUTO and Explicit modes in retrieving data from SQL Server in XML format?

1 Answers TCS,

How to creating a SqlCommand Object?

0 Answers Arigo Infotech,

What are the advantages and disadvantages of using datalist?

0 Answers

What is connection in ado.net?

0 Answers

What is fill method in ado.net?

0 Answers

What is ado net stands for?

0 Answers

What are the three Ado objects?

6 Answers Microsoft, StarSoft,

Explain the ADO . Net Architecture ( .Net Data Provider) ?

2 Answers

What is a datareader object?

0 Answers

What are the Different layers in ADO.Net?

10 Answers eXensys,

What are two types of transaction supported by ado.net?

0 Answers

For more ADO.NET Interview Questions Click Here