Assalam Allekum;
maine C Sharp p Access2016 ki database use kr k ek sales based project banaya hai jis jis main mujhe ek jaga error ka issue arha hai agar kisi ko pata hai to kindly mjhe guide karen. error yeh hai;
System.Data.OleDb.OleDbException: 'Data type mismatch in criteria expression.'
aur mera code;
Code:
Private void btnSave_Click(object sender, EventArgs e)
{
string InsertPur = "insert into AddCompany (CompanyCode,CompanyName,ContactPerson,Designation,CompanyAddress,TelephoneNo,WhatsAppNo,FacebookPage,CompanyPOBox,EmailAddress,CompanyWebsite,CompanyStatus,CreatedDate,CreatedBy) values ('" + txtCompanyID.Text + "', '" + txtCompanyName.Text + "','" + txtContactPerson.Text + "','" + txtDesignation.Text + "','" + txtCompanyAddress.Text + "','" + txtTelephone.Text + "','" + txtWhatsapp.Text + "','" + txtFacebook.Text + "','" + txtPOBox.Text + "','" + txtEmail.Text + "','" + txtWebsite.Text + "','" + Status + "','"+datepicker.Text+"','"+lblLoginID.Text+"')";
OleDbDataAdapter da = new OleDbDataAdapter(InsertPur, con);
DataSet ds = new DataSet();
da.Fill(ds); //Yahan error show ho rha hai
ViewData();
MetroMessageBox.Show(this, "User created successfully");
clearData();
txtCompanyName.Focus();
}
Bookmarks