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 :
<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 :
<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 :
<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 :
<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:
[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'.