G
Guest
Hi, I'm new to asp.net and c#, so this is probably an easy question for
everybody.
I want to have a dropdownlist (populated by states), when the user selects a
different value, populate a datagrid based on the dropdownlist's value.
I'm not quite sure what I'm missing here. Please advise.
THANKS!
Here's my code:
private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
BindData("WHERE StateCode = 'CA' ");
}
} //page load
private void BindData( string strState)
{
fillStates();
getAbbreviations( strState );
}
private void fillStatees()
{
sqlDataAdapter1.Fill(dsStates1);
DataTable dataTable = dsStates1.Tables[0];
ddListState.DataTextField = dataTable.Columns["StateName"].ToString();
ddListState.DataValueField = dataTable.Columns["StateCode"].ToString();
ddListState.DataBind();
}
private void getAbbreviations( string strState )
{
string conn = "Data Source=myServer;Initial Catalog=myDB;Integrated
Security=SSPI;";
string cmd;
cmd = cmd + "SELECT ID, Name from Client ";
SqlDataAdapter dataAdapter = new SqlDataAdapter( cmd, conn );
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
DataTable dataTable = dataSet.Tables[0];
dAbbreviations.DataSource = dataTable;
dAbbreviations.DataBind();
}
private void ddListState_SelectedIndexChanged(object sender,
System.EventArgs e)
{
string strState = "WHERE StateCode = '" +
ddListState.SelectedItem.Value + "' ";
BindData(strState);
}
everybody.
I want to have a dropdownlist (populated by states), when the user selects a
different value, populate a datagrid based on the dropdownlist's value.
I'm not quite sure what I'm missing here. Please advise.
THANKS!
Here's my code:
private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
BindData("WHERE StateCode = 'CA' ");
}
} //page load
private void BindData( string strState)
{
fillStates();
getAbbreviations( strState );
}
private void fillStatees()
{
sqlDataAdapter1.Fill(dsStates1);
DataTable dataTable = dsStates1.Tables[0];
ddListState.DataTextField = dataTable.Columns["StateName"].ToString();
ddListState.DataValueField = dataTable.Columns["StateCode"].ToString();
ddListState.DataBind();
}
private void getAbbreviations( string strState )
{
string conn = "Data Source=myServer;Initial Catalog=myDB;Integrated
Security=SSPI;";
string cmd;
cmd = cmd + "SELECT ID, Name from Client ";
SqlDataAdapter dataAdapter = new SqlDataAdapter( cmd, conn );
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
DataTable dataTable = dataSet.Tables[0];
dAbbreviations.DataSource = dataTable;
dAbbreviations.DataBind();
}
private void ddListState_SelectedIndexChanged(object sender,
System.EventArgs e)
{
string strState = "WHERE StateCode = '" +
ddListState.SelectedItem.Value + "' ";
BindData(strState);
}