Not insert in image
Please give me a answer
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pradip PandeyPosted Mar 22, 2013, 5:06 AM
Hope it will help you.
jayani chathurikaPosted Mar 22, 2013, 4:28 AM
How to solve in this message
Pradip PandeyPosted Mar 22, 2013, 2:24 AM
sql1 = "INSERT INTO PersonalInformation(NIC_No,Finger_Print_No,Emp_No,Mr_Mrs,Initial,Surname,Name,Designation,
Office_tel_no,Residence_No,Mobile_No,Gender,Residence_Address,District,Date_Of_Birth,Age,
Marital_Status,Passport_No,E_mail,Path,Register) VALUES('" + txtnicno.Text + "','" + txtfingerprintno.Text + "','" + txtempno.Text + "','" + ddlmr.Text + "','" + txtinitial.Text + "','" + txtsurname.Text + "','" + txtName.Text + "','" + ddldesignation.Text + "', '" + txtofficetelno.Text + "','" + txtresidencetelno.Text + "','" + txtmobileno.Text + "','" + ddlgender.Text + "','" + txtresidenceaddress.Text + "','" + ddldistrict.Text + "','" + txtdob.Text + "','" + txtage.Text + "','" + txtdob.Text + "','" + txtpassportno.Text + "','" + txtemail.Text + "', '" + txtPath.Text + "','" + txtRegister.Text + "' )"
Hope it will help you.
jayani chathurikaPosted Mar 22, 2013, 1:44 AM
Pradip PandeyPosted Mar 22, 2013, 1:38 AM
Path & register fields are not inserting because you are not passing the values for these 2 fields in your insert statement.Please check it.
Hope it will help you.