title: Visual Studio error cannot call method on int
body: <p>Just Trying to insert some simple data into a table but every time I try I get the error "cannot call method on int". Here is my code, thanks for any help data types in table are int for cinema Id and nvarchar(50) for ReviewText</p>
  
  <pre><code>protected void BtnSubmitReview_Click(object sender, EventArgs e)
      {
          try
          {           
              System.Data.SqlClient.SqlConnection sqlConnection1 = new System.Data.SqlClient.SqlConnection("RegistrationConnectionString");
  
              System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
              cmd.CommandType = System.Data.CommandType.Text;
  
              cmd.CommandText = "INSERT INTO ReviewText (ReviewText.CinemaID, ReviewText.ReviewText) VALUES (1, 'NorthWestern')";
              cmd.Connection = sqlConnection1;
  
              sqlConnection1.Open();
              cmd.ExecuteNonQuery();
              sqlConnection1.Close();
  
              Response.Write("Your Review was saved");                
          }
          catch (Exception ex)
          {
              Response.Write("Error" + ex.ToString());
          }
  </code></pre>
  
  <p>Error Shown:</p>
  
  <blockquote>
    <p>Cannot call methods on int.</p>
  </blockquote>
  
  <p>Description: </p>
  
  <blockquote>
    <p>An unhandled exception occurred during the execution of the current
    web request. Please review the stack trace for more information about
    the error and where it originated in the code.</p>
  </blockquote>
  
  <p>Exception Details: </p>
  
  <blockquote>
    <p>System.Data.SqlClient.SqlException: Cannot call methods on int.</p>
  </blockquote>
  
  <p>Source Error: </p>
  
  <blockquote>
    <p>An unhandled exception was generated during the execution of the
    current web request. Information regarding the origin and location of
    the exception can be identified using the exception stack trace below.</p>
  </blockquote>
  
  <p>Stack Trace: </p>
  
  <blockquote>
    <p>[SqlException (0x80131904): Cannot call methods on int.]<br>
    System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
    Boolean breakConnection, Action<code>1 wrapCloseInAction) +1767866<br>
    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
    exception, Boolean breakConnection, Action</code>1 wrapCloseInAction)
    +5352418    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
    stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +244<br>
    System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior,
    SqlCommand cmdHandler, SqlDataReader dataStream,
    BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
    stateObj, Boolean&amp; dataReady) +1691<br>
    System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +61<br>
    System.Data.SqlClient.SqlDataReader.get_MetaData() +90<br>
    System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
    RunBehavior runBehavior, String resetOptionsString) +365<br>
    System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
    async, Int32 timeout, Task&amp; task, Boolean asyncWrite, SqlDataReader
    ds) +1406<br>
    System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
    method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task,
    Boolean asyncWrite) +177<br>
    System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
    cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
    method) +53<br>
    System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
    behavior, String method) +134<br>
    System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior
    behavior) +41<br>
    System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior
    behavior) +10    System.Data.Common.DbDataAdapter.FillInternal(DataSet
    dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords,
    String srcTable, IDbCommand command, CommandBehavior behavior) +140<br>
    System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
    startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
    CommandBehavior behavior) +316</p>
  </blockquote>