ERROR when INSERTING VALUES into SQL database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an ASP.NET web application using C# code. I am trying to insert values
from a web form into an SQL database. I am using SQL COMMAND object for this.

I need to know HOW TO INSERT THE RADIO BUTTON LIST SELECTION entered by the
user in the web form into tha database. for eg. for inserting values from a
text box into the database we write code ::
sqlCommand1.Parameters["@a"].Value =TextBox1.Text
& for inserting integer values we write::
sqlCommand1.Parameters["@a"].Value =int.Parse(TextBox1.Text);

But what for a radio button list ? Also, how to insert value into the field
of SQL table whose datatype instead of text is specified as
1. VARCHAR
2. BIGINT (is it same as int.Parse(TextBox1.Text) )
3. SmallDateTime (is it same as
sqlCommand1.Parameters["@b"].Value=System.DateTime.Parse(TextBox1.Text);

Please help.

Thanks
 
For a radiobuttonlist, use rbl.SelectedValue.

Varchar fields will accept input from textboxes, as long as they are
declared with sufficient size.

Integer types will usually automatically cast string values if they
are simple numeric values.

Some simple experimentation should clarify these issues.

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*
 
Back
Top