SQL Server

Question

Hi there I am developing a winform application[with c#] with SQL Database [attached]. All process with SQL query are OK but at the first time when application open and user Login for application; SQL query takes too much time [may application is HANG or STOP working (say for 5-6 seconds) and then after successfully login application start. After it; all SQL process will executes well. If user close application and start over again ... it's again slow / Hang/ Not working starts.... I can't getting wht is matter with this...? Can you tell me what is mistake in my query?

Jignesh Trivedi · Answer

Hi I donot know what exact problem you are facing. by considering some point you can improve startup performance. like Reduce code in Form Load use lazy loading (load the data when required. always Call Dispose() Pre-compile your assemblies using NGEN when appropriate to decrease start-up time Remove all references from your project that are not used hope this will help you.

Nilesh Dalvi · Answer

As per suggestion given I put two labels for connection startup time and endup time... it takes 6 sec to load my Home Page. Abt how many entries in my Login table... its only 3 user in table and its only having nameusername & password column. Name------Username--------Password Nilesh------Nilesh123--------Nil123 Sharad-----Sharad123-------Shar123 Sushant----Sush123---------Sus123 [thats it....] Abt sql idexes ; i'm not shame to tell that I never used Index before... Is it really work for me; then plz tell me hw to use SQL Index for login page.

Wim Sturkenboom · Answer

So how often do you call that code in your application. Once I guess. You can add some timing checks to see what takes long. Opening the connection or executing the query or reading the result or ... DateTime dtStart = DateTime.Now; con.open(); DateTime dtEnd = DateTime.Now; ... ... com.ExecuteNonQuery(); DateTime dtEnd = DateTime.Now; ... ... etc Put breakpoints at sensible places and check the durations of the steps. How many records do you have in the table UserDetails? If there are a lot of them is your table correctly indexed? Note: your query is prone to SQL injection; read up on parameter queries.

Nilesh Dalvi · Answer

Here is my code for Login try { con.Open(); SqlCommand com = new SqlCommand( select * from UserDetails where IDNumber = ' + txtLogin.Text + ' and Password = ' + txtPassword.Text + ' and Designation=' + cmbType.SelectedValue.ToString() + '  con); com.ExecuteNonQuery(); SqlDataReader dr = com.ExecuteReader(); if (dr.Read()) { con.Close(); this.Hide(); EXeSmart ex = new EXeSmart(); ex.Show(); } else { MessageBox.Show(Invalid Login Error MessageBoxButtons.OK MessageBoxIcon.Error); con.Close(); txtLogin.Text =  ; txtPassword.Clear(); txtLogin.Focus(); } } catch { MessageBox.Show(Invalid Operation); txtLogin.Focus(); }

Munesh Sharma · Answer

please share your code .. after that we can get solution

Vithal Wadje · Answer

post sample code