Solved

Ms Jet Database

Posted on 2004-09-18
1
167 Views
Last Modified: 2010-04-23
Does the call to DataSet11.Clear() clears the dataset by removing all rows in all tables, but does it remove the rows in the database?
 

Public Class Form1
    Inherits System.Windows.Forms.Form

    Private cmd As System.Data.OleDb.OleDbCommand

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        OleDbDataAdapter1.Fill(DataSet11)
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        cmd = New System.Data.OleDb.OleDbCommand("SELECT * FROM tblStudents where Name = 'Fred'")
        cmd.CommandType = CommandType.Text
        cmd.Connection() = OleDbConnection1

     'Clear the dataset
         'DataSet11.Clear()

        OleDbDataAdapter1.SelectCommand = cmd

        'Call fill again
             OleDbDataAdapter1.Fill(DataSet11)

    End Sub
End Class
0
Comment
Question by:gbilios
1 Comment
 
LVL 96

Accepted Solution

by:
Bob Learned earned 50 total points
ID: 12102903
No, the dataset is an in-memory representation of the data in the database.

Bob
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now