hi to all out there.

I want to know that how i insert text box values into database.mean same whatever he write .i have to insert entered first name and last name into database. first name and lastname are content entered by use

this is what i did...........

Dim Str As String = "INSERT INTO tablename (username, password) Values(Text1Box1.text,textbox2.text)"

please tell where i am going wrong

When Str is passed to the database it is passed, literally, as:

INSERT INTO tablename (username, password) Values(Text1Box1.text,textbox2.text)

To correct this you will want to do something like this:
Dim Str As String = "INSERT INTO tablename (username, password) Values('" & Text1Box1.text & "','" & textbox2.text &"')"

Also, I would consider using some sort of parametertized query (such as a stored procedure) since this type of dynamic SQL leaves your application wide open for SQL Injection.

hth.
-Doug

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

can you make me understand why we did so mean only this one
('" & Text1Box1.text & "','" & textbox2.text &"')"

waiting for reply

Hmm. It is the basic concept of string concatenation; consider the following:

'For the purposes below, assume the Text property of TextBox1 contains the value Hello
Dim someString as String = TextBox1.Text
Dim someString2 as String = "TextBox1.Text"
Dim someString3 as String = someString & " " & someString2

Console.WriteLine(someString) 'Outputs: Hello
Console.WriteLine(someString2) 'Outputs TextBox1.Text
Console.WriteLine(someString3) 'Outputs Hello TextBox1.Text

So, in your example:
Dim Str As String = "INSERT INTO tablename (username, password) Values(Text1Box1.text,textbox2.text)"

The string INSERT INTO tablename (username, password) Values(Text1Box1.text,textbox2.text) is passed to the database because you have defined it as a string literal (everything is wrapped in " ") to actually appened your values to the string you need to use the Concatenate operator (&) as I outlined in my previous post.

The reason for the ' that directly preceed and follow " is because that is how most databases interpet string values. If you change my code to:

Dim Str As String = "INSERT INTO tablename (username, password) Values(" & Text1Box1.text & "," & textbox2.text &")"

A string that looks something like the following will be passed in:
INSERT INTO tablename (username, password) Values(SomeUsername, SomePassword)

Which is obviously an error. My original code will pass a sting into your database that looks like this:
INSERT INTO tablename (username, password) Values('SomeUsername', 'SomePassword') which is valid.

Does that make sense?

hth.
Doug

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

thanks allot for explaining.

once again thanks