1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:

public static DataTable OpenQuery(string connectionString, string query)
{
    DataTable dt = new DataTable();
    using (SqlConnection con = new SqlConnection(connectionString))
    {
        con.Open(); 
        using (SqlDataAdapter da = new SqlDataAdapter(query, conn))
        {            
            da.Fill(dt );
        }
    }
    return dt;
}					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:

private void button1_Click(object sender, EventArgs e)
        {
            string ConnectionString = "Server=" + "" + ";Database=myDataBase;Trusted_Connection=True;";
            string Query = "";
            OpenQuery(ConnectionString, Query);
        }

        public static DataTable OpenQuery(string connectionString, string query)
        {
            DataTable dt = new DataTable();
            using (SqlConnection con = new SqlConnection(connectionString))
            {
                con.Open();
                using (SqlDataAdapter da = new SqlDataAdapter(query, con))
                {
                    da.Fill(dt);
                }
            }
            return dt;
        }