{"id":2966,"date":"2013-03-10T19:18:47","date_gmt":"2013-03-10T11:18:47","guid":{"rendered":"http:\/\/www.vbtutor.net\/?page_id=2966"},"modified":"2018-06-24T23:02:05","modified_gmt":"2018-06-24T15:02:05","slug":"visual-basic-2010-lesson-30","status":"publish","type":"page","link":"https:\/\/www.vbtutor.net\/index.php\/visual-basic-2010-lesson-30\/","title":{"rendered":"Visual Basic 2010 Lesson 30- Creating Connection to Database"},"content":{"rendered":"

[Lesson 29]<\/a>\u00a0<\/strong><<\u00a0[CONTENTS]<\/a>\u00a0>>[Lesson 31]<\/a>
\n<\/a><\/strong><\/h4>\n

30.1 Creating Connection to a Database using ADO.NET<\/strong><\/h2>\n

In Visual Basic 2010, we need to create the connection to a database before we can access its data. Before we begin, let’s create a new database. Since we are using SQL Server 2008 as the database engine, we will use Microsoft Studio Management Express<\/strong> to create a database with the mdf extension. We shall name this database file as test.mdf. After creating the database, build a table called Contacts and create two fields and name them ContactName and State respectively. Enter a few data in the table and click Save All to save the data. Now we are ready to connect to this new database.<\/p>\n

ADO.NET offers a number of connection objects such as\u00a0OleDbConnection, SqlConnection<\/strong>\u00a0and more. OleDbConnection is used to access OLEDB data such as Microsoft Access\u00a0whilst SqlCOnnection\u00a0\u00a0is used to access data provided by Microsoft SQL server. Since we will work with SQL database in our example, we will use the SqlConnection object. To initialize the variable to a new SqlConnection object, we use the following syntax:<\/p>\n

Private MyCn As New SqlConnection<\/pre>\n