title: cmd.ExecuteNonQuery value of i integer is going -1 from 0
body: <p>Here i create table in database dynamically.
  User enters name as his wish and selects language radiobutton.
  So problem is after executing cmd.ExecuteNonQuery value of i integer is going -1 from 0. And shows that table couldnt be created but when i go to database its already created successfully. Please let me know where i am doing wrong. Thanx in Advance !!</p>
  
  <pre><code>protected void btnpaper_Click(object sender, EventArgs e)
      {
          try
          {                
                  string conn = ConfigurationManager.ConnectionStrings["sqlconn"].ConnectionString;
                  SqlConnection con = new SqlConnection(conn);
                  con.Open();
                  char[] arr = new char[] {'n','g','l','i','s','h'};
                  string str = "CREATE TABLE " + Label1.Text.Trim() + 
                               txtpaperset.Text.Trim()+ rbtnEng.Text.TrimEnd(arr) +
                               "(" + "quesNo int NOT NULL PRIMARY KEY, " + 
                               "question varchar(1000) NOT NULL," + 
                               "ansA varchar(500) NOT NULL, " + 
                               "ansB varchar(500) NOT NULL, " + 
                               "ansC varchar(500) NOT NULL, " + 
                               "ansD varchar(500) NOT NULL, " + 
                               "rightAns varchar(50) NOT NULL " + ")";                    
                  SqlCommand cmd = new SqlCommand(str, con);
                  int i = cmd.ExecuteNonQuery();
                  if (i &gt; 0)
                  {
                      lblerrormsg.Visible = true;
                      con.Close();
                  }
                  else
                  {
                      lblerrormsg.Text = "Table Not Created Please Try with Different Name!";                        
                      con.Close();
                  }                
  
          }
          catch (System.Exception excep)
          {
              MessageBox.Show(excep.Message);
          }      
      }
  </code></pre>