DataRow conversion issue in asp.net

How to convert system.data.datarow to an integer?

I Have a da开发者_如何学Pythontarow which is returning the count of records which i want to store in an integer variable The statement is as follows

int TotalRecords=ds.Tables[1].Rows[0];

here ds is the DataSet.

when i am trying to write the above statement it is telling me that i cannot implicitly convert System.Data.DataRow to int

You need to cast the value as an integer:

int TotalRecords = (int)ds.Tables[1].Rows[0]["YourColumnName"];

try that,

int TotalRecords=ds.Tables[1].Rows[0].Count();

you have to include Linq if not included

using System.Linq;