asp.net and SQL server- browser Process Slow

Question

1.00/5 (1 vote)

See more:

Dear Frnds,

I have developed one web application(asp.net c#). i used sql server database. when i click save,update,delete,retrieve button browser is processing after some seconds only action performed. how to quick access. pls help me..

thanks & Regards,
Vivek .R

Posted 12-Nov-14 21:51pm

Vivek.anand34

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2014-11-12T22:13:00

Solution 1

We can't answer that based on that information.
We have no idea how your code is written, how it works, anything really.

So start by getting some information on timings: Use the Stopwatch class to monitor how long it takes to actually do things like access the database and log the results to a file. Try to work out where the bottleneck is: is it in the connection to SQL? Or in the code you are using to send the info to SQL afterwards? Or does the DB stuff take trivial amounts of time and the communications between your browser and your webhost take forever?

When you have timing information you have two things:
1) A set of values against which to compare the results of any changes so you know what improved things, and by how much.
2) Hopefully, some idea of where the improvements are needed, and where it is pointless to try.

But without even that, everyone is whistling in the dark!

Posted 12-Nov-14 22:13pm

OriginalGriff

Comments

Vivek.anand34 13-Nov-14 4:22am

I used code like this:
try
{
SqlCommand cmd = new SqlCommand();
conn.Open();
string qur;
qur = "insert into EmpDetails (EmpId,EmpName,Contact) values('" + txtEmpId.Text + "','" + txtEmpName.Text + "','" + txtContact.Text + "')";
cmd = new SqlCommand(qur, conn);
cmd.ExecuteNonQuery();
MessageBox.Show("Saved Sucessfully");
conn.Close();
FillDataGrid();
}
catch(Exception ex)
{
MessageBox.Show("ERROR:"+ex);
}

OriginalGriff 13-Nov-14 4:31am

:sigh:
What do you think MessageBox does in website applications?
Where do you think it is displayed?
C# code is executed at the Server, not the Client. So the MessageBox will be displayed at the Server, not the Client. So, the user won't see it to click on the "OK" button, so it will sit there until the web hosting service decides it isn't going to get a response, and kills the task.

It worked on your development system because the client and the server were the same computer...

Vivek.anand34 13-Nov-14 4:51am

sorry. this is for example coding.. like this code we are done in web application.

OriginalGriff 13-Nov-14 5:10am

Where is the point of showing me code that doesn't actually look like the code you have a problem with?

That's like you taking my car to the garage because your car is broken and you want them to fix it!

Vivek.anand34 13-Nov-14 6:48am

I used code like this:
try
{
SqlCommand cmd = new SqlCommand();
conn.Open();
string qur;
qur = "insert into EmpDetails (EmpId,EmpName,Contact) values('" + txtEmpId.Text + "','" + txtEmpName.Text + "','" + txtContact.Text + "')";
cmd = new SqlCommand(qur, conn);
cmd.ExecuteNonQuery();
MessageBox.Show("Saved Sucessfully");
conn.Close();
FillDataGrid();
}
catch(Exception ex)
{
MessageBox.Show("ERROR:"+ex);
}

OriginalGriff 13-Nov-14 6:52am

That is identical to the code you showed me last time, which you then said was "this is for example coding.. like this code we are done in web application"

So either you are using MessageBox on the server - which won't work - or you are not using that code at all...

Vivek.anand34 13-Nov-14 7:03am

That code only am said..

Vivek.anand34 13-Nov-14 7:05am

y browser slow. whats d prob. my web application code is jst like tat code not same all..

OriginalGriff 13-Nov-14 7:17am

Let's go back and start at the beginning...

A Web Application involves two (or more) computers: a Server (which connects to the database) and a Client (which displays the information).
The computers communicate via the internet, and the Server sends information to the Client in the form of HTML and Javascript, which the Client displays in a Browser (e.g. IE, or Chrome) and sends back HTML data to the Server in response to user input.

All C# code is executed at the server: none of it leaves, and none of it is ever executed by the Client. The Client may not even be able to execute C# code as it may not be possible to run the .NET framework on the Client equipment, which does not have to be a PC. It could be a tablet running Android, and iPhone, running iOS, or an internet enabled fridge!

So when you write C# code that uses MessageBox, it is executed on the Server, not the Client. So the message box is displayed on the Server, not the Client. And the Client can't see the OK button in order to press it.

So, either you have made a horribly big mistake - which could be part of why your code is running slowly - or that isn't the code you are running.

If it isn't the exact code you are running, why show it to me? I can't tell from "this is sort of close to what I use" what the problem with the code you *do* use is!

If it is the exact code you are running, then you have some big problems, and you need to fix them - right now.

Vivek.anand34 13-Nov-14 23:59pm

This is my web app code..

conn.Open();
string qur;
qur = "insert into MED_MASTER (Medcode,Name,Meduom,Strength,Receipts,Issues,Balance,Reorderlevel,Minimumlevel,Maximumlevel,Del_flag,UserId,Date,CompanyCode) values('" + TxtMedCode.Text + "','" + TxtName.Text + "','" + TxtUOM.Text + "','" + TxtStrength.Text + "','" + TxtReceipts.Text + "','" + TxtIssues.Text + "','" + TxtBalance.Text + "','" + TxtReorder.Text + "','" + TxtMinLevel.Text + "','" + TxtMaxLevel.Text + "','N','"+usermas+"','" + DateTime.Now.ToString("MM/dd/yyyy hh:mm") + "','"+lblCompCode.Text+"')";
cmd = new SqlCommand(qur, conn);
cmd.ExecuteNonQuery();

ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Saved Successfully');", true);
GvMedMaster.DataBind();

OriginalGriff 14-Nov-14 7:22am

Better. (Except you are wide open to SQL Injection which could destroy your DB...)

And what happens when you add the Stopwatch and log what is taking what time?

Vivek.anand34 17-Nov-14 6:19am

7 secs taken to retrieve data from database..

OriginalGriff 17-Nov-14 6:28am

If you mean the databind then at a guess you are showing far, far too many rows - how many are there in your grid view?

Vivek.anand34 17-Nov-14 6:52am

in gridview more than one row only having.. when i click in gridview that values goes to textbox to edit them.

Vivek.anand34 17-Nov-14 6:54am

not for only in gridview. in autocomplete textbox i choose any choice from drop down its too take 2 r 3 secs values goes to textboxes.