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."); } }