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..

Answer / gopi

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

Answer / shahil singh

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

Answer / r.prajapati

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

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

Answer / rajesh bhawsar

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

Difference between datareader and dataset?

26 Answers   Microsoft, Noel Infotech, Satyam, Value Labs,

What is the executescalar method?

0 Answers  

What is Dataset Object?

0 Answers  

How to insert multiple records in asp .net from Gridview to Sql Database with out using loop condition ?

2 Answers  

What is the use of command objects?

2 Answers  

Explain the difference in record set and dataset?

0 Answers  

How many commands does the oledbcommand takes?what are they?

2 Answers  

What is ado.net explain with diagram?

0 Answers  

What are the disadvantages of using datalist?

0 Answers  

What are the three Ado objects?

6 Answers   Microsoft, StarSoft,

Which property is used to check whether a DataReader is closed or opened?

0 Answers  

Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?

0 Answers