Set primarykey to a datatable

[Lars E]

Hi all

How can i set primarykey to a datatable.
This datatable is in a dataset i get from a backend system.

My datatable contains several fields, and i want to make the fields
"c-custno1", "c-custno2" and "c-class" my primary key.

How can this be done?
Thanks
Lars E

[Greg Young [MVP]]

DataTable.Prima ryKey
http://msdn2.microsoft.com/en-US/lib...rimarykey.aspx

Cheers,

Greg
"Lars E" <la***********@ infocare.no> wrote in message
news:uD******** ******@TK2MSFTN GP02.phx.gbl...

Hi all

How can i set primarykey to a datatable.
This datatable is in a dataset i get from a backend system.

My datatable contains several fields, and i want to make the fields
"c-custno1", "c-custno2" and "c-class" my primary key.

How can this be done?
Thanks
Lars E

[Peter Bromberg [C# MVP]]

Example, multicolumn:

DataSet ds = new DataSet();
DataTable tbl;
//Create the Customers DataTable.
tbl = ds.Tables.Add(" Customers");
tbl.Columns.Add ("CustomerID ", typeof(string)) ;

tbl.PrimaryKey = new DataColumn[] {tbl.Columns["CustomerID "]};

//Create the Order Details DataTable.
tbl = ds.Tables.Add(" Order Details");
tbl.Columns.Add ("OrderID", typeof(int));
tbl.Columns.Add ("ProductID" , typeof(int));
tbl.PrimaryKey = new DataColumn[] {tbl.Columns["OrderID"],
tbl.Columns["ProductID"]};

Peter
--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Lars E" wrote:

Hi all

How can i set primarykey to a datatable.
This datatable is in a dataset i get from a backend system.

My datatable contains several fields, and i want to make the fields
"c-custno1", "c-custno2" and "c-class" my primary key.

How can this be done?
Thanks
Lars E

[Lars E]

Thanks.

I think i got the primary keys set.

But when i thies to use the datatable.row.f ind("primarykey ") i get an error:

"Unable to cast object of type 'System.String[]' to type
'System.IConver tible'"
mycode:

//Run trough the table and populate the new fields
for(int i=0;i< dtCustInfo.Rows .Count;i++)
{
//build up the primarykey
String[][] custContKey = new String[][] {
new String[] { dtCustInfo.Rows[0]["c-custno1"].ToString() },
new String[] { dtCustInfo.Rows[0]["c-custno2"].ToString() },
new String[] { "a" }};
//my problem starts....
DataRow foundRow = dtCustCont.Rows .Find(custContK ey); ->>>>>>> Error
if (foundRow != null)
{
MessageBox.Show ("found one...");
//modifiy the 3 fields with data fra det dataset
//dtCustInfo.Colu mns.Add(
}
}

I don't have a clue on how to solve this. Please help?

Thanks.
Lars E.

"Greg Young [MVP]" <Dr************ *@hotmail.com> skrev i melding
news:e5******** ******@TK2MSFTN GP03.phx.gbl...

DataTable.Prima ryKey
http://msdn2.microsoft.com/en-US/lib...rimarykey.aspx

Cheers,

Greg
"Lars E" <la***********@ infocare.no> wrote in message
news:uD******** ******@TK2MSFTN GP02.phx.gbl...

Hi all

How can i set primarykey to a datatable.
This datatable is in a dataset i get from a backend system.

My datatable contains several fields, and i want to make the fields
"c-custno1", "c-custno2" and "c-class" my primary key.

How can this be done?
Thanks
Lars E

[Lars E]

Hi again.

My solution for setting primary key.
I already have a datatable so i cant create column to this. My code now look
like this:

//make a datatable to use row.find() or datatable.selec t method
DataTable dtCustCont = new DataTable("Cust Cont");
dtCustCont = customers.Table s[1];
// set primary keys.
DataColumn[] keys = new DataColumn[3];
DataColumn column;
column = new DataColumn();
column = dtCustCont.Colu mns["cc-custnr1"];
keys[0] = column;
column = new DataColumn();
column = dtCustCont.Colu mns["cc-custnr2"];
keys[1] = column;
column = new DataColumn();
column = dtCustCont.Colu mns["cc-class"];
keys[2] = column;
// Set the PrimaryKeys property to the array.
dtCustCont.Prim aryKey = keys;

I now have problme with the dtCustCont.Sele ct(......) so that my main issue
right now :-)

Thanks
Lars E

"Lars E" <la***********@ infocare.no> skrev i melding
news:uD******** ******@TK2MSFTN GP02.phx.gbl...

Hi all

How can i set primarykey to a datatable.
This datatable is in a dataset i get from a backend system.

My datatable contains several fields, and i want to make the fields
"c-custno1", "c-custno2" and "c-class" my primary key.

How can this be done?
Thanks
Lars E