adspace


How to Insert a TextBox value in to Sql database using
VB.Net coding?

Answer Posted / anusuya

dim con as new sqlconnection
dim da as sqldataadapter
dim ds as new dataset
dim str as string

con.connectionstring="server=localhost;uid=sa;pwd=;database=
Hospital"
con.open
str="insert into patient values('" & lblid.Text & "','" &
txtname.Text & "','" & rtxtaddress.Text & "','" &
DateTimePicker1.Text & "','" & cmbgender.Text & "','" &
txtphone.Text & "','" & txtemcon.Text & "','" &
txtdoreg.Text &"')"
da=new sqldataadpter(str,con)
da.fill(ds,"patient")
msgbox "New Row inserted"
con.close

Is This Answer Correct ?    30 Yes 24 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is early binding?

1016


Explain how can we remove handlers at run time?

1077


What is the use of assembly?

1081


How to retrieve images in sql server database through vb.net?

1043


What are the features of c# which are not present in vb.net?

1185


What is option strict?

1214


Explain the difference between system.string and system.stringbuilder classes?

1082


Explain an assembly?

1059


How to send xml file on server using http protocol?

1077


How to store images in sql server database through vb.net?

1025


Explain the difference between datatable and dataset?

1423


How can I extract the formated word(bold,italic,underline,font,color etc) from the msword file.?

1108