Contents tagged with ADO.NET
-
Links 4 Later I
-
ORMapper Party
It seems this same argument comes up annually (yearly), why is that? Although I have to say, sometimes it gets entertaining! -
"?" vs @param
string sql = "SELECT COUNT(*) ";
sql += "FROM athletes ";
sql += "WHERE category = ? ";
sql += "AND gender = ? ";VSstring sql = "SELECT COUNT(*) ";
sql += "FROM athletes ";
sql += "WHERE category = @category ";
sql += "AND gender = @gender ";
Can I tell you how many hours I just spent on trying to get this *simple* query to work in Access via ADO.NET? What is up with the "?" as parameters? What happend to @param format like the SqlClient? Why do they work in the Access Querybuilder itself, but not using ADO.NET? Maybe I'm approaching this wrong. -
DataSet DataTable Relation Trouble
using System;