Tuesday, December 11, 2007

How to find rows and column in Dataset

IN VB.NET
variable as String=DataSet.Table(0).Rows(index)(column-index).ToString();

IN C#.NET

string variable=DataSet.Table[0].Rows[index][column-index].ToString();

Example:

string name=DataSet.Table[0].Rows[3][2].ToString();

e.g.

["for(i=0 ; i<[rows.count];i++)"]
{
string name=DataSet.Table[0].Rows[i][2].ToString(); 'where [2] is column index or you can put column name like ["col_name"]

}]

No comments: