各位大虾:datagridview中的combobox列

[birdfpl04]

各位大虾:datagridview中的几列改为combobox了,数据也绑定了,总是提示默认值错误不知道怎么改正,请各位帮忙.同时我不想取出数据库种的数据,只想直接插入怎么改!谢谢
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace lksystem
{
public partial class Frmshadd : Form
{
public SqlDataAdapter da;
public DataSet ds;
public SqlConnection mycon;
public Frmshadd()
{
InitializeComponent();
}
protected override bool ProcessCmdKey(ref Message msg, Keys keyData)//重写键盘回车代码
{
if ((!(ActiveControl is Button)) && (keyData == Keys.Up || keyData == Keys.Down || keyData == Keys.Enter))
{
if (keyData == Keys.Enter)
{
System.Windows.Forms.SendKeys.Send("{TAB}");
return true;
}
if (keyData == Keys.Down)
System.Windows.Forms.SendKeys.Send("{TAB}");
else
SendKeys.Send("+{Tab}");
return true;
}
else
return base.ProcessCmdKey(ref msg, keyData);
}


private void Frmshadd_Load(object sender, EventArgs e)
{
mycon = new SqlConnection("server=127.0.0.1;database=lkdata;user id=sa;pwd=");
da = new SqlDataAdapter("select sdhdm,bmdm,xybh,shmc,jjrq,sprq,zcfr,lxdh,zcdz,gsbh,swbh,shly,hydm,shzt from tb_sh", mycon);

ds = new DataSet();
SqlDataAdapter da1 = new SqlDataAdapter("select sdhdm,sdhmc from tb_sdh", mycon);
SqlDataAdapter da2 = new SqlDataAdapter("select bmdm,bmmc from tb_bm", mycon);
SqlDataAdapter da3 = new SqlDataAdapter("select hydm,hymc from tb_hy", mycon);
SqlDataAdapter da4 = new SqlDataAdapter("select zydm zymc from tb_zy", mycon);
SqlCommandBuilder cb = new SqlCommandBuilder(da);
da.Fill(ds, "tb_sh");
da1.Fill(ds, "tb_sdh");
da2.Fill(ds, "tb_bm");
da3.Fill(ds, "tb_hy");
da4.Fill(ds, "tb_zy");
dgvaddsh.AutoGenerateColumns = false;
dgvaddsh.DataSource = ds.Tables[0];

DataGridViewComboBoxColumn sdhdm=new DataGridViewComboBoxColumn ();
DataGridViewComboBoxColumn bmdm=new DataGridViewComboBoxColumn ();
DataGridViewComboBoxColumn shly=new DataGridViewComboBoxColumn ();
DataGridViewComboBoxColumn hydm=new DataGridViewComboBoxColumn() ;
dgvaddsh.Columns[0].DataPropertyName = "sdhdm";
dgvaddsh.Columns[1].DataPropertyName = "bmdm";
dgvaddsh.Columns[2].DataPropertyName = "xybh";
dgvaddsh.Columns[3].DataPropertyName = "shmc";
dgvaddsh.Columns[4].DataPropertyName = "jjrq";
dgvaddsh.Columns[5].DataPropertyName = "sprq";
dgvaddsh.Columns[6].DataPropertyName = "zcfr";
dgvaddsh.Columns[7].DataPropertyName = "lxdh";
dgvaddsh.Columns[8].DataPropertyName = "zcdz";
dgvaddsh.Columns[9].DataPropertyName = "gsbh";
dgvaddsh.Columns[10].DataPropertyName = "swbh";
dgvaddsh.Columns[11].DataPropertyName = "shly";
dgvaddsh.Columns[12].DataPropertyName = "hydm";
dgvaddsh.Columns[13].DataPropertyName = "shzt";
sdhdm.DataSource = ds.Tables[1];
sdhdm.ValueMember = "sdhdm";
sdhdm.DisplayMember = "sdhdm";

bmdm.DataSource = ds.Tables[2];
bmdm.ValueMember = "bmdm";
bmdm.DisplayMember = "bmdm";

shly.DataSource = ds.Tables[4];
shly.ValueMember = "zydm";
shly.DisplayMember = "zydm";
hydm.DataSource = ds.Tables[3];
hydm.ValueMember = "hydm";
hydm.DisplayMember = "hydm";
}

private void tsbsave_Click(object sender, EventArgs e)
{
try
{
da.Update(ds.Tables[0]);
MessageBox.Show("新增成功");
}
catch(Exception err)
{
mycon .Close();
MessageBox .Show( err.ToString ());
}

}


}
}

[优途科技]

不太明白你的意思。顶你一下吧。

[mathieuxiao]

如果提示默认值错误，很可能是因为你的数据库表中的值和你下拉框中Items里面包含的值不是完全一样。换句话话说，你的下拉框中有两个选项“1”和“2”，但是你的表中这一列的数据中有个值为“3”，这样就可能导致你的所出现的错误。

如果下拉框列的数据不想从数据库中去也是可以的，如下：

Class Department //代表部门
{
     int _depId;
     string _depName;

     public int DepId{get{return this._depId;} set{this._depId = value;}}
     public string DepName{get{return this._depName;} set{this._depName= value;}}

     public Department(int id, string name)
     {
          this._depId = id; this._depName = name;
     }
}

public partial class Frmshadd : Form 
{
     public form_load(object sender, EventArgs e) 
     {
          List<Department> depList = new List<Department>();
          depList.Add(new Department(1, "财务部")); 
          depList.Add(new Department(2, "业务部")); 

          DataGridViewComboBoxColumn cboCol = new DataGridViewComboBoxColumn();
          
          cboCol.ValueMember = "DepId"; 
          cboCol.DisplayMember = "DepName"; 
          cboCol.DataSource = depList; 

          cboCol.DataPropertyName = "Department";//这个值和你数据库中的列名保持一致

           this.dataGridView1.Columns.Add(cboCol);
     }
}

[wuyq11]

http://www.cnblogs.com/luqingfei/archive/2007/03/28/691372.html

[kbtjh]

顶,,学习一下!!!

[灵魂宝石]

顶

[birdfpl04]

谢谢各位

[birdfpl04]

我的整个意图是要做新增记录操作的. 确实是提示默认错误,谢谢mathieuxiao 的提示,我检查以下是不是数据不一致造成的.另外一个问题是 da = new SqlDataAdapter("select sdhdm,bmdm,xybh,shmc,jjrq,sprq,zcfr,lxdh,zcdz,gsbh,swbh,shly,hydm,shzt from tb_sh", mycon);
会将我库中所有记录都取出来,这个是我不想的,不知道怎么改才能实现.请各位帮助.谢谢!

[birdfpl04]

同时感谢三楼的,也帮我搞定了一个问题.

[mathieuxiao]

[Quote=引用 7 楼 birdfpl04 的回复:]
我的整个意图是要做新增记录操作的. 确实是提示默认错误,谢谢mathieuxiao 的提示,我检查以下是不是数据不一致造成的.另外一个问题是 da = new SqlDataAdapter("select sdhdm,bmdm,xybh,shmc,jjrq,sprq,zcfr,lxdh,zcdz,gsbh,swbh,shly,hydm,shzt from tb_sh", mycon);
会将我库中所有记录都取出来,这个是我不想的,不知道怎么改才能实现.请各位帮助.谢谢!
[/Quote]

你直接在select语句后加个where条件就可以了

[chinaconstraint]

不是可以用三层DataView过滤实现么

[mathieuxiao]

都可以，但是直接在select语句后面也行

DataView dv = ds.Tables[0].DefaultView;
dv.Filter = "sex = '男'";//这样就可以取出性别为男的所有数据了

[mathieuxiao]

shly.DataSource = dv; 
shly.ValueMember = "zydm"; 
shly.DisplayMember = "zydm";