I need to see mySQL for everyselection usermake--
It works fine when user select year but as soon as state is selected yr. disappear.
(should i use update panel --I need my sql to reflect any selection user make)
Pl. help
Here's aspx
Code:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="~/Search.aspx.cs" Inherits="HITS.Search" MasterPageFile="~/hits_main.master"%>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<asp:ScriptManager ID="scMgr" runat="server"/>
<div>
<asp:UpdatePanel ID="UP1" runat="server" >
<ContentTemplate>
</ContentTemplate>
</asp:UpdatePanel>
<table cellspacing="10" border=".02">
<tr>
<td align="left" >
<asp:RadioButtonList ID="RBl1" runat="server" AutoPostBack="True"
CellPadding="2" CellSpacing="5"
onselectedindexchanged="RBl1_SelectedIndexChanged">
<asp:ListItem Value="G" Selected="True" >Regular Grants</asp:ListItem>
<asp:ListItem Value ="A">ARRA Grants</asp:ListItem>
<asp:ListItem Value ="C">Contract</asp:ListItem>
</asp:RadioButtonList>
</td>
<td>
<asp:ObjectDataSource ID="Srcfmyr" runat="server"
OldValuesParameterFormatString="original_{0}" SelectMethod="GetData"
TypeName="HITS.App_code.stateTableAdapters.SOURCE_YEAR_VWTableAdapter">
<SelectParameters>
<asp:ControlParameter ControlID="RBl1" Name="myType"
PropertyName="SelectedValue" Type="String" DefaultValue="G" />
</SelectParameters>
</asp:ObjectDataSource>
From: <asp:DropDownList ID="ddlyr" runat="server" AppendDataBoundItems="true"
AutoPostBack="True" DataSourceID="Srcfmyr" DataTextField="SOURCE_YEAR"
DataValueField="SOURCE_YEAR" Font-Underline="False"
onselectedindexchanged="ddlyr_SelectedIndexChanged" >
<asp:ListItem Text="Year" Selected="True" Value="0"></asp:ListItem>
</asp:DropDownList>
<asp:ObjectDataSource ID="SrcToyr" runat="server"
OldValuesParameterFormatString="original_{0}" SelectMethod="GetData"
TypeName="HITS.App_code.stateTableAdapters.SOURCE_YEAR_VWTableAdapter">
<SelectParameters>
<asp:ControlParameter ControlID="RBl1" DefaultValue="G" Name="myType"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:ObjectDataSource>
<asp:Label ID="lblTo" runat ="server" Text="To:"></asp:Label>
<asp:DropDownList ID="ddlTo" runat="server" AppendDataBoundItems="true"
AutoPostBack="True" DataSourceID="Srcfmyr" DataTextField="SOURCE_YEAR"
DataValueField="SOURCE_YEAR" Font-Underline="False" OnSelectedIndexChanged="ddlTo_Clicked" >
<asp:ListItem Text="Year" Selected="True" Value="0"></asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td colspan="2" align="left" valign="middle">
<br /> <br/>
STATE:
<asp:DropDownList ID="ddlSt" runat="server"
DataSourceID="ObjectDataSource1" DataTextField="STATE_COUNTRY_NAME"
DataValueField="STATE_COUNTRY_CODE" AutoPostBack="True"
onselectedindexchanged="ddlSt_SelectedIndexChanged">
</asp:DropDownList>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
OldValuesParameterFormatString="original_{0}" SelectMethod="GetData"
TypeName="stateTableAdapters.STATE_COUNTRYTableAdapter">
<SelectParameters>
<asp:ControlParameter ControlID="ddlyr" Name="FromYear"
PropertyName="SelectedValue" Type="Decimal" />
<asp:ControlParameter ControlID="ddlTo" Name="ToYear"
PropertyName="SelectedValue" Type="Decimal" />
<asp:ControlParameter ControlID="RBl1" Name="mytype"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:ObjectDataSource>
.cs file
Code:
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Collections.Specialized;
using AjaxControlToolkit;
using System.Configuration;
using System.Data.OracleClient;
using System.ComponentModel;
namespace HITS
{
public partial class Search : System.Web.UI.Page
{
string sSQL = " ";
protected void Page_Load(object sender, EventArgs e)
{
MakeSQL();
}
protected void Clear_click(object sender, EventArgs e)
{
Response.Redirect("~/search.aspx");
}
protected void RBl1_SelectedIndexChanged(object sender, EventArgs e)
{
string rectype = RBl1.SelectedValue.ToString();
Int16 fmyr = Convert.ToInt16(ddlyr.SelectedValue);
if (rectype == "A")
{
mesg.Text = "ARRA NOT Available";
}
if (rectype == "C" && fmyr > 2000)
{
mesg.Text = "No Contracts After 2000";
}
else
MakeSQL();
}
public void MakeSQL()
{
sSQL += "AND RECORD_TYPE ='" + RBl1.SelectedValue.ToString() + "'";
Lbl1.Text = sSQL;
}
protected void ddlyr_SelectedIndexChanged(object sender, EventArgs e)
{
string rectype = RBl1.SelectedValue.ToString();
Int16 fmyr = Convert.ToInt16(ddlyr.SelectedValue);
if (rectype == "C" && fmyr > 2000)
{
mesg.Text = "No Contracts After 2000";
}
else
// RBl1.DataBind();
sSQL += "AND SOURCE_YEAR ='" + ddlyr.SelectedItem.ToString() + "'";
MakeSQL();
}
protected void ddlTo_Clicked(object sender, EventArgs e)
{
string sSQLfy = "";
string toval = ddlTo.SelectedItem.ToString();
string fmval = ddlyr.SelectedItem.ToString();
if (ddlTo.SelectedIndex >0)
{
int fmyr = int.Parse(ddlyr.SelectedItem.Text);
int toyr = int.Parse(ddlTo.SelectedItem.Text);
if(toyr<= fmyr)
{
ddlTo.ClearSelection();
}
else
sSQLfy = "AND SOURCE_YEAR between '" + toval + "' AND '" + fmval + "'";
sSQL =sSQLfy.ToString();
MakeSQL();
}
}
protected void ddlCongDistt_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void ddlSt_SelectedIndexChanged(object sender, EventArgs e)
{
//select State
// ddlSt.DataBind();
sSQL += "AND STATE_COUNTRY_CODE='" + ddlSt.SelectedValue.ToString() + "'";
MakeSQL();
}
protected void ddlCity_SelectedIndexChanged(object sender, EventArgs e)
{
sSQL += "AND CITY='" + ddlCity.SelectedValue.ToString() + "'";
MakeSQL();
}