Visual Basic

  Public Function selectAll(ByVal strSQL As String, ByVal tableName As String)<br />
        Dim dset As DataSet = New DataSet()<br />
        sqlite_cmd.CommandText = (strSQL)<br />
        sqlite_datareader = sqlite_cmd.ExecuteReader()<br />
<br />
        Dim sqlite_dataAdapter As SQLiteDataAdapter = New SQLiteDataAdapter(strSQL, sqlite_conn)<br />
        sqlite_commandBuilder = New SQLiteCommandBuilder(sqlite_dataAdapter)<br />
        sqlite_dataAdapter.Fill(dset, tableName)<br />
        Return dset<br />
    End Function

newbjohny wrote:

I have been taught this way at University so as not to crash out the program.

newbjohny wrote:

dset = dbConn.selectAll("SELECT * FROM " & tblName, tblName)

newbjohny wrote:

Private Sub cmbInsertData_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmbInsertData.SelectedIndexChanged

newbjohny wrote:

Public Function selectAll(ByVal strSQL As String, ByVal tableName As String)

newbjohny wrote:

I'm sorry but I do not know what a member variable is.

public class SomeClass
{
    // the following is a field
    private int someMemberVariable;
}