多个Datagridview相关联

最新推荐文章于 2020-11-19 10:22:41 发布

kliffy

最新推荐文章于 2020-11-19 10:22:41 发布

阅读量861

点赞数 2

CC 4.0 BY-SA版权

文章标签： string dataset object 数据库 database sql

版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文链接：https://blog.csdn.net/jxhanmin/article/details/2038080

string P_Str_cmdtxt = String.Empty;

string P_Str_select = String.Empty;

string strSQL = String.Empty;

//数据库连接

string sql = "server=172.16.200.33;DataBase=GJMY;uid=sa;pwd=sa;";

SqlConnection conn = new SqlConnection(sql);

conn.Open();

//数据库操作语句,找出数据..

P_Str_select = "shijian BETWEEN '" + this.dtStartTime.Value.ToString("yyyy-MM-dd") + "' AND";

P_Str_select = "'" + this.dtEndTime.Value.ToString("yyyy-MM-dd") + "'";

//strSQL += " and " + P_Str_select + "";

strSQL = "select * from PumiShengchan order by id asc";

//适配器,数据集,填充 Datagridview

SqlDataAdapter ads = new SqlDataAdapter(strSQL, conn);

DataSet data = new DataSet();

ads.Fill(data, "PumiShengchan");

dataGridView1.DataSource = data.Tables[0];

//Datagridview样式....

this.dataGridView1.RowsDefaultCellStyle.BackColor = Color.Bisque;

this.dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;

this.dataGridView1.GridColor = Color.BlueViolet;

this.dataGridView1.BorderStyle = BorderStyle.Fixed3D;

dataGridView1.ReadOnly = true;

private void dataGridView1_SelectionChanged(object sender, EventArgs e)

{

GridViewBind();

}

private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)

{

FillControls();

}

private void FillControls()

{

this.label1.Text = this.dataGridView1[1, this.dataGridView1.CurrentCell.RowIndex].Value.ToString();

this.label2.Text = this.dataGridView1[2, this.dataGridView1.CurrentCell.RowIndex].Value.ToString();

this.label3.Text = this.dataGridView1[3, this.dataGridView1.CurrentCell.RowIndex].Value.ToString();

}

属性:SelectionMode >> FullRowSelect

第二个datagridview数据填充语句:

GridViewBind()

{

strSQL2 = "select * from PumiShengchan_CP where RelationID='" + dataGridView1.SelectedRows[0].Cells["RelationID"].Value.ToString().Trim() + "'";

}

评论

被折叠的条评论为什么被折叠?

到【灌水乐园】发言

查看更多评论

添加红包

成就一亿技术人!

hope_wisdom

发出的红包

实付元

使用余额支付

点击重新获取

扫码支付

钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。