SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connstr"].ConnectionString);
string sql="select * from authors";
SqlDataAdapter sda=new SqlDataAdapter(sql,conn);
DataSet ds = new DataSet();
sda.Fill(ds,"作者");
GridView1.DataSource = ds; //GridView1.DataSource = ds.table["作者"]//GridView1.DataSource = ds.table[0].defaultview
GridView1.DataBind();
ExecuteNonQuery和SqlCommand一起用,也就没DataSet和SqlDataAdapter什么事了,通常用在对数据的增加、修改、删除,注意查询不能用它
private int cmd(string query)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connstr"].ConnectionString);
conn.Open();
SqlCommand cmd = new SqlCommand(query, conn);
return cmd.ExecuteNonQuery();
}
另外还有个ExecuteScalar也和SqlCommand一起用作用,返回单个值,如求和、总行数等SQL语句的聚合函数