public void LinkData(DataSet sd)
{
OleDbConnection thisOleDb = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\C#练习\宽带安装登记表\工作人员登记表.mdb");
thisOleDb.Open();
OleDbDataAdapter thisOleDat = new OleDbDataAdapter("SELECT * FROM 工作人员登陆库", thisOleDb);
OleDbCommandBuilder thisOleDbBer = new OleDbCommandBuilder(thisOleDat);
DataSet1 thisDset = new DataSet1();
thisOleDat.Fill(thisDset, "工作人员登陆库");
DataColumn[] keys = new DataColumn[1];
keys[0] = thisDset.Tables["工作人员登陆库"].Columns["用户名"];
thisDset.Tables["工作人员登陆库"].PrimaryKey = keys;
sd = thisDset;
return ;
}
超越自我(331361969) 19:27:08
然后调用是.
超越自我(331361969) 19:27:29
DataSet1 sd = new DataSet1 ();
this.LinkData(sd); DataRow findrow = sd.Tables["工作人员登陆库"].Rows.Find(textBox1.Text); if (findrow == null)
{
if (MessageBox.Show(textBox1.Text + "用户名不存在", "错误信息!", MessageBoxButtons.OKCancel, MessageBoxIcon.Error)
== DialogResult.OK)
{
textBox1.Text = "";
textBox2.Text = "";
textBox1.Focus();
}
else
{
textBox2.Text = "";
}
这样调用行吗?高手帮我看看。不对请指正.
{
OleDbConnection thisOleDb = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\C#练习\宽带安装登记表\工作人员登记表.mdb");
thisOleDb.Open();
OleDbDataAdapter thisOleDat = new OleDbDataAdapter("SELECT * FROM 工作人员登陆库", thisOleDb);
OleDbCommandBuilder thisOleDbBer = new OleDbCommandBuilder(thisOleDat);
DataSet1 thisDset = new DataSet1();
thisOleDat.Fill(thisDset, "工作人员登陆库");
DataColumn[] keys = new DataColumn[1];
keys[0] = thisDset.Tables["工作人员登陆库"].Columns["用户名"];
thisDset.Tables["工作人员登陆库"].PrimaryKey = keys;
sd = thisDset;
return ;
}
超越自我(331361969) 19:27:08
然后调用是.
超越自我(331361969) 19:27:29
DataSet1 sd = new DataSet1 ();
this.LinkData(sd); DataRow findrow = sd.Tables["工作人员登陆库"].Rows.Find(textBox1.Text); if (findrow == null)
{
if (MessageBox.Show(textBox1.Text + "用户名不存在", "错误信息!", MessageBoxButtons.OKCancel, MessageBoxIcon.Error)
== DialogResult.OK)
{
textBox1.Text = "";
textBox2.Text = "";
textBox1.Focus();
}
else
{
textBox2.Text = "";
}
这样调用行吗?高手帮我看看。不对请指正.
找不到数据库啊!