SqlCommand cmd=new SqlCommand(); cmd.ExecuteNonQuery("Select Max(Count) From TableName",con); sqlDataReader dr=new SqlDataReader(); dr.read(); int lnCount = Convert.ToInt32(dr[0].toString());
select max(column name) from tablename
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)