give me a suggestion
-
-
There's no way to answer that question because you haven't said anything about what you're doing. There are various methods to access data in a database. What you're doing with the data and your business requirements have a far more direct impact on how you access the data than what you're using.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak -
The first thing I can suggest to you is to read up on the different Areas of database communication. Personally I prefer the second technology but I have put it here for you to read upon TableAdapters[^] ADO.NET[^] Until you have a understanding of these I wouldn't yet approach LinQ or Entity Frameworks, that just my 2 cents on learning database communication.
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
-
There's no way to answer that question because you haven't said anything about what you're doing. There are various methods to access data in a database. What you're doing with the data and your business requirements have a far more direct impact on how you access the data than what you're using.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak -
the database contains about 25-30 tables .Each table has 5-15 columns.i want to do normal operations with a database : edit data , update , delete , add... etc.And i need to create reports with different data on database.
Again...that's what you have, not what you're doing. For example, if you're going to do some kind of processing on, say, 10000 records, you're not going to use a DataTable for this. You'll probably going to use a DataReader. Now, if you're going to bind a control to a couple of dozen records just to show them, you'd probably use a DataTable or DataSet and not a DataReader. What method works best for each situation is dictated by precising what you're doing, not what you have.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak -
Without knowing the details of the project, I can't answer exactly, but... We actually abstracted the SQL interface for our in-house software, so we don't often need to actually deal directly with the SQL server, we just write the commands and then get a result. I suggest you try something like this if you don't use datasets. It'll make your life alot easier writing and maintaining the code. If you have any queries you call frequenty, I would also suggest that you sent them up with their own functions to automatically create the SQL command. Again, it'll make maintainance much easier.
-
Again...that's what you have, not what you're doing. For example, if you're going to do some kind of processing on, say, 10000 records, you're not going to use a DataTable for this. You'll probably going to use a DataReader. Now, if you're going to bind a control to a couple of dozen records just to show them, you'd probably use a DataTable or DataSet and not a DataReader. What method works best for each situation is dictated by precising what you're doing, not what you have.
A guide to posting questions on CodeProject[^]
Dave KreskowiakThank you , for your suggestions. But , i make more simple my question : i'm a beginner on working with vb.net + sql server. Until today , i have developped several application in MS Access (backend + frontend). But now i want to make something in vb.net+ sql server. Someone suggest to use typed dataset because is more easy for begginners and is similar with the way i have worked in ms access.( it's easy to create forms with bounded controls , it's more easy to create reports....) Is this true ? thank you.
-
Thank you , for your suggestions. But , i make more simple my question : i'm a beginner on working with vb.net + sql server. Until today , i have developped several application in MS Access (backend + frontend). But now i want to make something in vb.net+ sql server. Someone suggest to use typed dataset because is more easy for begginners and is similar with the way i have worked in ms access.( it's easy to create forms with bounded controls , it's more easy to create reports....) Is this true ? thank you.
It could be. You don't konw until you try.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak -
I suggest you to try all types of communication while you are a beginner. When you'll start professional programming then you can decide what is best for your program. I telling you to see another tools (Entity Framework) to manipulate database http://www.microsoft.com/download/en/details.aspx?id=18504[^] Good luck.