Top "Ado.net" questions

Increasing the Command Timeout for SQL command

I have a little problem and hoping someone can give me some advice. I am running a SQL command, but …

c# sql ado.net connection-timeout

How do you Sort a DataTable given column and direction?

I need to resort, in memory, a DataTable based on a column and direction that are coming from a GridView. …

c# ado.net datatable

How to test if a DataSet is empty?

I'm modifying someone else's code where a query is performed using the following: DataSet ds = new DataSet(); SqlDataAdapter da = new …

c# ado.net dataset

What is the difference between ExecuteScalar, ExecuteReader and ExecuteNonQuery?

What are the different cases when we use these three? Where should I use one and where should I not?

asp.net ado.net

How to run multiple SQL commands in a single SQL connection?

I am creating a project in which I need to run 2-3 SQL commands in a single SQL connection. Here …

c# sql-server ado.net sqlconnection sqlcommand

entity object cannot be referenced by multiple instances of IEntityChangeTracker. while adding related objects to entity in Entity Framework 4.1

I am trying to save Employee details, which has references with City. But everytime I try to save my contact, …

c# asp.net entity-framework ado.net foreign-keys

Connection to SQL Server Works Sometimes

An ADO.Net application is only sometimes able to connect to another server on the local network. It seems random …

sql-server ado.net

Convert DataSet to List

Here is my c# code Employee objEmp = new Employee(); List<Employee> empList = new List<Employee>(); foreach (…

c# list ado.net dataset

Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures?

How would you rate each of them in terms of: Performance Speed of development Neat, intuitive, maintainable code Flexibility Overall …

sql linq-to-sql entity-framework ado.net linq-to-entities

Get the generated SQL statement from a SqlCommand object?

I have the following code: Using cmd As SqlCommand = Connection.CreateCommand cmd.CommandText = "UPDATE someTable SET Value = @Value" cmd.CommandText &…

c# vb.net ado.net