ADO.NET

                SqlConnection sqlCon = new SqlConnection(connectionString);
                SqlCommand sqlCmd = new SqlCommand(sql, sqlCon);
                SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd);
                DataSet ds= new DataSet();
                sqlDa.Fill(ds);