Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query a Dataset with a Period

Status
Not open for further replies.

jward

MIS
Dec 21, 2000
57
US
I'm populating a listbox with a dataset, then when I select
a item (partnumber) in the listbox I populate a datgrid with the data pertaining to the selected item. Here's where the problems comes in. If the selected item contains a period i recieve an error. for example if I select
1-56403 the datagrid gets populated fine then I select 1.4324b and I get the error "Can't create child list for field 1." so anything after the period is not showing up.

The binding is as follows

dgpartnum.SetDataBinding(ds, AllParts.SelectedItem.ToString)

Thanks
 
At any point in your application, is that number ever typed as an integer instead of a double, float, etc? Perhaps your dropping your fraction with a conversion somewhere...

Lazer
 
Try


dgpartnum.SetDataBinding(ds, "[" & AllParts.SelectedItem.ToString & "]").


 
Lazer
No, never it's never being converted to a integer, and
RiverGuy's suggestion didn't work either. Any other Idea's?

Thanks for the input


 

try this out !!!

DataGrid1.SetDataBinding(objDS, " & """ & AllParts.SelectedItem & """ & ")

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top