Visual Basic

foreach (DataRowView drv in myDataView){
drv.Row; //this is the original DataRow object
object kkVal = drv["KK"]; //you can also access values directly
}

object firstVal = myDataView[0]["KK"];

DataTable myDataTable;

//create DataView
DataView dataView = new DataView(myDataTable);
//now the view contains everything the table contains

//set sorting
dataView.Sort = "Period DESC";
//you could also sort by two column: dataView.Sort = "Period DESC, KK ASC";

//set filter criteria
dataView.Filter = "Value <> 0"; //probably its "!= 0" - im not sure

//Get the first KK value
object firstKK = dataView[0]["KK"];

//Iterate over all values
foreach (DataRowView drv in dataView) {
   //get original row
   DataRow dr = drv.Row;

  //do anything you want :-)
}

DataTable dt;
string maxPeriod = dt.Compute("MAX(Period)");
DataRow[] rowsWithMaxPeriod = dt.Select("Period = '" + maxPeriod + "'");
//the filter expression should be something likes this: "Period = '200601'")

cylix2000 wrote:

Who can tell me how to declare a string with double-quotation mark ?

cylix2000 wrote:

I have total lost.