Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
| Search | Today's Posts | Mark Forums Read
ADO.NET For discussion about ADO.NET.  Topics such as question regarding the System.Data namespace are appropriate.  Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 20th, 2006, 10:47 PM
Registered User
 
Join Date: Sep 2006
Location: , , Laos.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to TokenBug
Default Binding Dataset to DataCombo in .NET

I don't understand why microsoft left out the DataCombo in VS.NET. Anyway, I use the AxDataCombo which is equivalent. I have a Dataset which contains data from database, the problem is I cannot set the dataset to the DataCombo.RowSource, it complaints invalid type casting, I don't know how can I set the dataset to the DataCombo.RowSource, suppose I have a dataset called Dataset1 and DataCombo named DataCombo1.
I really need help urgently, please help
Thanks,
Thinnakone
 
Old September 24th, 2006, 02:15 AM
Friend of Wrox
Points: 793, Level: 10
Points: 793, Level: 10 Points: 793, Level: 10 Points: 793, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2005
Location: OKC, OK, USA.
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default

Need more information, i.e. the listing of your code. It would be more helpful to know the database type or datasource and to understand what you are attempting to do. Usually when Microsoft removes a function, they usually replace with a new and improved version.
 
Old September 27th, 2006, 02:13 AM
Registered User
 
Join Date: Sep 2006
Location: , , Laos.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to TokenBug
Default

The reason I use DataCombo is because it can display a field and maintain an ID field in the porperty BoundColumn.
for example,
I have an sql query: "Select CustTypeID, CustTypeName from Customer" from SQL server 2000, I want to display CustTypeName as a drop down list for user to choose one. When user choose CustTypeName,I need to retrieve CustTypeID from the current record selected.

Thanks

 
Old September 27th, 2006, 03:26 AM
Friend of Wrox
Points: 793, Level: 10
Points: 793, Level: 10 Points: 793, Level: 10 Points: 793, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2005
Location: OKC, OK, USA.
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default

TokenBug:
I understand now. Your issue is addressed in Chapter 4 with code and very good explanation on pp. 107-112 in the ASP.NET databases Using VB.Net. Downloading the code, is .../Ch04/Using_Listboxes.aspx. In the code, the user selects from a listbox of Employee's LastName with the selected Last Name EmployeeID is saved, using the property lbxEmployees.DataValuerField = "EmployeeID".

This works!!!! This will work for you...
 
Old September 29th, 2006, 05:02 AM
Registered User
 
Join Date: Sep 2006
Location: , , Laos.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to TokenBug
Default

I didn't mean to use the ListBox, I want to use DataCombo which is a drop down box which looks pretty much like a Combobox...
Anyway, I found the answer by myself, here is the link: http://www.akadia.com/services/dotnet_orablobs.html
Thanks for your help, I appriciate that.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Binding a menu with dataset zaghmout ASP.NET 2.0 Professional 1 August 14th, 2007 05:24 AM
Binding a DataSet to Cystal Report snufse Crystal Reports 0 March 30th, 2007 07:06 AM
binding the grid to dataset?? thas123 ASP.NET 2.0 Basics 1 December 27th, 2006 02:15 PM
Having Trouble With Binding Dataset in Access flyingfox Pro VB.NET 2002/2003 1 August 26th, 2004 03:22 PM
Binding a Dataset to a Report ChrisLane Crystal Reports 4 March 9th, 2004 02:04 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.