using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString)) { SqlDataAdapter sda = new SqlDataAdapter("select Categoryid,CategoryName from Categories",conn); DataSet ds = new DataSet(); sda.Fill(ds); GridView1.DataSource=ds' GridView1.DataBind(); }Page_Load事件
try {} 以下,以防出错
哦,学到,是否还有其它方法?只能通过绑定DataSource的方法吗?
private void BindGrid() { SqlConnection cn = new SqlConnection(@"server=.\SQLExpress;uid=sa;pwd=sa;database=pubs"); SqlDataAdapter da = new SqlDataAdapter("select au_id, state, contract from authors", cn); DataSet ds = new DataSet(); cn.Open(); da.Fill(ds); cn.Close(); GridView1.DataSource = ds; GridView1.DataBind(); } private void Page_Load(object sender, System.EventArgs e) { if (! IsPostBack ) { BindGrid(); } }
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString))
{
SqlDataAdapter sda = new SqlDataAdapter("select Categoryid,CategoryName from Categories",conn); DataSet ds = new DataSet();
sda.Fill(ds);
GridView1.DataSource=ds'
GridView1.DataBind();
}Page_Load事件
以下,以防出错
private void BindGrid()
{
SqlConnection cn = new SqlConnection(@"server=.\SQLExpress;uid=sa;pwd=sa;database=pubs");
SqlDataAdapter da = new SqlDataAdapter("select au_id, state, contract from authors", cn);
DataSet ds = new DataSet();
cn.Open();
da.Fill(ds);
cn.Close();
GridView1.DataSource = ds;
GridView1.DataBind();
} private void Page_Load(object sender, System.EventArgs e)
{
if (! IsPostBack )
{
BindGrid();
}
}
datasource=DataView