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
2 answers

Does this code pool SQL connections?

I'm using Essential.Logging's SQL logger. I looked at the source of the library here and saw (at the end) Everytime you want to log to SQL: using (var connection = DbProviderFactoryExtensions.CreateConnection(dbFactory,…
DeepSpace101
  • 13,110
  • 9
  • 77
  • 127
0
votes
1 answer

system.data assembly reference

I am trying to reference System.Data in a MonoTouch application for the iPhone, but am getting the following error: The type or namespace 'Data' does not exist in the namespace 'System'. Are you missing an assembly reference?" I have tried adding…
user1687352
  • 1
  • 1
0
votes
1 answer

Datagridview.DataPropertyName = System.Data.DataColumn.?

I have a list of columns Dim ListCol As List(Of System.Data.DataColumn) For Each Col As System.Data.DataColumn In Grid.Columns ListCol.Add(Col) Next I need the user friendly name of the columnl not the…
Ccorock
  • 892
  • 12
  • 37
0
votes
1 answer

SSAS Stored Procedure throwing permission

I am getting the error Execution of the managed stored procedure 'mystoredprocedure' failed with the following error: Exception has been thrown by the target of an invocation.Request for the permission of type…
EthanSpitz
  • 171
  • 1
  • 2
  • 14
-1
votes
2 answers

How to get the current date in DataTable.Compute

I am trying to compute the string expression by DataTable.Compute. A simple string like below is working: static void Compare() { var logicalExpression = "'2022-09-14' <= '2029-12-31'"; DataTable dt = new…
Edward
  • 28,296
  • 11
  • 76
  • 121
-1
votes
1 answer

How do I make my Web API project actually see the System.Data.SqlClient NuGet package?

There seem to be a good number of questions related to this, but I haven't found a solution to the problem yet. I apologize if the answer is here and I just haven't found it. I'm trying to create a Web API project that gives me the middle layer…
Kevin
  • 175
  • 8
-1
votes
1 answer

Is it possible to find out SQLSRV table index uniqueness using ADO.NET?

With Oracle I do this with DbConnection.GetSchema, but MSDN tells quite clearly that it is not possible with SQLSRV: https://msdn.microsoft.com/en-us/library/ms254969(v=vs.110).aspx#Indexes So how this can be done when table, index name and index…
char m
  • 7,840
  • 14
  • 68
  • 117
-1
votes
2 answers

How to add row with default values into System.Data.DataTable

I have DataTable and I need to add row with default values and save it into database. BONUS: Would be awesome to auto increment key column. How can I achieve that?
Farukh
  • 2,173
  • 2
  • 23
  • 38
-1
votes
1 answer

.NET 4.0 App running on .NET 4.5.1 crashes in System.Data.dll and hangs after throwing System.Data.SqlClient.SqlException

When I try to run .NET app targeting .NET 4.0 framework on a computer with only .NET 4.5.1 installed. The application normally runs on cca 50 computers within the same network domain, also on one computer with VS 2012 that has .NET 4.5.1 installed.…
Vojtěch Dohnal
  • 7,867
  • 3
  • 43
  • 105
-2
votes
1 answer

Simple select C# command - Beginner

Could you let me know where I am going wrong? I think its to do with the variable I have declared but I'm not sure using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using…
Martin
  • 1
  • 1
-3
votes
1 answer

System.Data tables data type fix on C#

I have run into an issue with system.data tables where i want to print out each row for each column, however I cant find a way that dose this for mixed data types such as the ones comprised in my table. here is the relevant code…
Alexander
  • 13
  • 3
1 2 3
…
10
11