private void btnTestTableExists_Click(object sender, EventArgs e)
{
string tableName = "MyTable";
string cmdText = "select * from " + tableName;
// MySql Assumes
// Access DB Assumes c:/test.mdb exists and may or maynot have a table named "mytable"
// MYSQL CONNECTION
string MySqlConString = "SERVER=localhost;DATABASE=test;UID=test1;PASSWORD=testpass;";
MySqlConnection mysqlConn = new MySqlConnection(MySqlConString);
MySqlCommand mySqlCommand = mysqlConn.CreateCommand();
mySqlCommand.CommandText = cmdText;
MySqlDataAdapter mySqlAdapter = new MySqlDataAdapter(mySqlCommand.CommandText, mysqlConn);
// OLEDB CONNECTION
string oleConString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = " + @"c:/test.mdb" + ";";
OleDbConnection oleConn = new OleDbConnection(oleConString);
OleDbCommand oleCommand = new OleDbCommand(cmdText);
OleDbDataAdapter myOleAdapter = new OleDbDataAdapter(oleCommand.CommandText, oleConn);
// ACTUAL TESTING
bool mySqltableExist = Extensions_Data.Data_Extensions.TableExists(mysqlConn, "mytable777");
bool oleTableExist = Extensions_Data.Data_Extensions.TableExists(oleConn, "mytable777");
mySqltableExist = mySqlAdapter.TableExists("mytable");
oleTableExist = myOleAdapter.TableExists("mytable");
// scratch stuff
MessageBox.Show("hey, it worked (T/F): " + mySqltableExist.ToString());
}
private void btnReadDatabase_Click(object sender, EventArgs e)
{
if (INFOMODE) return;
if (radMysql.Checked)
{
consoleWrite("reading database from across the web!...");
MySqlConnection connection = new MySqlConnection(MyConString);
MySqlCommand command = connection.CreateCommand();
MySqlDataReader Reader;
command.CommandText = "select * from " + txtTable.Text;
MySqlDataAdapter myAdapter = new MySqlDataAdapter(command.CommandText, connection);
// check if txtTable.Text exists
bool tableExist = myAdapter.TableExists(txtTable.Text);
if (tableExist)
{
connection.Open();
myDataset = new DataSet();
myAdapter.Fill(myDataset, txtTable.Text);
bindingSource1.DataSource = myDataset.Tables[0];
dataGridView1.DataSource = bindingSource1;
consoleWrite("Download Successful");
//try
//{
// Reader = command.ExecuteReader();
// while (Reader.Read())
// {
// string thisrow = "";
// for (int i = 0; i < Reader.FieldCount; i++)
// thisrow += Reader.GetValue(i).ToString() + ",";
// listBox1.Items.Add(thisrow);
// }
//}
//catch (Exception exp)
//{
// consoleWrite("Error: " + exp.Message);
//}
connection.Close();
}
else if (!tableExist)
{
consoleWrite("Table does not exist.");
}
}
else
{
// Set textbox to say "reading..." for 2 seconds
consoleWrite("reading database table...");
// download the database's table into myDataset
myDataset = GetDataAccessDb(false);
if (myDataset == null) // if GetData should fail... it returns a null... if we have a null, we gotta stop this execution
return;
bindingSource1.DataSource = myDataset.Tables[0];
dataGridView1.DataSource = bindingSource1;
consoleWrite("DataBase table '" + txtTable.Text + "' is now visible in text dataGridView.");
textBox2.Text = "Now Showing the .mdb data!!!!!!!!!!!!!!!!";
}
}
private void CheckDbsTable()
{
string tableName = txtTable.Text;
// open .mdb
// check table
if (radAccess.Checked)
{
DataSet myDataset = GetDataAccessDb(true);
if (myDataset == null)
{
SetTableNotCorrect();
return;
}
if (myDataset.Tables.Count >= 1)
{
foreach (DataTable tbl in myDataset.Tables)
{
if (tbl.TableName == tableName)
{
chkTableName.Text = "Table: " + tbl.TableName + " Exists";
chkTableName.Checked = true;
}
else
{
SetTableNotCorrect();
}
}
}
}
else if (radMysql.Checked)
{
// check if table exists
consoleWrite("Checking if table exists...");
MySqlConnection connection = new MySqlConnection(MyConString);
MySqlCommand command = connection.CreateCommand();
command.CommandText = "select * from " + txtTable.Text;
MySqlDataAdapter myAdapter = new MySqlDataAdapter(command.CommandText, connection);
// check if txtTable.Text exists
bool tableExist = myAdapter.TableExists(txtTable.Text);
if (tableExist)
{
chkTableName.Text = "Table: " + txtTable.Text + " Exists";
chkTableName.Checked = true;
}
else
SetTableNotCorrect();
consoleWrite("Done.");
}
}
