Ndtyjky

I am new to C#, so sorry if this is an easy question.
I have a database connected to my datagrid via MS-Access. I have the user input the information and save it to the database. I am having a problem where the "CARD NUMBER" cannot be 16 digits, as it throws an error for data type. thank you in advance!

OleDbCommand updateQuery = new OleDbCommand("INSERT INTO Profiles ([PROFILE NAME],[LOGIN EMAIL],[PASSWORD],[FULL NAME],[CARD NUMBER],[EXP MONTH],[EXP YEAR],CVV) VALUES(@name1,@email,@pass,@name2,@card,@expm,@expy,@cvv)", connection);



updateQuery.Parameters.Add("@name1", OleDbType.Variant).Value = textBox4.Text; //Profile Name

updateQuery.Parameters.Add("@email", OleDbType.Variant).Value = textBox2.Text; //Email

updateQuery.Parameters.Add("@pass", OleDbType.Variant).Value = textBox3.Text;  //Pass

updateQuery.Parameters.Add("@name2", OleDbType.Variant).Value = textBox1.Text; //Full Name

updateQuery.Parameters.Add("@card", OleDbType.VarNumeric).Value = textBox5.Text;  //CardNumber

updateQuery.Parameters.Add("@expm", OleDbType.Numeric).Value = comboBox1.Text; //EXPMonth

updateQuery.Parameters.Add("@expy", OleDbType.Numeric).Value = comboBox2.Text; //EXPYear

updateQuery.Parameters.Add("@cvv", OleDbType.Numeric).Value = textBox7.Text;   //CVV



updateQuery.ExecuteNonQuery();



connection.Close();



MessageBox.Show("Profile Saved");

this.Close();

RefreshDBConnection();

Note: I changed my code to:

updateQuery.Parameters.Add("@card", OleDbType.VarNumeric).Value = textBox5.Text;  //CardNumber

and now it throws an overflow error. Not sure what's happening.

what is the datatype in db, if it is int!!! change it to BigInt and it will work :)

Using BigInt will cause severe limitations as already noted, and using Long Text (Note field) is the worst thing you could do.

So, either use Short Text or Decimal set to hold at least 16 digits: