数据库连接

 string theConnectionString = "server=.;database=mydatabase;uid=sa;password=mydatabase;";
            try
            {
                SqlConnection theConnection = new SqlConnection(theConnectionString);
                theConnection.Open();
                if (theConnection.State==System.Data.ConnectionState.Open)
                {
                    //MessageBox.Show("Dadabase Connection is Open!");
                    label1.Text = "Dadabase Connection is Open!";
                }
                DataSet ds = new DataSet();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection =theConnection;
                cmd.CommandText = "select * from mytable";
                SqlDataAdapter sda = new SqlDataAdapter();
                sda.SelectCommand = cmd;
                sda.Fill(ds);
                theConnection.Close();
                DataTable dtbase = ds.Tables[0];
                dataGridView1.DataSource = dtbase;
            }
            catch (SqlException sql)
            {

                MessageBox.Show(sql.Message);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }