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

malice_ryan

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.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

malice_ryan21y ago
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-2,000 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.
0
shimtanny21y ago
Hi Better use OleDb classes for ms access. Simon
0
abdullah21y ago
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:\n{0}", e.Message); } dbConn.Close(); } } I have some E-book in .net and C# programing so if ur intersted send me Email at [email protected] >>>>> so i can send them to you.... Good luck......
0