SqlDataAdapter can it be used to access oracle db?
SqlDataAdapter can it be used to access oracle db? yes it says sql, but can it be used for oracle ...
dataadapter
New to Android. Is it possible for the user to specify the name of a Database to be created? Also on using multiple databases.
Hi everyone. I'm very new to Android. I'm thinking about creating an application that uses multiple databases. The user would be able to specify the name of the database to be created, and select which database to use from those existing in the /databases/ directory. Is this possible in android? ...
Dynamically modifying .NET DataSet DataTable
I’ve got a predefined Dataset with DataTables and DataAdapters in my applications. However, I now want to be able to modify the SP in SQL Server to add fields as needed, and have that reflected in the DataSet’s DataTable dynamically. This goes from a WebService into XML then goes to the client and gets converted back to the DataSet and...
How to do transaction control on data access using DataAdapter and Stored Procedure in C#?
How to do transaction control on data access using DataAdapter and Stored Procedure in C#? Currently I want to execute 2 stored procedure calls via DataAdapter, but I want to do transaction control on it. Is there any way to do it? ...
DataAdapter returns a empty rowset, but DataReader returns data.
Hi, I execute a query that calls a SP, that SP returns data... but when I call it with a DataAdapter I get no result data, if use a DataReader instead... then I get data. The database is SQL Server and the code is using OleDb for reasons I cannot change. These two calls returns diferent things: String commandText = "Declare @retur...
Import Excel file to SQL Server row-by-row
I'm importing an Excel file (about 1000 records only) to a dedicated SQL Server database. As I need to work on the incoming data from Excel (add a GUID per row, some data conversions) I want to do it row by row and don't want to bulk import (I have nothing against transactions, though). I'm confused on how to do it correctly. I can eith...