----------- Windows Phone 7手机开发、.Net培训、期待与您交流！ ------------

 

using (SqlConnection conn = new SqlConnection("Data Source=.; Initial Catalog=MyTest;User ID=sa;Password=123456"))             {                conn.Open();                using (SqlCommand cmd = conn.CreateCommand())                {                    cmd.CommandText = "select * from T_Student where Age<100";                    using (SqlDataReader reader = cmd.ExecuteReader())                    {                        while (reader.Read())                        {                           string name =  reader.GetString(1);                           int age = reader.GetInt32(2);                           MessageBox.Show(name + "," + age);                        }                    }                }            }