3
Answers

Data type mismatch in criteria expression exception

Atul Rokade

Atul Rokade

8y
412
1
while inserting null datetime into access database its giving me 
Data type mismatch in criteria expression exception  
 
string bank = txtbankname.Text;
bank = "";
string cheque = txtchequeno.Text;
cheque = "";
string billno = txtbillno.Text;
billno = "";
string codecreate = txtcodecreator.Text;
codecreate = "";
string connetionString = null;
connetionString = ConfigurationManager.ConnectionStrings["AccessConnectionString"].ConnectionString;
cnn.ConnectionString = connetionString;
string SqlString = "Insert Into Billing([FormNo],[Date],[TruckNo],[Office_Code],[Party_Code],[Party_Code1],[Location],[Supplier],[Item],[Invoice_no],[Invoice_date],[Package],[Weight],[Invest_Amount],[Percentage],[Amount],[Total_Amount],[Payment_Amount],[Payment_Type],[Bank_Name],[Cheque_No],[Cheque_Date],[Bill_No],[Bill_Date],[Code_Create]) Values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
using (cmd = new OleDbCommand(SqlString, cnn))
{
cnn.Open();
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@FormNo", txtformno.Text);
cmd.Parameters.AddWithValue("@Date", txtdate.Text);
cmd.Parameters.AddWithValue("@TruckNo", txttruck.Text);
cmd.Parameters.AddWithValue("@Office_Code", txtofficecode.Text);
cmd.Parameters.AddWithValue("@Party_Code", txtpartycode.Text);
cmd.Parameters.AddWithValue("@Party_Code1", txtpartycode1.Text);
cmd.Parameters.AddWithValue("@Location", txtlocation.Text);
cmd.Parameters.AddWithValue("@Supplier", txtsupplier.Text);
cmd.Parameters.AddWithValue("@Item", txtitem.Text);
cmd.Parameters.AddWithValue("@Invoice_no", txtinvoice.Text);
cmd.Parameters.AddWithValue("@Invoice_date", DateTime.Parse(txtmaskinvoice.Text));
cmd.Parameters.AddWithValue("@Package", txtpackage.Text);
cmd.Parameters.AddWithValue("@Weight", txtwieght.Text);
cmd.Parameters.AddWithValue("@Invest_Amount", Convert.ToDouble(txtinvestamount.Text));
cmd.Parameters.AddWithValue("@Percentage", txtpercentage.Text);
cmd.Parameters.AddWithValue("@Amount", Convert.ToDouble(txtamount.Text));
cmd.Parameters.AddWithValue("@Total_Amount", Convert.ToDouble(txttotalamount.Text));
cmd.Parameters.AddWithValue("@Payment_Amount", Convert.ToDouble(txtpaymentamount.Text));
cmd.Parameters.AddWithValue("@Payment_Type", txtpaymenttype.Text);
if (txtbankname.Text == "")
{
cmd.Parameters.AddWithValue("@Bank_Name", bank);
}
else
{
cmd.Parameters.AddWithValue("@Bank_Name", txtbankname.Text);
}
if (txtchequeno.Text == "")
{
cmd.Parameters.AddWithValue("@Cheque_No", cheque);
}
else
{
cmd.Parameters.AddWithValue("@Cheque_No", txtchequeno.Text);
}
DateTime chequeDate;
if (DateTime.TryParse(txtmaskchequedate.Text, out chequeDate))
{
cmd.Parameters.AddWithValue("@Cheque_Date", chequeDate);
}
else
{
// cmd.Parameters.AddWithValue("@Cheque_Date", DateTime.TryParse(txtmaskchequedate.Text,out value1));
cmd.Parameters.AddWithValue("@Cheque_Date", DBNull.Value);
}
if (txtbillno.Text == "")
{
cmd.Parameters.AddWithValue("@Bill_No", billno);
}
else
{
cmd.Parameters.AddWithValue("@Bill_No", txtbillno.Text);
}
DateTime BillDate;
if (DateTime.TryParse(txtmaskbilldate.Text, out BillDate))
{
cmd.Parameters.AddWithValue("@Bill_Date", BillDate);
}
else
{
cmd.Parameters.AddWithValue("@Bill_Date", DBNull.Value);
}
if (txtcodecreator.Text == "")
{
cmd.Parameters.AddWithValue("@Code_Create", codecreate);
}
else
{
cmd.Parameters.AddWithValue("@Code_Create", txtcodecreator.Text.ToString());
}
int n = cmd.ExecuteNonQuery();
cnn.Close();
if (n > 0)
{
MessageBox.Show("Data Inserted Successfully", "Data Inserted ", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
 

Answers (3)