gridview data download in asp.net

gridview print as design show on the form

in asp.net.

you can   download the show data on grid or listview or any control in aps.net. just change bold and underline.

 protected void Button1_Click(object sender, EventArgs e)

        {

            Response.Clear();

            Response.AddHeader("content-disposition", "attachment;filename=myexcelfile.doc");

            Response.ContentType = "application/vnd.xls";

            StringWriter sw = new StringWriter();

            HtmlTextWriter htw = new HtmlTextWriter(sw);

            GridView1.RenderControl(htw);

            Response.Write(sw.ToString());

            Response.End();

        }

        public override void VerifyRenderingInServerForm(Control control)

        {

            //base.VerifyRenderingInServerForm(control);

        }

Image code with sql server

Image Insert /Retrieve  with  sql server Database Table

Asp.net code insert image by  code

cmd.Parameters.Add("@ProductPicture", SqlDbType.VarBinary).Value = uploadProduct.FileBytes;

retrieve image from sql server databse

we take new asp.net page and convert byte to response. BinaryWrite

<asp:Image ID="Image1" runat="server" ImageUrl='<%# "GetProductPicture.aspx?ProductID=" + Eval("ProductID")%>' alt="Image" Width="150px" Height="100px" BorderColor="#CCCCCC" BorderStyle="Solid" BorderWidth="1" style="border-radius:5px;" />

Now productPicture page code

protected void Page_Load(object sender, EventArgs e)

    {

        SqlConnection con = null;

        try

        {

           int Prod_Id = Convert.ToInt32(Request.QueryString["ProductID"].ToString());

          con = new SqlConnection(ConfigurationManager.AppSettings["AsCon"].ToString());

            if (con != null)

            {

                con.Open();

            }

            SqlCommand cmd = new SqlCommand("select ProductPicture from ProductMaster where ProductID=" + Prod_Id + "", con);

            byte[] product = (byte[])cmd.ExecuteScalar();

            Response.BinaryWrite(product);

        }

        catch (Exception ex)

        {

           // Mailer.SendTechnicalMail(ex.Message);

        }

        finally

        {

            if (con != null)

            {

                con.Close();

            }

        }

    }

message box show in asp.net

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Collections;

using System.Collections.Generic;

/// <summary>

/// Summary description for MessageBox

/// </summary>

public class MessageBox

{

    // Lets keep the message coming from all the pages here

    static Dictionary<Page, Queue> pageTable = null;

   

    static MessageBox()

    {

        // Create the store

        pageTable = new Dictionary<Page, Queue>();

    }

    public static void Show(string str)

    {

        // Lets find out what page is sending the request

        Page page = HttpContext.Current.Handler as Page;

        // If a valid page is found

        if (page != null)

        {

            // Check if this page is requesing message show for the first time

            if (pageTable.ContainsKey(page) == false)

            {

                // Lets create a message queue dedicated for this page.

                pageTable.Add(page, new Queue());

            }

            // Let us add messages of this to the queue now

            pageTable[page].Enqueue(str);

            // Now let put a hook on the page unload where we will show our message

            page.Unload += new EventHandler(page_Unload);

        }       

    }

    static void page_Unload(object sender, EventArgs e)

    {

        // Lets find out which page is getting unloaded

        Page page = sender as Page;

        // If a valid page is founf

        if (page != null)

        {

            // Extract the messages for this page and push them to client side

            HttpContext.Current.Response.Write("<script>alert('" + pageTable[page].Dequeue() + "');</script>");

        }

    }

}

//Pokemon exception handling

           // MessageBox.Show("Exception has occured: " + //ex.Message);

asp.net payment Getways code

online payment getway in asp.net / vb.net

https://support.ebs.in/app/index.php?/Knowledgebase/List/Index/9


click on Integration Kits--> then download according your project code files

Extratct Zip--> Run Page pay.aspx

fill all basic information

then respose url please copy paste url local host : 7856 any no those show on your Browser

Shopping Cart Kits(47) Zencart Integration kit Ver 2.5 WHMCS 4.4.2 EBS Integration Kit V 2.5

Integration Kits(7) PERL EBS Integration Kit Ver 2.5 VB.NET EBS Integration Ver 2.5

Manuals(11) EBS Process and Procedure Policies EBS multi currency display manual

drop all table from sql server database

drop table from sql server database

EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"

other commands can u use for Alter And delete 

EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'

EXEC sp_MSForEachTable 'DELETE FROM ?'

EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'

key code, key press ASCII code

Press a key in the text box below to see the corresponding key code using in c# , javascript

Key	Code
backspace	8
tab	9
enter	13
shift	16
ctrl	17
alt	18
pause/break	19
caps lock	20
escape	27
page up	33
page down	34
end	35
home	36
left arrow	37
up arrow	38
right arrow	39
down arrow	40
insert	45
delete	46
0	48
1	49
2	50
3	51
4	52
5	53
6	54
7	55
8	56
9	57
a	65
b	66
c	67
d	68

 

Key	Code
e	69
f	70
g	71
h	72
i	73
j	74
k	75
l	76
m	77
n	78
o	79
p	80
q	81
r	82
s	83
t	84
u	85
v	86
w	87
x	88
y	89
z	90
left window key	91
right window key	92
select key	93
numpad 0	96
numpad 1	97
numpad 2	98
numpad 3	99
numpad 4	100
numpad 5	101
numpad 6	102
numpad 7	103

 

Key	Code
numpad 8	104
numpad 9	105
multiply	106
add	107
subtract	109
decimal point	110
divide	111
f1	112
f2	113
f3	114
f4	115
f5	116
f6	117
f7	118
f8	119
f9	120
f10	121
f11	122
f12	123
num lock	144
scroll lock	145
semi-colon	186
equal sign	187
comma	188
dash	189
period	190
forward slash	191
grave accent	192
open bracket	219
back slash	220
close braket	221
single quote	222