C# insert into Access database

Question

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?.

Are all this numbers of data type string in the database table? If not, I think you dont need the single-quotes enclosing the variables.. also if any of your fields does not have data you can then pass null values (assuming the fields are nullable in the table) — vmachan
– vmachan, Commented Jan 4, 2016 at 1:11
@ vmachan..No, they would be alpha-numeric actually. I will try that one — CamlCase
– CamlCase, Commented Jan 4, 2016 at 1:16

Mohit S · Accepted Answer · 2016-01-04 01:26:42Z

1

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 + "')";

edited Jan 4, 2016 at 1:26

answered Jan 4, 2016 at 1:23

Mohit S

14.1k6 gold badges36 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

CamlCase Over a year ago

Thank you,,,yes I guess when I have them reversed it would cause a problem.

Collectives™ on Stack Overflow

C# insert into Access database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related