need help - -PLEASE

[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_persons");
MySelect.DataSource= ds.Tables["contact_persons"].DefaultView;
MySelect.DataBind();
}

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

SqlConnection myConnection = new
SqlConnection("server=server;database=db;Trusted_C onnection=yes");

SqlDataAdapter myCommand = new SqlDataAdapter(selectCmd, myConnection);

myCommand.SelectCommand.Parameters.Add(new SqlParameter("@contact_person",
SqlDbType.NVarChar, 2));
myCommand.SelectCommand.Parameters["@contact_person"].Value =
MySelect.SelectedItem.Value;

DataSet ds = new DataSet();
myCommand.Fill(ds, "Authors");
MyDataGrid.DataSource= ds.Tables["Authors"].DefaultView;
MyDataGrid.DataBind();
}
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

[Mike]

I have
MySelect.DataValueField = "contact_person";
MySelect.DataTextField = "contact_person";

set in the properties not the code;
As for part 2, I don't understand what you are saying? I do get the grid
populated with a certain name is selected.


"Suresh" <an*******@discussions.microsoft.com> wrote in message
news:32**********************************@microsof t.com...

Mike,
One thing I noticed in your drop down list population code is that you haven't set the DataTextField and DataValueField for your drop down list
object.
myCommand.Fill(ds, "contact_persons");
//added lines
MySelect.DataValueField = "contact_person";
MySelect.DataTextField = "contact_person";
//done add
MySelect.DataSource= ds.Tables["contact_persons"].DefaultView;
MySelect.DataBind();

Slightly modify your drop down list populate query like the following:

SqlDataAdapter myCommand = new SqlDataAdapter("select distinct
contact_person as 'contact_person' from Authors", myConnection);

Note: In your click event handler you are setting the following filter:
myCommand.SelectCommand.Parameters["@contact_person"].Value =
MySelect.SelectedItem.Value;

But in your code you were never setting the value propery of your MySelect drop down object. Setting the DataTextField and DataValueField properties
should fix your problem.
Suresh.

----- Mike wrote: -----

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_persons");
MySelect.DataSource= ds.Tables["contact_persons"].DefaultView;
MySelect.DataBind();
}

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

SqlConnection myConnection = new
SqlConnection("server=server;database=db;Trusted_C onnection=yes");

SqlDataAdapter myCommand = new SqlDataAdapter(selectCmd, myConnection);
myCommand.SelectCommand.Parameters.Add(new SqlParameter("@contact_person", SqlDbType.NVarChar, 2));
myCommand.SelectCommand.Parameters["@contact_person"].Value =
MySelect.SelectedItem.Value;

DataSet ds = new DataSet();
myCommand.Fill(ds, "Authors");
MyDataGrid.DataSource= ds.Tables["Authors"].DefaultView;
MyDataGrid.DataBind();
}
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

[Suresh]

>As for part 2, I don't understand what you are saying? I do get the gri

populated with a certain name is selected
I don't know but you are matching against something for the selection against your database

More checks then..

You indicated you set the following
MySelect.DataValueField = "contact_person"

Then you have this line in your click handler method
myCommand.SelectCommand.Parameters.Add(new SqlParameter("@contact_person", SqlDbType.NVarChar, 2))

You've set the length of this parameter to 2. This will truncate the value you set for this parameter to size of 2 characters
What is the value that is being returned for the contact_person exactly? I think you want to set this value to some ID field that's associated with the contact person

Just as a test in debug mode check what value does this parameter have?
myCommand.SelectCommand.Parameters["@contact_person"].Value
after the following line is executed

myCommand.SelectCommand.Parameters["@contact_person"].Value = MySelect.SelectedItem.Value

Suresh

----- Mike wrote: ----

I hav
MySelect.DataValueField = "contact_person"
MySelect.DataTextField = "contact_person"

set in the properties not the code
As for part 2, I don't understand what you are saying? I do get the gri
populated with a certain name is selected


"Suresh" <an*******@discussions.microsoft.com> wrote in messag
news:32**********************************@microsof t.com.. Mike
One thing I noticed in your drop down list population code is that yo haven't set the DataTextField and DataValueField for your drop down lis
object

myCommand.Fill(ds, "contact_persons")

//added line
MySelect.DataValueField = "contact_person"
MySelect.DataTextField = "contact_person"
//done ad
MySelect.DataSource= ds.Tables["contact_persons"].DefaultView
MySelect.DataBind()

Slightly modify your drop down list populate query like the following
SqlDataAdapter myCommand = new SqlDataAdapter("select distinc

contact_person as 'contact_person' from Authors", myConnection)

Note: In your click event handler you are setting the following filter

myCommand.SelectCommand.Parameters["@contact_person"].Value
MySelect.SelectedItem.Value

But in your code you were never setting the value propery of your MySelec drop down object. Setting the DataTextField and DataValueField propertie
should fix your problem Suresh
----- Mike wrote: ----
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 selec

contac person, correct

Well, now my issue. I have 5 contact names in the drop down, (po from DB

when I select one nothing happens except for one name. I only ge
information back for only one person, nothing happens if i select
different name. The grid comes back blank, but is populated if I pic certain name. What would cause this to happen

here is the code for the drop down if (!IsPostBack

SqlDataAdapter myCommand = new SqlDataAdapter("select distinc
contact_person from Authors", myConnection)
DataSet ds = new DataSet()
myCommand.Fill(ds, "contact_persons")
MySelect.DataSource= ds.Tables["contact_persons"].DefaultView
MySelect.DataBind()

code for the grid

public void GetTask_Click(Object sender, EventArgs E

String selectCmd = "select * from authors where contact_person
@contact_person"

SqlConnection myConnection = ne

SqlConnection("server=server;database=db;Trusted_C onnection=yes")

SqlDataAdapter myCommand = new SqlDataAdapter(selectCmd

myConnection); myCommand.SelectCommand.Parameters.Add(new

SqlParameter("@contact_person", SqlDbType.NVarChar, 2));
myCommand.SelectCommand.Parameters["@contact_person"].Value =
MySelect.SelectedItem.Value;

DataSet ds = new DataSet(); myCommand.Fill(ds, "Authors");
MyDataGrid.DataSource= ds.Tables["Authors"].DefaultView;
MyDataGrid.DataBind();
}
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

>

[Mike]

I got it thanks, what helped is that you pointed out
myCommand.SelectCommand.Parameters.Add(new SqlParameter("@contact_person",
SqlDbType.NVarChar, 2)); 2 is only looking at the first 2 bytes of the
field, if I change that to read entire field it works. thanks for your help.

"Suresh" <an*******@discussions.microsoft.com> wrote in message
news:A6**********************************@microsof t.com...

As for part 2, I don't understand what you are saying? I do get the grid
populated with a certain name is selected.
I don't know but you are matching against something for the selection

against your database.
More checks then...

You indicated you set the following:
MySelect.DataValueField = "contact_person";

Then you have this line in your click handler method.
myCommand.SelectCommand.Parameters.Add(new SqlParameter("@contact_person", SqlDbType.NVarChar, 2));
You've set the length of this parameter to 2. This will truncate the value you set for this parameter to size of 2 characters. What is the value that is being returned for the contact_person exactly? I think you want to set this value to some ID field that's associated with
the contact person.
Just as a test in debug mode check what value does this parameter have?
myCommand.SelectCommand.Parameters["@contact_person"].Value
after the following line is executed.

myCommand.SelectCommand.Parameters["@contact_person"].Value = MySelect.SelectedItem.Value;
Suresh.

----- Mike wrote: -----

I have
MySelect.DataValueField = "contact_person";
MySelect.DataTextField = "contact_person";

set in the properties not the code;
As for part 2, I don't understand what you are saying? I do get the grid populated with a certain name is selected.


"Suresh" <an*******@discussions.microsoft.com> wrote in message
news:32**********************************@microsof t.com...

> Mike,
> One thing I noticed in your drop down list population code is that you

haven't set the DataTextField and DataValueField for your drop down list object. >> myCommand.Fill(ds, "contact_persons"); > //added lines
> MySelect.DataValueField = "contact_person";
> MySelect.DataTextField = "contact_person";
> //done add
> MySelect.DataSource= ds.Tables["contact_persons"].DefaultView;
> MySelect.DataBind();

>> Slightly modify your drop down list populate query like the following: >> SqlDataAdapter myCommand = new SqlDataAdapter("select distinct

> contact_person as 'contact_person' from Authors", myConnection);

>> Note: In your click event handler you are setting the following filter:

> myCommand.SelectCommand.Parameters["@contact_person"].Value =
> MySelect.SelectedItem.Value;

>> But in your code you were never setting the value propery of your

MySelect drop down object. Setting the DataTextField and DataValueField properties should fix your problem. >> Suresh.
>> ----- Mike wrote: -----
>> 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_persons");
> MySelect.DataSource= ds.Tables["contact_persons"].DefaultView;
> MySelect.DataBind();
> }

>> code for the grid:

> public void GetTask_Click(Object sender, EventArgs E)
> {
> String selectCmd = "select * from authors where contact_person

= > @contact_person";

>> SqlConnection myConnection = new

>

SqlConnection("server=server;database=db;Trusted_C onnection=yes"); >> SqlDataAdapter myCommand = new SqlDataAdapter(selectCmd,

myConnection); >> myCommand.SelectCommand.Parameters.Add(new

SqlParameter("@contact_person",

> SqlDbType.NVarChar, 2));
> myCommand.SelectCommand.Parameters["@contact_person"].Value =
> MySelect.SelectedItem.Value;

>> DataSet ds = new DataSet();

> myCommand.Fill(ds, "Authors");
> MyDataGrid.DataSource= ds.Tables["Authors"].DefaultView;
> MyDataGrid.DataBind();
> }
> 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
>>>>>