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 two fundamental objects in ADO.NET?

8 Answers   Ksb, TCS,

Explain different methods and Properties of DataReader which you have used in your project?

2 Answers  

What is ado.net connection?

0 Answers  

Execute nonquery returns no. of afected rows.So if my stored procedure hav lot of select stmnt, delete stmnt, insert stmnt..then what does execute nonquery returns in this case?

6 Answers   Wipro,

What are the different row versions available in table?

0 Answers  

Difference between function and trigger?

1 Answers   HCL,

Explain the various objects in dataset.

0 Answers  

describe the dataset object in ado.net.

0 Answers  

What is different between sqlcommand object and command behavior object?

0 Answers  

What are the namespaces used in ado.net for data access?

0 Answers  

Define the data provider classes that is supported by ado.net?

0 Answers  

what is execute scalar?

11 Answers   Atharva Infotech, Dohatec New Media, Make eIT, Protech,