Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
Hello
I have Created Gridview with popup edit Deailsview. Its working fine. I use Textbox for Search Information in GirdView and same Textbox use for search the same Employee information in detailsview as popup .
 
When I use textbox for search Employee information, girdview work fine and search employee information for employee whose Card no(employee id)i type in Textboxt. when i Click on the Edit button for edit same Employee information the popup also appears with same Employee id with same information in girdview. its seems work fine .
but after searching the first Card no(Employee id) if i replace the textbox value to other card no(Employee id) and enter than girdview work fine and show me the new employee information which we change in Textbox but the popup detailsview show me the old employee information only the id is change as new why? at the same time if i Delete the Value which we type in Textboxt and Enter and Try to search other card no(Employee id) again Girdview and popup Detailsview work fine why?
 
here is my code
<asp:SqlDataSource ID="emp" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
                    DeleteCommand="DELETE FROM [Maintable] WHERE [Card_No] = @Card_No" 
                    InsertCommand="INSERT INTO [Maintable] ([Card_No], [Name], [Trade], [Site], [Birthday], [Joining_Date], [Last_Entry_Date], [Passport_No], [Passport_Expiry_Date], [RP_No], [RP_Expiry_Date], [Passport_With], [Passport_G_Date], [Country], [Sponsor], [Employee_Statu]) VALUES (@Card_No, @Name, @Trade, @Site, @Birthday, @Joining_Date, @Last_Entry_Date, @Passport_No, @Passport_Expiry_Date, @RP_No, @RP_Expiry_Date, @Passport_With, @Passport_G_Date, @Country, @Sponsor, @Employee_Statu)" 
                    SelectCommand="SELECT * FROM [Maintable] WHERE ([Card_No] = @Card_No)" 
                    UpdateCommand="UPDATE [Maintable] SET [Name] = @Name, [Trade] = @Trade, [Site] = @Site, [Birthday] = @Birthday, [Joining_Date] = @Joining_Date, [Last_Entry_Date] = @Last_Entry_Date, [Passport_No] = @Passport_No, [Passport_Expiry_Date] = @Passport_Expiry_Date, [RP_No] = @RP_No, [RP_Expiry_Date] = @RP_Expiry_Date, [Passport_With] = @Passport_With, [Passport_G_Date] = @Passport_G_Date, [Country] = @Country, [Sponsor] = @Sponsor, [Employee_Statu] = @Employee_Statu WHERE [Card_No] = @Card_No">
                    <deleteparameters>
                        <asp:Parameter Name="Card_No" Type="String" />
                    </deleteparameters>
                    <insertparameters>
                        <asp:Parameter Name="Card_No" Type="String" />
                        <asp:Parameter Name="Name" Type="String" />
                        <asp:Parameter Name="Trade" Type="String" />
                        <asp:Parameter Name="Site" Type="String" />
                        <asp:Parameter Name="Birthday" Type="DateTime" />
                        <asp:Parameter Name="Joining_Date" Type="DateTime" />
                        <asp:Parameter DbType="Date" Name="Last_Entry_Date" />
                        <asp:Parameter Name="Passport_No" Type="String" />
                        <asp:Parameter Name="Passport_Expiry_Date" Type="DateTime" />
                        <asp:Parameter Name="RP_No" Type="Decimal" />
                        <asp:Parameter Name="RP_Expiry_Date" Type="DateTime" />
                        <asp:Parameter Name="Passport_With" Type="String" />
                        <asp:Parameter Name="Passport_G_Date" Type="DateTime" />
                        <asp:Parameter Name="Country" Type="String" />
                        <asp:Parameter Name="Sponsor" Type="String" />
                        <asp:Parameter Name="Employee_Statu" Type="String" />
                    </insertparameters>
                    <SelectParameters>
                        <asp:ControlParameter ControlID="txtsearch" Name="Card_No" PropertyName="Text" 
                            Type="String" />
                    </SelectParameters>
                    <updateparameters>
                        <asp:Parameter Name="Name" Type="String" />
                        <asp:Parameter Name="Trade" Type="String" />
                        <asp:Parameter Name="Site" Type="String" />
                        <asp:Parameter Name="Birthday" Type="DateTime" />
                        <asp:Parameter Name="Joining_Date" Type="DateTime" />
                        <asp:Parameter DbType="Date" Name="Last_Entry_Date" />
                        <asp:Parameter Name="Passport_No" Type="String" />
                        <asp:Parameter Name="Passport_Expiry_Date" Type="DateTime" />
                        <asp:Parameter Name="RP_No" Type="Decimal" />
                        <asp:Parameter Name="RP_Expiry_Date" Type="DateTime" />
                        <asp:Parameter Name="Passport_With" Type="String" />
                        <asp:Parameter Name="Passport_G_Date" Type="DateTime" />
                        <asp:Parameter Name="Country" Type="String" />
                        <asp:Parameter Name="Sponsor" Type="String" />
                        <asp:Parameter Name="Employee_Statu" Type="String" />
                        <asp:Parameter Name="Card_No" Type="String" />
                    </updateparameters>
                
                
                <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
                    BackColor="White" BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px" 
                    CellPadding="4" DataKeyNames="Card_No" DataSourceID="emp" ForeColor="Black" 
                    GridLines="Vertical" Height="16px" Width="1006px">
                    <alternatingrowstyle backcolor="White" />
                    <columns>
                        <asp:BoundField DataField="Card_No" HeaderText="Card_No" ReadOnly="True" 
                            SortExpression="Card_No" />
                        <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                        <asp:BoundField DataField="Trade" HeaderText="Trade" SortExpression="Trade" />
                        <asp:BoundField DataField="Site" HeaderText="Site" SortExpression="Site" />
                        <asp:BoundField DataField="Birthday" HeaderText="Birthday" 
                            SortExpression="Birthday" />
                        <asp:BoundField DataField="Joining_Date" HeaderText="Joining_Date" 
                            SortExpression="Joining_Date" />
                        <asp:BoundField DataField="Last_Entry_Date" HeaderText="Last_Entry_Date" 
                            SortExpression="Last_Entry_Date" />
                        <asp:BoundField DataField="Passport_No" HeaderText="Passport_No" 
                            SortExpression="Passport_No" />
                        <asp:BoundField DataField="Passport_Expiry_Date" 
                            HeaderText="Passport_Expiry_Date" SortExpression="Passport_Expiry_Date" />
                        <asp:BoundField DataField="RP_No" HeaderText="RP_No" SortExpression="RP_No" />
                        <asp:BoundField DataField="RP_Expiry_Date" HeaderText="RP_Expiry_Date" 
                            SortExpression="RP_Expiry_Date" />
                        <asp:BoundField DataField="Passport_With" HeaderText="Passport_With" 
                            SortExpression="Passport_With" />
                        <asp:BoundField DataField="Passport_G_Date" HeaderText="Passport_G_Date" 
                            SortExpression="Passport_G_Date" />
                        <asp:BoundField DataField="Country" HeaderText="Country" 
                            SortExpression="Country" />
                        <asp:BoundField DataField="Sponsor" HeaderText="Sponsor" 
                            SortExpression="Sponsor" />
                        <asp:BoundField DataField="Employee_Statu" HeaderText="Employee_Statu" 
                            SortExpression="Employee_Statu" />
                        <asp:TemplateField ShowHeader="False">
                    <itemtemplate>
                        <input class="button_popup" id="btnShowModalDiv"  önclick="$('#divSimplePopup').showModal(); return false;" type="submit" value="Edit"/>
                    </itemtemplate>
                
                    </columns>
                    <footerstyle backcolor="#CCCC99" />
                    <HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
                    <pagerstyle backcolor="#F7F7DE" forecolor="Black" horizontalalign="Right" />
                    <rowstyle backcolor="#F7F7DE" />
                    <SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
                    <sortedascendingcellstyle backcolor="#FBFBF2" />
                    <sortedascendingheaderstyle backcolor="#848384" />
                    <sorteddescendingcellstyle backcolor="#EAEAD3" />
                    <sorteddescendingheaderstyle backcolor="#575357" />
                
             <div id="divSimplePopup" class="popup" style="display: none; width: 500px;">
            <div class="container">
                <div>
                    <div class="style35">
                        <asp:Panel ID="Panel2" runat="server" BackColor="#1D4672" Height="24px" 
                            Width="588px">
                        
                        <asp:SqlDataSource ID="edit" runat="server" 
                            ConflictDetection="CompareAllValues" 
                            ConnectionString="<%$ ConnectionStrings:HRConnectionString %>" 
                            DeleteCommand="DELETE FROM [Maintable] WHERE [Card_No] = @original_Card_No AND (([Name] = @original_Name) OR ([Name] IS NULL AND @original_Name IS NULL)) AND (([Trade] = @original_Trade) OR ([Trade] IS NULL AND @original_Trade IS NULL)) AND (([Site] = @original_Site) OR ([Site] IS NULL AND @original_Site IS NULL)) AND (([Birthday] = @original_Birthday) OR ([Birthday] IS NULL AND @original_Birthday IS NULL)) AND (([Joining_Date] = @original_Joining_Date) OR ([Joining_Date] IS NULL AND @original_Joining_Date IS NULL)) AND (([Last_Entry_Date] = @original_Last_Entry_Date) OR ([Last_Entry_Date] IS NULL AND @original_Last_Entry_Date IS NULL)) AND (([Passport_No] = @original_Passport_No) OR ([Passport_No] IS NULL AND @original_Passport_No IS NULL)) AND (([Passport_Expiry_Date] = @original_Passport_Expiry_Date) OR ([Passport_Expiry_Date] IS NULL AND @original_Passport_Expiry_Date IS NULL)) AND (([RP_No] = @original_RP_No) OR ([RP_No] IS NULL AND @original_RP_No IS NULL)) AND (([RP_Expiry_Date] = @original_RP_Expiry_Date) OR ([RP_Expiry_Date] IS NULL AND @original_RP_Expiry_Date IS NULL)) AND (([Passport_With] = @original_Passport_With) OR ([Passport_With] IS NULL AND @original_Passport_With IS NULL)) AND (([Passport_G_Date] = @original_Passport_G_Date) OR ([Passport_G_Date] IS NULL AND @original_Passport_G_Date IS NULL)) AND (([Country] = @original_Country) OR ([Country] IS NULL AND @original_Country IS NULL)) AND (([Sponsor] = @original_Sponsor) OR ([Sponsor] IS NULL AND @original_Sponsor IS NULL)) AND (([Employee_Statu] = @original_Employee_Statu) OR ([Employee_Statu] IS NULL AND @original_Employee_Statu IS NULL))" 
                            InsertCommand="INSERT INTO [Maintable] ([Card_No], [Name], [Trade], [Site], [Birthday], [Joining_Date], [Last_Entry_Date], [Passport_No], [Passport_Expiry_Date], [RP_No], [RP_Expiry_Date], [Passport_With], [Passport_G_Date], [Country], [Sponsor], [Employee_Statu]) VALUES (@Card_No, @Name, @Trade, @Site, @Birthday, @Joining_Date, @Last_Entry_Date, @Passport_No, @Passport_Expiry_Date, @RP_No, @RP_Expiry_Date, @Passport_With, @Passport_G_Date, @Country, @Sponsor, @Employee_Statu)" 
                            OldValuesParameterFormatString="original_{0}" 
                            SelectCommand="SELECT [Card_No], [Name], [Trade], [Site], [Birthday], [Joining_Date], [Last_Entry_Date], [Passport_No], [Passport_Expiry_Date], [RP_No], [RP_Expiry_Date], [Passport_With], [Passport_G_Date], [Country], [Sponsor], [Employee_Statu] FROM [Maintable] WHERE ([Card_No] = @Card_No)" 
                            UpdateCommand="UPDATE [Maintable] SET [Name] = @Name, [Trade] = @Trade, [Site] = @Site, [Birthday] = @Birthday, [Joining_Date] = @Joining_Date, [Last_Entry_Date] = @Last_Entry_Date, [Passport_No] = @Passport_No, [Passport_Expiry_Date] = @Passport_Expiry_Date, [RP_No] = @RP_No, [RP_Expiry_Date] = @RP_Expiry_Date, [Passport_With] = @Passport_With, [Passport_G_Date] = @Passport_G_Date, [Country] = @Country, [Sponsor] = @Sponsor, [Employee_Statu] = @Employee_Statu WHERE [Card_No] = @original_Card_No AND (([Name] = @original_Name) OR ([Name] IS NULL AND @original_Name IS NULL)) AND (([Trade] = @original_Trade) OR ([Trade] IS NULL AND @original_Trade IS NULL)) AND (([Site] = @original_Site) OR ([Site] IS NULL AND @original_Site IS NULL)) AND (([Birthday] = @original_Birthday) OR ([Birthday] IS NULL AND @original_Birthday IS NULL)) AND (([Joining_Date] = @original_Joining_Date) OR ([Joining_Date] IS NULL AND @original_Joining_Date IS NULL)) AND (([Last_Entry_Date] = @original_Last_Entry_Date) OR ([Last_Entry_Date] IS NULL AND @original_Last_Entry_Date IS NULL)) AND (([Passport_No] = @original_Passport_No) OR ([Passport_No] IS NULL AND @original_Passport_No IS NULL)) AND (([Passport_Expiry_Date] = @original_Passport_Expiry_Date) OR ([Passport_Expiry_Date] IS NULL AND @original_Passport_Expiry_Date IS NULL)) AND (([RP_No] = @original_RP_No) OR ([RP_No] IS NULL AND @original_RP_No IS NULL)) AND (([RP_Expiry_Date] = @original_RP_Expiry_Date) OR ([RP_Expiry_Date] IS NULL AND @original_RP_Expiry_Date IS NULL)) AND (([Passport_With] = @original_Passport_With) OR ([Passport_With] IS NULL AND @original_Passport_With IS NULL)) AND (([Passport_G_Date] = @original_Passport_G_Date) OR ([Passport_G_Date] IS NULL AND @original_Passport_G_Date IS NULL)) AND (([Country] = @original_Country) OR ([Country] IS NULL AND @original_Country IS NULL)) AND (([Sponsor] = @original_Sponsor) OR ([Sponsor] IS NULL AND @original_Sponsor IS NULL)) AND (([Employee_Statu] = @original_Employee_Statu) OR ([Employee_Statu] IS NULL AND @original_Employee_Statu IS NULL))">
                            <deleteparameters>
                                <asp:Parameter Name="original_Card_No" Type="String" />
                                <asp:Parameter Name="original_Name" Type="String" />
                                <asp:Parameter Name="original_Trade" Type="String" />
                                <asp:Parameter Name="original_Site" Type="String" />
                                <asp:Parameter Name="original_Birthday" Type="DateTime" />
                                <asp:Parameter Name="original_Joining_Date" Type="DateTime" />
                                <asp:Parameter DbType="Date" Name="original_Last_Entry_Date" />
                                <asp:Parameter Name="original_Passport_No" Type="String" />
                                <asp:Parameter Name="original_Passport_Expiry_Date" Type="DateTime" />
                                <asp:Parameter Name="original_RP_No" Type="Decimal" />
                                <asp:Parameter Name="original_RP_Expiry_Date" Type="DateTime" />
                                <asp:Parameter Name="original_Passport_With" Type="String" />
                                <asp:Parameter Name="original_Passport_G_Date" Type="DateTime" />
                                <asp:Parameter Name="original_Country" Type="String" />
                                <asp:Parameter Name="original_Sponsor" Type="String" />
                                <asp:Parameter Name="original_Employee_Statu" Type="String" />
                            </deleteparameters>
                            <insertparameters>
                                <asp:Parameter Name="Card_No" Type="String" />
                                <asp:Parameter Name="Name" Type="String" />
                                <asp:Parameter Name="Trade" Type="String" />
                                <asp:Parameter Name="Site" Type="String" />
                                <asp:Parameter Name="Birthday" Type="DateTime" />
                                <asp:Parameter Name="Joining_Date" Type="DateTime" />
                                <asp:Parameter DbType="Date" Name="Last_Entry_Date" />
                                <asp:Parameter Name="Passport_No" Type="String" />
                                <asp:Parameter Name="Passport_Expiry_Date" Type="DateTime" />
                                <asp:Parameter Name="RP_No" Type="Decimal" />
                                <asp:Parameter Name="RP_Expiry_Date" Type="DateTime" />
                                <asp:Parameter Name="Passport_With" Type="String" />
                                <asp:Parameter Name="Passport_G_Date" Type="DateTime" />
                                <asp:Parameter Name="Country" Type="String" />
                                <asp:Parameter Name="Sponsor" Type="String" />
                                <asp:Parameter Name="Employee_Statu" Type="String" />
                            </insertparameters>
                            <SelectParameters>
                                <asp:ControlParameter ControlID="txtsearch" Name="Card_No" PropertyName="Text" 
                                    Type="String" />
                            </SelectParameters>
                            <updateparameters>
                                <asp:Parameter Name="Name" Type="String" />
                                <asp:Parameter Name="Trade" Type="String" />
                                <asp:Parameter Name="Site" Type="String" />
                                <asp:Parameter Name="Birthday" Type="DateTime" />
                                <asp:Parameter Name="Joining_Date" Type="DateTime" />
                                <asp:Parameter DbType="Date" Name="Last_Entry_Date" />
                                <asp:Parameter Name="Passport_No" Type="String" />
                                <asp:Parameter Name="Passport_Expiry_Date" Type="DateTime" />
                                <asp:Parameter Name="RP_No" Type="Decimal" />
                                <asp:Parameter Name="RP_Expiry_Date" Type="DateTime" />
                                <asp:Parameter Name="Passport_With" Type="String" />
                                <asp:Parameter Name="Passport_G_Date" Type="DateTime" />
                                <asp:Parameter Name="Country" Type="String" />
                                <asp:Parameter Name="Sponsor" Type="String" />
                                <asp:Parameter Name="Employee_Statu" Type="String" />
                                <asp:Parameter Name="original_Card_No" Type="String" />
                                <asp:Parameter Name="original_Name" Type="String" />
                                <asp:Parameter Name="original_Trade" Type="String" />
                                <asp:Parameter Name="original_Site" Type="String" />
                                <asp:Parameter Name="original_Birthday" Type="DateTime" />
                                <asp:Parameter Name="original_Joining_Date" Type="DateTime" />
                                <asp:Parameter DbType="Date" Name="original_Last_Entry_Date" />
                                <asp:Parameter Name="original_Passport_No" Type="String" />
                                <asp:Parameter Name="original_Passport_Expiry_Date" Type="DateTime" />
                                <asp:Parameter Name="original_RP_No" Type="Decimal" />
                                <asp:Parameter Name="original_RP_Expiry_Date" Type="DateTime" />
                                <asp:Parameter Name="original_Passport_With" Type="String" />
                                <asp:Parameter Name="original_Passport_G_Date" Type="DateTime" />
                                <asp:Parameter Name="original_Country" Type="String" />
                                <asp:Parameter Name="original_Sponsor" Type="String" />
                                <asp:Parameter Name="original_Employee_Statu" Type="String" />
                            </updateparameters>
                        
                        <asp:DetailsView ID="DetailsView3" runat="server" AutoGenerateRows="False" 
                            CellPadding="4" DataKeyNames="Card_No" DataSourceID="edit" ForeColor="#333333" 
                            GridLines="None" Height="50px" Width="538px" DefaultMode="Edit">
                            <alternatingrowstyle backcolor="White" />
                            <commandrowstyle backcolor="#FFFFC0" font-bold="True" />
                            <fieldheaderstyle backcolor="#FFFF99" font-bold="True" />
                            <fields>
                                <asp:BoundField DataField="Card_No" HeaderText="Card_No" ReadOnly="True" 
                                    SortExpression="Card_No" />
                                <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                                <asp:BoundField DataField="Trade" HeaderText="Trade" SortExpression="Trade" />
                                <asp:BoundField DataField="Site" HeaderText="Site" SortExpression="Site" />
                                <asp:BoundField DataField="Birthday" HeaderText="Birthday" 
                                    SortExpression="Birthday" />
                                <asp:BoundField DataField="Joining_Date" HeaderText="Joining_Date" 
                                    SortExpression="Joining_Date" />
                                <asp:BoundField DataField="Last_Entry_Date" HeaderText="Last_Entry_Date" 
                                    SortExpression="Last_Entry_Date" />
                                <asp:BoundField DataField="Passport_No" HeaderText="Passport_No" 
                                    SortExpression="Passport_No" />
                                <asp:BoundField DataField="Passport_Expiry_Date" 
                                    HeaderText="Passport_Expiry_Date" SortExpression="Passport_Expiry_Date" />
                                <asp:BoundField DataField="RP_No" HeaderText="RP_No" SortExpression="RP_No" />
                                <asp:BoundField DataField="RP_Expiry_Date" HeaderText="RP_Expiry_Date" 
                                    SortExpression="RP_Expiry_Date" />
                                <asp:BoundField DataField="Passport_With" HeaderText="Passport_With" 
                                    SortExpression="Passport_With" />
                                <asp:BoundField DataField="Passport_G_Date" HeaderText="Passport_G_Date" 
                                    SortExpression="Passport_G_Date" />
                                <asp:BoundField DataField="Country" HeaderText="Country" 
                                    SortExpression="Country" />
                                <asp:BoundField DataField="Sponsor" HeaderText="Sponsor" 
                                    SortExpression="Sponsor" />
                                <asp:BoundField DataField="Employee_Statu" HeaderText="Employee_Statu" 
                                    SortExpression="Employee_Statu" />
                            </fields>
                            <footerstyle backcolor="#990000" font-bold="True" forecolor="White" />
                            <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                            <pagerstyle backcolor="#FFCC66" forecolor="#333333" horizontalalign="Center" />
                            <rowstyle backcolor="#FFFBD6" forecolor="#333333" />
                        
                    <div class="style34" style="background-color: #1D4672">
                         
                        <input class="button_popup" id="btnCancel"  önclick="$('#divSimplePopup').hideModal(); return false;" type="submit" value="Cancel"/></div>
                    </div>
                    </div>
                    </div>
                    </div>
                                        
        
        <tr>
            <td class="style32">
                
                        <asp:SqlDataSource ID="Add" runat="server" 
                            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
                            DeleteCommand="DELETE FROM [Maintable] WHERE [Card_No] = @Card_No" 
                            InsertCommand="INSERT INTO [Maintable] ([Card_No], [Name], [Trade], [Site], [Birthday], [Joining_Date], [Last_Entry_Date], [Passport_No], [Passport_Expiry_Date], [RP_No], [RP_Expiry_Date], [Passport_With], [Passport_G_Date], [Country], [Sponsor], [Employee_Statu]) VALUES (@Card_No, @Name, @Trade, @Site, @Birthday, @Joining_Date, @Last_Entry_Date, @Passport_No, @Passport_Expiry_Date, @RP_No, @RP_Expiry_Date, @Passport_With, @Passport_G_Date, @Country, @Sponsor, @Employee_Statu)" 
                            SelectCommand="SELECT * FROM [Maintable] WHERE ([Card_No] = @Card_No)" 
                            
                            UpdateCommand="UPDATE [Maintable] SET [Name] = @Name, [Trade] = @Trade, [Site] = @Site, [Birthday] = @Birthday, [Joining_Date] = @Joining_Date, [Last_Entry_Date] = @Last_Entry_Date, [Passport_No] = @Passport_No, [Passport_Expiry_Date] = @Passport_Expiry_Date, [RP_No] = @RP_No, [RP_Expiry_Date] = @RP_Expiry_Date, [Passport_With] = @Passport_With, [Passport_G_Date] = @Passport_G_Date, [Country] = @Country, [Sponsor] = @Sponsor, [Employee_Statu] = @Employee_Statu WHERE [Card_No] = @Card_No">
                            <deleteparameters>
                                <asp:Parameter Name="Card_No" Type="String" />
                            </deleteparameters>
                            <insertparameters>
                                <asp:Parameter Name="Card_No" Type="String" />
                                <asp:Parameter Name="Name" Type="String" />
                                <asp:Parameter Name="Trade" Type="String" />
                                <asp:Parameter Name="Site" Type="String" />
                                <asp:Parameter Name="Birthday" Type="DateTime" />
                                <asp:Parameter Name="Joining_Date" Type="DateTime" />
                                <asp:Parameter DbType="Date" Name="Last_Entry_Date" />
                                <asp:Parameter Name="Passport_No" Type="String" />
                                <asp:Parameter Name="Passport_Expiry_Date" Type="DateTime" />
                                <asp:Parameter Name="RP_No" Type="Decimal" />
                                <asp:Parameter Name="RP_Expiry_Date" Type="DateTime" />
                                <asp:Parameter Name="Passport_With" Type="String" />
                                <asp:Parameter Name="Passport_G_Date" Type="DateTime" />
                                <asp:Parameter Name="Country" Type="String" />
                                <asp:Parameter Name="Sponsor" Type="String" />
                                <asp:Parameter Name="Employee_Statu" Type="String" />
                            </insertparameters>
                            <SelectParameters>
                                <asp:ControlParameter ControlID="txtsearch" Name="Card_No" PropertyName="Text" 
                                    Type="String" />
                            </SelectParameters>
                            <updateparameters>
                                <asp:Parameter Name="Name" Type="String" />
                                <asp:Parameter Name="Trade" Type="String" />
                                <asp:Parameter Name="Site" Type="String" />
                                <asp:Parameter Name="Birthday" Type="DateTime" />
                                <asp:Parameter Name="Joining_Date" Type="DateTime" />
                                <asp:Parameter DbType="Date" Name="Last_Entry_Date" />
                                <asp:Parameter Name="Passport_No" Type="String" />
                                <asp:Parameter Name="Passport_Expiry_Date" Type="DateTime" />
                                <asp:Parameter Name="RP_No" Type="Decimal" />
                                <asp:Parameter Name="RP_Expiry_Date" Type="DateTime" />
                                <asp:Parameter Name="Passport_With" Type="String" />
                                <asp:Parameter Name="Passport_G_Date" Type="DateTime" />
                                <asp:Parameter Name="Country" Type="String" />
                                <asp:Parameter Name="Sponsor" Type="String" />
                                <asp:Parameter Name="Employee_Statu" Type="String" />
                                <asp:Parameter Name="Card_No" Type="String" />
                            </updateparameters>
                        
                        </td>
        </tr>
    
Posted 21-Jan-13 3:10am
Edited 21-Jan-13 3:12am
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 910
1 OriginalGriff 523
2 Abhinav S 253
3 thatraja 245
4 Emre Ataseven 210
0 Sergey Alexandrovich Kryukov 8,282
1 OriginalGriff 4,750
2 Peter Leow 3,784
3 Maciej Los 3,515
4 Er. Puneet Goel 3,107


Advertise | Privacy | Mobile
Web04 | 2.8.140415.2 | Last Updated 21 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid