Hello,

I am new to ASP.NET. I have a table(users) in the database.
I placed two textboxes on the webform(txtUID, txtUName)

how can i insert this values to my users table.

like ... "insert into users(userid,username) values('" & txtUID.text & "','"
& txtUName.text & "')"

how can i execute this query?

thanks in advance

Hi,
Hoping that you want to submit data to the SQL Server, i am giving you a
sample code. Please refer it and read relative topics from MSDN too

like try- catch for error capturing etc.

Dim conn As New SqlConnection

conn.ConnectionString = "Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=DBName;Data Source=localhost"

conn.Open()

Dim cmd As New SqlCommand

cmd.Connection = conn

cmd.CommandText = "insert into users(userid,username) values('" &
txtUID.text & "','" & txtUName.text & "')"

cmd.ExecuteNonQuery()

conn.Close()

Thanks & Regards,
Mangesh

"Rajani" wrote:

"Rajani" wrote:

I'll offer some advice based on experience. You want to avoid such dynamic
text queries as much as possible. I recommend learning stored procedures and
looking up SQL Injection to learn of the security hazards of dynamic text
queries.

"Rajani" wrote: