CODEWITHSUNDEEP
c#
CamlCase
CamlCase

Reputation: 191

C# insert into Access database

I have a simple user interface for an inventory database. The operation will be insert into, edit existing, view data grid, etc....There are a total of 4 fields for the inventory. The insert statement I am using works but if one of the entries does not have a value then it shows an error when trying to insert.

" Data type mismatch in criteria expression " 

command.CommandText = "insert into Inventory(SerialNumber,PartNumber,ROnumber,Location) 
    values ('" + txtPart.Text + "','" + txtSerial.Text + "','" +
    txtRO.Text + "','" + txtLocation.Text + "')";

I assume it is because the code needs a value for each field so how do I get around this issue?.

Upvotes: 0

Views: 82

Answers (1)

Mohit S
Mohit S

Reputation: 14064

Actually when you trying to use this query you have said the First Parameter is SerialNumber and then PartNumber and when you are passing its reverse. 

command.CommandText = "insert into Inventory(SerialNumber,PartNumber,ROnumber,Location) 
                            values ('" + txtPart.Text + "','" + 
                                         txtSerial.Text + "','" + 
                                         txtRO.Text + "','" + 
                                         txtLocation.Text + "')";

Due to this reason the fields you are entering have different size May be part number is bigger in size instead of SerialNumber or vice versa. So you should change it to 

command.CommandText = "insert into Inventory(SerialNumber,PartNumber,ROnumber,Location) 
                            values ('" + txtSerial.Text + "','" + 
                                         txtPart.Text + "','" + 
                                         txtRO.Text + "','" + 
                                         txtLocation.Text + "')";

Upvotes: 1

Related Questions