locked
ASP .NET (Visual Basic) DATABASE HELP RRS feed

  • Question

  • What is the easiest way to access the MS Access database like adding a value to a specied colume and row , checking how hany rows in a table,etc ? 
    Vignesh
    Thursday, March 17, 2011 4:01 AM

Answers

  • Hi,

    first of all I want to point you to other forums where you find more experts:

    a) http://asp.net also has a lot of forums covering ASP.Net.
    b) There are Visual Basic and Visual Basic Express forums on MSDN:
    - http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/threads (VB General)
    - http://social.msdn.microsoft.com/Forums/en-US/Vsexpressvb/threads (VB Express)

    In general, I would use the ADO.Net Framework for such access. ADO.Net offers the classes OleDBConnection / OleDBCommand / ...  which work exactly as all these database connection classes so you can normaly copy code accessing other databases and just replace the used namespace and the used classes (e.g. replace the Sql to OleDb).

    ADO.Net also offers much more e.g. the entity framework where you can let Visual Studio generate you a full set of classes to access the database or create, delete or modify entities and so on ...

    I hope this helped a little.

    With kind regards,

    Konrad

    • Marked as answer by Rubel Khan Thursday, March 31, 2011 2:07 AM
    Thursday, March 17, 2011 5:57 AM
    Answerer