none
VB.Net 2010 Data Usage RRS feed

  • Question

  • I am brand new to .NET and really need to learn how to manipulate data from Access using .NET. I have looked over varied forums and though books but just do not seem to be able to make the connection. I currently have a connection to an Access DB in .NET and a completely blank form. What I want to be able to do is when the form loads I want to delete all the data in one of the tables in Access.

    The data base name is CorpAlliance

    The table name is BatchRecord

    I did create a SQL Delete routine in "TableAdapter Query Configuration Wizard" But I do not know how to execute it.

    Thanks in advance for the help.

     

     

    Tuesday, March 8, 2011 9:55 PM

Answers

  • Hi PCENGRAVER;
    To execute the query use the form TableAdapterName.SqlQueryName(ParametersHere); See this link TableAdapter Overview

    Fernando 
    If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".
    Wednesday, March 9, 2011 2:42 PM