Connection with SQL databases

To Connect to a database u need ConnectionString it define the data source and database name

use the following line of code

Dim ConString as string

ConString="Server=Your PC Name;Database=dbname;Integrated Security=SSPI"
dim cnn as new sqlconnection(ConString)
cnn.open()
do something
cnn.close()

what sort of project do you have?

Are you new to .net? Is it a .net project?

You should consider using the data application block in the enterprise library for database connectivity .... it uses patterns in the background to do everything ....

You should be able to find examples easily enough on the web, or on sites like this :)

Hi


Using System.Data.SqlClient;

sqlconnection con = new sqlconnection();
sqldataadapter da = new sqladapter("SQL COMMAND" , con);
dataset ds = new dataset();
da.fill(ds , "table");
grdiview1.datasource = ds.Tables[0].rows[0].Tostring();
grdiview1.DataBind();