dataset and dropdownlist

[Marty U.]

I have an assembly that contains a function that returns a dataset. I want to
bind that dataset to a dropdownlist. If I do it as such:

DataSet ds;
ds = myobject.GetDataSet();
droplist.DataSource = ds.Tables[0].DefaultView;
droplist.DataTextField =
Convert.ToString(ds.Tables[0].Columns["column"].ColumnName);

The droplist displays System.Data.DataRowView and I have had a brainfart and
can't seem to fix this simple problem. Suggestions Please!

Thanks
Marty U.

[Shiva]

I think the DataTextField property is not properly set. Just specify the
column name directly to the DataTextField instead of fetching it from the
ColumnName proeprty and then converting it to a string...

"Marty U." <Ma****@discussions.microsoft.com> wrote in message
news:64**********************************@microsof t.com...
I have an assembly that contains a function that returns a dataset. I want
to
bind that dataset to a dropdownlist. If I do it as such:

DataSet ds;
ds = myobject.GetDataSet();
droplist.DataSource = ds.Tables[0].DefaultView;
droplist.DataTextField =
Convert.ToString(ds.Tables[0].Columns["column"].ColumnName);

The droplist displays System.Data.DataRowView and I have had a brainfart and
can't seem to fix this simple problem. Suggestions Please!

Thanks
Marty U.

[Hermit Dave]

try this
DataSet ds = myobject.GetDataSet();
droplist.DataSource = ds.Tables[0]; // or droplist.DataSource = ds; if you
only have one table within the dataset
droplist.DataTextField = ds.Tables[0].Columns["TextValueColumn"].ToString();
// or you can use droplist.DataTextField = "TextValueColumn";
droplist.DataValueField =
ds.Tables[0].Columns["DataValueColumn"].ToString(); // or you can use
droplist.DataTextField = "DataValueColumn";
droplist.BindData();
ds.Dispose(); // if you dont need the object

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)
"Marty U." <Ma****@discussions.microsoft.com> wrote in message
news:64**********************************@microsof t.com...

I have an assembly that contains a function that returns a dataset. I want to bind that dataset to a dropdownlist. If I do it as such:

DataSet ds;
ds = myobject.GetDataSet();
droplist.DataSource = ds.Tables[0].DefaultView;
droplist.DataTextField =
Convert.ToString(ds.Tables[0].Columns["column"].ColumnName);

The droplist displays System.Data.DataRowView and I have had a brainfart and can't seem to fix this simple problem. Suggestions Please!

Thanks
Marty U.

[Marty U.]

Yep now I know why I don't normally work on Saturdays, on top of the other
items I was even referencing a column from the wrong da*n table.

Thanks folks.

"Hermit Dave" wrote:

try this
DataSet ds = myobject.GetDataSet();
droplist.DataSource = ds.Tables[0]; // or droplist.DataSource = ds; if you
only have one table within the dataset
droplist.DataTextField = ds.Tables[0].Columns["TextValueColumn"].ToString();
// or you can use droplist.DataTextField = "TextValueColumn";
droplist.DataValueField =
ds.Tables[0].Columns["DataValueColumn"].ToString(); // or you can use
droplist.DataTextField = "DataValueColumn";
droplist.BindData();
ds.Dispose(); // if you dont need the object

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)
"Marty U." <Ma****@discussions.microsoft.com> wrote in message
news:64**********************************@microsof t.com...

I have an assembly that contains a function that returns a dataset. I want

to

bind that dataset to a dropdownlist. If I do it as such:

DataSet ds;
ds = myobject.GetDataSet();
droplist.DataSource = ds.Tables[0].DefaultView;
droplist.DataTextField =
Convert.ToString(ds.Tables[0].Columns["column"].ColumnName);

The droplist displays System.Data.DataRowView and I have had a brainfart

and

can't seem to fix this simple problem. Suggestions Please!

Thanks
Marty U.

[Hermit Dave]

glad you got it sorted and that we could help.. have a nice one

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)
"Marty U." <Ma****@discussions.microsoft.com> wrote in message
news:79**********************************@microsof t.com...

Yep now I know why I don't normally work on Saturdays, on top of the other
items I was even referencing a column from the wrong da*n table.

Thanks folks.

"Hermit Dave" wrote:

try this
DataSet ds = myobject.GetDataSet();
droplist.DataSource = ds.Tables[0]; // or droplist.DataSource = ds; if you only have one table within the dataset
droplist.DataTextField = ds.Tables[0].Columns["TextValueColumn"].ToString(); // or you can use droplist.DataTextField = "TextValueColumn";
droplist.DataValueField =
ds.Tables[0].Columns["DataValueColumn"].ToString(); // or you can use
droplist.DataTextField = "DataValueColumn";
droplist.BindData();
ds.Dispose(); // if you dont need the object

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)
"Marty U." <Ma****@discussions.microsoft.com> wrote in message
news:64**********************************@microsof t.com...

I have an assembly that contains a function that returns a dataset. I

want to

bind that dataset to a dropdownlist. If I do it as such:

DataSet ds;
ds = myobject.GetDataSet();
droplist.DataSource = ds.Tables[0].DefaultView;
droplist.DataTextField =
Convert.ToString(ds.Tables[0].Columns["column"].ColumnName);

The droplist displays System.Data.DataRowView and I have had a

brainfart and

can't seem to fix this simple problem. Suggestions Please!

Thanks
Marty U.