C# ExecuteNonQuery用法
using System; using System.Data; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace UseExecuteNonQuery { public partial class Form1 : Form { public Form1() { InitializeComponent(); } SqlConnection conn; private void button1_Click(object sender, EventArgs e) { conn = new SqlConnection("server=.;database=db_12;uid=sa;pwd=sa"); conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = "update tb_command set 奖金=503 where 性别='女'"; cmd.CommandType = CommandType.Text; int i = Convert.ToInt32(cmd.ExecuteNonQuery());//返回受影响的函数 label2.Text = "共有" + i.ToString() + "名女员工获得奖金"; } } }
posted on 2017-09-18 16:08 stringAdmin 阅读(3550) 评论(0) 编辑 收藏 举报