通过SqlCommand对象执行SQL语句的方法

1.public override int ExecuteNonQuery();对连接执行 Transact-SQL 语句并返回受影响的行数。

点击查看代码

        private void button1_Click(object sender, EventArgs e)
        {
            conn = new SqlConnection("server=XIAOKE\\XIAOKE;database=db_CSharp;uid=sa;pwd=");
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = "update tb_command set 奖金=50 where 性别='女'";
            cmd.CommandType = CommandType.Text;
            int i = Convert.ToInt32(cmd.ExecuteNonQuery());
            label2.Text = "共有" + i.ToString() + "名女员工获得奖金";
        }

2.public SqlDataReader ExecuteReader();执行SQL语句，并生成一个包含数据的SqlDataReader对象的实例

点击查看代码

        private void button1_Click(object sender, EventArgs e)
        {
            conn = new SqlConnection("server=XIAOKE\\XIAOKE;database=db_CSharp;uid=sa;pwd=");
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = "select * from tb_command";
            cmd.CommandType = CommandType.Text;
            SqlDataReader sdr = cmd.ExecuteReader();
            while (sdr.Read())
            {
                listView1.Items.Add(sdr[1].ToString());
            }
            conn.Dispose();
            button1.Enabled = false;
        }