Solved

Fetch data from database and display in modalpopup .NET 2.0

Posted on 2009-07-04
9
426 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
  • 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
 

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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 7

Accepted Solution

by:
meispisces earned 125 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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

747 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now