using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;


namespace WFA_CREATE_DELETE
{
    
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        OleDbConnection con = new OleDbConnection(@"PROVIDER=Microsoft.ACE.OLEDB.12.0; Data Source=C:/Users/Dinesh/Documents/Database3.accdb");
        OleDbDataAdapter ea = new OleDbDataAdapter();
        DataSet dsl;
        DataSet esl;

        private void Form1_Load(object sender, EventArgs e)
        {


        
            OleDbDataAdapter da = new OleDbDataAdapter();


            


           //bool set = false;
            dsl = new DataSet();
            
            
           
           // string sql = "CREATE TABLE apparel(item_code int,item_price int,item_name text,item_size text)";
             
            //string vsql = "SELECT MSysObjects.Type, MSysObjects.Flags, MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Type)=1) AND ((MSysObjects.Flags)=0));";
        
            
             //  da = new System.Data.OleDb.OleDbDataAdapter(sql, con);
               
            
           // OleDbCommand cmdda = new OleDbCommand(sql, con);
           // OleDbCommand cmdea = new OleDbCommand(vsql, con);
            
            con.Open();

            DataTable table2 = con.GetSchema("tables");
    
            //cmdda.ExecuteNonQuery();
           // cmdea.ExecuteNonQuery();

            MessageBox.Show("Database Open");
            //da.Fill(dsl, "clothes");
            //ea.Fill(esl, "clothes1");
            
          
           // dataGridView1.DataSource = esl.Tables["clothes1"];
            
            dataGridView1.DataSource = table2;
            
            con.Close();
            con.Dispose();


        }

        public void Tabledel()
        {
            int a = 0, d = 0, count, itr;

            count = dataGridView1.RowCount;
            itr = dataGridView1.ColumnCount;

            while (a < count)
            {
                for (d = 0; d < itr; d++)
                {
                    if (dataGridView1.Rows[a].Cells[d].Value.ToString() == textBox1.Text)
                    {

                        MessageBox.Show("table exists");
                        esl = new DataSet();
                        string vsql = "drop table '" + textBox1.Text + "'";
                        ea = new System.Data.OleDb.OleDbDataAdapter(vsql, con);
                        OleDbCommand cmdea = new OleDbCommand(vsql, con);
                        //cmdea.Connection = con;

                        con.Open();
                        cmdea.ExecuteNonQuery();
                        MessageBox.Show("table dropped");



                        con.Close();
                        con.Dispose();
                    }
                }

                a++;
            }
        }


       

       
        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        public void button1_Click(object sender, EventArgs e)
        {
           Tabledel();
            
       
        }

    }
}