Named parameters in SQL- SQLDataAdapter vs. OleDBDataAdapter
New to SQL and VB.NET - would appreciate any insights into the following:
First, are there any substantial performance differences between the
SQLDataAdapter and the OleDBDataAdapter? I'm assuming there are. The primary
reason I ask is that I have docs and samples that work under
OleDBDataAdapter , but I am not getting them to work under SQLDataAdapter
Here's my confusion:
I'm trying to run a parameterized query through web forms. Basic simple
thing.
-The SQL statement that I used for the adapter is:
SELECT LastName, FirstName, Filepath, FileName, RecordDate, Length, SID,
IsArchive
FROM Table1
//if it is important, the Configuration Wizard concat'ed all those lines
together
-I set up a Dataset connected to the adapter
-I bound a datagrid to the dataset.
- created a button to load the dataset. here's the code for that:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
txtLastName.Text
DataSet11.Clear()
SqlDataAdapter1.Fill(DataSet11)
End Sub
What I think is supposed to happen is that on submitting a name that is in
the database, the datagrid will appear with any/all records matching the
last name. It doesn't.
What am I missing here?
Thanks for any and all help
Mike Maloney
