try
{
SqlConnection conn = new SqlConnection("server=" + DBInfo.getIPAddress() + "," + DBInfo.getPort() + ";database=" +DBInfo.getDBName() +";user id=" + DBInfo.getSqlName() + ";password=" + DBInfo.getPassword() + "");
conn.Open();
DataSet ds = new DataSet();
String sql = "select * from PictureDB.dbo.pInfo";
SqlDataAdapter sda = new SqlDataAdapter(sql, conn);//搬运数据
sda.Fill(ds, "pInfo");//把指定的数据放到dataadapter
PictureDataGridView.DataSource = ds.Tables[0];//填充到DataGridview
SqlCommandBuilder builder = new SqlCommandBuilder(sda);
sda.Update(ds, "pInfo");
this.PictureDataGridView.Columns[0].HeaderText = "编号";
this.PictureDataGridView.Columns[1].HeaderText = "元件名称";
this.PictureDataGridView.Columns[2].HeaderText = "查看图片";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
C# datagridview 数据集 适配器
最新推荐文章于 2023-03-22 19:27:03 发布