This is my Technical area of troubleshooting and learning new Programming skills and many more. Here you will find answers for many new technologies like asp.net 2.0/3.5,4.0 C# access, mysql, Amazon Webservice ,Sql-server, JD Edwards, SAS, Salesforce, APIs, MVC and many more. please visit & discuss.
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:
Post a Comment