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
Post a Comment