题：从学生管理数据库表中把我们班是汉族的男生查询出来


大神们，求留下代码~~
万分感谢！！！

1.连接数据库
2.把数据读到DataTable中
3.遍历DataTable表
        public static DataTable ExecuteDataTable(string sql, params SqlParameter[] parameters)
        {
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                     = sql;
                    cmd.Parameters.AddRange(parameters);

                    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                    DataSet dataset = new DataSet();
                    adapter.Fill(dataset);
                    return dataset.Tables[0];
                }
            }
        }

        private void button3_Click(object sender, RoutedEventArgs e)
        {
            DataTable table = SqlHelper.ExecuteDataTable("select * from T_Students where volk=@volk",
                new SqlParameter("@volk", "汉"));
            foreach (DataRow row in table.Rows)
            {
                string name = (string)row["Name"];
                MessageBox.Show(name);
            }
}

可以用一句select语句实现，参照教材或者帮助文件,用不着那么费劲的。

[此贴子已经被作者于2016-3-25 10:51编辑过]

好像这样就可以拉。。
select * from 学生管理数据库表 where rtrim(sex)='男' and rtrim(volk)='汉'