DropDown List from DataConn

DropDown List from DataConn

am 26.09.2007 22:14:03 von Jackscu

I know there are several steps envolved in establishing a connection to a DB
and then creating a DropDown List from Sql.

I am using Visual Studio 2003 7.1.3088 and I am trying to connect and create
a drop down list from a table.column in the db.

Could you point me in the right direction for some "good" documentation
completing this? I have established my db "connection and have been trying
to create a datagrid in order to accomplish the DropDown List with no
success.

thx
/j.>

Re: DropDown List from DataConn

am 27.09.2007 05:58:04 von notmyfirstname

Jack,

The first thing you should do is to use a windowsform or a webpage where the
dropdown can be located.

Cor

"Jack@scu" schreef in bericht
news:49A7DE3E-DCB6-45F2-A5C8-2D0F87CBC6CC@microsoft.com...
>I know there are several steps envolved in establishing a connection to a
>DB
> and then creating a DropDown List from Sql.
>
> I am using Visual Studio 2003 7.1.3088 and I am trying to connect and
> create
> a drop down list from a table.column in the db.
>
> Could you point me in the right direction for some "good" documentation
> completing this? I have established my db "connection and have been
> trying
> to create a datagrid in order to accomplish the DropDown List with no
> success.
>
> thx
> /j.>

Re: DropDown List from DataConn

am 27.09.2007 15:08:02 von Jackscu

The form is created.

"Cor Ligthert[MVP]" wrote:

> Jack,
>
> The first thing you should do is to use a windowsform or a webpage where the
> dropdown can be located.
>
> Cor
>
> "Jack@scu" schreef in bericht
> news:49A7DE3E-DCB6-45F2-A5C8-2D0F87CBC6CC@microsoft.com...
> >I know there are several steps envolved in establishing a connection to a
> >DB
> > and then creating a DropDown List from Sql.
> >
> > I am using Visual Studio 2003 7.1.3088 and I am trying to connect and
> > create
> > a drop down list from a table.column in the db.
> >
> > Could you point me in the right direction for some "good" documentation
> > completing this? I have established my db "connection and have been
> > trying
> > to create a datagrid in order to accomplish the DropDown List with no
> > success.
> >
> > thx
> > /j.>
>

Re: DropDown List from DataConn

am 28.09.2007 07:04:41 von notmyfirstname

Then add a combobox or a listbox to that.
Create a datatable,
Fill that with a dataadapter
Set the datasource of one from the first line
Set the displaymember to the name of the column you want to show
And run


Cor

Re: DropDown List from DataConn

am 28.09.2007 16:28:01 von Jackscu

Thx! This will give me a skeleton to put some meat on!

/j.>

"Cor Ligthert[MVP]" wrote:

> Then add a combobox or a listbox to that.
> Create a datatable,
> Fill that with a dataadapter
> Set the datasource of one from the first line
> Set the displaymember to the name of the column you want to show
> And run
>
>
> Cor