?
Solved

Fetch data from database and display in modalpopup .NET 2.0

Posted on 2009-07-04
9
Medium Priority
?
487 Views
Last Modified: 2013-12-05
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.
0
Comment
Question by:sudhir_gs1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
9 Comments
 
LVL 7

Expert Comment

by:meispisces
ID: 24776597
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
 

Author Comment

by:sudhir_gs1
ID: 24776639
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
 
LVL 7

Expert Comment

by:meispisces
ID: 24776723
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:sudhir_gs1
ID: 24782847
Hi, Thanks for help, You mean Modal popup  extender tag  panel tag?

Can you please modify my code and repost
0
 
LVL 7

Accepted Solution

by:
meispisces earned 500 total points
ID: 24784498
<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
 
LVL 7

Expert Comment

by:meispisces
ID: 24784523
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
 
LVL 7

Expert Comment

by:meispisces
ID: 24791397
Hey sudhir, is your problem solved?
0
 

Author Comment

by:sudhir_gs1
ID: 24802030
Thanks for your help. It solved my problem

Sudhir
0
 
LVL 7

Expert Comment

by:meispisces
ID: 24802058
thanks for accepting..and too very soon...!!!


0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question