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 dont 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, Im 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, Im 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# its 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.