C# and Database Programming

[Todd Jaspers]

Hey guys,

I'm writing an application and I'm very frustrated right now. What I
want to be able to do is have a form (regular Windows application), and have
a series of drop-downs.

What I'm doing right now, is running queries, and individually populating
the boxes with the data. What I would MUCH RATHER do, is have those drop-down
"combo-boxes" linked to a dataset. I want to be able to select an item in the
combo-box and then have access to the actual identifier (guid) instead of the
text.

Does anyone have any good references they can show me (links) that might
help me achieve this? I'm very frustrated...


thanks...

Todd

[Rick]

Re: C# and Database Programming

Hi Tood, hope this help you

http://www.codeproject.com/cs/miscctrl/DataGridZen.asp

http://mmofx.com/code.aspx?K=DATA

http://www.akadia.com/services/dotnet_databinding.html

Regards

"Todd Jaspers" <ToddJaspers@di scussions.micro soft.comescribi ó en el
mensaje news:2A89775E-5E64-4E54-B717-6A2808D74F59@mi crosoft.com...

Hey guys,
>
I'm writing an application and I'm very frustrated right now. What I
want to be able to do is have a form (regular Windows application), and
have
a series of drop-downs.
>
What I'm doing right now, is running queries, and individually populating
the boxes with the data. What I would MUCH RATHER do, is have those
drop-down
"combo-boxes" linked to a dataset. I want to be able to select an item in
the
combo-box and then have access to the actual identifier (guid) instead of
the
text.
>
Does anyone have any good references they can show me (links) that might
help me achieve this? I'm very frustrated...
>
>
thanks...
>
Todd

[Peter Bromberg [C# MVP]]

RE: C# and Database Programming

Not to sound like a broken MP3, but have you looked at the QUICKSTARTS?
The one for Windows Forms covers all this stuff:

http://samples.gotdotnet.com/quickstart/winforms/

Peter

--
Co-founder, Eggheadcafe.com developer portal:

http://www.eggheadcafe.com

UnBlog:

http://petesbloggerama.blogspot.com

"Todd Jaspers" wrote:

Hey guys,
>
I'm writing an application and I'm very frustrated right now. What I
want to be able to do is have a form (regular Windows application), and have
a series of drop-downs.
>
What I'm doing right now, is running queries, and individually populating
the boxes with the data. What I would MUCH RATHER do, is have those drop-down
"combo-boxes" linked to a dataset. I want to be able to select an item in the
combo-box and then have access to the actual identifier (guid) instead of the
text.
>
Does anyone have any good references they can show me (links) that might
help me achieve this? I'm very frustrated...
>
>
thanks...
>
Todd

[sloan]

Re: C# and Database Programming

Todd,

The biggest thing you have to remember is that you put OBJECTS into the
comboboxes, not key/value pairs.

So you need to pull the object, and then cast it, to get the correct value.

If its populated from a DataSet, then its a DataRow or something.

If its a strongly typed DataSet, then you'll have an actual SomeEntityRow
object.

...


"Todd Jaspers" <ToddJaspers@di scussions.micro soft.comwrote in message
news:2A89775E-5E64-4E54-B717-6A2808D74F59@mi crosoft.com...

Hey guys,
>
I'm writing an application and I'm very frustrated right now. What I
want to be able to do is have a form (regular Windows application), and

have

a series of drop-downs.
>
What I'm doing right now, is running queries, and individually populating
the boxes with the data. What I would MUCH RATHER do, is have those

drop-down

"combo-boxes" linked to a dataset. I want to be able to select an item in

the

combo-box and then have access to the actual identifier (guid) instead of

the

text.
>
Does anyone have any good references they can show me (links) that might
help me achieve this? I'm very frustrated...
>
>
thanks...
>
Todd