Click here to Skip to main content
11,718,289 members (82,460 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#
I have following data table
DataTable TableTransferNoteMain = new DataTable();
TableTransferNoteMain.Columns.Add("TrnNo",typeof(int));
for (int i = 0;i < 100; i++)
{
TableTransferNoteMain.Rows.Add(i) 
 
}//how to retrieve The Values of above table using column name like this 

for (int j = 0 ; j < TableTransferNoteMain.rows.count())
{
 int TrnNumber = TableTransferNoteMain.column["TrnNO"].value  // this is what i am expecting how to do this requirement 
}

how to retrieve a record by specifying a column name of a data table ?
Posted 21-Dec-12 17:07pm

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Hi Hope this will help you



foreach(DataRow MainRow in TableTransferNoteMain.Rows)
{
int TrnNumber=int.Parse(MainRow["TrnNo"]);
}
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 215
1 F-ES Sitecore 210
2 Maciej Los 140
3 Jochen Arndt 120
4 Andy Lanng 115
0 OriginalGriff 535
1 Maciej Los 529
2 Richard MacCutchan 440
3 CHill60 415
4 F-ES Sitecore 415


Advertise | Privacy | Mobile
Web04 | 2.8.150901.1 | Last Updated 21 Dec 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100