Click to See Complete Forum and Search --> : No Dataset Formview


Nate1
11-22-2007, 06:09 AM
I used the dataset wizard or whatever its called to create a dataset for a formview, .xsd,.xss. It works except it throws a funny error that doesn't appear in any of my other code (Datalists with manual Binding), Where can I find a good article on doing the same for a Formview

Nate1
11-22-2007, 06:23 AM
It now Works whereas the Dataset created by Visual Studio doesn't (For some records)


Dim SearchStr As String = "SELECT * FROM Listing WHERE iListingID = " + Request.QueryString("ID")

Dim ListingCmd As New SqlCommand(SearchStr, Connection())
Dim daListing As New SqlDataAdapter(ListingCmd)
Connection.Open()
Dim ds As New DataSet
daListing.Fill(ds)

fvListingDetails.DataSourceID = ""
fvListingDetails.DataSource = ds.Tables(0).DefaultView
fvListingDetails.DataBind()
Connection.Close()