Unable show the popup.

Question

1.00/5 (2 votes)

See more:

Hi,

Below is my Method. I want to show the message once the data inserted into table.

C#

try
{
                for (int i = 0; i < Dt.Rows.Count; i++)
                {
                    DataRow row = Dt.Rows[i];
                    int columnCount = Dt.Columns.Count;
                    string[] columns = new string[columnCount];
                    for (int j = 0; j < columnCount; j++)
                    {
                        columns[j] = row[j].ToString();
                    }
                    SqlCommand cmd = new SqlCommand("#");
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.Add(new SqlParameter("@ApplicationType", columns[0]));
                    cmd.Parameters.Add(new SqlParameter("@Title", columns[1]));
                    cmd.Parameters.Add(new SqlParameter("@FirstName", columns[2]));
                    cmd.Parameters.Add(new SqlParameter("@LastName", columns[3]));
                    cmd.Parameters.Add(new SqlParameter("@Gender", columns[4]));
                    DataSql dal = new DataSql();
                    object obj = dal.connectedMethod(cmd, DataSql.executemethods.ExecuteNonQuery);                    
                }
                System.Web.HttpContext.Current.Response.Write("<script language=\"javaScript\">" + "alert('All data's are uploaded into system!');" + "window.location.href='##';" + "<" + "/script>");
}

Please help me how to I show the message once all the data inserted into table.

Posted 12-Jul-15 17:48pm

v2vinoth

Updated 12-Jul-15 17:57pm

DamithSL

v2

Add a Solution

Comments

Afzaal Ahmad Zeeshan 12-Jul-15 23:58pm

Are you using ajax? Because, it doesn't even matter whether you show the popup or not if you are sending HTTP requests and reloading the pages based on HTTP requests.

Suvendu Shekhar Giri 13-Jul-15 0:04am

What '#' means in
SqlCommand cmd = new SqlCommand("#");
?

v2vinoth 13-Jul-15 0:22am

# means page redirect - index.aspx
I want to show alert the data inserted into table

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)

Sergey Alexandrovich Kryukov · Answer 1 · 2015-07-12T18:04:00

If you want to show a popup, show a popup, not alert, which is hardly designed for real fully-fledged Web applications. This is done using window.open:
https://developer.mozilla.org/en-US/docs/Web/API/Window/open[^].

However, many users consider all pop-ups as evil, for some good reasons. Not only this is intrusive and inconvenient, but the user will try to avoid annoying advertizement pop-ups. For this purpose, pop-up blocking browser plug-ins can be used; and such plug-ins are fairly popular.

At the same time, you can easily mimic the modal behavior on the same page, which is more convenient and gives much better impression and user experience. For example, you can use jQuiery UI Dialog:
https://jqueryui.com/dialog[^].

Besides, there a many 3-rd party jQuery components ("plug-ins"), collectively referred to as modal popup, offering different visual effects (notably dimming of the window) and other features: http://bfy.tw/Vdm[^].

—SA