ASP.NET - data set with rows count

hi 
  how  i can find total records in one tabal.
how i can compare particuratl tabel in rows of one sell

You can get the total number of rows count in ds like this;

int rowsCnt = ds.Tables[0].Rows.Count;

You can also specify name of table like;

int rowsCnt = ds.Tables["Employee"].Rows.Count;

if u want to get row count in dataset use

int intCount;
intCount = ds.Tables["myTable"].Rows.Count;

but not clear about yr 2nd query what u wnat compare table rows of one sell?

you can compare any value inside the datatable by referencing them with the position inside the dataset as

Dataset
    Datatable
        Rows
            Items (Column values)

you can compare like as...
Ds.Tables[0].Rows[0][0]
and
Ds.Tables[0].Rows[4][0]

You can use self join for compare 2 rows of the same table

SELECT t1.value, t2.value
 FROM MyTable t1, MyTable t2
 WHERE t1.id = @id
   AND t1.status = @status1
   AND t2.id = t1.id
   AND t2.status = @status2

you can use count function to count total number of records

eg

SELECT count( * ) as total_record FROM student

Suppose u have dataset names "mydataset"  and table name of dataset as "table1" (even u can access table with index)

for comparing cells use below code

 foreach (DataRow item in ds.Tables["table1"].Rows)
 {
      string temp = item["name"].ToString();  // "name" is column name
 }

to get count of dataset use below code

ds.Tables["table1"].Rows.Count

        SqlConnection cn = new SqlConnection("your connection string");

        SqlCommand cmd = new SqlCommand("select count(*) from employee", cn);

 

        int i = cmd.ExecuteScalar();

        Label1.Text = "there are " + i.ToString() + " records in employee table ";