Top "Ado.net" questions

Reading a date using DataReader

I read a string using this format with a data reader. How can I read in a date using similar …

c# .net ado.net datareader

What size do you use for varchar(MAX) in your parameter declaration?

I normally set my column size when creating a parameter in ADO.NET But what size do I use if …

c# sql-server-2008 ado.net

DataAdapter.Fill(Dataset)

i try to get some Data from a Access Database via OleDB in a DataSet. But the DataSet is empty …

c# ado.net dataset oledb oledbdataadapter

How can I retrieve a table from stored procedure to a datatable?

I created a stored procedure so as to return me a table. Something like this: create procedure sp_returnTable body …

c# .net asp.net sql-server ado.net

Base64 String throwing invalid character error

I keep getting a Base64 invalid character error even though I shouldn't. The program takes an XML file and exports …

c# string ado.net base64 invalid-characters

How to refresh datagrid in WPF

My source is in a MySQL database, I've made an update command and now I need to refresh my DataGrid. …

c# mysql wpf ado.net wpfdatagrid

How do I find out if a column exists in a VB.Net DataRow

I am reading an XML file into a DataSet and need to get the data out of the DataSet. Since …

.net vb.net ado.net dataset datarow

Handling 'Sequence has no elements' Exception

I am updating a quantity in my cart, but it is throwing a Sequence has no elements' exception. And I …

c# .net linq entity-framework ado.net

ExecuteNonQuery requires the command to have a transaction error in my code

I get the following error on cmd.ExecuteNonQuery. "ExecuteNonQuery requires the command to have a transaction when the connection assigned …

c# ado.net c#-2.0

The SqlParameter is already contained by another SqlParameterCollection - Does using() {} cheat?

While using the using() {} (sic) blocks as shown below, and assuming that cmd1 does not live beyond the scope of …

c# .net sql-server ado.net