Beispiel #1
0
        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());
        }
Beispiel #2
0
        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!!!!!!!!!!!!!!!!";
            }
        }
Beispiel #3
0
        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.");

            }
        }