Click here to Skip to main content
15,891,372 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,
I am into MarketProducts.master page have three dropdownlist control and one button.
dropdownlist first specify state and dropdownlist second specify city and dropdownlist third specify market name .when every three controls have selected value then onclick button control
until displayed selected market properties into Market_Selected.aspx page.
MarketProducts.master page :
HTML
<pre lang="xml"><table cellpadding="0"; cellspacing="0" align="right" width="185px">
<tr>
<td>
<p style="color:rgb(38,89,221);font-weight:bold;margin:10px;">state:</p>
</td>
<td align="right">
<asp:DropDownList
ID="ddlStateSelect"OnSelectedIndexChanged="ddlStateSelect_SelectedIndexChanged"
 CssClass="txt" Width="110px" runat="server"  AutoPostBack="True" >
    </asp:DropDownList>
 </td>
</tr>
 <tr>
<td align="left" style="width:60px;" >
<p style="color:rgb(38,89,221);font-weight:bold;margin:10px;">city</p>
</td>
<td align="right">
<asp:DropDownList ID="ddlCitySelect" runat="server"
OnSelectedIndexChanged="ddlCitySelect_SelectedIndexChanged"  CssClass="txt"  Width="110px"
AutoPostBack="True">
</asp:DropDownList>
</td>
</tr>
<tr>
<td align="left" style="width:60px;">
<p style="color:rgb(38,89,221);font-weight:bold;margin:10px;">market:</p>
</td>
<td align="right">
<asp:DropDownList ID="ddlMarketSelect" runat="server"   CssClass="txt" Width="110px" >
</asp:DropDownList>
</td>
</tr>
<tr>
 <td align="center" colspan="2">
<asp:Button ID="btnIdentity" runat="server" OnClick="btnIdentity_Click"  Text="salesroom or market properties" cssclass="txt"  PostBackUrl="~/Market_Selected.aspx" >
</td>
</tr>
</table>



MarketProducts.master.cs page :
C#
<pre lang="cs">
MarketDocumets marketdocuments = new MarketDocumets();
protected void btnIdentity_Click(object sender, EventArgs e)
    {

            marketdocuments.State = ddlStateSelect.SelectedValue.ToString();
            marketdocuments.City = ddlCitySelect.SelectedValue.ToString();
            marketdocuments.Market = ddlMarketSelect.SelectedValue.ToString();
    }



Market_Selected.aspx page :
ASP.NET
<pre lang="xml"><asp:Repeater ID="repIdentityMarket" runat="server">
   <HeaderTemplate></HeaderTemplate>
   <ItemTemplate>
<div class="tabsr"><div class="tabr1 default" id="ta2" ><asp:Label ID="lblMarketTitle" runat="server" Text='<%#Eval("MarketName") %>'></asp:Label></div>
</div>
 <table cellpadding="0" cellspacing="0"  align="right" width="185px">

<tr>

<td align="right">

<asp:Label ID="lblWorkHours" runat="server" Text='<%#Eval("MarketHoursW") %>'></asp:Label>
</td>
</tr>
<tr>
 <td align="right">

<asp:Label ID="lblSection" runat="server" Text='<%#Eval("MarketSection") %>'></asp:Label>
</td>
</tr>
<tr>
<td align="right">

<asp:Label ID="lblTelephone" runat="server" Text='<%#Eva("MarketTelephone")%>'></asp:Label>
</td>
</tr>
<tr>
 <td align="right">

<asp:Label ID="lblEmail" runat="server" Text='<%#Eval("MarketEmail") %>'></asp:Label>
</td>
</tr>
<tr>
 <td align="right">

<asp:Label ID="lblAddress" runat="server" Text='<%#Eval("MarketAddress") %>'></asp:Label>
</td>
</tr>
</table>
</ItemTemplate>
<FooterTemplate></FooterTemplate>
  </asp:Repeater>


Market_Selected.aspx.cs page :
C#
<pre lang="cs">MarketDocumets marketdocuments = new MarketDocumets();
    protected void Page_Load(object sender, EventArgs e)
    {
       repIdentityMarket.DataSource = marketdocuments.IdentityMarket(marketdocuments.State, marketdocuments.City, marketdocuments.Market);
        repIdentityMarket.DataBind();

    }



MarketDocumets.cs class:
C#
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, false)]
    public object IdentityMarket(string selectedstate, string selectedcity,string selectedmarket)
    {
        try
        {
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "select  MarketName,MarketSection,MarketTelephone,MarketEmail,MarketHoursW,MarketAddress from MarketDocuments where MarketState=@state and MarketCity=@city and MarketName=@market  ";
            cmd.Parameters.AddWithValue("state", selectedstate);
            cmd.Parameters.AddWithValue("city", selectedcity);
            cmd.Parameters.AddWithValue("market", selectedmarket);
            cmd.Connection = cn;
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            return dt;
        }
        catch (Exception ex)
        {
            return ex.Message.ToString();
        }
    }
    private string _State;

    public string State
    {

        get { return this._State; }

        set { this._State = value; }

    }
    private string _City;

    public string City
    {

        get { return this._City; }

        set { this._City = value; }

    }
    private string _Market;

    public string Market
    {

        get { return this._Market; }

        set { this._Market = value; }

    }

ERROR:DataBinding: 'System.Char' does not contain a property with the name 'MarketName'.
Posted
Updated 6-Jul-13 20:43pm
v2
Comments
Joezer BH 7-Jul-13 3:05am    
Show us the line that throws the exception is looks like you tried to get the coloumn MarketName's out of a specific char member instead of the DataRow.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900