Esempio n. 1
0
        public main(login my_login)
        {
            InitializeComponent();
            writetimu(i, i + 1, i + 2, i + 3, i + 4, i + 5);
            label2.Text  = "1";
            this.mylogin = my_login;
            xuehao       = mylogin.getxuehao();
            SqlConnection conn1 = new SqlConnection(_connectionString);

            conn1.Open();

            string        strSqlq1 = "select * from student where 学号 = '" + xuehao + "'";
            SqlCommand    cmd1     = new SqlCommand(strSqlq1, conn1);
            SqlDataReader dr1      = cmd1.ExecuteReader();

            if (dr1.Read())
            {
                xingming.Text = dr1["姓名"].ToString();
            }
            dr1.Close();
            cmd1.ExecuteNonQuery();

            String        deletescore = "delete from score";
            SqlCommand    cmd2        = new SqlCommand(deletescore, conn1);
            SqlDataReader dr2         = cmd2.ExecuteReader();

            dr2.Close();
            cmd2.ExecuteNonQuery();
        }
Esempio n. 2
0
        public main(login my_login)
        {
            InitializeComponent();
            this.mylogin = my_login;
            xuehao       = mylogin.getxuehao();
            SqlConnection conn1 = new SqlConnection();

            conn1.ConnectionString = @"Server = localhost;Database=CLASSTEST;integrated security=true";
            conn1.Open();

            string        strSqlq1 = "select * from student where 学号 = '" + xuehao + "'";
            SqlCommand    cmd1     = new SqlCommand(strSqlq1, conn1);
            SqlDataReader dr1      = cmd1.ExecuteReader();

            if (dr1.Read())
            {
                xingming.Text = dr1["姓名"].ToString();
            }
        }