Hi,
I am connecting to a foxpro table using adodb connection
Code:
 fcn = New ADODB.Connection
        fcn.ConnectionString = "provider=VFPOLEDB.1;Data Source= D:\" & shopname
        fcn.Open()
Using this I am trying to fill a datagrid values using binding. The value of ts=0
Code:
rst.Open("SELECT ITEM, ORD, INVENTORY FROM INVENT Where ITEM Like '" & itemno & "' ORDER BY ITEM", fcn)
        BindingSource1.DataSource = rst
         rst.Close()
 DataGridView1.Item(17, s).Value = Format((ts / Val(rst(1).Value)), "0.00")
But this statement is not working . I am getting follwoing error
Code:
Following exception occured in the datagridview
System Exceptio: 0.00 is not a valid value for Int32. --> System.formatException: Input string was not in a correct format
But this is working fine for OleDbConnection