Signature capture from signature pad in Web Application asp.net using c# (or) web signature capture asp net using mouse asp.net

In this post I Explained about capture the signature from signature pad to connect the Web application.  You have to use web signuature pad for this application.

.aspx code

<form id="form1"runat="server">

        <asp:HiddenField ID="HiddenField1" runat="server" />

        <div id="wPaint" style="position:relative; width:1200px; height:500px; background:#ACACAC; border:solid black 1px; overflow:hidden;"></div>

        <asp:Button ID="BtnSign" runat="server" Text="Save" CssClass="button" OnClientClick="javascript:saveImage();" onclick="BtnSign_Click"/>

        <asp:Button ID="BtnClearSign" runat="server" Text="Clear" CssClass="button" OnClientClick="javascript:loadImage();" />

       

        <script type="text/javascript">

                $("#wPaint").wPaint({

                      image: "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAfQAAAEsCAYAAAA1u0HIAAAMoElEQVR4Xu3VAQ0AAAjDMPBvGh0sxcF7ku84AgQIECBA4L3Avk8gAAECBAgQIDAG3RMQIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAgQMI/gEtiL4PDAAAAABJRU5ErkJggg==",

                      drawDown: function(e, element){ $("#canvasDown").val(element.settings.mode +": " + e.pageX + ',' + e.pageY); },

                      drawMove: function(e, element){ $("#canvasMove").val(element.settings.mode +": " + e.pageX + ',' + e.pageY); },

                      drawUp: function(e, element){ $("#canvasUp").val(element.settings.mode +": " + e.pageX + ',' + e.pageY); }

                });

                function loadImage()

                {

                      $("#wPaint").wPaint("image", "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAfQAAAEsCAYAAAA1u0HIAAAMoElEQVR4Xu3VAQ0AAAjDMPBvGh0sxcF7ku84AgQIECBA4L3Avk8gAAECBAgQIDAG3RMQIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAAYPuBwgQIECAQEDAoAdKFIEAAQIECBh0P0CAAAECBAICBj1QoggECBAgQMCg+wECBAgQIBAQMOiBEkUgQIAAAQIG3Q8QIECAAIGAgEEPlCgCAQIECBAw6H6AAAECBAgEBAx6oEQRCBAgQICAQfcDBAgQIEAgIGDQAyWKQIAAAQIEDLofIECAAAECAQGDHihRBAIECBAgYND9AAECBAgQCAgY9ECJIhAgQIAAgQMI/gEtiL4PDAAAAABJRU5ErkJggg==");

                }

                function saveImage()

                {

                      var imageSignData = $("#wPaint").wPaint("image");

                    document.getElementById('<%= HiddenField1.ClientID %>').value = imageSignData;

                }

          </script>                                

    </form>

.cs page code

using System;

usingSystem.Collections;

usingSystem.Configuration;

usingSystem.Data;

usingSystem.Data.SqlClient;

usingSystem.Linq;

usingSystem.Web;

usingSystem.Web.Security;

usingSystem.Web.UI;

using System.Web.UI.HtmlControls;

usingSystem.Web.UI.WebControls;

usingSystem.Xml.Linq;

using System.IO;

usingSystem.Drawing;

usingSystem.Diagnostics;

usingSystem.Collections.Generic;

usingSystem.ComponentModel;

usingSystem.Text;

usingSystem.Drawing.Imaging;

namespace company

{

    public partial class WebSign : System.Web.UI.Page

    {

        protectedvoid Page_Load(objectsender, EventArgs e)

        {

        }

        protectedvoid BtnSign_Click(objectsender, EventArgs e)

        {

            try

            {

                stringPATH = Server.MapPath(ResolveUrl("~\\"));

                stringstrPhoto = HiddenField1.Value; //Get the image from flash file

                intl = strPhoto.Length;

                strPhoto = strPhoto.Substring(22, l - 22);

                byte[] photo = Convert.FromBase64String(strPhoto);

                FileStreamfs = new FileStream(PATH + "Sign.png", FileMode.OpenOrCreate, FileAccess.Write);

                BinaryWriterbr = new BinaryWriter(fs);

                br.Write(photo);

                br.Flush();

                br.Close();

                fs.Close();

                stringscript2 = "alert('Signature Saved..');";

                System.Web.HttpContext.Current.Response.Write("<script language=\"javascript\">" + script2 + "</script>");

                InvertImage();

            }

            catch(Exception Ex)

            {

                stringscript3 = "alert('" + Ex + "');";

                System.Web.HttpContext.Current.Response.Write("<script language=\"javascript\">" + script3 + "</script>");

            }

        }

        protectedvoid InvertImage()

        {

            Bitmapbimg = (Bitmap)System.Drawing.Image.FromFile(Server.MapPath("~\\Sign.png"));

            Bitmapimg = null;

            img = newBitmap(bimg.Width, bimg.Height);

            for(int x = 0; x < bimg.Width; x++)

            {

                for(int y = 0; y < bimg.Height; y++)

                {

                    //Get the color

                    Colorclr = bimg.GetPixel(x, y);

                    //Invert the clr

                    clr = Color.FromArgb(255 - clr.R, 255 - clr.G, 255 - clr.B);

                    //Update the color

                    img.SetPixel(x, y, clr);

                }

            }

            bimg.Dispose();

            img.Save(Server.MapPath("~\\Signature.jpg"), System.Drawing.Imaging.ImageFormat.Jpeg);

        }

    }

}

print gridview data in asp.net using c# (or) export gridview to word/excel/pdf/csv in asp.net

In this post I Explained about exporting gridview data to the word or excel format. You can down load the complete grid view data on clicking the image button in the figure.

.Aspx Code :

  <form id="form1" runat="server">

    <div>&nbsp&nbsp&nbsp&nbsp

        <asp:ImageButton ID="ImgBtnBack" runat="server" ImageUrl="~/images/back.png" OnClick="ImgBtnBack_Click"/>

        <asp:ImageButton ID="ImgBtnPrint" runat="server" ImageUrl="~/images/print01.png" /> &nbsp&nbsp&nbsp&nbsp

        <asp:ImageButton ID="ImgBtnWord" runat="server" ImageUrl="~/images/Word01.png" OnClick="ImgBtnWord_Click"/> &nbsp&nbsp&nbsp&nbsp

        <asp:ImageButton ID="ImgBtnExcel" runat="server" ImageUrl="~/images/Excel01.png" OnClick="ImgBtnExcel_Click"/>

    </div>

    <div id="VQGridView">

        <asp:GridView ID="GridViewResult" runat="server" HorizontalAlign="Center"

            GridLines="None" Width="200%"

            CssClass="pnl-div" EmptyDataText="No Records Avaialable.."  >

            <FooterStyle BackColor="" Font-Bold="true" ForeColor="" />

            <RowStyle BackColor="#FFFFFF" HorizontalAlign="Left" />

            <EditRowStyle BackColor="" Width="100%" />

            <SelectedRowStyle BackColor="" Font-Bold="true" ForeColor="" />

            <PagerStyle BackColor="" ForeColor="" HorizontalAlign="Center" />

            <HeaderStyle BackColor="#17C5F7" ForeColor="#FFFFFF" Font-Bold="true" HorizontalAlign="Left" />

            <AlternatingRowStyle BackColor="#B6EEFF" />

        </asp:GridView>

    </div>

    </form>

.CS Page code :

using System;

usingSystem.Collections;

usingSystem.Configuration;

usingSystem.Data;

usingSystem.Data.SqlClient;

usingSystem.Linq;

usingSystem.Web;

using System.IO;

usingSystem.Web.Security;

usingSystem.Web.UI;

usingSystem.Web.UI.HtmlControls;

usingSystem.Web.UI.WebControls;

usingSystem.Web.UI.WebControls.WebParts;

usingSystem.Xml.Linq;

namespacecompany

{

    public partial class QueryResult : System.Web.UI.Page

    {

        protectedvoid Page_Load(objectsender, EventArgs e)

        {

            stringUNAME = Convert.ToString(Session["USER_NAME"]);

            stringprintScript =

            @"function PrintGridView()

            {

            var gridInsideDiv = document.getElementById('VQGridView');

            var printWindow = window.open('VQGridView.htm','PrintWindow','letf=0,top=0,width=1000,height=700,toolbar=1,scrollbars=1,status=1');

            printWindow.document.write(gridInsideDiv.innerHTML);

            printWindow.document.close();

            printWindow.focus();

            printWindow.print();

            printWindow.close();}";

            this.ClientScript.RegisterStartupScript(Page.GetType(), "PrintGridView", printScript.ToString(), true);

            ImgBtnPrint.Attributes.Add("onclick", "PrintGridView();");

           

            SqlConnectioncn = new SqlConnection();

            cn.ConnectionString = ConfigurationManager.ConnectionStrings["connecton string here"].ConnectionString;

            cn.Open();

            stringQUERY = " Your Sql Query";

            DataTabledt = new DataTable();

            SqlDataAdapteradp = new SqlDataAdapter(QUERY, cn);

            adp.Fill(dt);

            GridViewResult.DataSource = dt;

            GridViewResult.DataBind();

            cn.Close();

        }

        public override voidVerifyRenderingInServerForm(Control control)

        {

            /* Verifies that the control is rendered */

        }

        protectedvoid ImgBtnWord_Click(objectsender, ImageClickEventArgs e)

        {

            GridViewResult.AllowPaging = false;

            GridViewResult.DataBind();

            Response.ClearContent();

            Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Visitors.doc"));

            Response.Charset = "";

            Response.ContentType = "application/ms-word";

            StringWritersw = new StringWriter();

            HtmlTextWriterhtw = new HtmlTextWriter(sw);

            GridViewResult.RenderControl(htw);

            Response.Write(sw.ToString());

            Response.End();

        }

        protectedvoid ImgBtnExcel_Click(objectsender, ImageClickEventArgs e)

        {

            Response.ClearContent();

            Response.Buffer = true;

            Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Visitors.xls"));

            Response.ContentType = "application/ms-excel";

            StringWritersw = new StringWriter();

            HtmlTextWriterhtw = new HtmlTextWriter(sw);

            GridViewResult.AllowPaging = false;

            GridViewResult.DataBind();

            //Change the Header Row back to white color

            GridViewResult.HeaderRow.Style.Add("background-color", "#FFFFFF");

            //Applying stlye to gridview header cells

            for(int i = 0; i < GridViewResult.HeaderRow.Cells.Count; i++)

            {

                GridViewResult.HeaderRow.Cells[i].Style.Add("background-color", "#507CD1");

            }

            intj = 1;

            //This loop is used to apply stlye to cells based on particular row

            foreach(GridViewRow gvrow inGridViewResult.Rows)

            {

                //gvrow.BackColor = Color.White;

                if(j <= GridViewResult.Rows.Count)

                {

                    if(j % 2 != 0)

                    {

                        for (int k = 0; k < gvrow.Cells.Count; k++)

                        {

                            gvrow.Cells[k].Style.Add("background-color", "#EFF3FB");

                        }

                    }

                }

                j++;

            }

            GridViewResult.RenderControl(htw);

            Response.Write(sw.ToString());

            Response.End();

        }

        protectedvoid ImgBtnBack_Click(objectsender, ImageClickEventArgs e)

        {

            Response.Redirect("back.aspx");

        }

    }

}

Append a MenuStrip to an MDI Parent Window (Windows Forms) c# (or) mdi child menu in wpf

In this post , I explained how to bind data to menu strip in MDI PARENT FORM. multiple-document interface (MDI) child window can be different from the MDI parent window. For example, the MDI parent might be a spreadsheet, and the MDI child might be a chart. ,  I have used  stored procedures in this article.  I have binded the menu strip based on the role of the user.

using System;

usingSystem.Collections.Generic;

usingSystem.ComponentModel;

usingSystem.Data;

usingSystem.Drawing;

usingSystem.Text;

usingSystem.Windows.Forms;

using Telerik.WinControls;

usingMicrosoft.ApplicationBlocks.Data;

usingSystem.Data.SqlClient;

usingSystem.Diagnostics;

namespace Company

{

    public partial class MainForm : Telerik.WinControls.UI.RadForm

    {

        publicMainForm()

        {

            InitializeComponent();

        }

        public DataSet getMenu()

        {

            returnSqlHelper.ExecuteDataset(Program.Con, CommandType.StoredProcedure, "Storedprocedute_Menu_Details");

        }

        public DataSet getWorkMenu(stringrole, int menu)

        {

            SqlParameter[] cmdpar = new SqlParameter[2];

            cmdparam[0] = new SqlParameter("@p_menu", SqlDbType.Int);

            cmdparam[0].Value = menuid;

            cmdparam[1] = new SqlParameter("@p_role", SqlDbType.Int);

            cmdparam[1].Value = roleId;

            returnSqlHelper.ExecuteDataset(Program.Con, CommandType.StoredProcedure, "StoredProcedure", cmdpar);

        }

        privatevoid SelectedChildMenu_OnClick(object sender, System.EventArgse)

        {

            if(((ActiveMdiChild != null))) ActiveMdiChild.Close();

            cmbNames.SelectedValue = sender.ToString();

            stringformName = cmbNames.Text;

            string[] frms = formName.Split('&');

            objectoForm = new object();

            Program.frmName = frms[0];

            Program.mode = frms[1];

            stringprojName = "Company";

            TypetForm = System.Reflection.Assembly.GetExecutingAssembly().GetType(projName + "." + frms[0]);

            if(Program.frmName == "Calculator")

            {

                Process.Start("C:\\WINDOWS\\system32\\calc.exe");

            }

            elseif (((tForm != null)))

            {

                oForm = Activator.CreateInstance(tForm);

                ((Form)oForm).MdiParent = this;

                ((Form)oForm).Show();

            }

        }

        public void MainForm_Load(objectsender, EventArgs e)

        {

            MenuStrip2.Items.Clear();

            ToolStripMenuItemchildItem = default(ToolStripMenuItem);

            intcnt = 0;

            DataSetmenuData = null;

            menuData = getMenu();

            cmbFuncNames.DataSource = menuData.Tables[1];

            cmbFuncNames.DisplayMember = "progam";

            cmbFuncNames.ValueMember = "work";

            for(int j = 0; j <= menuData.Tables[0].Rows.Count - 1; j++)

            {

                intid = Convert.ToInt32(menuData.Tables[0].Rows[j]["MENUID"]);

                ToolStripMenuItemparItem = new ToolStripMenuItem();

                parItem.Name = id.ToString();

                stringmenuName = menuData.Tables[0].Rows[j]["MENUNAME"].ToString();

                parItem.Text = menuName;                 MenuStrip2.Items.Add(parItem);

                DataSetchildDs = new DataSet();

                childDs = getWorkMenu(Program.userrole, id);

                ContextMenuStripcms = new ContextMenuStrip();

                for(int i = 0; i <= childDs.Tables[0].Rows.Count - 1; i++)

                {

                    childItem = new ToolStripMenuItem();

                    childItem.ForeColor = System.Drawing.Color.Black;

                    childItem.Name = childDs.Tables[0].Rows[i]["WorkID"].ToString();

                    childItem.Text = childDs.Tables[0].Rows[i]["WorkNAME"].ToString();

                    childItem.Tag = childDs.Tables[0].Rows[i]["PROG_NAME"].ToString();

                    parItem.DropDownItems.Add(childItem);

                    cms.Items.Add(childItem.Text, null, new System.EventHandler(SelectedChildMenu_OnClick));

                }

                ToolStripMenuItemtsi = (ToolStripMenuItem)parItem;

                tsi.DropDown = cms;

            }

        }

        privatevoid MainForm_FormClosing(object sender, FormClosingEventArgse)

        {

            Application.Exit();

        }

        privatevoid MenuStrip2_ItemClicked(object sender, ToolStripItemClickedEventArgse)

        {

            if(e.ClickedItem.Text == "close")

            {

                Application.Exit();

            }

        }

    }

}