Populating a Combo box using a SqlDataReader

[Neil Guyette]

Hello, Everyone,

I'm trying to find information on how to populate a combo
box using a SqlDataReader. I want to be able to set the
value of the combo's value property different then the
combo's text property (what the user will see). Is this
possible with a SqlDataReader?

Thanks

-Neil

[Gary Chang]

Hi Neil,

Thanks for posting in the group!

SqlDataReader provides a means of reading a forward-only stream of rows
from a SQL Server database(simila r to a cached read-only recordset).

populate a combo box using a SqlDataReader,

If you have a valid SqlDataReader, you can manually retrieve data from that
SqlDataReader to populate a combo box.(no automatic way)

The following is a VC++ SqlDataReader sample program link:
http://samples.gotdotnet.com/quickst...ngPref=CP&path
=/quickstart/howto/samples/adoplus/sqldtreader/sqldtreader.src
Best regards,
Gary Chang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| Content-Class: urn:content-classes:message
| From: "Neil Guyette" <ng******@gemss ensors.com>
| Sender: "Neil Guyette" <ng******@gemss ensors.com>
| Subject: Populating a Combo box using a SqlDataReader
| Date: Tue, 9 Dec 2003 16:08:31 -0800
| Lines: 11
| Message-ID: <05************ *************** *@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| thread-index: AcO+sb7FuJ4jS1J EThqZKLILpFlTng ==
| Newsgroups: microsoft.publi c.dotnet.langua ges.vc
| Path: cpmsftngxa07.ph x.gbl
| Xref: cpmsftngxa07.ph x.gbl microsoft.publi c.dotnet.langua ges.vc:31048
| NNTP-Posting-Host: tk2msftngxa11.p hx.gbl 10.40.1.163
| X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.vc
|
| Hello, Everyone,
|
| I'm trying to find information on how to populate a combo
| box using a SqlDataReader. I want to be able to set the
| value of the combo's value property different then the
| combo's text property (what the user will see). Is this
| possible with a SqlDataReader?
|
| Thanks
|
| -Neil
|

[Neil Guyette]

Mr. Chang,

Thanks for your reply.

I realized that the SqlDataReader is forward only, but
when coding an asp.net page and using a dropdownbox you
can bind it to a SqlDataReader. I found my solution last
night, instead of using a SqlDataReader I'm now using a
SqlDataAdapter. Using the SqlDataAdapter to fill a
DataSet object.

Once again thanks a lot.

Neil Guyette

-----Original Message-----
Hi Neil,

Thanks for posting in the group!

SqlDataReade r provides a means of reading a forward-only stream of rowsfrom a SQL Server database(simila r to a cached read-only recordset).

populate a combo box using a SqlDataReader,If you have a valid SqlDataReader, you can manually

retrieve data from that SqlDataReader to populate a combo box.(no automatic way)

The following is a VC++ SqlDataReader sample program link:http://samples.gotdotnet.com/quickst...l/srcview.aspx ?lbLangPref=CP& path=/quickstart/howto/samples/adoplus/sqldtreader/sqldtreade r.src

Best regards,
Gary Chang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "Neil Guyette" <ng******@gemss ensors.com>
| Sender: "Neil Guyette" <ng******@gemss ensors.com>
| Subject: Populating a Combo box using a SqlDataReader
| Date: Tue, 9 Dec 2003 16:08:31 -0800
| Lines: 11
| Message-ID: <05************ *************** *@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300| thread-index: AcO+sb7FuJ4jS1J EThqZKLILpFlTng ==
| Newsgroups: microsoft.publi c.dotnet.langua ges.vc
| Path: cpmsftngxa07.ph x.gbl
| Xref: cpmsftngxa07.ph x.gbl microsoft.publi c.dotnet.langua ges.vc:31048| NNTP-Posting-Host: tk2msftngxa11.p hx.gbl 10.40.1.163
| X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.vc
|
| Hello, Everyone,
|
| I'm trying to find information on how to populate a combo| box using a SqlDataReader. I want to be able to set the| value of the combo's value property different then the
| combo's text property (what the user will see). Is this| possible with a SqlDataReader?
|
| Thanks
|
| -Neil
|

.

[Gary Chang]

Hi Neil,

Thanks for your quickly response!

We are very delightful to know you have found your resolution.

Thanks again for participating the community.
Best regards,
Gary Chang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------