Databases
StackOverflow2013
Postsdbo
POerror in converting datatype nvarchar to bigint
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POerror in converting datatype nvarchar to bigint
    text
    copied!<p>this code is giving me error: </p> <pre><code>error in converting datatype nvarchar to bigint </code></pre> <p>this is my table values:</p> <pre> @customer_first_name nvarchar(50), @customer_last_name nvarchar(50), @customer_address nvarchar(max), @gender nchar(10), @date_of_birth datetime, @customer_email_id varchar(50), @customer_occuption varchar(50), @customer_phone_number Bigint, @nominee_name nchar(50), @customer_id nvarchar(50), @account_type nvarchar(50), @account_number nvarchar(50), @transfer_access_code nvarchar(50), @account_balance Bigint, @pin_code BigInt, @nationality nvarchar(50), @password nvarchar(50) </pre> <pre><code>lblAmount.Text = HFamount .Value ; int balamount = Convert.ToInt32(lblAmount.Text); int Cpincode = Convert.ToInt32(txtpincode.Text); long phone = Convert.ToInt64(txtphone.Text); string cust_id = CUSTOMER_ID_GENERATOR(); string sqlquery = "INSERT INTO customer_details values(@customer_first_name,@customer_last_name,@customer_address,@gender,@date_of_birth,@customer_email_id,@customer_occuption,@customer_phone_number,@nominee_name,@customer_id,@account_type,@account_number,@transfer_access_code,@account_balance,@pin_code,@nationality,@password)"; string strconstring = ConfigurationManager.ConnectionStrings["ONLINE_BANKING2_ConnectionString"].ConnectionString; SqlConnection mycon = new SqlConnection(strconstring); mycon.Open(); SqlCommand cmdRegister= new SqlCommand(sqlquery,mycon); cmdRegister.Parameters.Add(new SqlParameter("@customer_first_name",txtcustname.Text.ToString())); cmdRegister.Parameters.Add(new SqlParameter("@customer_last_name",txtcustlastname.Text.ToString())); cmdRegister.Parameters.Add(new SqlParameter("@customer_address",txtAddress.Text.ToString())); cmdRegister.Parameters.Add(new SqlParameter("@gender", rbtngender.SelectedItem.Value.ToString())); cmdRegister.Parameters.Add(new SqlParameter("@date_of_birth", txtDOB.Text)); cmdRegister.Parameters.Add(new SqlParameter("@customer_email_id", txtemail.Text.ToString())); cmdRegister.Parameters.Add(new SqlParameter("@customer_occuption", txtcustoccupation.Text.ToString())); cmdRegister.Parameters.Add(new SqlParameter("@customer_phone_number", phone)); cmdRegister.Parameters.Add(new SqlParameter("@nominee_name", txtnominee.Text.ToString())); cmdRegister.Parameters.Add(new SqlParameter("@customer_id", cust_id)); cmdRegister.Parameters.Add(new SqlParameter("@account_type", accType.SelectedItem.Value.ToString())); cmdRegister.Parameters.Add(new SqlParameter("@account_number", ACCOUNT_NUMBER_GENERATOR())); cmdRegister.Parameters.Add(new SqlParameter("@transfer_access_code",Transfer_code())); cmdRegister.Parameters.Add(new SqlParameter("@account_balance", balamount)); cmdRegister.Parameters.Add(new SqlParameter("@pin_code", Cpincode)); cmdRegister.Parameters.Add(new SqlParameter("@nationality", DropCountry.SelectedItem.Value.ToString())); cmdRegister.Parameters.Add(new SqlParameter("@password",txtpasswd2.Text.ToString())); cmdRegister.ExecuteNonQuery(); mycon.Close(); </code></pre> <p>please help me </p> <p>only views on reply </p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload