Hi, I am using following code and trying to get data by given parameters. I donot know how to pass the parameter value to my query. Dim con As New OleDb.OleDbConnection Dim ds As New DataSet Dim da As OleDb.OleDbDataAdapter Dim sql As String con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = D:\.Net Programs\DB Experiments\AddressBook.mdb" con.Open() sql = "SELECT * FROM tblContacts where Name=? and City=?" da = New OleDb.OleDbDataAdapter(sql, con) da.Fill(ds, "AddressBook") con.Close() Please advise. Thanks Furqan
sql = "SELECT * FROM tblContacts where Name=@NM and City=@CT" da = New OleDb.OleDbDataAdapter(sql, con) da.SelectCommand.Parameters.AddWithValue("@NM", name) da.SelectCommand.Parameters.AddWithValue("@CT", city)
da.SelectCommand.Parameters.Add
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)