R8cb66i0

1        public DataTable Select()
2        {
3            MySqlConnection conn = null;
4            DataTable dt = new DataTable();
5            try
6            {
7                conn = new MySqlConnection(connstring);
8                conn.Open();
9                string create_tb = "CREATE TABLE IF NOT EXISTS Contact(ID int NOT NULL PRIMARY KEY AUTO_INCREMENT, Nume varchar(255), Prenume varchar(255), NrTel varchar(255), Adresa text, Gen varchar(255));";
10                MySqlCommand cmd = new MySqlCommand(create_tb, conn);
11                cmd.ExecuteNonQuery();
12               // string drop = "DROP TABLE Contact";
13                //MySqlCommand cmd1 = new MySqlCommand(drop, conn);
14                //cmd1.ExecuteNonQuery();
15                string query = "SELECT * FROM Contact;";
16                MySqlDataAdapter da = new MySqlDataAdapter(query, conn);
17                DataSet ds = new DataSet();
18                da.Fill(ds, "Contact");
19                dt = ds.Tables["Contact"];
20            }
21            catch(Exception ex)
22            {
23                MessageBox.Show("Connection failed:"+ex);
24            }
25            finally
26            {
27                conn.Close();
28            }
29            return dt;
30        }