Dim EditProductDataAdapter As New SqlDataAdapter("select * from ProductDetails where ProductName=" + comboVal, BillingDBConn) Dim EditProductDataSet As New DataSet BillingDBConn.Open() EditProductDataAdapter.Fill(EditProductDataSet, "ProductDetails") ..> at this point i got an exception .. whats wrong with my first line given above