Creating a database in C#
-
Please excuse me if im way off here, but I will try to communicate my goals well. I have taken 1 class in C# and I am super green at it. I am attempting to create a database that several people in the US would have access to. We tried MS Access, but as you know it is a bit slow. I would like to create something a little faster. Im not only doing it to help myself and coworkers, but for the learning experience also. To put it simply, the database I have in mind would simply consist of a form where we could enter information in several fields, and be able to retrieve it later... thats what a database is. My goal is to have the program access a simple txt file stored on a local drive that the program would access to get the information. I say a txt file, because this is all I was taught, and it was very basic. It was also stored on the local PC so the path name was simple. Are there any suggestion to where I should start. Any good books, or source code I could get and manipulate. Thanks for your time.
-
Please excuse me if im way off here, but I will try to communicate my goals well. I have taken 1 class in C# and I am super green at it. I am attempting to create a database that several people in the US would have access to. We tried MS Access, but as you know it is a bit slow. I would like to create something a little faster. Im not only doing it to help myself and coworkers, but for the learning experience also. To put it simply, the database I have in mind would simply consist of a form where we could enter information in several fields, and be able to retrieve it later... thats what a database is. My goal is to have the program access a simple txt file stored on a local drive that the program would access to get the information. I say a txt file, because this is all I was taught, and it was very basic. It was also stored on the local PC so the path name was simple. Are there any suggestion to where I should start. Any good books, or source code I could get and manipulate. Thanks for your time.
If it was me, I would use MySQL instead of a text file. It is free and open source (not that you would make changes to the underlying database engine) and there are plenty of administrative tools that are easy to use. Load the engine, create your tables and go. On the C# side just create a dataset that reflects your database, populate the dataset at runtime, bind your dataset to your webform or windows form and enjoy the hours the microsoft people put in to make your life easy. As far as references, I went to half price books and got an ADO.NET book, that is your best bet.
-
Please excuse me if im way off here, but I will try to communicate my goals well. I have taken 1 class in C# and I am super green at it. I am attempting to create a database that several people in the US would have access to. We tried MS Access, but as you know it is a bit slow. I would like to create something a little faster. Im not only doing it to help myself and coworkers, but for the learning experience also. To put it simply, the database I have in mind would simply consist of a form where we could enter information in several fields, and be able to retrieve it later... thats what a database is. My goal is to have the program access a simple txt file stored on a local drive that the program would access to get the information. I say a txt file, because this is all I was taught, and it was very basic. It was also stored on the local PC so the path name was simple. Are there any suggestion to where I should start. Any good books, or source code I could get and manipulate. Thanks for your time.
Use SQL Server Express or MSDE. They are free, and unlike MySQL they are free for commercial use, and they are not crap. Plus there is tons of info on the web on how to use them ( any info on connecting to SQL Server will work ). Christian Graus - Microsoft MVP - C++
-
Use SQL Server Express or MSDE. They are free, and unlike MySQL they are free for commercial use, and they are not crap. Plus there is tons of info on the web on how to use them ( any info on connecting to SQL Server will work ). Christian Graus - Microsoft MVP - C++
Im a bigtime newb, so I have a few questions. Will either one of these software packages provide me with the tools I need to create an interface with user, so they can add and retrieve data from the database. And a simple way to create a place to store the data. I know Im asking a lot here, I think I need to get some documentation. Any good sites?
-
Im a bigtime newb, so I have a few questions. Will either one of these software packages provide me with the tools I need to create an interface with user, so they can add and retrieve data from the database. And a simple way to create a place to store the data. I know Im asking a lot here, I think I need to get some documentation. Any good sites?
frankie123 wrote:
Will either one of these software packages provide me with the tools I need to create an interface with user, so they can add and retrieve data from the database.
No. You're asking in the C# forum, and you can use C# to build an interface. If you want everything done for you in a WYSIWYG fashion, then Access is definately the answer. If you were going to read a flat text file in code, then MSDE is a far better solution. Christian Graus - Microsoft MVP - C++