VB.NET with SQL SERVER 2005 Database Question

• • Reply

  12 years ago

  by JoshTheFlame

  Joshua

  , United States

  Joined 15 years ago
  Hi All, I am new to VB.NET and I got a task to develop a database application contains almost 6 to 7 data entry forms alongwith 2 master detail entry forms. I am confuse about how to use SQLConnection object and data adapter thing like on every form loading I should create object like the following Dim ConnectionString As String = "Data Source=AXEPEE;Initial Catalog=master;User ID=sa;Password=admin123" Dim ConnectionObject As New SqlConnection(ConnectionString) Try ConnectionObject.Open() MsgBox("Connection Successfully Varified ! ") ConnectionObject.Close() Catch ex As Exception MsgBox("Can not open connection ! ") End Try and on insert, update & delete button seperate code ...and also want to ask if the above method is professional way to deal with connections..if anyother professional assistance you guys can provide to improve my system performance or how to use this in a professional way I would appreciate.
  Report abuse