Is there any way to access the prepared statement as sent to the SQL server? Dim params(1) As OleDb.OleDbParameter params(0) = New OleDb.OleDbParameter("@ID", OleDb.OleDbType....

I m using NHibernate with Burrow and Fluent to shuttle data from SQLServer2005 into a directory full of FoxPro 7 dbf s. When I try to save a new record through Burrow s GenericDAO, I get an exception ...

I have text files that are Tab delimited. I created a Schema.ini like so: [MY_FILE.TAB] Format=TabDelimited ColNameHeader=False Col1=id Short Col2=data Text This is the code I use to read it (C#): ...

I have an ADO.NET Managed Data Provider that is registered in machine.config in DbProviderFactory - It is available for use from, say, Analysis Services, so I know it is correctly registered. However,...

Does anyone know a good custom LINQ provider to query data from Excel spreadsheets?

I am processing an uploaded file through a ASP.NET page. I am using the following connection string: string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + excelFile + @";...

I have an data base (.mdb) and it has a column with dates (dd/mm/yy) , some one give me a code to get all the dates in database between 2 dates , the code was : Select * from table where date ...

I have a database (MDB, Access) and I connect it to my program using an OLE object, now I have in the db a column filled with dates (ddmmyy), I want to search and view (in Data grid view) all the ...