How to insert data to database using TextBox?

[ninjaX]

i have a problem for the INSERT part. :( :(

i only know how to add data into database...like:

 

		SqlCommand myCommand = new SqlCommand("Insert into employee(id, name, pass) values('1','John','aaa')", sqlConnection1);

 

but, i don't know how to use the TextBox insert data to database. What is the codes for the VALUES part? Who know can help me???

[Robby]

Assuming that the ID column is numeric you may want to get rid of the single quotes and converting the value to Int, I'm not sure of any J# syntax....

 

SqlCommand myCommand = new SqlCommand("Insert into employee(id, name, pass) values(" + Convert.ToInt32(TextBoxID.Text) + ",'" + TextBox1.Text + "','" + TextBox2.Text + "')", sqlConnection1);

[ninjaX]

Assuming that the ID column is numeric you may want to get rid of the single quotes and converting the value to Int, I'm not sure of any J# syntax....

 

SqlCommand myCommand = new SqlCommand("Insert into employee(id, name, pass) values(" + Convert.ToInt32(TextBoxID.Text) + ",'" + TextBox1.Text + "','" + TextBox2.Text + "')", sqlConnection1);

 

i think this one is use at the VB.NET one

because J# dont have .text one

[ninjaX]

thanks....

but i tried already still cannot add-in database.

This is my new changing codes:

 

SqlCommand myCommand = new SqlCommand("Insert into employee(id, name, pass) values(" + textBox1.get_Text() + "," + textBox2.get_Text() + "," + textBox3.get_Text() + ")", sqlConnection1);

 

who know abt the J# syntax??? can somebody help me...

[Robby]

In J# it's TextBox1.set_Text and .get_Text

This may help http://samples.gotdotnet.com/quickstart/latebreaking/default.aspx?url=/quickstart/latebreaking/quickstartinfo.aspx?id=1081&lang=VJS

[Robby]

You need the single quotes to surround your variables

[ninjaX]

ok..thanks.