Top "Ado.net" questions

ADO.

Handling ExecuteScalar() when no results are returned

I am using the following SQL query and the ExecuteScalar() method to fetch data from an Oracle database: sql = "select …

c# oracle ado.net
ExecuteReader requires an open and available Connection. The connection's current state is Connecting

When attempting to connect to MSSQL database via ASP.NET online, I will get the following when two or more …

c# .net sql-server ado.net database-connection
Insert 2 million rows into SQL Server quickly

I have to insert about 2 million rows from a text file. And with inserting I have to create some master …

c# asp.net sql-server database ado.net
How to fill a datatable with List<T>

How can convert a list to a datatable [Serializable] public class Item { public string Name { get; set; } public double Price { …

c# ado.net datatable
Using MySQL with Entity Framework

Can't find anything relevant about Entity Framework/MySQL on Google so I'm hoping someone knows about it.

mysql .net entity-framework ado.net
Mixed mode assembly is built against version ‘v2.0.50727′ of the runtime

I'm getting the following exception: Mixed mode assembly is built against version ‘v2.0.50727′ of the runtime and cannot be loaded …

.net visual-studio-2010 .net-4.0 ado.net crystal-reports
Inserting values into a SQL Server database using ado.net via C#

I have created a simple program to insert values into the table [regist], but I keep getting the error Incorrect …

c# sql sql-server ado.net executenonquery
Unable to find the requested .Net Framework Data Provider in Visual Studio 2010 Professional

Why am I getting "Unable to find the requested .Net Framework Data Provider" when trying to setup a new datasource …

asp.net .net visual-studio-2010 ado.net datasource
Entity Framework and Connection Pooling

I've recently started to use the Entity Framework 4.0 in my .NET 4.0 application and am curious about a few things relating …

.net database entity-framework ado.net connection-pooling
Invalid attempt to read when no data is present

private void button1_Click(object sender, EventArgs e) { string name; name = textBox5.Text; SqlConnection con10 = new SqlConnection("con strn"); SqlCommand …

c# ado.net