winform取到数据库信息的方法

winform取到数据库信息的方法

我要做的是下图的选择一行商铺点击的详情按钮

        private void uiSymbolButton2_Click(object sender, EventArgs e){if (Dgv_Data.SelectedRows.Count != 1){this.ShowWarningDialog("请选中一行!");return;}//判断是否选择一行t_dpxx t = new t_dpxx();t.Id = int.Parse(Dgv_Data.SelectedRows[0].Cells[0].Value.ToString());//获取你选中表格行的IDDataTable dt = t.Xian();t.Shopname = dt.Rows[0][2].ToString();Xq xq = new Xq(t);xq.ShowDialog();//显示对话框}

调用到的Xian()函数

public class t_dpxx{public int Id { get; set; }public string Shopimg { get; set; }public string Shopname { get; set; }public string Send { get; set; }public string Delivery { get; set; }public string Month { get; set; }public string Cent { get; set; }public string Username { get; set; }public string Idcard { get; set; }public string Password { get; set; }public string Phone { get; set; }public string Address { get; set; }public string Mail { get; set; }public string Brief { get; set; }//获取数据库中各个列的值
public DataTable Xian(){string sql = string.Format("select * from t_dpxx where id ={0}", Id);//数据库中查找我们想获取的数据行SqlHelper sqlHelper = new SqlHelper();return sqlHelper.ExecuteReaderEx(sql);}}

在详情Xq页面引用

public Xq(t_dpxx t){InitializeComponent();LabelShopname.Text = t.Shopname;//我们将数值赋值给文本框LabelId.Text = t.Id.ToString();}