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 different types of Commands available with DataAdapter ?

1 Answers   Arigo Infotech,

What is isolation?

0 Answers  

What is partial class?

0 Answers  

What is the difference between the clone() and copy() methods of the dataset class?

0 Answers  

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

0 Answers  

Call a stored procedure from ado.net and pass parameter to it ?

7 Answers   Keane India Ltd, TCS,

What is ado.net components?

0 Answers  

What is the key feature of ADO.NET compared to ADO ?

3 Answers   TCS,

How do you find the count of records in a dataset?

0 Answers  

What are the important features of ado.net 2.0?

0 Answers  

What are all components of ADO.Net data provider?

0 Answers  

how to keep track of index in listbox items.

2 Answers