111,098
社区成员




private void Form1_Load(object sender, EventArgs e)
{//在文本控件中显示数据
t_nl.DataBindings.Add("Text", myDataSet, "_user._name");
//在下拉控件中显示数据
t_xb.DataSource = myDataSet;
t_xb.DisplayMember = "_user._name";
t_xb.ValueMember = "_user._name";
}
public void GetConnected()//创建一个OleDbConnection
{
try
{
string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = user.mdb";
OleDbConnection myConn = new OleDbConnection(strCon);
string strCom = " SELECT * FROM _user ";
myDataSet = new DataSet();//创建一个DataSet
myConn.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);//用OleDbDataAdapter 得到一个数据集
myCommand.Fill(myDataSet, "_user");//把Dataset 绑定_user 数据表
myConn.Close();//关闭此OleDbConnection
myBind = this.BindingContext[myDataSet, "_user"];
}
catch (Exception e)
{
MessageBox.Show("连接错误! " + e.ToString(), "错误");
}
}