Export From Multiple Grid to Excel and PDF Formate

Export From Multiple Grid to Excel and PDF Formate

protected void btn_Exportxecel_Click(object sender, EventArgs e)
        {
            Response.Clear();
            Response.AddHeader("content-disposition", "attachment;filename=Export.xls");
            Response.Charset = "";
            Response.ContentType = "application/vnd.xls";

            StringWriter StringWriter = new System.IO.StringWriter();
            HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter);

            HtmlTextWriter.Write("<table width='100%'><tr><td colspan='9' align='center'><b>" + "Personal Detail" + "</b></td></tr></table>");
            Grid_PersonalDetail.RenderControl(HtmlTextWriter);
            HtmlTextWriter.RenderBeginTag(HtmlTextWriterTag.Br);

            HtmlTextWriter.Write("<table width='100%'><tr><td colspan='9' align='center'><b>" + "Address Deteail" + "</b></td></tr></table>");
            gridadress.RenderControl(HtmlTextWriter);
            HtmlTextWriter.RenderBeginTag(HtmlTextWriterTag.Br);

            HtmlTextWriter.Write("<table width='100%'><tr><td colspan='9' align='center'><b>" + "Invoice Detail" + "</b></td></tr></table>");
            grd_Invoicedetail.RenderControl(HtmlTextWriter);
            HtmlTextWriter.RenderBeginTag(HtmlTextWriterTag.Br);

            HtmlTextWriter.Write("<table width='100%'><tr><td colspan='9' align='center'><b>" + "Product Detail" + "</b></td></tr></table>");
            grd_product.RenderControl(HtmlTextWriter);
            HtmlTextWriter.RenderBeginTag(HtmlTextWriterTag.Br);

            HtmlTextWriter.Write("<table width='100%'><tr><td colspan='9' align='center'><b>" + "AMC/CMC Detail" + "</b></td></tr></table>");
            grd_AMC.RenderControl(HtmlTextWriter);
            HtmlTextWriter.RenderBeginTag(HtmlTextWriterTag.Br);

            HtmlTextWriter.Write("<table width='100%'><tr><td colspan='9' align='center'><b>" + "Service Detail" + "</b></td></tr></table>");
            grid_Service.RenderControl(HtmlTextWriter);
          

            Response.Write(StringWriter.ToString());
            Response.End();
        }

        protected void btn_exporttoPdf_Click(object sender, EventArgs e)
        {
            CssClass_GridView(gridadress);

            StringWriter sw0 = new StringWriter();
            HtmlTextWriter hw0 = new HtmlTextWriter(sw0);
            if (gridadress != null && gridadress.Rows.Count > 0)
            {
                hw0.Write("<table width='100%'><tr ><td><font size='5' color='white' align='left' style='text-align:left;'>");
                hw0.Write("Expense Record");
                hw0.Write("</font></td></tr>");
                hw0.Write("<tr><td>");
                hw0.Write("<font size='1' align='left' style='text-align:left;'>");
                StringWriter sw2 = new StringWriter();
                //EnableEventValidation = "false";
                //this.EnableViewState = False;
                sw2.Write("<table width='100%' Font-Bold='true' Font-Size='Large'><tr><td colspan='9' align='center'><b>" + "Personal Detail" + "</b></td></tr></table>");
                Grid_PersonalDetail.RenderControl(new HtmlTextWriter(sw2));
                sw2.Write("<table width='100%' Font-Bold='true' Font-Size='Large'><tr><td colspan='9'></td></tr></table>");
                gridadress.RenderControl(new HtmlTextWriter(sw2));
                sw2.Write("<table width='100%' Font-Bold='true' Font-Size='Large'><tr><td colspan='9' align='center'><b>" + "Invoice Deteail" + "</b></td></tr></table>");
                grd_Invoicedetail.RenderControl(new HtmlTextWriter(sw2));
                sw2.Write("<table width='100%' Font-Bold='true' Font-Size='Large'><tr><td colspan='9' align='center'><b>" + "Product Deteail" + "</b></td></tr></table>");             
                grd_product.RenderControl(new HtmlTextWriter(sw2));
                sw2.Write("<table width='100%' Font-Bold='true' Font-Size='Large'><tr><td colspan='9' align='center'><b>" + "AMC/CMC Deteail" + "</b></td></tr></table>");
                grd_AMC.RenderControl(new HtmlTextWriter(sw2));
                sw2.Write("<table width='100%' Font-Bold='true' Font-Size='Large'><tr><td colspan='9' align='center'><b>" + "Service Deteail" + "</b></td></tr></table>");
                grid_Service.RenderControl(new HtmlTextWriter(sw2));
                string html = sw2.ToString();
                hw0.Write(html);
                hw0.Write("</font>");
                hw0.Write("</td></tr></table>");
                StringReader sr = new StringReader(sw0.ToString().Replace("%20", " "));
                Document pdfDoc = new Document(PageSize.A4, 9f, 9f, 9f, 0f);
               //
            
              
             
                iTextSharp.text.html.simpleparser.HTMLWorker htmlparser = new iTextSharp.text.html.simpleparser.HTMLWorker(pdfDoc);
                string filename = Session["UserName"].ToString() + "_Details_" + DateTime.Now.Ticks + ".pdf";
                string file_Path = "~\\ExportFiles\\" + filename;
                PdfWriter.GetInstance(pdfDoc, new FileStream(Server.MapPath(file_Path), FileMode.Create));
                pdfDoc.Open();
                htmlparser.Parse(sr);
                pdfDoc.Close();
                // Response.Redirect("../ExportFiles/" + filename);
                Response.Redirect("../ExportFiles/" + filename, "_blank", "menubar=0,scrollbars=1,width=780,height=900,top=10");
            }
            else
            {
                ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", "alert('There Is No Data To Export Here. Please Fill Data  Firstly....')", true);
            }
        }

        protected void CssClass_GridView(GridView NewGrid)
        {
            NewGrid.Style.Add("width", "100%");
            NewGrid.Attributes.Add("ShowFooter", "True");
            NewGrid.Attributes.Add("CellPadding", "1");
            NewGrid.Font.Size = 10;
            NewGrid.ForeColor = System.Drawing.Color.FromArgb(51, 51, 51);
            NewGrid.GridLines = GridLines.None;
            NewGrid.ShowFooter = true;
            NewGrid.AlternatingRowStyle.BackColor = System.Drawing.Color.White;
            NewGrid.EditRowStyle.BackColor = System.Drawing.Color.FromArgb(36, 97, 191);
            NewGrid.FooterStyle.BackColor = System.Drawing.Color.FromArgb(80, 124, 209);
            NewGrid.FooterStyle.Font.Bold = true;
            NewGrid.FooterStyle.ForeColor = System.Drawing.Color.White;
            NewGrid.HeaderStyle.BackColor = System.Drawing.Color.FromArgb(80, 124, 209);
            NewGrid.HeaderStyle.Font.Bold = true;
            NewGrid.HeaderStyle.ForeColor = System.Drawing.Color.White;
            NewGrid.HeaderStyle.HorizontalAlign = HorizontalAlign.Left;
            NewGrid.RowStyle.BackColor = System.Drawing.Color.FromArgb(239, 243, 251);
            NewGrid.RowStyle.HorizontalAlign = HorizontalAlign.Left;
        }

Sql Cursor

Sql Cursor

DECLARE @ProductID decimal
DECLARE @getProductID cursor
SET @getProductID = CURSOR FOR
SELECT AddTaxRate
FROM salesnew
OPEN @getProductID
FETCH NEXT
FROM @getProductID INTO @ProductID
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @ProductID
FETCH NEXT
FROM @getProductID INTO @ProductID
END
CLOSE @getProductID

Bind Accrodian Dynamically

 Bind Accrodian Dynamically

<html>
<head><Title>Dynamically bind Accrodian</title>
</head>
<body>
<tr style="vertical-align: top;">
                    <td valign="top" style="width: 5%;">
                    </td>
                    <td valign="top" style="width: 90%;" align="center">
                        <cc1:Accordion ID="Accordion1" runat="server" CssClass="accordion" Width="100%" HeaderCssClass="accordionHeader"
                            Height="100%" HeaderSelectedCssClass="accordionHeaderSelected" ContentCssClass="accordionContent">
                        </cc1:Accordion>
                    </td>
                    <td valign="top" style="width: 5%;">
                    </td>
                </tr>
</head>
</body>

void bindData()
    {
        dt = new DataTable();
        cmd = new SqlCommand("selectEachCust_TablesID", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@MainID", MainID);
        con.Open();
        da = new SqlDataAdapter(cmd);
        da.Fill(dt);
        con.Close();
        if (dt.Rows.Count > 0)
        {
            bindAccordian(dt);
        }
    }

    void bindAccordian(DataTable dt1)
    {
        int i = 0;
        for (int j = 0; j < dt1.Columns.Count; j++)
        {
            if ((dt1.Rows[0][j].ToString()!="") && (Convert.ToInt64(dt1.Rows[0][j].ToString()) > 0))
            {
                AccordionPane p1 = new AccordionPane();

                p1.Style.Add("overflow", "scroll");
                //p1.Style.Add("Height", "100%");
                p1.ID = "AccordionPane" + i;
                Label lblHeader = new Label();
                lblHeader.ID = "lblHeader" + i;
                HiddenField hdnFld_tblName = new HiddenField();
                hdnFld_tblName.ID = "hdnFld_tblName" + i;
                if (dt1.Columns.Count > 1 && (tablename == "Sales" || tablename == "Service"))
                {
                    if (j == 0)
                    {
                        lblHeader.Text = "BSO Sales Order";
                        hdnFld_tblName.Value = "tblBsoSalesOrder";
                    }
                    else if (j == 1)
                    {
                        lblHeader.Text = "Billing Address";
                        hdnFld_tblName.Value = "tblBsoBillingAddress";
                    }
                    else if (j == 2)
                    {
                        lblHeader.Text = "Delivery Address";
                        hdnFld_tblName.Value = "tblBsoDeliveryAddress";
                    }
                    else if (j == 3)
                    {
                        lblHeader.Text = "Product Details";
                        hdnFld_tblName.Value = "tblBsoProducts";
                    }
                    else if (j == 4)
                    {
                        lblHeader.Text = "Spare Details";
                        hdnFld_tblName.Value = "tblBsoSpares";
                    }
                    else if (j == 5)
                    {
                        lblHeader.Text = "Charges";
                        hdnFld_tblName.Value = "tblBsoCharges";
                    }
                  
                      
                }
                else
                {
                    if (j == 0 && tablename == "AMC")
                    {
                        lblHeader.Text = "AMC Details";
                        hdnFld_tblName.Value = "tblAmc";
                    }
                    if (j == 1 && tablename == "AMC")
                    {
                        lblHeader.Text = "All AMC Details";
                        hdnFld_tblName.Value = "tblAmcDetails";
                    }
                    else if (j == 0 && tablename == "Query")
                    {
                        lblHeader.Text = "Query Details";
                        hdnFld_tblName.Value = "tblQuery";
                    }
                }
                p1.HeaderContainer.Controls.Add(lblHeader);
                DataTable dt2 = new DataTable();
                cmd = new SqlCommand("selectEachTableDetails", con);
                cmd.CommandType = CommandType.StoredProcedure;
                if (j != 3 && j != 4)
                    cmd.Parameters.AddWithValue("@MainID", dt1.Rows[0][j].ToString());
                else
                    cmd.Parameters.AddWithValue("@MainID", MainID);
                cmd.Parameters.AddWithValue("@TableName", hdnFld_tblName.Value.ToString());
                con.Open();
                da = new SqlDataAdapter(cmd);
                da.Fill(dt2);
                con.Close();
                if (hdnFld_tblName.Value == "tblBsoProducts")
                {
                    dt3 = dt2;
                    grv_Product.DataSource = dt2;
                    grv_Product.DataBind();
                    grv_Product.Visible = true;
                    p1.ContentContainer.Controls.Add(grv_Product);
                }
                else if (hdnFld_tblName.Value == "tblBsoSpares")
                {
                    dt4 = dt2;
                    grv_Spare.DataSource = dt2;
                    grv_Spare.DataBind();
                    grv_Spare.Visible = true;
                    p1.ContentContainer.Controls.Add(grv_Spare);
                }
              
                else if (dt2.Rows.Count < 2)
                {
                    dt6 = dt2;
                    GridView grid_AmcNew = new GridView();

                    grid_AmcNew.DataSource = dt2;
                    grid_AmcNew.DataBind();
                    grid_AmcNew.Visible = true;
                    CssClass_GridView(grid_AmcNew);
                    p1.ContentContainer.Controls.Add(grid_AmcNew);
                }
                Accordion1.Panes.Add(p1);
                i++;
            }
        }

Onkeypress textbox and value show in label

 Onkeypress on textbox and value show in label

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default4.aspx.cs" Inherits="Default4" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>
<head>
<link class="jsbin" href="http://ajax.googleapis.com/ajax/libs/jqueryui/1/themes/base/jquery-ui.css" rel="stylesheet" type="text/css" />
<script class="jsbin" src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.js"></script>
<script class="jsbin" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.5/jquery-ui.js"></script>
<meta charset=utf-8 />
<title>JS Bin</title>
<!--[if IE]>
  <script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script>
<![endif]-->
<style>
  article, aside, figure, footer, header, hgroup,
  menu, nav, section { display: block; }
</style>
<script type="text/javascript">
    $(function () {
        $('#txt1').keyup(function () {
         $('#output1').text($(this).val());
         $('#p1').text($(this).val());
        });
        $('#txt2').keyup(function () {
            $('#output2').text($(this).val());
            $('#p2').text($(this).val());
        });
        $('#txt3').keyup(function () {
            $('#output3').text($(this).val());
            $('#p3').text($(this).val());
        });
    });

</script>
</head>
<body>
<form id="form1" runat="server">
 <%-- <input id="txt1" type="text" />--%>
  <asp:TextBox ID="txt1" runat="server"></asp:TextBox><br />
  <asp:Label ID="output1" runat="server"></asp:Label><br />
   <asp:TextBox ID="txt2" runat="server"></asp:TextBox><br />
  <asp:Label ID="output2" runat="server"></asp:Label><br />
   <asp:TextBox ID="txt3" runat="server"></asp:TextBox><br />
  <asp:Label ID="output3" runat="server"></asp:Label>
  <br /><br />
 
   <div>
   <p id="p1"></p><br />
    <p id="p2"></p><br />
     <p id="p3"></p>
   </div>

  </form>
</body>
</html>

Procedure for Calculate Age

Procedure for Calculate Age

alter procedure pn_getDatedifference
(
@startdate datetime
)
as
begin

declare @monthToShow int
declare @dayToShow int
declare @enddate datetime
--set @startdate='01/21/1934'
set @enddate=getdate()

if(DAY(@startdate) > DAY(@enddate))
begin
set @dayToShow=0

if (month(@startdate) > month(@enddate))
begin
set @monthToShow= (12-month(@startdate)+ month(@enddate)-1)
end
else if (month(@startdate) < month(@enddate))
begin
set @monthToShow= ((month(@enddate)-month(@startdate))-1)
end
else
begin
set @monthToShow= 11
end
set @monthToShow= convert(int, DATEDIFF(mm,0,DATEADD(dd,DATEDIFF(dd,0,@enddate)- DATEDIFF(dd,0,@startdate),0)))-((convert(int,FLOOR(DATEDIFF(day, @startdate, @enddate) / 365.25))*12))-1
if(@monthToShow<0)
begin
set @monthToShow=0
end



declare @amonthbefore integer
set @amonthbefore=Month(@enddate)-1
if(@amonthbefore=0)
begin
set @amonthbefore=12
end

if(@amonthbefore in(1,3,5,7,8,10,12))
begin
set @dayToShow=31-DAY(@startdate)+DAY(@enddate)
end
if(@amonthbefore=2)
begin
IF (YEAR( @enddate ) % 4 = 0 AND YEAR( @enddate ) % 100 != 0) OR YEAR( @enddate ) % 400 = 0
begin
set @dayToShow=29-DAY(@startdate)+DAY(@enddate)
end
else
begin
set @dayToShow=28-DAY(@startdate)+DAY(@enddate)
end
end
if(@amonthbefore in (4,6,9,11))
begin
set @dayToShow=30-DAY(@startdate)+DAY(@enddate)
end

end
else
begin
set @monthToShow=convert(int, DATEDIFF(mm,0,DATEADD(dd,DATEDIFF(dd,0,@enddate)- DATEDIFF(dd,0,@startdate),0)))-((convert(int,FLOOR(DATEDIFF(day, @startdate, @enddate) / 365.25))*12))
if(month(@enddate)< month(@startdate))
begin
set @monthToShow=12+(month(@enddate)-month(@startdate))
end
else
begin
set @monthToShow= (month(@enddate)-month(@startdate))
end

set @dayToShow=DAY(@enddate)-DAY(@startdate)
end


SELECT
--FLOOR(DATEDIFF(day, @startdate, @enddate) / 365.25) as [yearToShow],
--@monthToShow as monthToShow ,@dayToShow as dayToShow ,
convert(varchar,FLOOR(DATEDIFF(day, @startdate, @enddate) / 365.25)) +' Year ' + convert(varchar,@monthToShow) +' months '+convert(varchar,@dayToShow)+' days ' as age
end

Java Script for GridView Pager

Java Script for GridView Pager

<script src='<%=Page.ResolveUrl("~/Scripts/tablesorter.js") %>' type="text/javascript"></script>
     <script src='<%=Page.ResolveUrl("~/Scripts/jquery.tablesorter.pager.js") %>' type="text/javascript"></script>



<script type="text/javascript">

    $(document).ready(function () {
        var rowsCount = '<%=Grid_Subscription.Rows.Count %>';
        var s = document.getElementById('<%= Grid_Subscription.ClientID %>');
        $("#" + s.id.toString()).tablesorter({ sortList: [[0, 0]], headers: { 6: { sorter: false }, 7: { sorter: false }, 8: { sorter: false}} }).tablePagination({ optionsForRows: [10, 25, 50, 100, rowsCount] });
    });
</script>

Javascript Validation of Numeric,Phone,Albhabet,Date

Javascript Validation of Numeric,Phone,Albhabet,Date

<html>
<head><title>Javascript validation</title>

<script language="javascript" type="text/javascript">
        function isCurrency(evt, txtid) {
            var charCode = (evt.which) ? evt.which : event.keyCode
            var ctrl = document.getElementById(txtid)
            if (ctrl.value.indexOf('.') == -1 && charCode == 46)
                true;
            else if (charCode > 31 && (charCode < 48 || charCode > 57)) {
                alert(" you can enter Only Numeric character..!!!");
                return false;
            }
            return true;
        }
        function CheckDate(sender, args) {
            if (sender._selectedDate > new Date()) {
                alert("Please Select Valid Birth Date...!!");
                sender._selectedDate = new Date();
                sender._textbox.set_Value(sender._selectedDate.format(sender._format));
            }
        }
        function OnlyAlphabets(evt) {
            var charCode = (evt.which) ? evt.which : event.keyCode
            if ((charCode >= 97 && charCode <= 122) || (charCode >= 65 && charCode <= 90) || (charCode <= 32))
                true;
            else {
                alert("Only Alhaphet Characters Are Allowed To Enter..!!!");
                return false;
            }
            return true;
        }

        function DisableButton(buttonElem) {
            buttonElem.value = "Please Wait....";
            buttonElem.disabled = true;

        }
        function isName(evt, txtid) {
            var charCode = (evt.which) ? evt.which : event.keyCode
            var ctrl = document.getElementById(txtid)
            if ((charCode >= 65 && charCode <= 90) || (charCode >= 97 && charCode <= 122) || (charCode == 32) || (charCode == 46)) {
                return true;
            }
            else
                alert("You Can Enter Only Alphabets,Space,Or Dot(.)");
            return false;
        }
        function isNumberKey(evt) {
            var charCode = (evt.which) ? evt.which : event.keyCode
            if (charCode > 31 && (charCode < 48 || charCode > 57)) {
                alert("you can enter Only Numeric character..!!!");
                return false;
            }
            return true;
        }
        function isPhoneNo(evt) {
            var charCode = (evt.which) ? evt.which : event.keyCode
            if (charCode == 45) return true;
            if (charCode > 31 && (charCode < 48 || charCode > 57)) {
                alert("you can enter Only Numeric characters and '-' ...!!!");
                return false;
            }
            return true;
        }

        function NoNumberKey(evt) {
            var charCode = (evt.which) ? evt.which : event.keyCode
            if (charCode >= 48 && charCode <= 57) {
                alert("Digits are not allowed..!!!");
                return false;
            }
            return true;
        }

    </script>
</head>
<body>
<form id="from1" runat="server">
<div>
<table>
<tr>
<td>User Name:</td>
<td>
 <asp:TextBox ID="txt_username" runat="server" CssClass="txt" MaxLength="10"
  onkeypress="return OnlyAlphabets(evt);" Width="116px"></asp:TextBox>
</td>
</tr>
<tr>
<td>Mobile:</td>
<td>
 <asp:TextBox ID="txt_Mobile" runat="server" CssClass="txt" MaxLength="10"
  onkeypress="return isNumberKey(event);" Width="116px"></asp:TextBox>
</td>
</tr>
</div>
</form>
</body>
</html>