Query insert number to access

Question

User810354248 posted

in amy asp.net+vb web with access database i have form to insert data i am using this lines as code

oledbcom.Parameters.Add(New OleDbParameter("@p", OleDbType.VarChar,50)).Value = alauthtxt.Text

but what will come for number field OleDbType.VarChar,50)).Value = alauthtxt.Text

Answer 1

User-1716253493 posted

Try like this

oledbcom.Parameters.AddWithValue("@p",int.Parse(alauthtxt.Text));

Answer 2

User810354248 posted

i had alredy tried this it gives

Compilation Error

Answer 3

User697462465 posted

Hi Baiju EP,

Please don't post duplicate threads, the your thread have already replied by our engineer, the following is the reply content, please try to refer it:

Hi Baiju Ep,

About your problem,please try the code below:

int a =Convert.ToInt32(Lable1.Text);
oledbcom.Parameters.Add(New OleDbParameter("@num", OleDbType.Integer)).Value =a ;

Best Regards,
Terry Guo