usingSystem;
usingSystem.Collections.Generic; usingSystem.ComponentModel; usingSystem.Data;
usingSystem.Data.SqlClient; usingSystem.Drawing; usingSystem.Text;
usingSystem.Windows.Forms;
namespaceSys {
publicpartialclassForm3:Form {
publicForm3() {
InitializeComponent();
}
privatevoidForm3_Load(objectsender,EventArgse) {
dataGridView1.AllowUserToAddRows=false; dataGridView1.AutoGenerateColumns=false;
using(SqlConnectionsqlconn=newSqlConnection(\"server=.;uid=sa;pwd=sa;database=xx\")) {
stringsql1=@\"selectuserid,fullname,a.[description],b.ugroupid fromusersaleftouterjoinusergroupb ona.grade=b.ugroupid\";
stringsql2=\"selectdistinctugroupid,[description]fromusergroup\";
DataGridViewComboBoxColumndgvComboBoxColumn=dataGridView1.Columns[\"grade\"]asDataGridViewComboBoxColumn; dgvComboBoxColumn.DataPropertyName=\"ugroupid\";
dgvComboBoxColumn.DataSource=GetTable(sql2).DefaultView;//必须在设置dataGridView1的DataSource的属性前设置 dgvComboBoxColumn.DisplayMember=\"description\"; dgvComboBoxColumn.ValueMember=\"ugroupid\";
dataGridView1.DataSource=GetTable(sql1).DefaultView;//一定要在dgvComboBoxColumn的DataSource后设置 } }
privateDataTableGetTable(stringsql) {
using(SqlConnectionsqlconn=newSqlConnection(\"server=.;uid=sa;pwd=yuling1310;database=smls\")) {
DataTabledt=newDataTable();
SqlDataAdaptersqlda=newSqlDataAdapter(sql,sqlconn); sqlda.Fill(dt); returndt; } } } }