Hi there, I have have a challenge with my application. I am developing it using VB.Net and SQL server 2014. My database contains 2k plus records. I used to search and return the results very fast when the database was still small. The problem now is that whenever i try to search, it times out before the search is complete. see my code below. What should my code be to avoid time out and also search very fast? 'connecting to the database Try Dim con As New SqlClient.SqlConnection("Server=.\SQLEXPRESS;Initial Catalog=RCS;Integrated Security=True") Dim cmd As New SqlCommand() cmd.Connection = con Dim da …
|+0 forum 10|
Hi, I have two computers (Desktop and laptop), The desktop is my office computer and I have been using it for my application development(Visual basic). I have Visual studio 2013 and SQL Server 2014 installed on both computers. I exported the database from my desktop computer to the laptop and copied the project from the project folder to the project folder of the laptop. I went further on to change the connection string to suit the path of the database on the laptop. The problem am facing now is that some forms cannot fit on the screen of the laptop …
|+0 forum 3|
Hello everyone, This is Mike joing DANIWEB from Zambia. I have learnt a lot from this site and i have decided to join and learn more and more. I am new to visual basic programming. Looking forward to learn more from the experts in here.
|+0 forum 4|