请教错误 :System.Data.OleDb.OleDbException 至少一个参数没有被指定值。
KeHuShuJuBiao = new System.Data.OleDb.OleDbDataAdapter();
Ds = new DataSet();
OleDbSelectCom = new System.Data.OleDb.OleDbCommand();
OleDbInsertCom = new System.Data.OleDb.OleDbCommand();
OleDbUpdateCom = new System.Data.OleDb.OleDbCommand();
OleDbDeleteCom = new System.Data.OleDb.OleDbCommand();
KeHuShuJuBiao.DeleteCommand = OleDbDeleteCom;
KeHuShuJuBiao.InsertCommand = OleDbInsertCom;
KeHuShuJuBiao.SelectCommand = OleDbSelectCom;
KeHuShuJuBiao.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "CustomerInformationSheet", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("HomeNummber", "HomeNummber"),
new System.Data.Common.DataColumnMapping("CustomerName", "CustomerName"),
new System.Data.Common.DataColumnMapping("Sex", "Sex"),
new System.Data.Common.DataColumnMapping("IDtype", "IDtype"),
new System.Data.Common.DataColumnMapping("IDnumber", "IDnumber"),
new System.Data.Common.DataColumnMapping("Phone", "Phone"),
new System.Data.Common.DataColumnMapping("CheckInTime", "CheckInTime"),
new System.Data.Common.DataColumnMapping("CheckInDays", "CheckInDays"),
new System.Data.Common.DataColumnMapping("Deposit", "Deposit")
})
});
KeHuShuJuBiao.UpdateCommand = OleDbUpdateCom;
OleDbSelectCom.CommandText = "SELECT HomeNummber, CustomerName, Sex, IDtype,IDnumber, Phone, CheckInTime, CheckInDays, Deposit FROM CustomerInformationSheet";
OleDbSelectCom.Connection = Conn;
//
// OleDbInsertCommand1
//
OleDbInsertCom.CommandText = @"INSERT INTO CustomerInformationSheet(HomeNummber, CustomerName, Sex, IDtype,IDnumber, Phone, CheckInTime, CheckInDays,Deposit) VALUES (@HomeNummber, @CustomerName, @Sex, @IDtype, @IDnumber, @Phone, @CheckInTime, @CheckInDays, @Deposit)";
OleDbInsertCom.Connection = Conn;
OleDbInsertCom.Parameters.Add(new System.Data.OleDb.OleDbParameter("@HomeNumber", System.Data.OleDb.OleDbType.VarChar, 6, "HomeNumber"));
OleDbInsertCom.Parameters.Add(new System.Data.OleDb.OleDbParameter("@CustomerName", System.Data.OleDb.OleDbType.VarChar, 20, "CustomerName"));
OleDbInsertCom.Parameters.Add(new System.Data.OleDb.OleDbParameter("@IDtype", System.Data.OleDb.OleDbType.VarChar, 30, "IDtype"));
OleDbInsertCom.Parameters.Add(new System.Data.OleDb.OleDbParameter("@Sex", System.Data.OleDb.OleDbType.VarChar, 6, "Sex"));
OleDbInsertCom.Parameters.Add(new System.Data.OleDb.OleDbParameter("@IDnumber", System.Data.OleDb.OleDbType.Date, 8, "IDnumber"));
OleDbInsertCom.Parameters.Add(new System.Data.OleDb.OleDbParameter("@Phone", System.Data.OleDb.OleDbType.Date, 8, "Phone"));
OleDbInsertCom.Parameters.Add(new System.Data.OleDb.OleDbParameter("@CheckInTime", System.Data.OleDb.OleDbType.VarChar, 60, "CheckInTime"));
OleDbInsertCom.Parameters.Add(new System.Data.OleDb.OleDbParameter("@CheckInDays", System.Data.OleDb.OleDbType.VarChar, 10, "CheckInDays"));
OleDbInsertCom.Parameters.Add(new System.Data.OleDb.OleDbParameter("@Deposit", System.Data.OleDb.OleDbType.VarChar, 24, "Deposit"));
KeHuShuJuBiao.Fill(Ds, "CustomerInformationSheet");问题出在这句
Dt = Ds.Tables["CustomerInformationSheet"];
dataGridView1.DataSource = Dt;
dataGridView1.DataMember = "";