sqldataadapter
SqlDataAdapter Output Variable Question C#
I do not clearly understand how to format the SqlDataAdapter for output variables when working with C#[详细]
2023-01-19 00:48 分类:问答64-bit OutOfMemoryException with SqlDataAdapter
The environment is: 64-bit Windows ~50GB RAM .NET 3.5 SP1 SQL 2008 The code is (essentially, from memory):[详细]
2023-01-18 12:57 分类:问答SqlDataAdapter issues
There are several queries to be performed which return the DataTable object. In order to speed up the development I created a private method which should return the dataset by taking the query string[详细]
2023-01-17 17:52 分类:问答SqlDataAdapter can it be used to access oracle db?
SqlDataAdapter can it be used to access oracle db?开发者_JAVA百科 Yes it says sql, but can it be used for oracle?Microsoft has deprecated its own Oracle drivers. Use Oracle\'s drivers instead. They w[详细]
2023-01-12 09:30 分类:问答C# SqlDataAdapter.Fill giving error about data conversion when passed datatable parameter
I\'m trying to fill a datatable using a SqlDataAdapter in C#. I\'m not very familiar with the objects, and am basically working off a template of someone else\'s code to try to figure out how it works[详细]
2023-01-11 22:08 分类:问答SQL Server 2008 - Stored Procedure Gets Stuck When Called From WPF Service Using a SqlDataAdapter
This has me pulling my hair out.We have a workflow, hosted as a WCF service, which makes a call to another WCF ser开发者_StackOverflow中文版vice which then calls a stored procedure.Store procedure cal[详细]
2023-01-11 03:38 分类:问答Calling a stored procedure with null parameters and SqlDataAdapter
I have a stored procedure which I cann from my C# code. I am passing some parameters which I put in a HashTable first. It looks like that:[详细]
2023-01-07 01:40 分类:问答How to check for errors when running DataAdapter/DataSet SQL query?
This is how I update a table using DataAdapter and DataSet in VB using SQL Server: sqlStmt = String.Format("INSERT INTO my_table (name, lastname) VALUES (\'John\', \'Doe\')")[详细]
2023-01-06 07:09 分类:问答TransactionScope not rolling back with SqlDataAdapter.Update
I\'m using SqlDataAdapter.Update with DataTables to update two SQL tables in a single transaction. If either insert fails I want to roll back all data. This is my code:[详细]
2023-01-04 03:49 分类:问答How can I synchronise two datatables and update the target in the database?
I am trying to synchronise two tables between two databases.I thought that the best way to do this would be to use the DataTable.Merge method.This seems to pick up the changes, but nothing ever gets c[详细]
2022-12-27 15:10 分类:问答