Export DataBase Data to Excel Sheet in ASP.NET C#

 

protected void Export_DatabaseData_Click(object sender, EventArgs e)
    {
        string sql = "";
        //Generating Excel Report :-

String ExportFileName = "ExportedSheet_" + DateTime.Now.Day.ToString() +   DateTime.Now.Month.ToString() + DateTime.Now.Year.ToString() + "_" + DateTime.Now.Hour.ToString() + "_" + DateTime.Now.Minute.ToString() + "_" + DateTime.Now.Second.ToString() + "_" + DateTime.Now.Millisecond.ToString() + ".xls";

//Fetching data from Database through query:-

         Sql = "SELECT * FROM <TABLENAME>";   //Query for fetching data.
        DataTable dt = new DataTable();
        objDB.GetData(sql, ref dt);   //**Executing query and get data in data table.**//
        Response.Clear();
        Response.Buffer = true;
        Response.AddHeader("content-disposition", "attachment;filename= " + ExportFileName + ";");      
        Response.Charset = "";
        Response.ContentType = "application/text";
        StringBuilder sb = new StringBuilder();
        for (int k = 0; k < dt.Columns.Count; k++)
        {
            //add Separator
            sb.Append(dt.Columns[k].ColumnName + ',');
        }

        //Append New Line
        sb.Append("\r\n");
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            for (int k = 0; k < dt.Columns.Count; k++)
            {
                //Add Separator
                sb.Append(dt.Rows[i][k].ToString().Replace(",", ";") + ',');
            }
            //Append new line
            sb.Append("\r\n");
        }
        Response.Output.Write(sb.ToString());       
        Response.Flush();
        Response.End();   
    }   

Server Side alert box for all browsers in asp.net c#

ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "alert('I am alert message !');", true);

How to enable JavaScript in your browser

JavaScript is enabled in your web browser. If you disable JavaScript, this text will change.

Instructions for web developers

You may want to consider linking to this site, to educate any script-disabled users on how to enable JavaScript in five most commonly used browsers. You are free to use the code below and modify it according to your needs.

<noscript>
 For full functionality of this site it is necessary to enable JavaScript.
 Here are the <a href="http://www.enable-javascript.com/" target="_blank">
 instructions how to enable JavaScript in your web browser</a>.
</noscript>

On enable-javascript.com we optimize the script-disabled user experience as much as we can:

• The instructions for your browser are put at the top of the page
• All the images are inlined, full-size, for easy perusing
• This developer-centric message is out of the way

We want your visitors to have JavaScript enabled just as much as you do!

Mozilla Firefox

1. On the web browser click "Firefox" menu and then select "Options".
2. In the "Options" window select the "Content" tab.
3. Mark the "Enable JavaScript" checkbox.
4. In the opened "Options" window click on the "OK" button to close it.
5. Click on the "Reload current page" button of the web browser to refresh the page.

• 1.
• 2.
• 3.
• 4.
• 5.

Internet Explorer

1. On web browser menu click "Tools" menu and select "Internet Options".
2. In the "Internet Options" window select the "Security" tab.
3. On the "Security" tab click on the "Custom level..." button.
4. When the "Security Settings - Internet Zone" dialog window opens, look for the "Scripting" section.
5. In the "Active Scripting" item select "Enable".
6. When the "Warning!" window pops out asking "Are you sure you want to change the settings for this zone?" select "Yes".
7. In the "Internet Options" window click on the "OK" button to close it.
8. Click on the "Refresh" button of the web browser to refresh the page.

• 1.
• 2.
• 3.
• 4.
• 5.
• 6.
• 7.
• 8.

Internet Explorer < 9

1. On web browser menu click "Tools" and select "Internet Options".
2. In the "Internet Options" window select the "Security" tab.
3. On the "Security" tab click on the "Custom level..." button.
4. When the "Security Settings - Internet Zone" dialog window opens, look for the "Scripting" section.
5. In the "Active Scripting" item select "Enable".
6. When the "Warning!" window pops out asking "Are you sure you want to change the settings for this zone?" select "Yes".
7. In the "Internet Options" window click on the"OK" button to close it.
8. Click on the "Refresh" button of the web browser to refresh the page.

• 1.
• 2.
• 3.
• 4.
• 5.
• 6.
• 7.
• 8.

Mozilla Firefox < 4

1. On the web browser menu click "Tools" and select "Options".
2. In the "Options" window select the "Content" tab.
3. Mark the "Enable JavaScript" checkbox.
4. In the opened "Options" window click on the "OK" button to close it.
5. Click on the "Reload current page" button of the web browser to refresh the page.

• 1.
• 2.
• 3.
• 4.
• 5.

Google Chrome

1. On the web browser menu click on the "Customize and control Google Chrome" and select "Settings".
2. In the "Settings" section click on the "Show advanced settings..."
3. Under the the "Privacy" click on the "Content settings...".
4. When the dialog window opens, look for the "JavaScript" section and select "Allow all sites to run JavaScript (recommended)".
5. Click on the "OK" button to close it.
6. Close the "Settings" tab.
7. Click on the "Reload this page" button of the web browser to refresh the page.

• 1.
• 2.
• 3.
• 4.
• 5.
• 6.
• 7.

Apple Safari

1. On the web browser menu click on the "Edit" and select "Preferences".
2. In the "Preferences" window select the "Security" tab.
3. In the "Security" tab section "Web content" mark the "Enable JavaScript" checkbox.
4. Click on the "Reload the current page" button of the web browser to refresh the page.

• 1.
• 2.
• 3.
• 4.

Opera

• 1. a) Click on "Menu", hover mouse on the "Settings" then hover mouse on the "Quick preferences" and mark the "Enable JavaScript" checkbox.
• 1. b) If "Menu bar" is shown click on the "Tools", hover mouse on the "Quick preferences" and mark the "Enable JavaScript" checkbox.

• 1. a)
• 1. b)

Opera < v. 10

1. On the web browser menu click "Tools" and select "Preferences".
2. In the "Preferences" window select the "Advanced" tab.
3. On the "Advanced" tab click on "Content" menu item.
4. Mark the "Enable JavaScript" checkbox.
5. In the opened "Preferences" window click on the "OK" button to close it.
6. Click on the "Reload" button of the web browser to refresh the page.

• 1.
• 2.
• 3.
• 4.
• 5.
• 6.