Query a Dataset with a Period

[jward]

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

 

[RebLazer]

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

 

[RiverGuy]

Try


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

 

[jward]

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

 

[PankajBanga]

try this out !!!

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