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

Unable to find an entry point named 'DllBidEntryPoint' in DLL 'System.Data.dll'

I have a project in MVC .we use EntityFrameWork.core for connection to database and use SqlServer as DataBase .In Debug Mode every thing is ok. but when we published the project we faced to an exception. the Message of exception that was in log's…
mahdi
  • 111
  • 2
  • 4
0
votes
1 answer

VS C# Sql Client unable to connect to SQL Server, uses Windows auth instead of SQL Server auth

I have two desktop clients with VS 2017. I inherited a C# .NET app that connects to a SQL Server in the next room. We generally use SQL Server authentication (as opposed to Windows authentication) when we perform SQL queries. I use a connection…
Paperclip Bob
  • 346
  • 2
  • 8
0
votes
0 answers

How to update System.Data version to 2.0.5.0

First of all, I'm working with Visual Studio 2015 (and can't upgrade VS version) and using a MySQL library. My using directives are using System; using System.Data; using MySql.Data.MySqlClient; And I'm trying to connect with a MySQL database…
Windgate
  • 365
  • 1
  • 4
  • 14
0
votes
0 answers

How does DataAdapter.Fill move across data all in "one large hit"?

I want to check an assumption I've always made. I was having a brief discussion with a team mate where he suggested that DataAdapter Fill was faster than using a DataReader to retrieve data as it didn't iterate through the records. I suggested that…
Jules 999
  • 125
  • 1
  • 9
0
votes
1 answer

How to customize InnerException.Message for System.Data.UpdateException in ASP.NET

First of all thanks for taking the time to read through my post. I have a question that may be a newbie piece of cake for some. I am adding data to a database table using Entity Framework. When adding a duplicate Primary Key I get an exception in…
DeSilva Rakesh
  • 3
  • 2
0
votes
1 answer

How do I update a column in a System.Data datarow using V8 under ClearScript?

I'm using the V8ScriptEngine v8 = new V8ScriptEngine(V8ScriptEngineFlags.DisableGlobalMembers); and have exposed the "System.Data" namespace into the ClearScript environment. var htc = new HostTypeCollection(); foreach (var assembly in new…
bugmagnet
  • 7,631
  • 8
  • 69
  • 131
0
votes
1 answer

Why doesn't my DataTable.DefaultView.Sort sort things in order?

So I'm trying to sort some data and print it, but DataTable.DefaultView.Sort doesn't seem to work how I would expect it to work. Given this data: Col1 Col2 Col3 2802 32 0 2802 80 3 2802 130 3 2802 40 0 2802 40…
dirkdiggl3r
  • 11
  • 1
0
votes
1 answer

Getting DataTables in tree diagram form from a single DataTable

I have a DataTable that contains following columns: type,name,year,version. I want DataTables that contain unique combinations. The table is first divided into multiple tables that have unique name+year combinations. Those tables need to be split…
Jan
  • 47
  • 9
0
votes
1 answer

DataTable.AsEnumerable() does not Exist on my Visual Studio For Mac System.Data

I downloaded Visual Studio for Mac to give it a try. I am working with data and linq. When I try the following, AsEnumerable does not exist. using System.Linq; using System.Data; namespace TestingDataTable2 { class Program { …
Mwspencer
  • 1,142
  • 3
  • 18
  • 35
0
votes
1 answer

UWP project cannot find System.Data version 4.0.0.0

I'm working on a UWP application and when trying to activate a function from System.Data.Sqlclient this exception pops up: System.IO.FileNotFoundException: 'Could not load file or assembly 'System.Data, Version=4.0.0.0, Culture=neutral, …
Amjx
  • 1
  • 2
0
votes
1 answer

Copy source datatable to destination datatable with the schema of destination

I'm trying to copy the data from source dt to destination datatable. source datatble types are sting and destination datatble types contains datetime along with strings. datatable dt2=new datatable(); foreach (DataRow row in dt1.Rows) { …
Ashu
  • 11
  • 5
0
votes
1 answer

NetCoreApp2.1 System.Data reference error

I've got a DLL library compiled in .NET Framework 4.6.1. It uses Microsoft.SqlServer.SqlManagementObjects v.140.17283.0 and Unofficial.Sql.Server.Management.Objects v17.4.1 that I've installed from NuGet. All works fine. Now I want to use this…
Lic
  • 1,757
  • 3
  • 14
  • 16
0
votes
1 answer

Add collection as SQL parameter to SqlCommand without using (Table-Valued-Parameter) type

I'm trying to use a table as a parameter in my SQL query, but I cannot get it to work without using the name of an existing type (Table Valued Parameter). In MSSQL I can do this: declare @mytable table (column1 int, column2 nvarchar(10)) insert into…
yaba
  • 829
  • 7
  • 11
0
votes
2 answers

Build error complaining that it cannot find System.Data.Entity in asp.net application

I'm building an ASP.net application using Visual Studio Web Developer 2010 Express and have followed the Nerd Dinner tutorial for a large part. The problem is that when I try to build, it is constantly giving me a build error saying: Error 43 …
Vinayak Suley
  • 537
  • 5
  • 9
0
votes
1 answer

C# Create Directory based on ZIP code value of file and Transfer Files using System.IO, System.Data, & CSVReader

Existing App: I have a C# app that runs a search and fetches matching lead files and throws them into a specificied directory. Adding functionality to: have the system check to see if a subdirectory exists for the file's zip code and if it doesn't…
Brian McCarthy
  • 4,658
  • 16
  • 49
  • 66
1 2 3
…
10 11