Select command in dataAdapter

Hot Topic

DeSerialization error with strongnamed assemblies
Best encryption/decryption for strings
Sockets and Serialization
Trouble connecting to a Link Table in Access Database
EventLogPermission
.net equivalent of vb6 winsock
getcurrentprocess problem
Add Inherited Form using MC++
COM+ Transaction error in ASP.NET
Plural of word

.NET Development

Showing data in a DatagridView or ListBox - VB 2005
Using hiddentext control by making viewstate false to polpulate controls.
How to measure the memory pressure?
Problem with adding an ID value while updating a dataset that contains relations
DataSet to new Access Database?
i miss so many files like MSI MSVCR.dll on my pc wher i can douwnload this
SqlDataSource InsertParameters
Where to get full description of ComponentModel(designers) namespace ?
How are delegates cleaned up?
Com+ Error

Select command in dataAdapter

 Hi all,

I'm building an application to get data from Access database.

I need only to get one field from the database with a dynamic Where creteria I built.

How can use the select command of the dataAdapter in Visual Studio to get the data.

I write the dynamic select sentence in calles the Fill method of the dataAdapter, I get the exception "No parameter was found".

The select sentence I built : "Select person from tblPersons where ((Name = Dany) and (birthData Between #12/5/2005# And #20/12/2005#));

How can I do that

Regards...  

 

Answer this question

Select command in dataAdapter

  • excalidalf

    Hi Wasim,

    You can pass the SQL Query directly to the contructor of the SqlDataAdaper. Sample below:

    ---------------------------------------------------------------------------------------------------------

    CODE SNIPPET

    ---------------------------------------------------------------------------------------------------------

    SqlConnection conn = new SqlConnection("CONNECTIONSTRING");

    DataSet dsetData = new DataSet();

    SqlDataAdapter adapter = new SqlDataAdapter("Select person from tblPersons where ( ( Name = Dany) and (birthData Between #12/5/2005# And #20/12/2005#) )", conn);

    adapter.Fill(dsetData);

    ---------------------------------------------------------------------------------------------------------

    *CONNECTIONSTRING represents the actual connection string.

    Regards,

    Vikram

  • Select command in dataAdapter
Answer this question