you can try it, but I am not testprivate void ComputeBySalesSalesID(DataSet myDataSet){
// Presumes a DataTable named "Orders" that has a column named "Total."
DataTable myTable;
myTable = myDataSet.Tables["Orders"];
// Declare an object variable.
object objSum;
objSum = myTable.Compute("Max(Total)");
}
// Presumes a DataTable named "Orders" that has a column named "Total."
DataTable myTable;
myTable = myDataSet.Tables["Orders"];
// Declare an object variable.
object objSum;
objSum = myTable.Compute("Max(Total)");
}
SqlDataAdapter adp=new SqlDataAdapter("select * from Employees",cn);
DataSet ds=new DataSet();
adp.Fill(ds,"Orders");
DataView dv=ds.Tables[0].DefaultView;
dv.RowFilter="employeeid<7 and employeeid>4";
DataGrid1.DataSource=dv;
DataGrid1.DataBind();
{
for(int i=0 ;i<dt.Rows.Count;i++)
{
int k = Convert.ToInt32( dt.Rows[i][0] );
if( k >= num )
{
return i;
}
}
}
dv.RowFilter = "Column > 90";
dv.Sort = "Column";
DataRow o = null;
if (dv.Count > 0)
o = dv[0].Row;