Stack Overflow
Stack Overflow

Questions tagged [system.data]

System.Data is a namespace of the .NET framework. It provides access to classes that represent the ADO.NET architecture.

System.Data is a namespace of the .NET framework. It provides access to classes that represent the ADO.NET architecture.

References

161 questions
0
votes
1 answer

System.Data.DataRowView c#

Whenever I run this code I get back - System.Data.DataRowView. I don't understand what the problem. I have tried to looking here for solutions but I can't understand (I'm new in programing..). public void loadLabels() { using…
bar
  • 25
  • 1
  • 2
  • 6
0
votes
1 answer

How can I capture SQL query performance statistics when executing queries via ADO.NET

When I use Sql Server Profiler, I can see a bunch of useful performance statistics for my queries (CPU, page reads, etc). I'd like to be able to capture these when my .NET code runs queries for logging and benchmarking purposes. To best correlate…
ChaseMedallion
  • 20,860
  • 17
  • 88
  • 152
0
votes
2 answers

What is the fastest way to fill a simple object from a DataTable?

I was just wondering is there a faster or more efficient method to convert a DataTable to an object? The method I am currently using is this: public class Job { int JobID { get; set; } decimal JobCost { get; set; } Job(DataRow dr) …
user3241130
  • 85
  • 8
0
votes
1 answer

IndexOutOfRangeException when calling SqlQuery.ExecuteAsCollection() but not in the Command & Watch Windows

I have a very strage problem with the SqlQuery.ExecuteAsCollection() method and I am not sure whether this is related to SubSonic, my database or .NET. When the following line gets executed: FlowerCollection myCollection =…
t3chb0t
  • 16,340
  • 13
  • 78
  • 118
0
votes
0 answers

Replacement for System.Data.dll for Windows Phone 8.1

I am having trouble while adding System.Data.dll in Windows Phone 8.1 Application. Following compile time error show after adding System.Data.dll in project reference and adding following class: public class EntityResponse { public DataSet[]…
Ankush Madankar
  • 3,689
  • 4
  • 40
  • 74
0
votes
1 answer

Checking if DataRow cell partially contains string

I need to eliminate all rows that contain either string notUsed or string notUsed2, where a particular identity is 2. I'm using a foreach loop to accomplish this, prior to appending any of my data to a stringbuilder. I would have chosen a method…
Wolfish
  • 960
  • 2
  • 8
  • 34
0
votes
2 answers

Extension to extract column from DataRow[] as List, Array, etc with same data type

I want to make an extension method for System.Data.DataRow[] that will take a single column from the DataRow[] and convert it to a list, array, etc of the columns data type. Originally I had this as a string extension that would churn out an array…
wesmantooth
  • 625
  • 2
  • 11
  • 29
0
votes
2 answers

Inheriting from System.Data.Common.DbCommand, Parameters property is null

I'm busy building a custom framework for data retrieval and serialization and I'm running into a problem when defining a proprietary database connection/command/parameter combo. Everything works as expected until I try and add parameters to my…
FarligOpptreden
  • 5,013
  • 22
  • 23
0
votes
1 answer

.NET/ADO.NET: Detecting Connection Pool Limits

I am getting connection timeouts and I suspect they may be caused by a bug that is allowing me to exceed my connection pool limit. Is there a way to progamatically detect this?
Jonathan Allen
  • 68,373
  • 70
  • 259
  • 447
0
votes
1 answer

ASP.NET database entity

I have big problem with MVC5. I am doing tutorial MVC MusicStore and I got a problem with databse. I have to add using system.data.entity But Viusual don't know what is the entity. I was searching information about this problem and there was only…
AdamLato
  • 47
  • 2
  • 13
0
votes
2 answers

Help Optomizing Bulk Inserts into Oracle Using VB.NET

I am inserting a block of 5000 records at a time, one block right after the other. The commands are created in a seperate DLL and can call anyone of 4 different stored procedures. Is there a bulk insert method that might speed this up. Currrently…
user38349
  • 2,945
  • 9
  • 36
  • 47
0
votes
0 answers

How can I force my application to use System.Data.dll from the .net Framework 4.0 on a working station the has installed 4.5 .Net Framework on it?

I have a client-server application which communicates through WCF. I have a method that sends a System.Data.SqlClient.SqlConnection from the server to the client. After installing visual studio 2012 (which installed .NetFramework 4.5) on the working…
Ionesta
  • 21
  • 1
0
votes
1 answer

Selection into DataTable as a Cell

What is the best way to get a specific [Column][Row] value into a DataTable ? private DataTable CurrentTable { get; set; } public string selectCell(int Column, int Row) { return CurrentTable............ }
CheapD AKA Ju
  • 713
  • 2
  • 7
  • 21
0
votes
1 answer

.NET 4.0 System.Data issue

I am developing a .NET 4.0 application. It runs fine on the development machine (win7 32bit), but it reports this issue when installed and started on a win7 64bit machine. I think the issue has something to do with the System.Data module, because…
Khanh Hua
  • 1,086
  • 1
  • 14
  • 22
0
votes
1 answer

DataTable merge treats duplicate PK as update rather than erroring

I am trying to merge two DataTables - one representing current data, and one representing proposed insertions to that data. These tables have the same schema, both with a simple, user-provided primary key string. What I'd like is, if the a proposed…
Rawling
  • 49,248
  • 7
  • 89
  • 127
1 2 3
…
10
11