locked
newbie question RRS feed

  • Question

  • I hope I'm in the right spot, I am working on a project with an Access database and VS2010, the database has a few columns with date or number ranges, How do I set the application to read a set of ranges.  the project is an inventory of film, I need to be able to enter some information on the form and when I or the end user clicks on "OK" or hits enter the program will display where a particular roll of film is in a cabinet.  There are a couple of comboboxes and a few textboxes on the form. I want to be able to enter the Title, ISSN, date, volume, and issue and the program show me in other textboxes the cabinet, drawer, column and row where a particular roll of film is.

    Can anyone help??

    I will be more than happy to send code snippets or screen shots of what I am doing if it well help.

    • Moved by Amanda Zhu Tuesday, February 19, 2013 6:08 AM off-topic issue
    Wednesday, February 13, 2013 6:44 PM

All replies

  • Hello Ac5pw,

    Thank you for your post.

    What type of application is your application? WPF app? Windows Forms app?

    Best regards,


    Amanda Zhu [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Friday, February 15, 2013 7:50 AM
  • Hi,

    a quick overview to get you started. (Just use some keywords in google together with "tutorial" or "introduction" to get more information! Or ask for more details if you need help finding some good tutorials or introductions.)

    The part of the .Net Framework which is repsonsible for data access is called ADO.Net. It includes a wide range of classes including:
    - Core database access. The core classes are DbConnection and DbCommand (or better - derived from these)
    - DataSet/DataTable - these classes provide an offline storage of data. Together with DataAdapters you can easily read data to these classes and write changes back.
    - enhanced things like EntityFramework, Linq, ... feek free to read about that but I would concentrate on the other stuff first.

    To acces an access database, the classes you should look up are OleDbConnection and OleDbCommand:
    http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbconnection.aspx
    http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbcommand.aspx

    The description of the classes provide examples, but it might be hard to get a working connection string. The following url might be usefull:
    http://www.connectionstrings.com/access

    With this you can do a first start and do SQL Commands on your access database. If you do not know SQL so far, then you should read some SQL tutorial.

    If you got that working, you could check out the second technology: Read data into a DataSet, change it there and then write it back. The big advantage is, that you can easily bind controls to data inside a DataSet or DataTable so you need almost no code for the UI stuff. (So the user can change existing data, add new data or delete records. All that is required is something like a save button that writes changes to the database (which can be easily done with the adapter, too).

    But that 2nd step is really the 2nd step. Start with the other stuff first (which is also required when using data adapters/tables/sets.

    With kind regards,

    Konrad

    Friday, February 15, 2013 8:07 AM