Remove From My Forums

insertion and update perform in single button where data can come from another page?

Question

User-1026236167 posted

hello

i want to insert data in the databse from one page and data is display using gridview in another page i have apply some code in gridview

<asp:TemplateField>
<ItemTemplate>
<a href="ManageEmployee.aspx?id=<%# Eval("tbl_id") %>">Edit</a>
</ItemTemplate>
</asp:TemplateField>

where data is come back to source page fill in the textboxes for the update some data

so my problem is i have single button BT_submit_Click and i have to create method named FillInformation(decimal tbl_id) how this method can call in button with some condition where data can saved in the databse and data can come from another page data is updated in single button

aspx

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="ManageEmployee.aspx.cs" Inherits="Store.ManageEmployee" %>
<asp:Content ID="Content1" ContentPlaceHolderID="title" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="contentbody" runat="server">

     
  
          <div class="container-fluid">
     
  
    
               
                 
                   <h3 style="color:black; font-size:2.8em">Manage Employee</h3>    
                   <hr />

        
                 <br />  <h3 style="color:black; ">Basic Info</h3>    
                   <hr />


         <div class="row">
                <div class="col-sm-3">
  <span style="color:black;"><b>
                             
                  User id *</b></span><br />
                   <span style="color:black; "> <asp:TextBox ID ="TB_user" runat="server" Width="240px"  /></span><br />
                       <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ErrorMessage="required" ControlToValidate="TB_user" ForeColor="Red"  ></asp:RequiredFieldValidator>
          
       

                  </div>
                  <div class="col-sm-3">
  <span style="color:black;"><b>
                             
                Password *</b></span><br />
                   <span style="color:black; "> <asp:TextBox ID ="TB_password" runat="server" Width="240px"  /></span><br />
                       <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ErrorMessage="required" ControlToValidate="TB_password" ForeColor="Red"  ></asp:RequiredFieldValidator>
          
       

</div>                 

             <div class="col-sm-3">

                        <span style="color:black"><b>Person Name *</b></span><br />
                   <span style="color:black"> <asp:TextBox ID ="TB_person" runat="server" Width="240px"/></span><br />
                           <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="required" ControlToValidate="TB_person" ForeColor="Red"  ></asp:RequiredFieldValidator>
          
             </div>
               <div class="col-sm-3">
                                      <span style="color:black; "><b>Email</b></span><br />
                   <span style="color:black; "> <asp:TextBox ID ="TB_email" runat="server" Width="240px" placeholder="jsrtech@gmail.com" /></span><br />
         <asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server" ControlToValidate="TB_email" ErrorMessage=" eg. you@gmail.com" ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*" ForeColor="red"  ></asp:RegularExpressionValidator>
   
                    
             </div>

           
             
      
           

             
               

              </div>

             
              <div class="row">

                     <div class="col-sm-3">

                        <span style="color:black"><b>Salary</b></span><br />
                   <span style="color:black"> <asp:TextBox ID ="TB_salary" runat="server" Width="240px"/></span><br />
          
             </div>
          
                     <div class="col-sm-3">

                        <span style="color:black"><b>Image</b></span><br />
                   <span style="color:black"> <asp:fileupload ID ="image1" runat="server" Width="240px"/></span><br />
          
             </div>
                     <div class="col-sm-3">

                        <span style="color:black"><b>Signature</b></span><br />
                   <span style="color:black"> <asp:fileupload ID ="sign" runat="server" Width="240px"/></span><br />
            <span style="color:black"> <asp:fileupload ID ="Fileupload1" runat="server" Visible="false" Width="240px"/></span><br />
             </div>
          
                  
              </div>


         
                   <br /><h3 style="color:black; ">Contact Details</h3>    
                   <hr />
     
              <div class="row">
                  
     <div class="col-sm-3">
                 <span style ="font-family:Arial"><b>Select Country</b> </span>
         <br />
<asp:DropDownList ID="ddl_country" runat="server" Height="30" Width="240"

 OnSelectedIndexChanged="ddlCountry_SelectedIndexChanged" AutoPostBack="true">

<asp:ListItem Text = "Select Country" Value = ""></asp:ListItem>

</asp:DropDownList>
            
              </div>
                   <div class="col-sm-3">
      
                              
                    <span style ="font-family:Arial"><b>Select State</b> </span>
<br />
<asp:DropDownList ID="ddl_state" runat="server" Height="30" AutoPostBack="true" Width="240"

  OnSelectedIndexChanged="ddlState_SelectedIndexChanged">

<asp:ListItem Text = "Select State" Value = ""></asp:ListItem>

</asp:DropDownList>
      
            
              </div>
                                    <div class="col-sm-3">
        <span style ="color:black"><b>Select City</b></span>
<br />
<asp:DropDownList ID="ddlCity" runat="server" Height="30" AutoPostBack="true" Width="240" >

<asp:ListItem Text = "Select City" Value = ""></asp:ListItem>

</asp:DropDownList>
                              
                           
    </div>
          <div class="col-sm-3">
                             <span style="color:black; "><b>Mobile No.1</b></span><br />
                  <span style="color:black;  "> <asp:TextBox ID ="TB_mob1" runat="server" Width="240px"  placeholder="8541236523" /></span><br />
                 <asp:RegularExpressionValidator ID="r1" runat="server" ControlToValidate="TB_mob1" ErrorMessage="Invalid Number"  ValidationExpression="^([6-9]{1})([0-9]{9})$" ForeColor="Red"></asp:RegularExpressionValidator>
        
          </div>    </div>
              <div class="row">

          <div class="col-sm-3">
                             <span style="color:black; "><b>Mobile No.2</b></span><br />
                  <span style="color:black;  "> <asp:TextBox ID ="TB_mob2" runat="server" Width="240px"  placeholder="8541236523" /></span><br />
        <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ErrorMessage="Invalid number" ControlToValidate="TB_mob2"  ValidationExpression="^([6-9]{1})([0-9]{9})$" ForeColor="Red"></asp:RegularExpressionValidator>
 
              </div>
          

                  <div class="col-sm-3">
                             <span style="color:black; "><b>Pincode</b></span><br />
                  <span style="color:black;  "> <asp:TextBox ID ="TextBox1" runat="server" Width="240px"   /></span><br />
 
              </div>
                  <div class="col-sm-6">
                             <span style="color:black; "><b>   Address 1</b></span><br />
                   <span style="color:black; "> <asp:TextBox ID ="TB_add1" runat="server" Width="515px"/></span><br />
        
              </div>
          

              </div>
              <div class="row">
     <div class="col-sm-6">
                           <span style="color:black; "><b>   Address 2</b></span><br />
                   <span style="color:black; "> <asp:TextBox ID ="TB_add2" runat="server" Width="515px"/></span><br />
        
              </div>

    


              </div>

<div class="row">
  

</div>               
        
             
                  <br /><br />  <h3 style="color:black; ">Documents Information</h3>    
                   <hr />
     
              <div class="row">
                  <div class="col-sm-3">
                                       <span style="color:black"><b>
                               <br />Aadhar Card Image
     
                                           </b></span><br />
                      <span style="color:black; "> <asp:fileupload ID ="adharimg" runat="server" Width="240" /></span><br />
     
   

                  </div>
                  <div class="col-sm-3">
                                     <b>
                               <br />
                            Aadhar Card No.  </b><br />
                     <asp:TextBox ID ="TB_aadharno" runat="server" Width="240px"  /><br />
   
                      </div>

                  <div class="col-sm-3">
                                       <span style="color:black"><b>
                               <br />Pan Card Image
     
                                           </b></span><br />
                      <span style="color:black; "> <asp:fileupload ID ="panimg" runat="server" Width="240" /></span><br />
     
   

                  </div>
                  <div class="col-sm-3">
                                     <b>
                               <br />
                            Pan Card No.  </b><br />
                     <asp:TextBox ID ="TB_panno" runat="server" Width="240px"  /><br />
   
                      </div>

              </div>
              
     
              <div class="row">
                  <div class="col-sm-3">
                                       <span style="color:black"><b>
                               <br /> Vehicle License Image
     
                                           </b></span><br />
                      <span style="color:black; "> <asp:fileupload ID ="licenseimg" runat="server" Width="240" /></span><br />
     
   

                  </div>
                  <div class="col-sm-3">
                                     <b>
                               <br />
                            Vehicle License No.  </b><br />
                     <asp:TextBox ID ="TB_licenseno" runat="server" Width="240px"  /><br />
   
                      </div>

                  <div class="col-sm-3">
                                       <span style="color:black"><b>
                               <br />Voter Card Image
     
                                           </b></span><br />
                      <span style="color:black; "> <asp:fileupload ID ="voterimg" runat="server" Width="240" /></span><br />
     
   

                  </div>
                  <div class="col-sm-3">
                                     <b>
                               <br />
                            Voter Card No.  </b><br />
                     <asp:TextBox ID ="TB_voterno" runat="server" Width="240px"  /><br />
   
                      </div>

              </div>
              

             
                
              
             <br /> <br /> <h3 style="color:black; ">Bank Details</h3>    
                   <hr />
              <div class="row">
                  <div class="col-sm-3">
      
           <span style="color:black;"> <b> Account Holder Name</b></span><br />
                   <span style="color:black; "> <asp:TextBox ID ="TB_holder" runat="server" Width="240px"  /></span><br />
       </div>
                  <div class="col-sm-3">
                  <span style="color:black; "><b>
                              
                             
                               Account No.</b></span><br />
                   <span style="color:black; "> <asp:TextBox ID ="TB_account" runat="server" Width="240px"/></span><br />
       </div>
                  <div class="col-sm-3">
                    
                           <span style="color:black; "><b>
                               
                               Ifsc Code</b></span><br />
                   <span style="color:black; "> <asp:TextBox ID ="TB_ifsc" runat="server" Width="240px" /></span><br />
       </div>

                  <div class="col-sm-3">
                    
                          <span style="color:black;"><b>
                               
                              Bank Name </b></span><br />
                   <span style="color:black; "> <asp:TextBox ID ="TB_bank" runat="server" Width="240px"  /></span><br />
       </div>

        </div>                       
            
        <div class="row">
                   <div class="col-sm-3">
                    
                          <span style="color:black;"><b>
                           <br />    
                              Bank Branch </b></span><br />
                   <span style="color:black; "> <asp:TextBox ID ="TB_branch" runat="server" Width="240px"  /></span><br />
       </div>

            </div>
        

       
      
                                          <br /><br />  <h3 style="color:black; ">Remarks</h3>    
                   <hr />
              <div class="row">

                  <div class="col-sm-6">
                                   <span style="color:black"><b>
                               
                              Remarks 1</b></span><br />
                   <span style="color:black"> <asp:TextBox ID ="TB_remarks1" runat="server" Width="500px"/></span><br />
       
                  
                  </div>
                  <div class="col-sm-6">
                                   <span style="color:black"><b>
                               
                              Remarks 2</b></span><br />
                   <span style="color:black"> <asp:TextBox ID ="TB_remarks2" runat="server" Width="500px"/></span><br />
       
                  
                  </div>

              </div>
                  
              <div class="row">
                  <div class="col-sm-6">
                                   <span style="color:black"><b>
                               <br />
                              Remarks 3</b></span><br />
                   <span style="color:black"> <asp:TextBox ID ="TB_remarks3" runat="server" Width="500px"/></span><br />
       
                  
                  </div>
                  <div class="col-sm-6">
                                   <span style="color:black"><b>
                               <br />
                              Remarks 4</b></span><br />
                   <span style="color:black"> <asp:TextBox ID ="TB_remarks4" runat="server" Width="500px"/></span><br />
       
                  
                  </div></div>
              <div class="row">
                  <div class="col-sm-6">
                                   <span style="color:black"><b>
                               <br />
                              Remarks 5</b></span><br />
                   <span style="color:black"> <asp:TextBox ID ="TB_remarks5" runat="server" Width="500px"/></span><br />
       
                  
                  </div>
                  <div class="col-sm-6">
                                   <span style="color:black"><b>
                               <br />
                              Remarks 6</b></span><br />
                   <span style="color:black"> <asp:TextBox ID ="TB_remarks6" runat="server" Width="500px"/></span><br />
       
                  
                  </div></div>
            <br />
              <div class="row">
                  <div class="col-sm-4">
                                  <asp:Button ID="BT_submit" runat="server"  Text="Submit" style="border-radius:5px" Height="41px" Width="145px"    BackColor="#000000" BorderColor="#000000" ForeColor="White" OnClick="BT_submit_Click"  />
      </div>
              </div>  <br />

        </div>
            
</asp:Content>

aspx

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="ManageEmployee.aspx.cs" Inherits="Store.ManageEmployee" %>
<asp:Content ID="Content1" ContentPlaceHolderID="title" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="contentbody" runat="server">

<div class="container-fluid">

<h3 style="color:black; font-size:2.8em">Manage Employee</h3>
<hr />

<br /> <h3 style="color:black; ">Basic Info</h3>
<hr />

</div>
<div class="col-sm-3">
<span style="color:black;"><b>

Password *</b></span><br />
<span style="color:black; "> <asp:TextBox ID ="TB_password" runat="server" Width="240px" /></span><br />
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ErrorMessage="required" ControlToValidate="TB_password" ForeColor="Red" ></asp:RequiredFieldValidator>

</div>

<span style="color:black"><b>Person Name *</b></span><br />
<span style="color:black"> <asp:TextBox ID ="TB_person" runat="server" Width="240px"/></span><br />
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="required" ControlToValidate="TB_person" ForeColor="Red" ></asp:RequiredFieldValidator>

</div>
<div class="col-sm-3">
<span style="color:black; "><b>Email</b></span><br />
<span style="color:black; "> <asp:TextBox ID ="TB_email" runat="server" Width="240px" placeholder="jsrtech@gmail.com" /></span><br />
<asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server" ControlToValidate="TB_email" ErrorMessage=" eg. you@gmail.com" ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*" ForeColor="red" ></asp:RegularExpressionValidator>

</div>

</div>

<span style="color:black"><b>Salary</b></span><br />
<span style="color:black"> <asp:TextBox ID ="TB_salary" runat="server" Width="240px"/></span><br />

</div>

<div class="col-sm-3">

<span style="color:black"><b>Image</b></span><br />
<span style="color:black"> <asp:fileupload ID ="image1" runat="server" Width="240px"/></span><br />

</div>
<div class="col-sm-3">

<span style="color:black"><b>Signature</b></span><br />
<span style="color:black"> <asp:fileupload ID ="sign" runat="server" Width="240px"/></span><br />
<span style="color:black"> <asp:fileupload ID ="Fileupload1" runat="server" Visible="false" Width="240px"/></span><br />
</div>

</div>

<br /><h3 style="color:black; ">Contact Details</h3>
<hr />

<div class="row">

<div class="col-sm-3">
<span style ="font-family:Arial"><b>Select Country</b> </span>
<br />
<asp:DropDownList ID="ddl_country" runat="server" Height="30" Width="240"

OnSelectedIndexChanged="ddlCountry_SelectedIndexChanged" AutoPostBack="true">

<asp:ListItem Text = "Select Country" Value = ""></asp:ListItem>

</asp:DropDownList>

</div>
<div class="col-sm-3">

<span style ="font-family:Arial"><b>Select State</b> </span>
<br />
<asp:DropDownList ID="ddl_state" runat="server" Height="30" AutoPostBack="true" Width="240"

OnSelectedIndexChanged="ddlState_SelectedIndexChanged">

<asp:ListItem Text = "Select State" Value = ""></asp:ListItem>

</asp:DropDownList>

</div>
<div class="col-sm-3">
<span style ="color:black"><b>Select City</b></span>
<br />
<asp:DropDownList ID="ddlCity" runat="server" Height="30" AutoPostBack="true" Width="240" >

<asp:ListItem Text = "Select City" Value = ""></asp:ListItem>

</asp:DropDownList>

</div>
<div class="col-sm-3">
<span style="color:black; "><b>Mobile No.1</b></span><br />
<span style="color:black; "> <asp:TextBox ID ="TB_mob1" runat="server" Width="240px" placeholder="8541236523" /></span><br />
<asp:RegularExpressionValidator ID="r1" runat="server" ControlToValidate="TB_mob1" ErrorMessage="Invalid Number" ValidationExpression="^([6-9]{1})([0-9]{9})$" ForeColor="Red"></asp:RegularExpressionValidator>

</div> </div>
<div class="row">

<div class="col-sm-3">
<span style="color:black; "><b>Mobile No.2</b></span><br />
<span style="color:black; "> <asp:TextBox ID ="TB_mob2" runat="server" Width="240px" placeholder="8541236523" /></span><br />
<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ErrorMessage="Invalid number" ControlToValidate="TB_mob2" ValidationExpression="^([6-9]{1})([0-9]{9})$" ForeColor="Red"></asp:RegularExpressionValidator>

</div>

<div class="col-sm-3">
<span style="color:black; "><b>Pincode</b></span><br />
<span style="color:black; "> <asp:TextBox ID ="TextBox1" runat="server" Width="240px" /></span><br />

</div>
<div class="col-sm-6">
<span style="color:black; "><b> Address 1</b></span><br />
<span style="color:black; "> <asp:TextBox ID ="TB_add1" runat="server" Width="515px"/></span><br />

</div>

</div>
<div class="row">
<div class="col-sm-6">
<span style="color:black; "><b> Address 2</b></span><br />
<span style="color:black; "> <asp:TextBox ID ="TB_add2" runat="server" Width="515px"/></span><br />

</div>

</div>

</div>

<br /><br /> <h3 style="color:black; ">Documents Information</h3>
<hr />

<div class="row">
<div class="col-sm-3">
<span style="color:black"><b>
<br />Aadhar Card Image

</b></span><br />
<span style="color:black; "> <asp:fileupload ID ="adharimg" runat="server" Width="240" /></span><br />

</div>
<div class="col-sm-3">
<b>
<br />
Aadhar Card No. </b><br />
<asp:TextBox ID ="TB_aadharno" runat="server" Width="240px" /><br />

</div>

<div class="col-sm-3">
<span style="color:black"><b>
<br />Pan Card Image

</b></span><br />
<span style="color:black; "> <asp:fileupload ID ="panimg" runat="server" Width="240" /></span><br />

</div>
<div class="col-sm-3">
<b>
<br />
Pan Card No. </b><br />
<asp:TextBox ID ="TB_panno" runat="server" Width="240px" /><br />

</div>

</div>

<div class="row">
<div class="col-sm-3">
<span style="color:black"><b>
<br /> Vehicle License Image

</b></span><br />
<span style="color:black; "> <asp:fileupload ID ="licenseimg" runat="server" Width="240" /></span><br />

</div>
<div class="col-sm-3">
<b>
<br />
Vehicle License No. </b><br />
<asp:TextBox ID ="TB_licenseno" runat="server" Width="240px" /><br />

</div>

<div class="col-sm-3">
<span style="color:black"><b>
<br />Voter Card Image

</b></span><br />
<span style="color:black; "> <asp:fileupload ID ="voterimg" runat="server" Width="240" /></span><br />

</div>
<div class="col-sm-3">
<b>
<br />
Voter Card No. </b><br />
<asp:TextBox ID ="TB_voterno" runat="server" Width="240px" /><br />

</div>

</div>

<br /> <br /> <h3 style="color:black; ">Bank Details</h3>
<hr />
<div class="row">
<div class="col-sm-3">

<span style="color:black;"> <b> Account Holder Name</b></span><br />
<span style="color:black; "> <asp:TextBox ID ="TB_holder" runat="server" Width="240px" /></span><br />
</div>
<div class="col-sm-3">
<span style="color:black; "><b>

Account No.</b></span><br />
<span style="color:black; "> <asp:TextBox ID ="TB_account" runat="server" Width="240px"/></span><br />
</div>
<div class="col-sm-3">

<span style="color:black; "><b>

Ifsc Code</b></span><br />
<span style="color:black; "> <asp:TextBox ID ="TB_ifsc" runat="server" Width="240px" /></span><br />
</div>

</div>

<div class="row">
<div class="col-sm-3">

<span style="color:black;"><b>
<br />
Bank Branch </b></span><br />
<span style="color:black; "> <asp:TextBox ID ="TB_branch" runat="server" Width="240px" /></span><br />
</div>

</div>

<br /><br /> <h3 style="color:black; ">Remarks</h3>
<hr />
<div class="row">

<div class="col-sm-6">
<span style="color:black"><b>

Remarks 1</b></span><br />
<span style="color:black"> <asp:TextBox ID ="TB_remarks1" runat="server" Width="500px"/></span><br />

</div>
<div class="col-sm-6">
<span style="color:black"><b>

Remarks 2</b></span><br />
<span style="color:black"> <asp:TextBox ID ="TB_remarks2" runat="server" Width="500px"/></span><br />

</div>

</div>

<div class="row">
<div class="col-sm-6">
<span style="color:black"><b>
<br />
Remarks 3</b></span><br />
<span style="color:black"> <asp:TextBox ID ="TB_remarks3" runat="server" Width="500px"/></span><br />

</div>
<div class="col-sm-6">
<span style="color:black"><b>
<br />
Remarks 4</b></span><br />
<span style="color:black"> <asp:TextBox ID ="TB_remarks4" runat="server" Width="500px"/></span><br />

</div></div>
<div class="row">
<div class="col-sm-6">
<span style="color:black"><b>
<br />
Remarks 5</b></span><br />
<span style="color:black"> <asp:TextBox ID ="TB_remarks5" runat="server" Width="500px"/></span><br />

</div>
<div class="col-sm-6">
<span style="color:black"><b>
<br />
Remarks 6</b></span><br />
<span style="color:black"> <asp:TextBox ID ="TB_remarks6" runat="server" Width="500px"/></span><br />

</div></div>
<br />
<div class="row">
<div class="col-sm-4">
<asp:Button ID="BT_submit" runat="server" Text="Submit" style="border-radius:5px" Height="41px" Width="145px" BackColor="#000000" BorderColor="#000000" ForeColor="White" OnClick="BT_submit_Click" />
</div>
</div> <br />

</div>

</asp:Content>

Saturday, August 15, 2020 9:31 AM

Answers

User1535942433 posted

Hi prabhjot1313,

Accroding to your description and codes,I could understand that:

1.You have a page which have textboxes to insert data into database and you have another page which have a gridview to show the data.

2.On the first page,you click the submit button to insert data.And then you redirect to the second page to show the data.

3.In the gridview,you could click link on each row,and the data will reback to the first page.The data will be showed in the textbox for updating.

4.After updating,you click the submit button to update database and also to show in the gridview.

As far as I think,you could use linkbutton in the gridview and get seleted row index.And you could use querystring to fill data in the textbox.

More details,you could refer to below codes:

First Page:

 <div class="container-fluid">

        <h3 style="color: black; font-size: 2.8em">Manage Employee</h3>
        <hr />


        <br />
        <h3 style="color: black;">Basic Info</h3>
        <hr />


        <div class="row">
            <div class="col-sm-3">
                <span style="color: black;"><b>User id *</b></span><br />
                <span style="color: black;">
                    <asp:TextBox ID="TB_user" runat="server" Width="240px" /></span><br />
                <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ErrorMessage="required" ControlToValidate="TB_user" ForeColor="Red"></asp:RequiredFieldValidator>



            </div>
            <div class="col-sm-3">
                <span style="color: black;"><b>Password *</b></span><br />
                <span style="color: black;">
                    <asp:TextBox ID="TB_password" runat="server" Width="240px" /></span><br />
                <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ErrorMessage="required" ControlToValidate="TB_password" ForeColor="Red"></asp:RequiredFieldValidator>



            </div>

            <div class="col-sm-3">

                <span style="color: black"><b>Person Name *</b></span><br />
                <span style="color: black">
                    <asp:TextBox ID="TB_person" runat="server" Width="240px" /></span><br />
                <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="required" ControlToValidate="TB_person" ForeColor="Red"></asp:RequiredFieldValidator>

            </div>
            
        <div class="row">
            <div class="col-sm-4">
                <asp:Button ID="BT_submit" runat="server" Text="Submit" Style="border-radius: 5px" Height="41px" Width="145px" BackColor="#000000" BorderColor="#000000" ForeColor="White" OnClick="BT_submit_Click" />
            </div>
        </div>
        <br />

    </div>

Code-behind:

protected void Page_Load(object sender, EventArgs e)
        {
            if (this.Page.PreviousPage!=null)
            {
                int rowIndex = int.Parse(Request.QueryString["RowIndex"]);
                GridView GridView1 = (GridView)this.Page.PreviousPage.FindControl("GridView1");
                GridViewRow row = GridView1.Rows[rowIndex];
                TB_user.Text = (row.FindControl("lbId") as Label).Text;
                TB_password.Text = (row.FindControl("lbPw") as Label).Text;
                TB_person.Text = (row.FindControl("lbName") as Label).Text;

               
            }
            
        }

        protected void BT_submit_Click(object sender, EventArgs e)
        {
            if (Request.QueryString["RowIndex"] != null)
            {
                var cnnString = ConfigurationManager.ConnectionStrings["aspnet-TestApplicationWithDatabase-20190820030542"].ConnectionString;
                var sqlstring = "Update Test8 set Password= @Password,PersonName= @PersonName Where Id=@Id";
                using (SqlConnection cnn = new SqlConnection(cnnString))
                {
                    cnn.Open();
                    using (SqlCommand cmd = new SqlCommand(sqlstring, cnn))
                    {
                        cmd.Parameters.AddWithValue("@Id", TB_user.Text);
                        cmd.Parameters.AddWithValue("@Password", TB_password.Text);
                        cmd.Parameters.AddWithValue("@PersonName", TB_person.Text);

                        
                        cmd.ExecuteNonQuery();
                       
                    }
                }
                Response.Redirect("2169968.aspx");
            }
            else
            {
                var cnnString = ConfigurationManager.ConnectionStrings["aspnet-TestApplicationWithDatabase-20190820030542"].ConnectionString;
                var sqlstring = "insert into Test8 values(@Id,@Password,@PersonName)";
                using (SqlConnection cnn = new SqlConnection(cnnString))
                {
                    using (SqlCommand cmd = new SqlCommand(sqlstring, cnn))
                    {
                        cmd.Parameters.AddWithValue("@Id", TB_user.Text);
                        cmd.Parameters.AddWithValue("@Password", TB_password.Text);
                        cmd.Parameters.AddWithValue("@PersonName", TB_person.Text);

                        cnn.Open();
                        cmd.ExecuteNonQuery();
                    }
                }
                Response.Redirect("2169968.aspx");
            }
            
        }

Second Page:

 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
                <Columns>
                    <asp:TemplateField HeaderText="Id">
                        <ItemTemplate>
                            <asp:Label ID="lbId" runat="server" Text='<%# Eval("Id") %>'></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Password">
                        <ItemTemplate>
                            <asp:Label ID="lbPw" runat="server" Text='<%# Eval("Password") %>'></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="PersonName">
                        <ItemTemplate>
                            <asp:Label ID="lbName" runat="server" Text='<%# Eval("PersonName") %>'></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Edit">
                        <ItemTemplate>
                            <asp:LinkButton ID="lnkDetails" runat="server" Text="Send Details" PostBackUrl='<%# "WebForm93.aspx?RowIndex=" + Container.DataItemIndex %>'></asp:LinkButton>
                        </ItemTemplate>
                    </asp:TemplateField>
                </Columns>
            </asp:GridView>

Code-Behind:

protected void bind()
        {
            string str, strSql;
            str = System.Configuration.ConfigurationManager.ConnectionStrings["aspnet-TestApplicationWithDatabase-20190820030542"].ConnectionString;
            SqlConnection conn = new SqlConnection(str);
            strSql = "select * from Test8";
            SqlDataAdapter da = new SqlDataAdapter(strSql, str);
            DataSet ds = new DataSet();
            da.Fill(ds, "Test8");
            this.GridView1.DataSource = ds.Tables[0].DefaultView;
            this.GridView1.DataBind();
            conn.Close();
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                bind();
            }
        }

Result:

Best regards,

Yijing Sun

Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM

Monday, August 17, 2020 3:37 AM

Answered by:

insertion and update perform in single button where data can come from another page?

Question

Answers