private void bindata()
{
QueryDb.InitConnDB();//连接数据库;
DataSet myds;
DataTable mytable1=new DataTable();
DataTable mytable2=new DataTable();
DataTable mytable3=new DataTable();
DataTable mytable4=new DataTable();
myds=myUserInfo.getassistant();
for(int i=0;i<myds.Tables[0].Rows.Count;i++)
{
string result=myds.Tables[0].Rows[i]["Atype"].ToString();
if(result=="0")
{
DataRow row1;
mytable1.Columns.Add(new DataColumn("aname",typeof(String)));
row1=mytable1.NewRow();
row1[0]=myds.Tables[0].Rows[i]["Aname"].ToString();
mytable1.Rows.Add(row1);
}
else if(result=="1")
{
DataRow row2;
mytable2.Columns.Add(new DataColumn("aname",typeof(String)));
row2=mytable2.NewRow();
row2[0]=myds.Tables[0].Rows[i]["Aname"].ToString();
mytable2.Rows.Add(row2);
}
else if(result=="2")
{
DataRow row3;
mytable3.Columns.Add(new DataColumn("aname",typeof(String)));
row3=mytable3.NewRow();
row3[0]=myds.Tables[0].Rows[i]["Aname"].ToString();
mytable3.Rows.Add(row3);
}
else if(result=="3")
{
DataRow row4;
mytable4.Columns.Add(new DataColumn("aname",typeof(String)));
row4=mytable4.NewRow();
row4[0]=myds.Tables[0].Rows[i]["Aname"].ToString();
mytable4.Rows.Add(row4);
} }
Xueliid.DataSource=new DataView(mytable1);
Xueliid.DataBind();
Politicsid.DataSource=new DataView(mytable2);
Politicsid.DataBind();
Competenceid.DataSource=new DataView(mytable3);
Competenceid.DataBind();
Departid.DataSource=new DataView(mytable4);
Departid.DataBind();
Nativeid.DataSource=myUserInfo.getnative().Tables[0].DefaultView;
Nativeid.DataBind();}
{
QueryDb.InitConnDB();//连接数据库;
DataSet myds;
DataTable mytable1=new DataTable();
DataTable mytable2=new DataTable();
DataTable mytable3=new DataTable();
DataTable mytable4=new DataTable();
myds=myUserInfo.getassistant();
for(int i=0;i<myds.Tables[0].Rows.Count;i++)
{
string result=myds.Tables[0].Rows[i]["Atype"].ToString();
if(result=="0")
{
DataRow row1;
mytable1.Columns.Add(new DataColumn("aname",typeof(String)));
row1=mytable1.NewRow();
row1[0]=myds.Tables[0].Rows[i]["Aname"].ToString();
mytable1.Rows.Add(row1);
}
else if(result=="1")
{
DataRow row2;
mytable2.Columns.Add(new DataColumn("aname",typeof(String)));
row2=mytable2.NewRow();
row2[0]=myds.Tables[0].Rows[i]["Aname"].ToString();
mytable2.Rows.Add(row2);
}
else if(result=="2")
{
DataRow row3;
mytable3.Columns.Add(new DataColumn("aname",typeof(String)));
row3=mytable3.NewRow();
row3[0]=myds.Tables[0].Rows[i]["Aname"].ToString();
mytable3.Rows.Add(row3);
}
else if(result=="3")
{
DataRow row4;
mytable4.Columns.Add(new DataColumn("aname",typeof(String)));
row4=mytable4.NewRow();
row4[0]=myds.Tables[0].Rows[i]["Aname"].ToString();
mytable4.Rows.Add(row4);
} }
Xueliid.DataSource=new DataView(mytable1);
Xueliid.DataBind();
Politicsid.DataSource=new DataView(mytable2);
Politicsid.DataBind();
Competenceid.DataSource=new DataView(mytable3);
Competenceid.DataBind();
Departid.DataSource=new DataView(mytable4);
Departid.DataBind();
Nativeid.DataSource=myUserInfo.getnative().Tables[0].DefaultView;
Nativeid.DataBind();}
Politicsid.DataSource=new DataView(mytable2);//这里出现问题。
比如:
C# AP 程式
comboBox1.DisplayMember="USER_NAME";
comboBox1.DataSource = oDs.Tables[0].DefaultView;C# Web 程式
comboBox1.DisplayMember="USER_NAME";
comboBox1.DataTextField ="字段名";
comboBox1.DataValueField ="字段名";
comboBox1.DataSource = oDs.Tables[0].DefaultView; [DataView]