Monday, January 19, 2009

Count Record using asp.net C# , count(*)

 SqlConnection cnn = new SqlConnection("server=DBSERVER;User id=USER;password=PASSWORD;database=DB");
  SqlCommand cmd = new SqlCommand("Select count(*) from abctest", cnn);
  cnn.Open();
  Response.Write(cmd.ExecuteScalar().ToString());

No comments: