一个数据库加DataGird的绑定操作

最新推荐文章于 2024-09-14 19:55:29 发布

shipfi

最新推荐文章于 2024-09-14 19:55:29 发布

阅读量1.3k

点赞数

分类专栏：项目开发文章标签：数据库 datagrid dataset string table user

本文链接：https://blog.csdn.net/shipfi/article/details/190696

版权

项目开发专栏收录该内容

5 篇文章 0 订阅

订阅专栏

System.Data.SqlClient.SqlConnection sqlConnection1;
   //System.Data.SqlClient.SqlCommand sqlCommand1;
   System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
   System.Data.DataSet ds;
   string strConn,strSql;

   strSql="Select * from WZ";
   strConn = "workstation id=SHIPFI;packet size=4096;user id=sa;data source=SHIPFI;persist secu" +
    "rity info=False;initial catalog=xiaoxiao";
   sqlConnection1 = new System.Data.SqlClient.SqlConnection(strConn);
   //sqlCommand1 = new System.Data.SqlClient.SqlCommand();
   sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();

   sqlDataAdapter1.SelectCommand = new System.Data.SqlClient.SqlCommand(strSql,sqlConnection1);
   sqlDataAdapter1.TableMappings.Add("Table","WZ");
   ds = new DataSet("WZ");
   sqlDataAdapter1.Fill(ds);

DataGrid1.DataSource = ds.Tables["WZ"].DefaultView;
DataGrid1.DataBind();