数据加载到表出错
这句话发生错误:this.immunityTableAdapter.Fill(this.immunityDataSet.immunity);
错误是:No value given for one or more required parameters.(上面还写着未处理OleDbException).到底是什么东西错了啊?请各位指教!
private void button5_Click(object sender, EventArgs e)
{
string[] s = new string[30];
int f = 0;
for (int i = 0; i < 6; i++)
{
for (int j = i + 1; j < 6; j++)
{
Immunity(i, j);
s[f] = ArrayToString(c);
f++;
Immunity(j, i);
s[f] = ArrayToString(c);
f++;
}
}
try
{
string connString = @ "
provider = microsoft.jet.oledb.4.0;
data source = E:\课件\Copy of 人工免疫系统在计算机病毒检测中的应用研究\人工免疫系统在计算机病毒检测中的应用研究\Immunity.mdb;
";
OleDbConnection Conn = new OleDbConnection(connString);
Conn.Open();
for (int i = 0; i < 30; i++)
{
string strInsert = " INSERT INTO Immunity ( code , status , times , age ) VALUES ( ' " + s[i] + " ', '未成熟检测器 ', '0 ', '1 ') ";
OleDbCommand inst = new OleDbCommand(strInsert, Conn);
inst.ExecuteNonQuery();
}
this.immunityTableAdapter.Fill(this.immunityDataSet.immunity);
Conn.Close();
}
catch (Exception error)
{
MessageBox.Show( "连接数据库发生错误为: " + error.ToString(), "错误! ");
}
}
private void Form1_Load(object sender, EventArgs e)
{
// TODO: 这行代码将数据加载到表“immunityDataSet.immunity”中。您可以根据需要移动或移除它。
this.immunityTableAdapter.Fill(this.immunityDataSet.immunity);
}
[解决办法]
窗體一啟動,還沒有連數據庫,
[解决办法]
你用的是数据表控件绑定做的吧,是否是在button5_Click()后出错?如果是,在this.immunityTableAdapter.Fill(this.immunityDataSet.immunity); 前一行加条 this.immunityDataSet.Clear(); 试试。