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)}

What are the steps you will take to improve performance? Will you use dataset or datareader?

0 Answers  

What is ole access?

0 Answers  

Explain executenonquery?

0 Answers  

what is Execute NOn Query?

29 Answers   Infosys, Protech, Sars Systems, SwanSoft Technologies,

What is the difference between sqldatareader and sqldataadapter?

0 Answers  

What do you know about ADO.NET's objects and methods?

0 Answers   NA,

What are the different methods available under the sqlcommand class to access the data?

0 Answers  

What is Debug.write does?

1 Answers  

Explain the namespaces in which .net has the data functionality class.

0 Answers  

Which is faster datareader or dataadapter?

0 Answers  

What is an orm, and why would you use one instead of plain old ado.net?

0 Answers  

How can we serialize the dataset object?

0 Answers