using (SqlConnection conn = new SqlConnection(connectionString) )
{
conn.Open();
SqlCommand cmd = new SqlCommand("select * from tb where 1=1", conn);
SqlDataAdapter adapter = new SqlDataAdapter(cmd );
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
}