asp.net - Event after data binding using SqlDataSource -


i have 1 textbox search , 1 formview in page:

<div runat="server" id="adminarea">     <table>         <tr>             <td>                 <asp:label id="label4" runat="server" text="enter member id :"></asp:label></td>             <td><br />                 <asp:textbox id="textbox5" runat="server" textmode="number"></asp:textbox><br />                 <asp:requiredfieldvalidator id="requiredfieldvalidator1" validationgroup="vgsearch" forecolor="red" controltovalidate="textbox5" runat="server" errormessage="enter valid member id"></asp:requiredfieldvalidator>             </td>             <td>                 <asp:button id="button1" onclick="button1_click" cssclass="btn btn-primary" runat="server" text="search" validationgroup="vgsearch" /></td>         </tr>     </table> </div>  <asp:formview id="formview1" defaultmode="edit" width="100%" runat="server" datasourceid="profileinformationdatasource" datakeynames="id" >     <edititemtemplate>            <table align="center" cellpadding="5" cellspacing="5" class="auto-style1" style="margin-top:20px;">                <tr>                     <td colspan="3"><b><%# eval("name") %></b>'s profile</td>                </tr>                /**                ** many fields here bind                **/     </edititemtemplate> </asp:formview> 

to bind above form fields using sqldatasource:

 <asp:sqldatasource id="profileinformationdatasource" runat="server" connectionstring='<%$ connectionstrings:defaultconnection %>' selectcommand="select top 1 mem.name,mem.img_src,mem.id, convert(varchar(10), mem.dob, 111) dob,mem.sex,mem.member_cert_id,mem.address,mem.country , mem.state,mem.city,mem.zip,mem.phone,mem.mobile,mem.email_id,mem.bank_acc_no,mem.bank_pan_no,mem.account_holder_name,mem.bank_name,mem.bank_code,mem.bank_address,mem.bank_zip,mem.bank_location,mem.bank_country,mem.bank_branch members mem mem.id = @memberid order mem.id desc"  updatecommand="update members set name = @name, dob = @dob , member_cert_id = @member_cert_id , address = @address , country = @country, state = @state , zip = @zip, mobile= @mobile , phone= @phone, email_id = @email_id, bank_pan_no = @bank_pan_no, bank_acc_no = @bank_acc_no, account_holder_name = @account_holder_name, bank_name= @bank_name, bank_code = @bank_code, bank_address = @bank_address, bank_zip =@bank_zip, bank_location = @bank_location id= @id " >         <selectparameters>                  <asp:controlparameter controlid="textbox5" defaultvalue="0" name="memberid" propertyname="text" />         </selectparameters>      <updateparameters>         <asp:parameter name="name" type="string" />         <asp:parameter name="dob" type="string" />         <asp:parameter name="member_cert_id" type="string" />         <asp:parameter name="address" type="string" />         <asp:parameter name="country" type="string" />         <asp:parameter name="state" type="string" />         <asp:parameter name="zip" type="string" />         <asp:parameter name="mobile" type="string" />         <asp:parameter name="phone" type="string" />         <asp:parameter name="email_id" type="string" />         <asp:parameter name="bank_pan_no" type="string" />         <asp:parameter name="bank_acc_no" type="string" />         <asp:parameter name="account_holder_name" type="string" />         <asp:parameter name="bank_name" type="string" />         <asp:parameter name="bank_code" type="string" />         <asp:parameter name="bank_address" type="string" />         <asp:parameter name="bank_zip" type="string" />         <asp:parameter name="bank_location" type="string" />         <asp:parameter name="id" />     </updateparameters>  </asp:sqldatasource> 

whenever click search button fields filling sqldatasource. problem in formview have updatepanels country, state , city dropdown. want load them back-end code.

so want event fired after filling of data.


Comments

Popular posts from this blog

javascript - Google App Script ContentService downloadAsFile not working -

javascript - Function overwritting -

php - Find a regex to take part of Email -