[转帖]DataGrid的自定义分页UserControl(9) using(SqlConnection conn = new SqlConnection("User id=sa;passWord=admin;server=server-mk;initial catalog=pubs;timeout=90") { SqlCommand cmd = new SqlCommand("select count(*) as eXPr1 from authors",conn); cmd.Connection.Open(); rowcount = (int)cmd.ExecuteScalar(); cmd.Connection.Close();