Convert textbox text to integer Convert textbox text to integer sql-server sql-server

Convert textbox text to integer


Suggest do this in your code-behind before sending down to SQL Server.

 int userVal = int.Parse(txtboxname.Text);

Perhaps try to parse and optionally let the user know.

int? userVal;if (int.TryParse(txtboxname.Text, out userVal) {  DoSomething(userVal.Value);}else{ MessageBox.Show("Hey, we need an int over here.");   }

The exception you note means that you're not including the value in the call to the stored proc. Try setting a debugger breakpoint in your code at the time you call down into the code that builds the call to SQL Server.

Ensure you're actually attaching the parameter to the SqlCommand.

using (SqlConnection conn = new SqlConnection(connString)){    SqlCommand cmd = new SqlCommand(sql, conn);    cmd.Parameters.Add("@ParamName", SqlDbType.Int);    cmd.Parameters["@ParamName"].Value = newName;            conn.Open();    string someReturn = (string)cmd.ExecuteScalar();        }

Perhaps fire up SQL Profiler on your database to inspect the SQL statement being sent/executed.


You don't need to write a converter, just do this in your handler/codebehind:

int i = Convert.ToInt32(txtMyTextBox.Text);

OR

int i = int.Parse(txtMyTextBox.Text);

The Text property of your textbox is a String type, so you have to perform the conversion in the code.


Example:

int x = Convert.ToInt32(this.txtboxname.Text) + 1 //You dont need the "this"txtboxname.Text = x.ToString();

The x.ToString() makes the integer into string to show that in the text box.

Result:

  1. You put number in the text box.
  2. You click on the button or something running the function.
  3. You see your number just bigger than your number by one in your text box.

:)