How to add Primary key in DataSet

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

Question Posted / hydwhitehouse

6 Answers
40142 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 bubbled event can you please explain?

0 Answers

What is ado oledb and odbc?

0 Answers

What is Data view?

0 Answers

What are the Data providers in ADO.Net?

0 Answers

What is difference between dataset and datatable?

0 Answers

What are advantages of microsoft-provided data provider classes in ado.net?

0 Answers

What provider ado.net use by default? Explain the role of data provider in ado.net?

0 Answers

What we do with the object of ado.net dataset after using it?Can we dispose it or can we set it nothing?Is it must or not?

4 Answers SVI,

What is ado or jdbc?

0 Answers

What is sqldatasource?

0 Answers

what is data Adapter?

26 Answers CMC, CSS, IBM,

What is azure ado?

1 Answers

For more ADO.NET Interview Questions Click Here