Post
Ask Question
sathish kumar

sathish kumar

  • NA
  • 117
  • 163.4k

i want to select only one radio button based on gridview row selection

Jul 10 2012 2:20 AM

hi friends...


   i want to select only one radio button based on gridview row selection


 <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
        <td class="welcome">
            <asp:Label ID="lblMenu" runat="server" Text="General Collection"
                Font-Size="Medium"></asp:Label>
            &nbsp;&nbsp;
           <asp:label ID="Label32" runat="server" text="(*) - Mandatory Fields"
            ForeColor="Red"></asp:label>
            </td>
        </tr>
        <tr>
        <td height="1" style="background:images/undertext_bg.gif" class="bgx"><img alt= "" src="images/spacer.gif" width="1" height="1" /></td>
        </tr>
       </table>
       
       <table>
       <tr>
       <td class="style14">
           &nbsp;<asp:Label ID="Label1" runat="server" Text="Receipt No"></asp:Label>
           <asp:Label ID="Label41" runat="server" ForeColor="Red" Text="(*)"></asp:Label>
        &nbsp;&nbsp;&nbsp;<asp:TextBox ID="txtReceiptNo" runat="server" ForeColor="#000099" Width="100px"></asp:TextBox>
           &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<asp:Label ID="Label2" runat="server" Text="Date"></asp:Label>
           &nbsp;<asp:Label ID="Label44" runat="server" ForeColor="Red" Text="(*)"></asp:Label>
                &nbsp; &nbsp;<asp:TextBox ID="txtDate" runat="server" ForeColor="#000099"
               Width="77px"></asp:TextBox>
           &nbsp;&nbsp; <asp:Label ID="Label38" runat="server" Text="Patient Type"></asp:Label>
           &nbsp;<asp:Label ID="Label31" runat="server" ForeColor="Red" Text="(*)"></asp:Label>
           &nbsp;<asp:RadioButton ID="rbIP" runat="server" GroupName="a" Text="IP"  
            AutoPostBack="true" oncheckedchanged="rbIP_CheckedChanged"/>
&nbsp; <asp:RadioButton ID="rbOP" runat="server" GroupName="a" Text="OP"
            AutoPostBack="true" oncheckedchanged="rbOP_CheckedChanged" />
&nbsp;
<asp:RadioButton ID="rbDirect" runat="server" GroupName="a" Text="Direct"
            AutoPostBack="true" oncheckedchanged="rbDirect_CheckedChanged" />
           <br />
           <br />
           &nbsp;<asp:Label ID="Label3" runat="server" Text="Hospital No"></asp:Label>
        &nbsp;<asp:Label ID="Label28" runat="server" ForeColor="Red" Text="(*)"></asp:Label>
                &nbsp;&nbsp;<asp:TextBox ID="txtHospitalNo" runat="server" ForeColor="#000099" Width="103px"></asp:TextBox>
           &nbsp; <asp:Label ID="Label4" runat="server" Text="Patient Name"></asp:Label>
           &nbsp;<asp:Label ID="Label40" runat="server" ForeColor="Red" Text="(*)"></asp:Label>
          
           &nbsp;<asp:DropDownList ID="ddlTitle" runat="server"
                Height="22px" ForeColor="#000099"
               onselectedindexchanged="ddlTitle_SelectedIndexChanged">
                <asp:ListItem>&lt;--Title--&gt;</asp:ListItem>
                <asp:ListItem>Sri.</asp:ListItem>
                <asp:ListItem>Kumar</asp:ListItem>
                <asp:ListItem>Kumari</asp:ListItem>
                <asp:ListItem>Mr.</asp:ListItem>
                <asp:ListItem>Mrs.</asp:ListItem>
                <asp:ListItem>Miss</asp:ListItem>
                <asp:ListItem>Ms.</asp:ListItem>
                <asp:ListItem>Dr.</asp:ListItem>
                <asp:ListItem>Prof.</asp:ListItem>
                <asp:ListItem>Master</asp:ListItem>
                <asp:ListItem>Mother Of</asp:ListItem>
                <asp:ListItem>Brother Of</asp:ListItem>
                <asp:ListItem>Baby Of</asp:ListItem>
                <asp:ListItem>Father Of</asp:ListItem>
                <asp:ListItem>Others</asp:ListItem>
            </asp:DropDownList>
           &nbsp;
           <asp:DropDownList ID="ddlPatientName" runat="server" Height="22px"
               Width="254px" ForeColor="#000099" AutoPostBack="True">
           </asp:DropDownList>
                      
           <br />
           <br />
           &nbsp;<asp:Label ID="Label42" runat="server" Text="Visit Type"></asp:Label>
           &nbsp;<asp:Label ID="Label43" runat="server" ForeColor="Red" Text="(*)"></asp:Label>
           &nbsp;&nbsp;&nbsp; <asp:DropDownList ID="ddlVisitType" runat="server" Height="22px" Width="202px" ForeColor="#000099">
           </asp:DropDownList>
           &nbsp;</td>       
       </tr>
      
       </table>
       <table>
       <tr>
       <td class="style17" align="center">
           <asp:Label ID="Label5" runat="server" Text="Transaction Type"></asp:Label></td>
           &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
         <td class="style16" align="center">  <asp:Label ID="Label6" runat="server" Text="Charge"></asp:Label> </td>    
       </tr>
       <tr>
       <td class="style18">
           &nbsp;&nbsp;&nbsp;&nbsp;
           <asp:DropDownList ID="ddlTransactionType" runat="server" Height="20px"
               Width="239px" ForeColor="#000099" AutoPostBack="True"
               onselectedindexchanged="ddlTransactionType_SelectedIndexChanged">
           </asp:DropDownList>
           
           </td>
           <td class="style12">           
           <asp:TextBox ID="txtCharge" runat="server" ForeColor="#000099" AutoPostBack="True"></asp:TextBox></td>
           <td class="style15">
               &nbsp;&nbsp;<asp:Button ID="cmdAddItem" runat="server" Font-Bold="True" Font-Names="Tahoma"
                              Font-Size="X-Small" Height="26px" onclick="cmdAddItem_Click" Text="ADD ITEM"
                              Width="84px" />
               <br />
           </td>
       </tr>
       
       </table>
       
        <table class="style4">
        <tr>
            <td>
            <asp:GridView ID="gvGeneralCollection" runat="server" DataKeyNames="TransName"
                    CellPadding="4"  ForeColor="#333333" GridLines="None"
                    Width="579px" AllowPaging="True" AutoGenerateColumns="False" ShowFooter="True"
                    EmptyDataText="No Records found !!" style="margin-left: 30px"
                    onrowdeleting="gvGeneralCollection_RowDeleting" onrowdatabound="gvGeneralCollection_RowDataBound"
                    >
                    <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
                     <Columns>
                       
                        <asp:BoundField DataField="TransName" HeaderText="TransName"
                            SortExpression="TransName">
                        </asp:BoundField>                       
                        <asp:TemplateField HeaderText="Charge">
                        <ItemTemplate>
                        <asp:Label ID="lbltotalAmount" runat="server" Text='<%# Eval("Charge")%>' ></asp:Label>
                        </ItemTemplate>
                          <FooterTemplate>
        <asp:Label ID="lbltotalAmount" runat="server" Text="0.00"></asp:Label>
        </FooterTemplate>    
                        
                        </asp:TemplateField>
                       
      <asp:TemplateField >
     <ItemTemplate>
       <asp:LinkButton ID="LinkButton1"
         CommandArgument='<%# Eval("TransName") %>'
         CommandName="Delete" runat="server" OnClientClick="javascript:return confirm('Do you really want to \ndelete the item?');">
         Delete</asp:LinkButton>
     </ItemTemplate>
   </asp:TemplateField>
                      
                    </Columns>
                    <PagerSettings Position="Top" FirstPageText="First" LastPageText="Last"
                        Mode="NextPreviousFirstLast" NextPageText="Next" PreviousPageText="Previous" />
                  <FooterStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
                
   <RowStyle CssClass="RowStyle" />

   <PagerStyle CssClass="PagerStyle" />

    <SelectedRowStyle CssClass="SelectedRowStyle" />

    <HeaderStyle CssClass="HeaderStyle" />

    <EditRowStyle CssClass="EditRowStyle" />

    <AlternatingRowStyle CssClass="AltRowStyle" />
     
                        </asp:GridView>
            </td>
        </tr>
        </table>
        <table class="style5">
        <tr>
        <td class="style10">
            <br />
            &nbsp;<asp:Label ID="Label7" runat="server" Text="a Sum of Rs"></asp:Label>
            &nbsp;<asp:TextBox ID="txtSum" runat="server" Width="107px" ForeColor="#000099"></asp:TextBox>
            &nbsp;&nbsp;&nbsp;
            <asp:Label ID="Label8" runat="server" Text="By"></asp:Label>
            &nbsp;&nbsp;&nbsp;
            <asp:RadioButton ID="rbCash" runat="server" Text="Cash" GroupName="b"
                AutoPostBack="true" oncheckedchanged="rbCash_CheckedChanged"/>
            &nbsp;
            <asp:RadioButton ID="rbCheque" runat="server" Text="Cheque" GroupName="b"
                AutoPostBack="true" oncheckedchanged="rbCheque_CheckedChanged" />
            <asp:RadioButton ID="rbDD" runat="server" Text="DD"  GroupName="b"
                AutoPostBack="true" oncheckedchanged="rbDD_CheckedChanged"/>
            &nbsp;&nbsp;&nbsp;
            <asp:RadioButton ID="rbCreditCard" runat="server"  Text="Credit Card"
                GroupName="b" AutoPostBack="true"
                oncheckedchanged="rbCreditCard_CheckedChanged"/>
            &nbsp;&nbsp;&nbsp;
            <asp:RadioButton ID="rbDebitCard" runat="server" Text="Debit Card"
                GroupName="b" AutoPostBack="true"
                oncheckedchanged="rbDebitCard_CheckedChanged" />
            &nbsp;&nbsp;&nbsp;
            <asp:RadioButton ID="rbAmountCollectLater" runat="server"
                Text="Amount Collect Later" GroupName="b" AutoPostBack="true"
                oncheckedchanged="rbAmountCollectLater_CheckedChanged" />
            <br />
        </td>
        </tr>
        <tr><td class="style13">
            &nbsp;
            <asp:Label ID="Label9" runat="server" Text="Vide No"></asp:Label>
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <asp:TextBox ID="txtVideNo" runat="server" Width="109px" ForeColor="#000099"></asp:TextBox>
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <asp:Label ID="Label10" runat="server" Text="Dated"></asp:Label>
            &nbsp;&nbsp;&nbsp;&nbsp; <asp:TextBox ID="txtDated" runat="server" Width="81px"
                ForeColor="#000099"></asp:TextBox>
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <asp:Label ID="Label11" runat="server" Text="Drawn On"></asp:Label>
            &nbsp;&nbsp;
            &nbsp;<asp:TextBox ID="txtDrawnOn" runat="server" Width="119px"
                ForeColor="#000099"></asp:TextBox>
            <br />
        </td></tr>
        <tr>
        <td class="style13">
            &nbsp;
            <asp:Label ID="Label12" runat="server" Text="Select Consulted Doctor"></asp:Label>
            &nbsp;&nbsp;&nbsp;&nbsp;
            <asp:DropDownList ID="ddlConsultedDoctor" runat="server" Height="22px"
                ForeColor="#000099" Width="324px">
            </asp:DropDownList>
            <br />
        </td>
        </tr>
        <tr>
        <td class="style13">
            &nbsp;
            <asp:Label ID="Label13" runat="server" Text="Remarks"></asp:Label>
            &nbsp;&nbsp;
            <asp:TextBox ID="txtRemarks" runat="server" style="margin-left: 14px"
                TextMode="MultiLine" Width="548px"  ForeColor="#000099"></asp:TextBox>
        </td>
        </tr>
        </table>
        <table >
            <tr><td></td></tr>
            <tr>
                <td >
                    
                    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;</td>
                <td class="Name">
                    
                    <asp:Button ID="cmdAdd" runat="server" Text="ADD" Width="84px" Font-Bold="True"
                        Font-Names="Tahoma" Font-Size="X-Small" onclick="cmdAdd_Click" />
                    <asp:Button ID="cmdModify" runat="server" Text="MODIFY" Width="84px" Font-Bold="True"
                        Font-Names="Tahoma" Font-Size="X-Small" onclick="cmdModify_Click"  />
                    <asp:Button ID="cmdDelete" runat="server" Text="DELETE" Width="84px" Font-Bold="True"
                        Font-Names="Tahoma" Font-Size="X-Small" onclick="cmdDelete_Click"  />
                    <asp:Button ID="cmdCancel" runat="server" Text="RESET" Width="84px" Font-Bold="True"
                        Font-Names="Tahoma" Font-Size="X-Small" onclick="cmdCancel_Click"  />
                    
                </td>
            </tr>
            
        </table>
         <div class="styleDiv">
             &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;<br />
             &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <asp:Label ID="LblSearch" runat="server"
                    Text="Filter By "></asp:Label>
                &nbsp;&nbsp;<asp:DropDownList ID="ddlSearch" runat="server" ForeColor="#000099">
                <asp:ListItem Text="Receipt No" Value="ReceiptNo" />            
               <asp:ListItem Text="Hospital No" Value="HospitalNo" />
               <asp:ListItem Text="Payment Type" Value="Payment_Type" />             
               <asp:ListItem Text="Remarks" Value="Remarks" />             

                </asp:DropDownList>
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <asp:TextBox ID="TxtSearch" runat="server" Width="130px" ForeColor="#000099"></asp:TextBox>
             &nbsp;<asp:Button ID="CmdSearch" runat="server" Height="20px"
                        onclick="CmdSearch_Click" Text="Search" Width="84px" />
                    <asp:Button ID="CmdClear" runat="server" Height="20px" onclick="CmdClear_Click"
                        Text="Clear" Width="84px" />

                <br />
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                <br />
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <asp:Label ID="lblSearchRecords" runat="server" Text="Label"></asp:Label>
                <br />
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<asp:Label ID="lblPage" runat="server"
                    Text="Label"></asp:Label>
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                    <asp:Label ID="lblPageList" runat="server" Text="Go to"></asp:Label>&nbsp;&nbsp;&nbsp;&nbsp;
                    <asp:DropDownList ID="ddlPageList" runat="server"
                        onselectedindexchanged="ddlPageList_SelectedIndexChanged"
                    AutoPostBack = "true" ForeColor="#000099"></asp:DropDownList>
                   
                &nbsp;
                <asp:Label ID="Label33" runat="server" Text="Page"></asp:Label>
                   
                <br />
             &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                <asp:Label
                    ID="Label36" runat="server" Text="Total Records :"></asp:Label>
<asp:Label ID="lblRecords" runat="server" Text="(Label )"></asp:Label>

            </div>
               
      <table class="GridViewStyle">
                      
             <tr>
            <td class="style3">
             <asp:Panel ID="scrollableGridArea" runat="server" ScrollBars ="Auto"
                      style="overflow:scroll; height: 290px; width:700px" Height="240px"
                      Width="787px">
                  <asp:GridView ID="gvCollection" runat="server" AllowPaging="True"
                      AutoGenerateColumns="False" CellPadding="4" DataSourceID="SqlCollection"
                      EmptyDataText="No Records found !!" ForeColor="#333333" GridLines="None"
                      Height="289px" ondatabound="gvCollection_DataBound"
                      onprerender="gvCollection_PreRender"
                      onrowcommand="gvCollection_RowCommand"
                      onselectedindexchanged="gvCollection_SelectedIndexChanged"
                      ShowFooter="True" Width="482px">
                      <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
                      <Columns>
                          <asp:CommandField ShowSelectButton="true" />
                          <asp:BoundField DataField="ReceiptNo" HeaderText="ReceiptNo" SortExpression="ReceiptNo" />
                          <asp:BoundField DataField="ReceiptDate" HeaderText="ReceiptDate"
                              SortExpression="ReceiptDate" />  
                             <asp:BoundField DataField="Patient_ID" HeaderText="Patient ID"
                              SortExpression="Patient_ID" />  
                                <asp:BoundField DataField="DoctorID" HeaderText="DoctorID" SortExpression="DoctorID" />
                          <asp:BoundField DataField="Amount" HeaderText="Amount"
                              SortExpression="Amount" />
                          <asp:BoundField DataField="Payment_Type" HeaderText="Payment Type"
                              SortExpression="Payment_Type" />
                          <asp:BoundField DataField="Cheque_No" HeaderText="Cheque No"
                              SortExpression="Cheque_No" />                      
                            
                               <asp:BoundField DataField="Cheque_Date" HeaderText="Cheque Date "
                              SortExpression="Cheque_Date" />           
                         
                          <asp:BoundField DataField="Banker" HeaderText="Banker"
                              SortExpression="Banker" />  
                          <asp:BoundField DataField="DateCreated" HeaderText="DateCreated"
                              SortExpression="DateCreated" />
                          <asp:BoundField DataField="Remarks" HeaderText="Remarks"
                              SortExpression="Remarks" />
                         
                      </Columns>
                      <FooterStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
                      <PagerStyle CssClass="PagerStyle" />
                      <SelectedRowStyle CssClass="SelectedRowStyle" />
                      <HeaderStyle CssClass="HeaderStyle" />
                      <EditRowStyle CssClass="EditRowStyle" />
                      <AlternatingRowStyle CssClass="AltRowStyle" />
                      <PagerSettings FirstPageText="First" LastPageText="Last"
                          Mode="NextPreviousFirstLast" NextPageText="Next" PageButtonCount="5"
                          Position="Top" PreviousPageText="Previous" />
                  </asp:GridView>
                   <asp:SqlDataSource ID="SqlCollection" runat="server"
                      ConnectionString="<%$ ConnectionStrings:CMC %>"
                      SelectCommand=" SELECT COLLECTION_TRANS.ReceiptNo, COLLECTION_TRANS.ReceiptDate, COLLECTION_TRANS.DoctorID, COLLECTION_TRANS.Charge,payment_details.Patient_ID, payment_details.Payment_Type, payment_details.Amount, payment_details.Cheque_No, payment_details.Cheque_Date,payment_details.Banker, payment_details.DateCreated, payment_details.Remarks FROM COLLECTION_TRANS INNER JOIN payment_details ON COLLECTION_TRANS.HospitalNo = payment_details.HospitalNo"                
                      FilterExpression="{0} LIKE '{1}%'">
                   
                    <FilterParameters>
                     <asp:ControlParameter Name="FieldToSearch" ControlID="ddlSearch" PropertyName="SelectedValue" />
                     
                        <asp:ControlParameter Name="SearchCriteria" ControlID="TxtSearch"
                            PropertyName="Text" />                           
                     
                     </FilterParameters>
                </asp:SqlDataSource>
                </asp:Panel>
            </td>
            </tr>
        </table>


below is my aspx.cs code

public partial class GeneralCollection : System.Web.UI.Page
{
    decimal grdAmount = 0;
    private string PatientType = "";
    private string PaymentType = "";
    private string SearchString = "";
      
    protected void Page_Load(object sender, EventArgs e)
    {
        if (IsPostBack == false)
        {
            VisitType();
            TransactionType();
            ReceiptNo();
            PatientName();
            ConsultedDoctor();
            Grid_clear();

            txtReceiptNo.ReadOnly = true;
            txtDate.Enabled = false;
            txtHospitalNo.ReadOnly = true;
            ddlVisitType.Enabled = false;
            ddlPatientName.Enabled = false;
            ddlTitle.Enabled = false;
            ddlTransactionType.Enabled = false;
            txtCharge.Enabled = false;
            txtSum.Enabled = false;
            txtVideNo.Enabled = false;
            ddlConsultedDoctor.Enabled = false;
            txtDrawnOn.Enabled = false;
            txtDated.Enabled = false;
            txtRemarks.Enabled = false;
            cmdModify.Enabled = false;
            cmdDelete.Enabled = false;
            cmdDelete.Attributes.Add("OnClick", "return WarningDelete()");
            lblSearchRecords.Visible = false;
            //User = Request.QueryString["txtuser"];
          //  this.txtDrawnOn.Text = Request.QueryString["txtuser"];
        }
    }

    protected void ReceiptNo()
    {
        string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
        SqlConnection sqlConn = new SqlConnection(dbConn);
        sqlConn.Open();
        string strSQL = "Select MAX(CID) from COLLECTION_TRANS ";
        SqlCommand cmd = new SqlCommand(strSQL, sqlConn);
        object No = cmd.ExecuteScalar();
        if (No == DBNull.Value)
        {
           txtReceiptNo.Text = "1";
        }
        else
        {
            int m = Convert.ToInt32(No.ToString());
            int n = m + 1;
            txtReceiptNo.Text = n.ToString();

        }

        sqlConn.Close();
    }

    protected void VisitType()
    {
        ddlVisitType.Items.Clear();
        string strSQL;
        string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
        SqlConnection sqlConn = new SqlConnection(dbConn);
        sqlConn.Open();
        strSQL = " select VisitName from VisitTypes ";
        SqlCommand cmdRoomType = new SqlCommand(strSQL, sqlConn);
        ddlVisitType.Items.Add("<======Select=====>");

        SqlDataReader dr = cmdRoomType.ExecuteReader();
        while (dr.Read())
        {
            ddlVisitType.Items.Add(dr[0].ToString());
        }

        sqlConn.Close();
    }

    protected void TransactionType()
    {
        ddlTransactionType.Items.Clear();
        string strSQL;
        string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
        SqlConnection sqlConn = new SqlConnection(dbConn);
        sqlConn.Open();
        strSQL = " select TypeName from TransactionType ";
        SqlCommand cmdRoomType = new SqlCommand(strSQL, sqlConn);
        ddlTransactionType.Items.Add("<======Select=====>");

        SqlDataReader dr = cmdRoomType.ExecuteReader();
        while (dr.Read())
        {
            ddlTransactionType.Items.Add(dr[0].ToString());
        }

        sqlConn.Close();
    }

    protected void ConsultedDoctor()
    {
        ddlConsultedDoctor.Items.Clear();
        string strSQL;
        string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
        SqlConnection sqlConn = new SqlConnection(dbConn);
        sqlConn.Open();
        strSQL = "select Name from doctor_details";
        SqlCommand cmdConsultedDoctor = new SqlCommand(strSQL, sqlConn);
        ddlConsultedDoctor.Items.Add("<============Select==========>");

        SqlDataReader drConsultedDoctor = cmdConsultedDoctor.ExecuteReader();
        while (drConsultedDoctor.Read())
        {
            ddlConsultedDoctor.Items.Add(drConsultedDoctor[0].ToString());
        }

        sqlConn.Close();
    }

    protected void PatientName()
    {

        ddlPatientName.Items.Clear();
        string strSQL;
        string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
        SqlConnection sqlConn = new SqlConnection(dbConn);
        sqlConn.Open();
        strSQL = "select Patient_Name from registration_details";
        SqlCommand cmdPatientName = new SqlCommand(strSQL, sqlConn);
        ddlPatientName.Items.Add("<============Select==========>");

        SqlDataReader drPatientName = cmdPatientName.ExecuteReader();
        while (drPatientName.Read())
        {
            ddlPatientName.Items.Add(drPatientName[0].ToString());
        }

        sqlConn.Close();
    }
    public static string DoctorID(string strDoctorCode)
    {
        string Code = "";
        string strSQL;
        string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
        SqlConnection sqlConn = new SqlConnection(dbConn);
        sqlConn.Open();
        strSQL = " select RegID from doctor_details where Name='" + strDoctorCode + "'";
        SqlCommand cmdTestHeads = new SqlCommand(strSQL, sqlConn);
        SqlDataReader drTestHeads = cmdTestHeads.ExecuteReader();
        if (drTestHeads.Read())
        {
            Code = drTestHeads[0].ToString();
        }
        sqlConn.Close();
        return Code;
    }

    public static string PatientCode(string strPatientId)
    {
        string Code = "";
        string strSQL;
        string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
        SqlConnection sqlConn = new SqlConnection(dbConn);
        sqlConn.Open();
        strSQL = " select RegID from registration_details where Patient_Name='" + strPatientId + "'";
        SqlCommand cmdTestHeads = new SqlCommand(strSQL, sqlConn);
        SqlDataReader drTestHeads = cmdTestHeads.ExecuteReader();
        if (drTestHeads.Read())
        {
            Code = drTestHeads[0].ToString();
        }
        sqlConn.Close();
        return Code;
    }

    protected void ddlTransactionType_SelectedIndexChanged(object sender, EventArgs e)
    {
        string strSQL;     
        string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
        SqlConnection sqlConn = new SqlConnection(dbConn);
        sqlConn.Open();
        strSQL = "select Charge from TransactionType where TypeName='"+ddlTransactionType.SelectedItem.ToString()+"'";
        SqlCommand cmdWardDetails = new SqlCommand(strSQL, sqlConn);

        SqlDataReader drWardDetails = cmdWardDetails.ExecuteReader();
        if(drWardDetails.Read())
        {
            txtCharge.Text = drWardDetails[0].ToString();
        }
        sqlConn.Close();
    }

    protected void ClearFields()
    {
        txtReceiptNo.Text = "";
        txtDate.Text = "";
        txtHospitalNo.Text = "";
        ddlVisitType.SelectedIndex = 0;
        ddlPatientName.SelectedIndex = 0;
        ddlTitle.SelectedIndex = 0;
        ddlTransactionType.SelectedIndex = 0;
        ddlConsultedDoctor.SelectedIndex = 0;
        txtCharge.Text = "";
        txtSum.Text = "";
        txtVideNo.Text = "";     
        txtDrawnOn.Text = "";
        txtDated.Text = "";
        txtRemarks.Text = "";
    }  
    protected void cmdAddItem_Click(object sender, EventArgs e)
    {

        gvGeneralCollection.Visible = true;

        try
        {

            if (ddlTransactionType.SelectedIndex != 0)
            {
                gvGeneralCollection.Visible = true;
                string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
                SqlConnection sqlConn = new SqlConnection(dbConn);
                sqlConn.Open();

                string strSQL1 = " INSERT INTO [tmpTransList](THID,TransName,Charge)VALUES('" + txtReceiptNo.Text + "','" + ddlTransactionType.SelectedItem.ToString() + "','" + txtCharge.Text + "')";

                SqlCommand cmd1 = new SqlCommand(strSQL1, sqlConn);
                cmd1.ExecuteNonQuery();

                SqlDataAdapter dadapter = new SqlDataAdapter(" SELECT THID,TransName,Charge from tmpTransList", sqlConn);
                DataSet dset = new DataSet();
                dadapter.Fill(dset);
                gvGeneralCollection.DataSource = dset;
                gvGeneralCollection.DataBind();
                sqlConn.Close();
                ddlTransactionType.SelectedIndex = 0;
                txtCharge.Text = "";
            }
            else
            {
                Response.Write("<script language='javascript'>alert('Select Transaction Type!!!');</script>");
            }
        }

        catch (Exception)
        {
            Response.Write("<script language='javascript'>alert('Invalid Data!!!');</script>");
        }
       
    }

   
    protected void rbIP_CheckedChanged(object sender, EventArgs e)
    {
        if (rbIP.Checked == true)
        {
           PatientType = "IP";
            string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
            SqlConnection sqlConn = new SqlConnection(dbConn);
            sqlConn.Open();
            string strSQL = "Select MAX(RegID) from registration_details ";
            SqlCommand cmdRegistration = new SqlCommand(strSQL, sqlConn);
            object No = cmdRegistration.ExecuteScalar();


            if (No == DBNull.Value)
            {
                txtHospitalNo.Text = "CMC1";

            }
            else
            {
                int m = Convert.ToInt32(No.ToString());
                int n = m + 1;
                txtHospitalNo.Text = "CMC" + n.ToString();

            }
        }
    }
    protected void rbOP_CheckedChanged(object sender, EventArgs e)
    {
        if (rbOP.Checked == true)
        {
            PatientType = "OP";
            string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
            SqlConnection sqlConn = new SqlConnection(dbConn);
            sqlConn.Open();
            string strSQL = "Select MAX(RegID) from registration_details ";
            SqlCommand cmdRegistration = new SqlCommand(strSQL, sqlConn);
            object No = cmdRegistration.ExecuteScalar();


            if (No == DBNull.Value)
            {
                txtHospitalNo.Text = "CMC1";

            }
            else
            {
                int m = Convert.ToInt32(No.ToString());
                int n = m + 1;
                txtHospitalNo.Text = "CMC" + n.ToString();

            }
        }
    }
    protected void rbDirect_CheckedChanged(object sender, EventArgs e)
    {
        if (rbDirect.Checked == true)
        {
            PatientType = "Direct";

            string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
            SqlConnection sqlConn = new SqlConnection(dbConn);
            sqlConn.Open();
            string strSQL = "Select MAX(RegID) from registration_details ";
            SqlCommand cmdRegistration = new SqlCommand(strSQL, sqlConn);
            object No = cmdRegistration.ExecuteScalar();


            if (No == DBNull.Value)
            {
                txtHospitalNo.Text = "RF1";

            }
            else
            {
                int m = Convert.ToInt32(No.ToString());
                int n = m + 1;
                txtHospitalNo.Text = "RF" + n.ToString();

            }
        }
    }

    protected void Save_Record()
    {
        try
        {
            if (validate_data())
            {
                string DocId = DoctorID(ddlConsultedDoctor.SelectedValue);
                string PId = PatientCode(ddlPatientName.SelectedValue);
                string  User = Request.QueryString["txtuser"];

                string Computer = System.Environment.MachineName;
                string strSQL;
                string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
                SqlConnection sqlConn = new SqlConnection(dbConn);
                sqlConn.Open();
                strSQL = "INSERT INTO [COLLECTION_TRANS](ReceiptNo,ReceiptDate,DoctorID,HospitalNo,Charge,UserLogged,DateCreated)VALUES ('" + txtReceiptNo.Text + "','" + txtDate.Text + "','" + DocId + "','" + txtHospitalNo.Text + "','" + txtSum.Text + "','" + User + "','" + System.DateTime.Now.ToString("dd/MM/yyyy") + "')";
                SqlCommand cmdCollection = new SqlCommand(strSQL, sqlConn);
                cmdCollection.ExecuteNonQuery();

              //  string strSQL1 = "INSERT INTO [payment_details](Receipt_Number,Receipt_Date,HospitalNo,Patient_ID,Amount,Payment_Type,Cheque_No,Cheque_Date,Banker,DateCreated,Remarks)VALUES ('" + txtReceiptNo.Text + "','" + txtDate.Text + "','" + txtHospitalNo.Text + "','" + PId + "','" + txtSum.Text + "','" + PaymentType + "','" + txtVideNo.Text + "','" + txtDated.Text + "','" + txtDrawnOn.Text + "','" + System.DateTime.Now.ToString("dd/MM/yyyy") + "','" + txtRemarks.Text + "')";

                //string strSQL1 = "INSERT INTO [payment_details](Receipt_Number,Receipt_Date,HospitalNo,Patient_ID,Amount,Payment_Type,Cheque_No,ComputerName,Banker,DateCreated,Remarks,Cheque_Date)VALUES ('" + txtReceiptNo.Text + "','" + txtDate.Text + "','" + txtHospitalNo.Text + "','" + PId + "','" + txtSum.Text + "','" + PaymentType + "','" + txtVideNo.Text + "','" + Computer + "','" + txtDrawnOn.Text + "','" + System.DateTime.Now.ToString("dd/MM/yyyy") + "','" + txtRemarks.Text + "','"+txtDated.Text+"')";
                //SqlCommand cmdPaymentDetails = new SqlCommand(strSQL1, sqlConn);
                //cmdPaymentDetails.ExecuteNonQuery();
                //sqlConn.Close();
                Response.Write("<script language='javascript'>alert('Data Saved Successfully...');</script>");
                Load_Record();
            }
        }
        catch (Exception)
        {
            Response.Write("<script language='javascript'>alert('Data Not Saved Successfully...');</script>");
        
        }

    }

    protected void Delete_Record()
    {

        string strSQL;
        string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
        SqlConnection sqlConn = new SqlConnection(dbConn);
        sqlConn.Open();
        strSQL = "Delete [COLLECTION_TRANS] Where ReceiptNo ='"+txtReceiptNo.Text+"'";
        SqlCommand cmdWardDetails = new SqlCommand(strSQL, sqlConn);
        cmdWardDetails.ExecuteNonQuery();
        sqlConn.Close();
        Response.Write("<script language='javascript'>alert('Entry Deleted Successfully...');</script>");
        Load_Record();
       // Record_Count();
    }
    protected void Load_Record()
    {
     SqlCollection.SelectCommand = " SELECT  COLLECTION_TRANS.ReceiptNo, COLLECTION_TRANS.ReceiptDate, COLLECTION_TRANS.TransType, COLLECTION_TRANS.DoctorID,COLLECTION_TRANS.HospitalNo, COLLECTION_TRANS.DateCreated, payment_details.Amount, payment_details.Payment_Type,payment_details.Cheque_No, payment_details.Cheque_Date, payment_details.Banker, payment_details.Patient_ID, payment_details.Remarks,payment_details.DateCreated AS Expr1 FROM COLLECTION_TRANS CROSS JOIN payment_details";
     SqlCollection.SelectCommand="SELECT COLLECTION_TRANS.ReceiptNo, COLLECTION_TRANS.ReceiptDate, COLLECTION_TRANS.DoctorID, COLLECTION_TRANS.Charge,payment_details.Patient_ID, payment_details.Payment_Type, payment_details.Amount, payment_details.Cheque_No, payment_details.Cheque_Date,payment_details.Banker, payment_details.DateCreated, payment_details.Remarks FROM COLLECTION_TRANS INNER JOIN payment_details ON COLLECTION_TRANS.HospitalNo = payment_details.HospitalNo";
   
    }

    protected void Update_Record()
    {
        try
        {
            string strSQL;         
            string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
            SqlConnection sqlConn = new SqlConnection(dbConn);
            sqlConn.Open();
            strSQL = "Update [COLLECTION_TRANS] Set ReceiptDate='" + txtDate.Text + "',TransType='" + ddlTransactionType.SelectedItem.ToString() + "',HospitalNo='" + txtHospitalNo.Text + "' ,Charge='" + txtCharge.Text + "' Where ReceiptNo ='" +txtReceiptNo.Text+ "'";
            SqlCommand cmdWardDetails = new SqlCommand(strSQL, sqlConn);
            cmdWardDetails.ExecuteNonQuery();
            sqlConn.Close();
            Response.Write("<script language='javascript'>alert('Data Updated Successfully...');</script>");
            Load_Record();
        }
        catch (Exception)
        {
            Response.Write("<script language='javascript'>alert('Rate per Bed Value Should be Numeric !!!...');</script>");
        }
    }
  
    protected bool validate_data()
    {               
      //  string strSQL;
      //  string strName;
      //  strName = "";
      //  string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
      //  SqlConnection sqlConn = new SqlConnection(dbConn);
      //  sqlConn.Open();
      ////  strSQL = "Select ReceiptDate,TransType,DoctorID,HospitalNo,Charge from [COLLECTION_TRANS] Where ReceiptNo='" + txtReceiptNo.Text + "'";
      //  strSQL = "SELECT COLLECTION_TRANS.ReceiptNo, COLLECTION_TRANS.ReceiptDate, COLLECTION_TRANS.DoctorID, COLLECTION_TRANS.Charge,payment_details.Patient_ID, payment_details.Payment_Type, payment_details.Amount, payment_details.Cheque_No, payment_details.Cheque_Date,payment_details.Banker, payment_details.DateCreated, payment_details.Remarks FROM COLLECTION_TRANS INNER JOIN payment_details ON COLLECTION_TRANS.HospitalNo = payment_details.HospitalNo";
       
      //  SqlCommand cmdWardDetails = new SqlCommand(strSQL, sqlConn);
      //  SqlDataReader drWard = cmdWardDetails.ExecuteReader();
      //  while (drWard.Read())
      //  {

      //      strName = drWard[0].ToString();


      //  }
      //  sqlConn.Close();

      //  if (strName != "")
      //  {
      //      Response.Write("<script language='javascript'>alert('This Receipt No Already Exists!!!');</script>");
      //      return false;
      //  }


      //  if (txtDate.Text== "")
      //  {
      //      Response.Write("<script language='javascript'>alert('Please Enter Date!!!');</script>");
      //      return false;
      //  }
             
      //  if (txtHospitalNo.Text == "")
      //  {
      //      Response.Write("<script language='javascript'>alert('Please Enter Hospital No!!!');</script>");
      //      return false;
      //  }
      
        return true;
    }
    protected void Display_Record(string strCode)
    {
        string strSQL;       
        string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
        SqlConnection sqlConn = new SqlConnection(dbConn);
        sqlConn.Open();
       // strSQL = "Select ReceiptDate,TransType,DoctorID,HospitalNo,Charge from [COLLECTION_TRANS] where ReceiptNo='" +txtReceiptNo.Text+ "'  ";

        strSQL = "SELECT COLLECTION_TRANS.ReceiptNo, COLLECTION_TRANS.ReceiptDate, COLLECTION_TRANS.DoctorID, COLLECTION_TRANS.Charge,payment_details.Patient_ID, payment_details.Payment_Type, payment_details.Amount, payment_details.Cheque_No, payment_details.Cheque_Date,payment_details.Banker, payment_details.DateCreated, payment_details.Remarks FROM COLLECTION_TRANS INNER JOIN payment_details ON COLLECTION_TRANS.HospitalNo = payment_details.HospitalNo";
        SqlCommand cmdWardDetails = new SqlCommand(strSQL, sqlConn);

        SqlDataReader drWardDetails = cmdWardDetails.ExecuteReader();
        while (drWardDetails.Read())
        {
          txtReceiptNo.Text= drWardDetails[0].ToString();        
          txtDate.Text= drWardDetails[1].ToString();
          ddlConsultedDoctor.SelectedItem.Text = drWardDetails[2].ToString();
          txtSum.Text = drWardDetails[3].ToString();
          ddlPatientName.SelectedItem.Text = drWardDetails[4].ToString();

        }
        sqlConn.Close();
    }
  
    protected void cmdAdd_Click(object sender, EventArgs e)
    {
        string strAdd;
        strAdd = cmdAdd.Text;
        if (strAdd == "ADD")
        {

            ClearFields();
            ReceiptNo();
            string DocId = DoctorID(ddlConsultedDoctor.SelectedValue);
            txtDate.Text = System.DateTime.Now.ToString("dd-MM-yyyy");
            cmdAdd.Text = "SAVE";
            txtReceiptNo.Enabled = true;
            txtDate.Enabled = true;
            txtHospitalNo.Enabled = true;
            ddlVisitType.Enabled = true;
            ddlPatientName.Enabled = true;
            ddlTitle.Enabled = true;
            ddlTransactionType.Enabled = true;
            txtCharge.Enabled = true;
            txtSum.Enabled = true;
            txtVideNo.Enabled = true;
            ddlConsultedDoctor.Enabled = true;
            txtDrawnOn.Enabled = true;
            txtDated.Enabled = true;
            txtRemarks.Enabled = true;

            cmdDelete.Enabled = false;
            cmdModify.Enabled = false;
        }
        else if (strAdd == "SAVE")
        {
            if (txtReceiptNo.Text == "" || txtDate.Text == "" || txtHospitalNo.Text == "" || ddlPatientName.SelectedItem.Text == "" || txtSum.Text == "")
            {
                Response.Write("<script language='javascript'>alert('(*) fields are Required to Save the Data!!!');</script>");
            }
            else
            {
                Save_Record();
            }

            cmdAdd.Text = "ADD";
            ClearFields();
            cmdDelete.Enabled = false;
            cmdModify.Enabled = false;

            txtReceiptNo.Enabled = false;
            txtDate.Enabled = false;
            txtHospitalNo.Enabled = false;
            ddlVisitType.Enabled = false;
            ddlPatientName.Enabled = false;
            ddlTitle.Enabled = false;
            ddlTransactionType.Enabled = false;
            txtCharge.Enabled = false;
            txtSum.Enabled = false;
            txtVideNo.Enabled = false;
            ddlConsultedDoctor.Enabled = false;
            txtDrawnOn.Enabled = false;
            txtDated.Enabled = false;
            txtRemarks.Enabled = false;
        }
    }
    protected void cmdModify_Click(object sender, EventArgs e)
    {
        string strAdd;
        strAdd = cmdModify.Text;
        if (strAdd == "MODIFY")
        {
            txtReceiptNo.Enabled = false;
            txtDate.Enabled = false;
            txtHospitalNo.Enabled = false;
            ddlVisitType.Enabled = false;
            ddlPatientName.Enabled = false;
            ddlTitle.Enabled = false;
            ddlTransactionType.Enabled = false;
            txtCharge.Enabled = false;
            txtSum.Enabled = false;
            txtVideNo.Enabled = false;
            ddlConsultedDoctor.Enabled = false;
            txtDrawnOn.Enabled = false;
            txtDated.Enabled = false;
            txtRemarks.Enabled = false;


            cmdModify.Text = "UPDATE";
            cmdDelete.Enabled = false;
            cmdAdd.Enabled = false;
        }
        else if (strAdd == "UPDATE")
        {
            if (txtReceiptNo.Text == "" || txtDate.Text == "" || txtHospitalNo.Text == "" || ddlPatientName.SelectedItem.Text == "" || txtSum.Text == "")
            {
                Response.Write("<script language='javascript'>alert('Entry Not Selected for Modification!!!');</script>");
            }
            else
            {
                Update_Record();
            }
            cmdModify.Text = "MODIFY";
            ClearFields();
            cmdModify.Enabled = false;
            cmdDelete.Enabled = false;
            cmdAdd.Enabled = true;

            txtReceiptNo.Enabled = false;
            txtDate.Enabled = false;
            txtHospitalNo.Enabled = false;
            ddlVisitType.Enabled = false;
            ddlPatientName.Enabled = false;
            ddlTitle.Enabled = false;
            ddlTransactionType.Enabled = false;
            txtCharge.Enabled = false;
            txtSum.Enabled = false;
            txtVideNo.Enabled = false;
            ddlConsultedDoctor.Enabled = false;
            txtDrawnOn.Enabled = false;
            txtDated.Enabled = false;
            txtRemarks.Enabled = false;

        }
    }
    protected void cmdDelete_Click(object sender, EventArgs e)
    {
        if (txtReceiptNo.Text== "")
        {
            Response.Write("<script language='javascript'>alert('Entry Not Selected for Deletion!!!');</script>");
        }
        else
        {
            Delete_Record();
        }
    }
    protected void cmdCancel_Click(object sender, EventArgs e)
    {
        cmdAdd.Text = "ADD";
        cmdModify.Text = "MODIFY";
      
        gvGeneralCollection.Visible = false;
        ClearFields();
        Grid_clear();
        txtReceiptNo.Enabled = false;
        txtDate.Enabled = false;
        txtHospitalNo.Enabled = false;
        ddlVisitType.Enabled = false;
        ddlPatientName.Enabled = false;
        ddlTitle.Enabled = false;
        ddlTransactionType.Enabled = false;
        txtCharge.Enabled = false;
        txtSum.Enabled = false;
        txtVideNo.Enabled = false;
        ddlConsultedDoctor.Enabled = false;
        txtDrawnOn.Enabled = false;
        txtDated.Enabled = false;
        txtRemarks.Enabled = false;
        cmdAdd.Enabled = true;
        cmdModify.Enabled = false;
        cmdDelete.Enabled = false;
        Grid_clear();
    }

    protected void Grid_clear()
    {
        string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
        SqlConnection sqlConn = new SqlConnection(dbConn);
        sqlConn.Open();

        string strSQL;
        strSQL = "Delete from tmpTransList ";
        SqlCommand cmdPoOreder = new SqlCommand(strSQL, sqlConn);
        cmdPoOreder.ExecuteNonQuery();
        sqlConn.Close();

    }
    protected void BindGrid()
    {

        string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
        SqlConnection sqlConn = new SqlConnection(dbConn);
        sqlConn.Open();
        SqlDataAdapter ItemIssueAdapter = new SqlDataAdapter("Select * from tmpTransList", sqlConn);
        DataSet datasetItemIssues = new DataSet();
        ItemIssueAdapter.Fill(datasetItemIssues);

        gvGeneralCollection.DataSource = datasetItemIssues.Tables[0];
        gvGeneralCollection.DataBind();
    }
    protected void gvGeneralCollection_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        try
        {

            string TransName = gvGeneralCollection.DataKeys[e.RowIndex].Values[0].ToString();
            string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
            SqlConnection sqlConn = new SqlConnection(dbConn);
            sqlConn.Open();
            SqlDataAdapter da = new SqlDataAdapter("", sqlConn);


            da.DeleteCommand = new SqlCommand("delete from tmpTransList where TransName='" + TransName + "'", sqlConn);

            da.DeleteCommand.ExecuteNonQuery();
            BindGrid();
            sqlConn.Close();


        }
        catch (Exception)
        {
            Response.Write("<script language='javascript'>alert('No Records Found to Delete Item!!!');</script>");
        }
    }
    protected void gvGeneralCollection_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        try
        {
            if (e.Row.RowType == DataControlRowType.EmptyDataRow)
            {
             
                grdAmount = 0;
            }
            if (e.Row.RowType == DataControlRowType.DataRow)
            {

                decimal TotalAmount = Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Charge"));                             
                          
                grdAmount = grdAmount + TotalAmount;

            }

            if (e.Row.RowType == DataControlRowType.Footer)
            {

                Label lb4 = (Label)e.Row.FindControl("lbltotalAmount");
                lb4.Text = grdAmount.ToString();

                txtSum.Text= grdAmount.ToString();
              
            }
        }
        catch (Exception)
        {
            // Response.Write("<script language='javascript'>alert('Data Table is null...');</script>");

        }
    }
    protected void rbCash_CheckedChanged(object sender, EventArgs e)
    {
        if (rbCash.Checked == true)
        {
            PaymentType= "Cash";
        }
    }
    protected void rbCheque_CheckedChanged(object sender, EventArgs e)
    {
        PaymentType = "Cheque";
    }
    protected void rbDD_CheckedChanged(object sender, EventArgs e)
    {
        PaymentType = "DD";
    }
    protected void rbCreditCard_CheckedChanged(object sender, EventArgs e)
    {
        PaymentType = "Credit Card";
    }
    protected void rbDebitCard_CheckedChanged(object sender, EventArgs e)
    {
        PaymentType = "Debit Card";
    }
    protected void rbAmountCollectLater_CheckedChanged(object sender, EventArgs e)
    {
        PaymentType = "Amount Collect Later";
    }
    protected void ddlTitle_SelectedIndexChanged(object sender, EventArgs e)
    {     
        //ddlPatientName.Items.Clear();
        //string strSQL;
        //string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
        //SqlConnection sqlConn = new SqlConnection(dbConn);
        //sqlConn.Open();
        //strSQL = "select Patient_Name from registration_details where Title='"+ddlTitle.SelectedItem.ToString()+"'";
        //SqlCommand cmdPatientName = new SqlCommand(strSQL, sqlConn);
        //ddlPatientName.Items.Add("<============Select==========>");

        //SqlDataReader drPatientName = cmdPatientName.ExecuteReader();
        //while (drPatientName.Read())
        //{
        //    ddlPatientName.Items.Add(drPatientName[0].ToString());
        //}

        //sqlConn.Close();
    }
    protected void gvCollection_DataBound(object sender, EventArgs e)
    {
        lblPage.Text = string.Format("You are viewing page {0} of {1}", gvCollection.PageIndex + 1, gvCollection.PageCount);
        ddlPageList.Items.Clear();
        for (int i = 0; i < gvCollection.PageCount; i++)
        {
            ListItem pageListItem = new ListItem(string.Concat(i + 1), i.ToString());
            ddlPageList.Items.Add(pageListItem);
            if (gvCollection.Rows.Count > 0)
            {
                lblSearchRecords.Text = "Results found " + gvCollection.Rows.Count.ToString() + "Records";

            }

            if (i == gvCollection.PageIndex)
            {
                pageListItem.Selected = true;

            }

        }
    }
    public string HighlightText(string InputTxt)
    {
        string Search_Str = TxtSearch.Text;

        Regex RegExp = new Regex(Search_Str.Replace(" ", "|").Trim(), RegexOptions.IgnoreCase);

        return RegExp.Replace(InputTxt, new MatchEvaluator(ReplaceKeyWords));
    }

    public static string ReplaceKeyWords(Match m)
    {
        return ("<span class=highlight>" + m.Value + "</span>");
    }
    protected void gvCollection_PreRender(object sender, EventArgs e)
    {
        GridView gv = (GridView)sender;
        GridViewRow gvr = (GridViewRow)gv.TopPagerRow;
        if (gvr != null)
        {
            gvr.Visible = true;

        }
    }
    protected void gvCollection_RowCommand(object sender, GridViewCommandEventArgs e)
    {

    }
    protected void gvCollection_SelectedIndexChanged(object sender, EventArgs e)
    {


    }
    protected void CmdSearch_Click(object sender, EventArgs e)
    {
        SearchString = TxtSearch.Text;
        lblSearchRecords.Visible = true;

        if (TxtSearch.Text == "")
        {

            lblSearchRecords.Text = "Enter Keyword to search by ";
            lblSearchRecords.Visible = true;
        }
        else
        {

            lblSearchRecords.Text = "Results found " + gvCollection.Rows.Count.ToString() + "Records";
            lblSearchRecords.Visible = true;
        }
    }
    protected void CmdClear_Click(object sender, EventArgs e)
    {
        lblSearchRecords.Visible = false;
        TxtSearch.Text = "";
        SearchString = "";
        gvCollection.DataBind();
    }
    protected void ddlPageList_SelectedIndexChanged(object sender, EventArgs e)
    {
        gvCollection.PageIndex = Convert.ToInt32(ddlPageList.SelectedValue);
    }


  Now i want to select Sex and Payment Type Radio button Based on gridview selected row.

 Anyone help me please...........Its urgent..

   Thanks in advance..................