datagridview数据绑定

来源:互联网 发布:网络指纹考勤机 编辑:程序博客网 时间:2024/03/29 10:08

 
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = "server=(local);uid=sa;pwd=sa;database=DatabaseName";
        SqlCommand cmd = new SqlCommand();
        cmd.CommandText = "select * from DatabaseName";
        cmd.Connection = conn;
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = cmd;
        conn.Open();
        DataSet ds = new DataSet();
        sda.Fill(ds,DatabaseName);
        conn.Close();
        this.myDataGrid.DataSource = ds;
        this.DataBind();

原创粉丝点击