I need some help with general information (mostly db related)

Question

Hi all and thanks in advance for any replies to this post. I've been programming for about 10 years now mostly doing side projects for whatever tickled my fancy. Just a hobby nothing professional. Until now I've never worked with a visual programming language. I've found C# to be a lot to my liking for my upcoming project. My first request is pretty easy. I'd like to know of a good book that would get me started on C# programming. Normally I take a new programming language and learn by example and of course lots of trial and error. However since I've never done visual programming before I thought a book to assist me might be in order. :) I really don't want any introduction style books because I am very familiar with the basics of programming so I was looking for something that hopefully skips past the very basics. Secondly this program is going to require storing lots and lots of data. That means I'll need some kind of database. And to be honest I've gotten quite confused with all this ADO SQL Access ODBE etc. type language. I don't need any kind of client/server configuration just a way to easily access and manipulate a large amount of data stored on the local drive. So what is the best database interface (?) to use for maximum efficiency in this situation. And if necessary a recommended book on the subject is also a plus. :) Thanks a ton.

malice_ryan · Answer

Define complex. The data setup is basically going to be in a user:lots of data type format. There will be many users on the order of thousands. The data will mostly be sets of strings potentially 1-2000 sets. It will be updated frequently but only a few users at a time (5-20). So I basically need something that will be able to locate a user entry quickly. I suppose a text file would work I'm not sure how efficient it is though.

shimtanny · Answer

Hi Better use OleDb classes for ms access. Simon

abdullah · Answer

Hi ....... if your data isnt complex use a text file to store them.....so that you can manipulate the data easily........ if the data is complex and ur project is not web-based project so use Access since its easer in managment.... Here what you need for the Access : using System.Data.Odbc; // To Excute the SQL Queries.... public static void ExeData(string q) { string conString = Driver={Microsoft Access Driver (*.mdb)};DBQ=db1.mdb; OdbcConnection dbConn = new OdbcConnection(conString); dbConn.Open(); try { string sqlString = q ; OdbcCommand sqlCommand = new OdbcCommand(sqlString dbConn); sqlCommand.ExecuteNonQuery(); } catch (Exception e) { Console.WriteLine(Oooops. I did it again:
{0} e.Message); } dbConn.Close(); } } I have some E-book in .net and C# programing so if ur intersted send me Email at abdullah02@gmail.com >>>>> so i can send them to you.... Good luck......