Using( var adapter = new OleDbDataAdapter(queryString, connectionString))Īdapter. Use the SqlConnection object to open SQL Server connection To set up the connection string of the SqlConnection object, add the following code to the Form1Load event procedure: VB Copy 'Create a Connection object. imports imports public class login private sub loginuserclick (sender as object, e as eventargs) handles loginuser.click dim conn as new sqlconnection if conn.state connectionstate.closed then nnectionstring ('server192.168.0. When i execute a query with the following method, i get a timeout. Using ( var connection = new OleDbConnection(connectionString))

On that way you ensure that all unmanaged resources are disposed properly: internal static DataSet executeQuery( string queryString) Programming Languages: C, HTML, XML, XSL and XSLT, VB.NET, Java Script. Note that you should use the using-statement for your connection and other objects implementing IDisposable like the OleDbDataAdapter. Strong knowledge and familiarity of SQL Server 2005/2008/2012 and Visual Studio. If you can't establish a connection to the database and you also want to increase that timeout, you have to do that in the connection-string, for example(default is 15 seconds): 'Data Source=(local) Connection Timeout=30 Initial Catalog=AdventureWorks Integrated Security=SSPI ' Copy You can set the CommandTimeout of the SelectCommand: = 180 // default is 30 seconds Copy

Sql adapter transaction vb.net