I am building a database. I use SQL. I want to insert a new row .For that i use insert command. the problem is

Question

For eg:
command=new oledbcommand("INSERT INTO table(COL) VALUES(textbox1.text)
I get a error. Actually my program is not able to get the value from textbox1.text

Answer 1

In C#:

string strSQL = "INSERT INTO tablename (columnname) VALUES '" + textbox1.text + "'";
OleDbCommand command = new OleDbCommand(strSQL);

In VB.NET:

Dim strSQL As String = "INSERT INTO tablename (columnname) VALUES '" + textbox1.text + "'"

Dim command As OleDbCommand = New OleDbCommand(strSQL);

Answer 2

It really depends on what language you are using.

You'll definitely need to quite the text though so it should be

Values('textbox1.text')

You'll also need to substitute in the value of textbox1.text

So you could do:
command = new oledbcommand("INSERT INTO table(COL) VALUES('" & textbox1.text & "')")

(Replace the & with whatever operand for string concatenation is used in your language.

Answer 3

command=new oledbcommand("INSERT INTO table(COL) VALUES('" & textbox1.text & "')

to pass the value from text box, you should concatenate the value with the sql correctly.

Answer 4

hi
your problem is syntax related.

you are about to insert int to field that must be var char type.

try this

insert into table(COL) values('textbook1.text')