How to add Primary key in DataSet

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

Question Posted / hydwhitehouse

6 Answers
40118 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 are the steps in connecting to database ?

2 Answers Microsoft,

What is the difference between executequery and executenonquery?

0 Answers

What is ado.net architecture?

0 Answers

Difference between ADO and ADO.Net

4 Answers IBM,

What are the benefits of ADO.NET?

0 Answers B-Ways TecnoSoft,

What is executenonquery ado.net?

0 Answers

What are the Features and disadvantages of dataset

0 Answers Microsoft,

What are the benefits of using of ADO.NET in .NET 4.0?

0 Answers

Differences between dataset.clone and dataset.copy?

2 Answers Ksb, TCS,

Explain acid properties?

4 Answers

ADO and ADO.NET differences?

3 Answers Microsoft,

feature of ADO.Net

11 Answers Wipro,

For more ADO.NET Interview Questions Click Here