Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ASP.NET SQL-Server
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 4:10am
Edited 21-Jan-13 4:12am
(no name)105.9K
v2

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

  Print Answers RSS
0 DamithSL 300
1 Sergey Alexandrovich Kryukov 287
2 OriginalGriff 195
3 Zoltán Zörgő 149
4 Peter Leow 115
0 OriginalGriff 7,510
1 DamithSL 5,519
2 Sergey Alexandrovich Kryukov 5,044
3 Maciej Los 4,961
4 Kornfeld Eliyahu Peter 4,514


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

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100