Top "Ado.net" questions

Populate data table from data reader

I'm doing a basic thing in C# (MS VS2008) and have a question more about proper design than specific code. …

c# .net ado.net

Microsoft.ACE.OLEDB.12.0 provider is not registered

I have a Visual Studio 2008 solution with two projects (a Word-Template project and a VB.Net console application for testing). …

visual-studio ms-access ado.net oledb

Calling stored procedure with return value

I am trying to call a stored procedure from my C# windows application. The stored procedure is running on a …

c# sql-server stored-procedures ado.net return-value

Can you get the column names from a SqlDataReader?

After connecting to the database, can I get the name of all the columns that were returned in my SqlDataReader?

c# ado.net sqldatareader

Insert into C# with SQLCommand

What's the best way to INSERT data into a database? This is what I have but it's wrong.. cmd.CommandText = "…

c# .net ado.net sqlcommand

A connection was successfully established with the server, but then an error occurred during the pre-login handshake

I am getting following error when i am trying to connect Production DB from Local Environment. I was able to …

.net sql-server sql-server-2008 ado.net database-connection

How to change the DataTable Column Name?

I have one DataTable which has four columns such as StudentID CourseID SubjectCode Marks ------------ ---------- ------------- -------- 1 100 MT400 80 2 100 MT400 79 3 100 …

c# asp.net ado.net datatable

Reading DataSet

How do I read data from a DataSet in WPF? I have a train schedule table with just 2 columns and …

c# .net wpf ado.net dataset

How to check empty DataTable

I have a DataSet where I need to find out how many rows has been changed using the following code: …

c# ado.net

Get output parameter value in ADO.NET

My stored procedure has an output parameter: @ID INT OUT How can I retrieve this using ado.net? using (SqlConnection …

c# .net ado.net