Dropdownlist populates Datagrid

[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);
}

 

[Guest]

Sorry, I edited my code too quickly... this is the correct 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 fillStates()
{
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 = "SELECT ID, Name ";
cmd = cmd + "FROM Client ";
cmd = cmd + strBranch;
cmd = cmd + "ORDER BY Name;";

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);
}