need some help, driving me nuts

[Mike]

I have a web page that displays contact people in a drop down.
the users selects a person then clicks the go button.
The datagrid should pop with all the information on the select contact
person, correct?

Well, now my issue. I have 5 contact names in the drop down, (pop from DB)
when I select one nothing happens except for one name. I only get
information back for only one person, nothing happens if i select a
different name. The grid comes back blank, but is populated if I pick a
certain name. What would cause this to happen?

here is the code for the drop down.
if (!IsPostBack)
{
SqlDataAdapter myCommand = new SqlDataAdapter( "select distinct
contact_person from Authors", myConnection);
DataSet ds = new DataSet();
myCommand.Fill( ds, "contact_person s");
MySelect.DataSo urce= ds.Tables["contact_person s"].DefaultView;
MySelect.DataBi nd();
}

code for the grid:
public void GetTask_Click(O bject sender, EventArgs E)
{
String selectCmd = "select * from authors where contact_person =
@contact_person ";

SqlConnection myConnection = new
SqlConnection(" server=server;d atabase=db;Trus ted_Connection= yes");

SqlDataAdapter myCommand = new SqlDataAdapter( selectCmd, myConnection);

myCommand.Selec tCommand.Parame ters.Add(new SqlParameter("@ contact_person" ,
SqlDbType.NVarC har, 2));
myCommand.Selec tCommand.Parame ters["@contact_perso n"].Value =
MySelect.Select edItem.Value;

DataSet ds = new DataSet();
myCommand.Fill( ds, "Authors");
MyDataGrid.Data Source= ds.Tables["Authors"].DefaultView;
MyDataGrid.Data Bind();
}
since this code correctly agains the pubs db authors table, i took that
table and put it in my Database to verify it wasn't a db issue, that worked
fine, when took that table and made column name changes, and data changes -
nothing. I only get information for 1 person.

need help

thnx

[Nick Malik]

what value are you getting from this statement:

myCommand.Selec tCommand.Parame ters["@contact_perso n"].Value =
MySelect.Select edItem.Value;

I haven't looked at your database, but is 'contact_person ' defined as an
NVarChar(2) field, because that's what you are sending to the query.

If so, does your dropdown just show a list of these short values?

That's where I'd look if I were you.
--- Nick

"Mike" <cs*********@sb cglobal.net> wrote in message
news:eV******** ********@TK2MSF TNGP11.phx.gbl. .. I have a web page that displays contact people in a drop down.
the users selects a person then clicks the go button.
The datagrid should pop with all the information on the select contact
person, correct?

Well, now my issue. I have 5 contact names in the drop down, (pop from DB)
when I select one nothing happens except for one name. I only get
information back for only one person, nothing happens if i select a
different name. The grid comes back blank, but is populated if I pick a
certain name. What would cause this to happen?

here is the code for the drop down.
if (!IsPostBack)
{
SqlDataAdapter myCommand = new SqlDataAdapter( "select distinct
contact_person from Authors", myConnection);
DataSet ds = new DataSet();
myCommand.Fill( ds, "contact_person s");
MySelect.DataSo urce= ds.Tables["contact_person s"].DefaultView;
MySelect.DataBi nd();
}

code for the grid:
public void GetTask_Click(O bject sender, EventArgs E)
{
String selectCmd = "select * from authors where contact_person =
@contact_person ";

SqlConnection myConnection = new
SqlConnection(" server=server;d atabase=db;Trus ted_Connection= yes");

SqlDataAdapter myCommand = new SqlDataAdapter( selectCmd, myConnection);

myCommand.Selec tCommand.Parame ters.Add(new SqlParameter("@ contact_person" ,
SqlDbType.NVarC har, 2));
myCommand.Selec tCommand.Parame ters["@contact_perso n"].Value =
MySelect.Select edItem.Value;

DataSet ds = new DataSet();
myCommand.Fill( ds, "Authors");
MyDataGrid.Data Source= ds.Tables["Authors"].DefaultView;
MyDataGrid.Data Bind();
}
since this code correctly agains the pubs db authors table, i took that
table and put it in my Database to verify it wasn't a db issue, that worked fine, when took that table and made column name changes, and data changes - nothing. I only get information for 1 person.

need help

thnx