Fetch data from database and display in modalpopup .NET 2.0

Hi All,
I am using modalpopupextender. i am fetching the data and want to display in modalpopup when ever user selects and clicks one button.

I can able to fetch the data and assign to lables placed in a panel which shall popup. I am assigning the data to labels, but cant see the data.
No error or exception i am getting. Please suggest the rigth approch to solve this issue.
sudhir_gs1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

meispiscesCommented:
How are you assigning the data to the labels?

please post the HTML code of modal popup. I want to have a look into that....and then could i solve your problem correctly

thanks

0
sudhir_gs1Author Commented:
I am assigning data to labels in code behind
                <asp:UpdatePanel ID="UpdatePanel1" runat="server">
                    <ContentTemplate>
                        <table bgcolor="#580coc"style="width: 375px" cellpadding="0" cellspacing="0">
                            <tr>
                                <td style="width: 97px; height: 28px; color: white;">Sales Executive
                                </td>
                                    <td><asp:DropDownList ID="DropDownList1" runat="server" Width="104px" AutoPostBack="True" OnSelect="drawboundry('we')" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged" >
                                    </asp:DropDownList>
                                </td>
                            </tr>
                            <tr align="center"> <td colspan=2 style="color: white;">Coolers</td></tr>
                            <tr align="center">
                                <td colspan=2>
                                    &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
                                    &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
                             
                                    <asp:ListBox ID="lstcooler" runat="server" Width="136px"></asp:ListBox>
                                </td>
                               
                            </tr>
                            <tr align ="center" >
                                <td colspan=2 style="height: 31px" align="left">
                                    &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;<input id="Button1" type="button" onclick="getcooler('str');getBoundries('I');"
                                        value="Load" style="width: 104px" />
                                        <asp:TextBox ID="TextBox1" runat="server" ></asp:TextBox>
                                    &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<asp:Button ID="btnshowinfo" runat="server" Text="Show Information"
                                        Width="128px" /><br />
                                    <ajaxToolkit:ModalPopupExtender ID="ModalPopupExtender2" runat="server" BackgroundCssClass="modalBackground"
                                       DropShadow="true" OkControlID="btnOk" OnOkScript=""
                                       PopupControlID="Panel2" PopupDragHandleControlID="Panel4" TargetControlID="TextBox1">
                                    </ajaxToolkit:ModalPopupExtender>
                                </td>
                                
                            </tr>
                        </table>
                    </ContentTemplate>
                </asp:UpdatePanel>
 
----------vb code--------
 
Protected Sub btnshowinfo_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnshowinfo.Click
        Dim sql As StringBuilder = New StringBuilder()
 
        sql.Append("SELECT ITEM_NAME,ASSET_TAG,ADDRESS,PHONE_NO,GCC_CODE,LAST_SERVICE_DATE,NEXT_SERVICE_DATE,AVG_SALES,NO_COMPLAINTS")
        sql.Append(" FROM COOLERDETAILS")
        sql.Append(" WHERE OUTLET_NAME='" & lstcooler.SelectedItem.Text & "'")
        Dim row As DataRow = Db.GetDataRow(sql.ToString())
 
        lblItemName.Text = row("Item_name").ToString()
        lblAssetTag.Text = row("Asset_tag").ToString()
        lblAddress.Text = row("Address").ToString()
        lblPhoneNo.Text = row("Phone_No").ToString()
        lblGccCode.Text = row("GCC_code").ToString()
        lblLastService.Text = row("Last_service_date").ToString()
        lblNextService.Text = row("Next_Service_Date").ToString()
        lblAverageSales.Text = row("Avg_Sales").ToString()
        lblNoOfComplanints.Text = row("No_Complaints").ToString()
 
        ModalPopupExtender2.Show()
    End Sub

Open in new window

0
meispiscesCommented:
Modify your code as

Modal popup Opening Tag

Update Pane Opening Tag

Content Template Opening Tag

Your Design Code  (Table, tr, td etc)


 Content Template Closing Tag

Update Panel Closing Tag

Modal popup Closing Tag
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

sudhir_gs1Author Commented:
Hi, Thanks for help, You mean Modal popup  extender tag  panel tag?

Can you please modify my code and repost
0
meispiscesCommented:
<ajaxToolkit:ModalPopupExtender ID="ModalPopupExtender2" runat="server" BackgroundCssClass="modalBackground"
                                       DropShadow="true" OkControlID="btnOk" OnOkScript=""
                                       PopupControlID="pnlExample " PopupDragHandleControlID="Panel4" TargetControlID="btnExample" >

<asp:Button id="btnExample" runat="Server" style="display:none"><asp:panel id ="pnlExample runat="server"  style="display:none">

<asp:UpdatePanel ID="UpdatePanel1" runat="server">
                    <ContentTemplate>
                        <table bgcolor="#580coc"style="width: 375px" cellpadding="0" cellspacing="0">
                            <tr>
                                <td style="width: 97px; height: 28px; color: white;">Sales Executive
                                </td>
                                    <td><asp:DropDownList ID="DropDownList1" runat="server" Width="104px" AutoPostBack="True" OnSelect="drawboundry('we')" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged" >
                                    </asp:DropDownList>
                                </td>
                            </tr>
                            <tr align="center"> <td colspan=2 style="color: white;">Coolers</td></tr>
                            <tr align="center">
                                <td colspan=2>
                                               
                                             
                             
                                    <asp:ListBox ID="lstcooler" runat="server" Width="136px"></asp:ListBox>
                                </td>
                               
                            </tr>
                            <tr align ="center" >
                                <td colspan=2 style="height: 31px" align="left">
                                              <input id="Button1" type="button" onclick="getcooler('str');getBoundries('I');"
                                        value="Load" style="width: 104px" />
                                        <asp:TextBox ID="TextBox1" runat="server" ></asp:TextBox>
                                             <asp:Button ID="btnshowinfo" runat="server" Text="Show Information"
                                        Width="128px" /><br />

</td>
                               
                            </tr>
                        </table>
                    </ContentTemplate>
                </asp:UpdatePanel>

</ajaxToolkit:ModalPopupExtender>


Changes are marked in Bold

thanks!!!


0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
meispiscesCommented:
Ooopsss.. i forgot to add the closing tag of Panel,

it would be after updatePanel....like </asp:panel>

Also there would not be anything like  </ajaxToolkit:ModalPopupExtender>

the Modal poup extender has closing tag like

<asp:modalpopupextender id="mpe1" ..........  .....     ......   drag="true" / >


thanks
0
meispiscesCommented:
Hey sudhir, is your problem solved?
0
sudhir_gs1Author Commented:
Thanks for your help. It solved my problem

Sudhir
0
meispiscesCommented:
thanks for accepting..and too very soon...!!!


0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.