Hello,
I am using bellow command to check max value of column .It works upto 10 after that it sends always 10 though my data base already increased upto 13 rows.
I also checked SELECT ISNULL (MAX(ID)+1,0)
SELECT ISNULL (MAX(ID),0)
Please suggest me what to do.
SqlCommand cmd = new SqlCommand("SELECT ISNULL (MAX(ID)+1,1) AS Result FROM CustomerDetail", con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
id = dr[0].ToString();
id = (Convert.ToInt64(id) + 1).ToString();
}
}