使用ExecuteNonQuery（）操作数据

函数ExecuteNonQuery（）可以对数据库执行更新，插入，删除操作，并返回操作影响的行数，若执行语句不是SQL语句，则返回-1，应用实例如下：

配置文件信息：

  <connectionStrings>
    <add name ="SQLCONNECTIONSTRING" connectionString =" data Source = localhost;database = hrmbook;user id = sa;pwd = sa" providerName = "System.Data.SqlClient"></add>
  </connectionStrings>

程序代码如下：

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class DataQuery : System.Web.UI.Page
{
    private string myConnectionString = ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            TestDataQuery();
            Response.End();
        }
    }
    private void TestDataQuery()
    {
        //创建SqlConnection
        SqlConnection myConnection = new SqlConnection(myConnectionString);
        string cmdText = "INSERT INTO 职员基本信息表(内部编号,职员编号,姓名,性别) VALUES(80,'sr8888','newUser','男')";
        SqlCommand myCommand = new SqlCommand(cmdText, myConnection);
        SqlDataReader mydr;
        string drcmdText = "SELECT TOP 5 * FROM 职员基本信息表 ORDER BY 内部编号 DESC";
        try
        {
            //打开数据库链接
            myConnection.Open();
            //插入数据
            int nCount = myCommand.ExecuteNonQuery();
            Response.Write("插入" + nCount.ToString() + "条新记录.<br>");
            //显示数据
            myCommand.CommandText = drcmdText;
            mydr = myCommand.ExecuteReader();
            PrintData(mydr);
            //修改数据
            cmdText = "UPDATE 职员基本信息表 SET 性别 = '女' WHERE 内部编号 = 80";
            myCommand.CommandText = cmdText;
            myCommand.ExecuteNonQuery();
            Response.Write("修改" + nCount.ToString() + "条新记录.<br>");
            myCommand.CommandText = drcmdText;
            mydr = myCommand.ExecuteReader();
            PrintData(mydr);
            //删除数据
            cmdText = "DELETE 职员基本信息表 WHERE 内部编号 = 80";
            myCommand.CommandText = cmdText;
            myCommand.ExecuteNonQuery();
            Response.Write("删除" + nCount.ToString() + "条新记录.<br>");
            //显示数据
            myCommand.CommandText = drcmdText;
            mydr = myCommand.ExecuteReader();
            PrintData(mydr);
        }
        catch (SqlException sqlex)
        {
            Response.Write(sqlex.Message + "<br>");
        }
        finally
        {
            myConnection.Close();
        }
    }
    private void PrintData(SqlDataReader mydr)
    {
        while (mydr.Read())
        {
            //向列表中添加Item项
            Response.Write(mydr["姓名"]  + "----" +
            //读取姓名
            mydr["性别"] + "<br>");
        }
        mydr.Close();
    }
}