Database connetivity in vb.net with sql server2005

Question

vb.net database with sql server

Dorababu Meka · Answer

Dim connectionString As String = Data Source=.;Initial Catalog=pubs;Integrated Security=True Dim sql As String = SELECT * FROM tablename Dim connection As New SqlConnection(connectionString) connection.Open() //remaining code of yours if you are retrieving from app.config file then you can use as follows Dim FilePath As String = ConfigurationManager.AppSettings(ConnectionString)

sathish kumar · Answer

using System.Data.SqlClient; string dbconn= configurationManager.connectionstrings[Db].connectionstring sqlconnection conn= new sqlconnection(dbconn) conn.open() sqlcommand cmd=new sqlcommand(Queryconn) cmd.executeNonquery() conn.close() Hope u can understand now.....