Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / deepmala soni

Dim myConnection As SqlConnection
Dim myCommand As SqlCommand
Dim ra as Integer
'integer holds the number of records inserted
myConnection = New SqlConnection
("server=localhost;uid=sa;pwd=;database=Hospital")
'you need to provide password for sql server
myConnection.Open()
mycommand = New SqlCommand("INSERT INTO Patient
(ID,Name,address,DateofBirth,Gender,Phone,Emergencycontact,D
ateofRegistration) VALUES('" + lblid.Text + "','" +
txtname.Text + "','" + rtxtaddress.Text + "','" +
DateTimePicker1.Text + "','" + cmbgender.Text + "','" +
txtphone.Text + "','" + txtemcon.Text + "','" +
txtdoreg.Text + "')", myconnection)
ra=myCommand.ExecuteNonQuery()
MessageBox.Show("New Row Inserted" & ra)
myConnection.Close()

Is This Answer Correct ?    46 Yes 18 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Name and explain some of the exclusive features which are present in vb?

919


What are all the parts of .net framework?

921


what is difference between namespace and assembly?

1028


Explain what observations between vb.net and vc#.net?

905


What is an assembly and its use?

954


what is the advantage of option strict on?

1010


Write a VB.Net console program to check whether a number is perfect or not.

7710


What do you mean by Redim in VB.NET?

1113


i have two class that contain's two methods as same name in derived class i have to call these two methods what will happen at run time ?

2613


How to connect crystal report in vb.net ?

889


Explain convert.tostring and i.tostring method?

877


Explain the difference between value and reference types?

841


Before in my vb app I would just load the icons from dll. How can I load the icons provided by .net dynamically?

928


What are the shadow variables?

1006


Explain about globalization?

819