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

i making a project using windows application c#, i want to show user name, password, and one button login. i wanna make it with sealed class .how its possible . when i clicked my login button all project should be open. pls cleare me.

1 Answers  

What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?

2 Answers  

If a dataset contains 100 rows, how to fetch rows between 10 and 20 only ?

14 Answers   Ksb,

Explain the role of data provider in ado.net?

0 Answers  

Is ado.net an orm?

0 Answers  

What are the different execute methods of Ado.Net?

0 Answers  

Advantage of ADO.Net?

2 Answers   QualSoft, TCS,

Define connection string?

0 Answers  

Differences between dataset.clone and dataset.copy?

2 Answers   Ksb, TCS,

What are the advantages and drawbacks of using ado.net?

0 Answers  

How to store data in memory?

0 Answers  

What is ado.net object model?

0 Answers