The title speaks for itself. I'm building a winforms C# 2.0 app. Any tutorials or inspiring ideas?
+2
A:
ADO.NET is a big topic - but the keywords to search for here are SqlConnection, SqlCommand, SqlDataReader, etc. If you like DataSet (I'm not a fan, but some people love them), then the dataset designer will do a lot for you.
Another option is to use a .NET 2.0 web-service (asmx) for data access via a central app-server - making it a "smart client".
With later .NET versions, WCF (.NET 3.0), LINQ-to-SQL (.NET 3.5), Entity Framework (.NET 3.5 SP1) and ADO.NET Data Services (.NET 3.5 SP1) become options.
Marc Gravell
2009-05-06 08:33:32
+1 good article
m_oLogin
2009-05-07 12:11:05
A:
upgrade to C# 3.5 and use a Add->New Item->Linq to Sql Class... by far the easiest way i've ever seen, you can just drag from server explorer the tables you want... otherwise...
it's much more difficult in 2.0 until you get your rythym down, As previous poster i'd recommend SqlConnection and SqlDataReader, etc. Before .NET 3.5 we had an ancient helper method that simply did something like the following
DataAccessLayer dal = new DataAccessLayer("Connection String"); SQLDataReader sr = dal.getDataReader("SQLCOMMANDSTRING"); sr.Close(); dal.runProcess("SQLCOMMANDSTRING");
etc..
for some specifics on how to use the SQL objects check the following: http://www.developerfusion.com/article/4278/using-adonet-with-sql-server/2/
DNeoMatrix
2009-05-06 08:37:39
It's still not exactly 'difficult' to declare a few classes, set some properties and then interpret the result. Besides. I much more prefer that people get down and learn what's really going on before doing drag'n'drop programming. =)
J. Steen
2009-05-06 08:39:43
yes, yes, sorry... i've been studying for finals all night, please forgive me. =)
DNeoMatrix
2009-05-06 09:12:02
+1
A:
There's not much difference between a local SQL Server instance and a distant one. You just set something like Server=sqlserver.remote-machine.com in your connection string.
Mehrdad Afshari
2009-05-06 08:41:20
Well, there is if there is a firewall in the way ;-p And of course round-trip performance becomes more of an issue, depending on the meaning of "remote".
Marc Gravell
2009-05-06 09:05:15