title: Error converting data type varchar to bigint (C# ASP.NET)
body: <p>I'm trying to store a Int64 variable to data column with bigint data type. Following is my sql insert query and parameter declarations.</p>
  
  <pre><code>cmd.CommandText = "INSERT INTO tbl_subscribers VALUES ('@callerID2', '@timeStamp', '@unregisterDate ', '1')";
  
  cmd.Parameters.Add("@callerID2", SqlDbType.BigInt);
          cmd.Parameters["@callerID2"].Value = SMSObject.callerID;
          cmd.Parameters.Add("@timeStamp", SqlDbType.DateTime);
          cmd.Parameters["@timeStamp"].Value = SMSObject.timeStamp.ToString("yyyy-MM-dd HH:mm:ss");
          cmd.Parameters.Add("@unregisterDate", DBNull.Value);
          cmd.Parameters["@unregisterDate"].Value = DBNull.Value;
  </code></pre>
  
  <p>When it try to store the data, I get </p>
  
  <blockquote>
    <p>Error converting data type varchar to bigint.</p>
  </blockquote>
  
  <p>Any advices?</p>