Dataset for client?
Hey fellow snyc dudes and dudettes... :) Anyone had any trouble using a dataset for return values in a datagridview for the client app?
trying to make this work...
' Open the Connection For SQL Compact EditionDim cnAsNew SqlServerCe.SqlCeConnection("Data Source = " & Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) &"\ffgsCRM.sdf")
Dim cmdProductAs SqlServerCe.SqlCeCommand
' create dataset with table
cn.Open()
cmdProduct = cn.CreateCommand
cmdProduct.CommandText =
"SELECT ProductDesc AS Description, ProductCost AS Cost, ProductListPrice AS [List Price] FROM Product"Dim daProductAsNew SqlServerCe.SqlCeDataAdapter(cmdProduct)Dim dtProductAsNew Data.DataTable("Product")daProduct.Fill(dtProduct)
Dim dsAsNew DataSetds.Tables.Add(dtProduct)
'' FILL DATAGRIDVIEW
Me.dbGridProducts.DataSource = dsI have this working:
' search product description
Dim reqProductSearchAsStringreqProductSearch = tstxtSearchDescription.Text
' Open the Connection For SQL Compact EditionDim _conn =New SqlCeConnection("Data Source = " & Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) &"\ffgsCRM.sdf")Dim cmdAsNew SqlCeCommand()cmd.Connection = _conn
cmd.CommandText =
"select ProductDesc as Description, ProductCost as Cost, ProductListPrice as [List Price] from Product where ProductDesc like '%" & reqProductSearch &"%' ORDER BY ProductDesc"_conn.Open()
Dim resultSetAs SqlCeResultSetresultSet = cmd.ExecuteResultSet(ResultSetOptions.Scrollable
Or ResultSetOptions.Updatable)'' FILL DATAGRIDVIEWdbGridProducts.DataSource = resultSet
With dbGridProducts.Columns(
"Description").Width = 550EndWithThanks,
Bill
