try
{
string connectionString = Properties.Settings.Default.dataConnectionString;
int i = 0;
DateTime gendate;
OleDbConnection conn = new OleDbConnection(connectionString);
conn.Open();
while (i < chooselistbox.Items.Count)
{
string sql = "insert into tData(fCode,fGenDate) values(?,?) ";
d.TryGetValue(chooselistbox.Items[i].ToString(), out gendate);
OleDbCommand cmd = new OleDbCommand(sql, conn);
cmd.Parameters.Add("fCode", OleDbType.VarChar).Value = chooselistbox.Items[i];
cmd.Parameters.Add("fGenDate", OleDbType.DBDate).Value = gendate;
cmd.ExecuteNonQuery();
i++;
}
conn.Close();
MessageBox.Show("数据已存入数据库");
}
catch (Exception er)
{
MessageBox.Show("数据存储失败!" + er.Message);
}
{
string connectionString = Properties.Settings.Default.dataConnectionString;
int i = 0;
DateTime gendate;
OleDbConnection conn = new OleDbConnection(connectionString);
conn.Open();
while (i < chooselistbox.Items.Count)
{
string sql = "insert into tData(fCode,fGenDate) values(?,?) ";
d.TryGetValue(chooselistbox.Items[i].ToString(), out gendate);
OleDbCommand cmd = new OleDbCommand(sql, conn);
cmd.Parameters.Add("fCode", OleDbType.VarChar).Value = chooselistbox.Items[i];
cmd.Parameters.Add("fGenDate", OleDbType.DBDate).Value = gendate;
cmd.ExecuteNonQuery();
i++;
}
conn.Close();
MessageBox.Show("数据已存入数据库");
}
catch (Exception er)
{
MessageBox.Show("数据存储失败!" + er.Message);
}
看数据库在什么位置
"urity Info=True"
然后我的数据库是放在可执行文件那个目录的
"urity Info=True"
[email protected]