110,537
社区成员
发帖
与我相关
我的任务
分享
private void Bind2(int Areacode2)
{
SqlConnection scConnection = new SqlConnection(connstr); //建立Connection
SqlCommand scCommand2 = scConnection.CreateCommand(); //建立Command
scCommand2.CommandText = "select Id,Shipdate,Shipcompany,Company,Portship,Shipday,[20],[40],HQ,Dodate,Endday,Tax,Addcharge,Mark,Areacode1,Areacode2 from zheng where Areacode1=@Areacode1 and Areacode2=@Areacode2";
scCommand2.Parameters.AddWithValue("@Areacode1", area);
scCommand2.Parameters.AddWithValue("@Areacode2", Areacode2);
sdaAdapter2 = new SqlDataAdapter(scCommand2); //建立Adapter
scbBuilder2 = new SqlCommandBuilder(sdaAdapter2); //该对象负责生成用于更新数据库的SQL语句,不必自己创建这些语句
dsSet.Clear(); //使用容器前先清空容器
sdaAdapter2.Fill(dsSet, "zheng"); //填充数据
bind2 = this.BindingContext[dsSet.Tables["zheng"]];
dataGridView2.DataSource = dsSet.Tables["zheng"]; //数据源绑定
}
DataTable temptable = new DataTable();
temptable.Columns.Add("index");
temptable.Columns.Add("value");
((DataGridViewComboBoxColumn)setteidialog.grid_homon_saki.Columns[1]).Resizable = DataGridViewTriState.False;
for (int no = 0; no < 3; no++)
{
temptable.Rows.Add((no).ToString(), string.Format("{0} {1}", (no).ToString(), moji_saki_kubun(no)));
}
((DataGridViewComboBoxColumn)setteidialog.grid_homon_saki.Columns[1]).DataSource = temptable;
((DataGridViewComboBoxColumn)setteidialog.grid_homon_saki.Columns[1]).DisplayMember = "value";
((DataGridViewComboBoxColumn)setteidialog.grid_homon_saki.Columns[1]).ValueMember = "index";
moji_saki_kubun 里 写的就是你 获取到的 所有下拉框绑定的东西
取初始值的时候 grid_homon_saki.Rows[i].Cells[1].Value = s.value.ToString(); 直接写就好
dt[i].tosting是你从数据库 明确值的那个
然后 更新就和TEXT形式的GRID什么的也就都一样了。
//这边是数据绑定的代码,其中第二列是DataGridViewComboBoxColumn
DataTable dt= new DataTable("ForTest");
dt.Columns.Add("Column1", Type.GetType("System.Int32"));
dt.Columns.Add("Column3", Type.GetType("System.String"));
DataRow y;
y = dt.NewRow();
y["Column1"] = 1;
y["Column3"] = 1;
dt.Rows.Add(y);
DataTable dtSex = new DataTable();
dtSex.Columns.Add("Value");
dtSex.Columns.Add("Name");
DataRow drSex;
drSex = dtSex.NewRow();
drSex[0] = "0";
drSex[1] = "男";
dtSex.Rows.Add(drSex);
drSex = dtSex.NewRow();
drSex[0] = "1";
drSex[1] = "女";
dtSex.Rows.Add(drSex);
drSex = dtSex.NewRow();
drSex[0] = "2";
drSex[1] = "未知";
dtSex.Rows.Add(drSex);
DataGridViewComboBoxColumn columnCbx = ((DataGridViewComboBoxColumn)dataGridView1.Columns[1]);
columnCbx.ValueMember = "Value";
columnCbx.DisplayMember = "Name";
columnCbx.DataSource = dtSex;
dataGridView1.DataSource = dt;
private void BindShipdate()
{
DataGridViewComboBoxColumn shipdate = (DataGridViewComboBoxColumn)dataGridView2.Columns["Shipdate"];
DataTable dtSex = new DataTable();
dtSex.Columns.Add("Value");
dtSex.Columns.Add("Name");
DataRow drSex;
drSex = dtSex.NewRow();
drSex[0] = "0";
drSex[1] = "男";
dtSex.Rows.Add(drSex);
drSex = dtSex.NewRow();
drSex[0] = "1";
drSex[1] = "女";
dtSex.Rows.Add(drSex);
drSex = dtSex.NewRow();
drSex[0] = "2";
drSex[1] = "未知";
dtSex.Rows.Add(drSex);
shipdate.ValueMember = "Value";
shipdate.DisplayMember = "Name";
shipdate.DataSource = dtSex;
}