How to check all CheckBox inside a GridView in ASP.net using JQuery

Write the code in ASPX page:-

 <script src="../../Scripts/jquery-1.7.1.js" type="text/javascript"></script>
<script src="../../Scripts/jquery-1.7.1.min.js" type="text/javascript"></script>
<script type="text/javascript">
    function SelectAllCheckboxes(chk) {
        $('#<%=GvLedgers.ClientID %>').find("input:checkbox").each(function () {
            if (this != chk) {
                this.checked = chk.checked;
            }
        });
    }
</script>

  GridView Design :-


<asp:GridView ID="GvLedgers" runat="server" AutoGenerateColumns="False">
                    <Columns>
                        <asp:BoundField HeaderText="Ledger"   DataField="Ledger_Name" />
                        <asp:TemplateField>
                            <HeaderTemplate>
                                <asp:CheckBox ID="ChkHeader" runat="server" onclick="javascript:SelectAllCheckboxes(this);" />
                            </HeaderTemplate>
                            <ItemTemplate>                               
                                <asp:CheckBox ID="ChkLedger" runat="server" />
                            </ItemTemplate>
                        </asp:TemplateField>
                    </Columns>
                </asp:GridView>

Recursive Function example in Sql Server

 For a better definition please visit the below site
http://www.techterms.com/definition/recursivefunction

 Table Structure:-



  Create  procedure [Ufms].[KC_SelectLedgersBank]      

as
begin

WITH RecursiveLedgers AS (SELECT        Ledger_ID, Ledger_Name, Parent_Ledger_ID
                                        FROM            Ledgers
                                        WHERE        (Ledger_ID = 3  )
                                        UNION ALL
                                        SELECT        L.Ledger_ID, L.Ledger_Name, L.Parent_Ledger_ID
                                        FROM            RecursiveLedgers AS RL  INNER JOIN
                                                                 Ledgers AS L ON f.ledger_id = L.Parent_Ledger_ID )
    SELECT        Ledger_ID, Ledger_Name, Parent_Ledger_ID
     FROM            RecursiveLedgers
 end

Out Put:-





It is very useful for MLM (Multi Level Marketing)

How to convert a string date value to DateTime when it complex

    Sometimes we accept Date value in textbox as a string format in "dd/MM/yyyy" but our database field contain the DateTime datatype. The complex situation comes that the string does not convert to DateTime easily. Here a single line which will convert it surely

  BnkDt.Text ="15/08/2012" //"dd/Mm/yyyy" format
 IFormatProvider Culture = new System.Globalization.CultureInfo("fr-FR", true);
 DateTime dt = DateTime.Parse(BnkDt.Text, Culture, System.Globalization.DateTimeStyles.AssumeLocal);

Update table through Cursor in Sql Server

Create PROCEDURE  UpdateBankDate

as
begin

DECLARE @VoucherId  int
DECLARE @BankDate  datetime

DECLARE curNewList CURSOR
   FAST_FORWARD
    FOR
       SELECT Voucher_Id,bank_date  From DataTableVoucherBankDate 
       OPEN curNewList
            FETCH NEXT FROM curNewList into @VoucherId, @BankDate
                 While @@FETCH_STATUS = 0
                     begin
                          UPDATE vouchers  Set BankDate = @BankDate  From DataTableVoucherBankDate 
                          Where Vouchers.voucher_id = @VoucherId
                          FETCH NEXT FROM curNewList into @VoucherId, @BankDate
                     end
      close curNewList
     deallocate curNewList

Compare Dateime Difference in ASP.Net Example

 Design View:-

  <body>
    <form id="form1" runat="server">
    <div>
      <asp:Label ID="Label3" runat="server" Text="DataBase Date :"></asp:Label>
      <asp:Label ID="Label4" runat="server" ></asp:Label>
        <asp:Label ID="Label1" runat="server" Text="Select A Date :"></asp:Label>
     <asp:TextBox ID="TxtDate" runat="server"></asp:TextBox>
        <asp:ImageButton ID="ImaCalender" runat="server"
            ImageUrl="~/Images/Calender.jpg" Height="20px" Width="20px"
            onclick="ImaCalender_Click"/>
                <asp:Calendar ID="Calendar1"
                    runat="server" Visible="False" onselectionchanged="Calendar1_SelectionChanged"
                    ></asp:Calendar>
                <asp:Button ID="ButnComprasion" runat="server" Text="Compare"
            onclick="ButnComprasion_Click" /><br />
        <asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>
    </div>
    </form>
</body>



  C# Code :-

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class Projects_Others_DateDifferencet : System.Web.UI.Page
{
    SqlConnection con;
    SqlCommand cmd;
    SqlDataReader dr; 
    DateTime getdate;
    static DateTime  selectedDate;
    protected void Page_Load(object sender, EventArgs e)
    {      
            try
            {

                con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString);
                con.Open();
                cmd = new SqlCommand("select convert(varchar(20),date_of_signing,111) as date_of_signing from ufms.fms_companyInfo", con);
                dr = cmd.ExecuteReader();
                if (dr.Read())
                {
                    getdate = Convert.ToDateTime(dr["date_of_signing"].ToString());
                    Label4.Text = getdate.ToString("dd/MM/yyyy");
                }

                con.Close();
            }
            catch (Exception ex)
            {

            }
      
    }
    protected void ImaCalender_Click(object sender, ImageClickEventArgs e)
    {
        Calendar1.Visible = true;
    }
    protected void Calendar1_SelectionChanged(object sender, EventArgs e)
    {
        TxtDate.Text = Calendar1.SelectedDate.ToString("dd/MM/yyyy");
        selectedDate =Convert.ToDateTime( Calendar1.SelectedDate.ToString("MM/dd/yyyy"));
        Calendar1.Visible = false;
    }
    protected void ButnComprasion_Click(object sender, EventArgs e)
    {
        TimeSpan diff = getdate - selectedDate;
        if (diff.Days <= 0)
        {
            Label2.Text = "Please select valid date";
        }
        else
        {
            Label2.Text = "You have " + diff.Days + " days less from DataBase Date";
        }

    }
}

GridView data to DataTable in ASP.Net

   In my project I needed this work and I think it is useful in many cases.
 
    Step-1:
       we have to create a table equal to grigview column we want to get
      public DataTable CreateTable()
        {
            dt = new DataTable();
            dt.Columns.Add("Category", typeof(string));
            dt.Columns.Add("DINPANCINFCRN_No", typeof(string));
            dt.Columns.Add("PromotorsName", typeof(string));
            dt.Columns.Add("FatherOrHusbandName", typeof(string));
            ...........................................up to any column
            dt.Columns.Add("Email", typeof(string)); 
            return dt;

        } 
 
Step-2:     
     Then we have to assign value from Gridview to DataTable

      public DataTable InnerData()
        {
            CreateTable();
            DataRow dr;
            foreach (GridViewRow row in GvPrmoter.Rows)
            {
                dr = dt.NewRow();
                dr[0] = row.Cells[0].Text;
                dr[1] = row.Cells[1].Text;
                dr[2] = row.Cells[2].Text;
                dr[3] = row.Cells[3].Text;
               .....................
                dr[n] = row.Cells[n].Text;
                dt.Rows.Add(dr);
            }          
            return dt;
        }
Step-3:     
     Then we can call the  InnerData() method  inside any event
 

How to check all Checkbox inside a Gridview in Asp.net

Design View :-


                       <HeaderTemplate>
                            <asp:CheckBox ID="CheckAll" runat="server" AutoPostBack="True"    oncheckedchanged="CheckAll_CheckedChanged"   />
                            <asp:Label ID="LblApproved" runat="server" Text="Approved All" />
                        </HeaderTemplate>



                      <ItemTemplate>
                            <asp:CheckBox ID="ChkApprove" runat="server" Checked='<%# Eval("Approved") %>' />                          
                        </ItemTemplate>



C# Code :-


 protected void CheckAll_CheckedChanged(object sender, EventArgs e)
        {
            CheckBox chk = (CheckBox)GridView1.HeaderRow.FindControl("CheckAll");
            if (chk.Checked)
            {
                for (int i = 0; i < GridView1.Rows.Count; i++)
                {
                    CheckBox chkrow = (CheckBox)GridView1.Rows[i].FindControl("ChkApprove");
                    chkrow.Checked = true;
                }


            }
            else
            {
                for (int i = 0; i < GridViewBankReceipt.Rows.Count; i++)
                {
                    CheckBox chkrow = (CheckBox)GridView1t.Rows[i].FindControl("ChkApprove");
                    chkrow.Checked = false;
                }
            }
        }