Reading from and writing to an SQL database

Hi,

Here is a sample code to use sql database in vb.net

Create database using the server explorer tool in visual studio 2008 as

1. Right Click on Data Connection -> Add Connection
If the data source is 'Microsoft SQL Server Database File (SqlClient)'
then just type the database name and click OK

2. Just select the data base file and press F4 it sets focus to database properties
3. Copy the connection sting from properties.
4. Start doing as below,

Dim con As New SqlConnection("Past your connection string here")
dim cmd as sqlcommand
cmd=new sqlcommand("Select * from table_name", con)
'In the above statement I've enter the command text and connection property for the sql command
con.open()
cmd.executenonquery()
con.close()

That is all

Thank You,

Ganesh