C# VS 2005 - SQL Query Parameters to an ODBC DataSource
Please support our C# advertiser: DiscountASP.NET – 3 Months Free on C# Web Hosting
![]() |
•
•
Posts: 8
Reputation:
Solved Threads: 0
Hello everyone,
I used to have my MS Access 2002 DataBase placed in my application folder and connect to it through an OLEDB connection. Everything worked fine.
Now I decided to create an ODBC DataSource and suddenly I'm not able to pass parameters to the SQL Query the way I used to with the OLEDB connection.
Here's a sample code of the SQL Query and C# code on my form:
FillByClienteDataNumero query:
Form code:
Any ideas why the above SQL query and code work with an OLEDB connection but not with an ODBC DataSource? Thanks a million!
JC.
I used to have my MS Access 2002 DataBase placed in my application folder and connect to it through an OLEDB connection. Everything worked fine.
Now I decided to create an ODBC DataSource and suddenly I'm not able to pass parameters to the SQL Query the way I used to with the OLEDB connection.
Here's a sample code of the SQL Query and C# code on my form:
FillByClienteDataNumero query:
SELECT Data, Cliente, Tipo, Número, Espécie, Lote, Análise, Preço FROM qryALL1 WHERE (Cliente = ?) AND (Data >= ?) AND (Data <= ?) AND (Tipo = ?) ORDER BY Data, Número
Form code:
private void btnSeekBA_Click(object sender, EventArgs e)
{
try
{
this.qryALL1TableAdapter.FillByClienteDataTipo(this.sascrDataSet.qryALL1, cbCliente.Text, new System.Nullable<System.DateTime>(((System.DateTime)(System.Convert.ChangeType(DataIni.Text, typeof(System.DateTime))))), new System.Nullable<System.DateTime>(((System.DateTime)(System.Convert.ChangeType(DataFin.Text, typeof(System.DateTime))))), "Boletim");
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
} Any ideas why the above SQL query and code work with an OLEDB connection but not with an ODBC DataSource? Thanks a million!
JC.
![]() |
Similar Threads
Other Threads in the C# Forum
- sql query problem with MS Access and C# (C#)
- sql query updating problem (Visual Basic 4 / 5 / 6)
- Javascript array from sql query (JSP)
- Please help me out with MySQL query (MySQL)
- PHP/SQL query help (PHP)
- Change Query Parameters (MS Access and FileMaker Pro)
- Retreiving variables from a sql query into a form (PHP)
Other Threads in the C# Forum
- Previous Thread: Datagrid
- Next Thread: Calling function in a child window from main parent window
•
•
•
•
Views: 16598 | Replies: 0 | Currently Viewing: 1 (0 members and 1 guests)





Linear Mode