C网站开发基础之增删改查.docx

基于c#的增删改查创建空的A空的应用程序，右键创建一个新类 命名SqlHelper这是SqlHelper.cs中的内容：using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Configuration;using System.Data;using System.Data.SqlClient;namespace WebApp{ class SqlHelper { private static string connStr = ConfigurationManager.ConnectionStrings[connStr].ConnectionString; public static object ExecuteScalar(string Sql, params SqlParameter[] parameters) { using (SqlConnection conn = new SqlConnection(connStr)) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = Sql; cmd.Parameters.AddRange(parameters); return cmd.ExecuteScalar(); } } } public static DataTable ExecuteDataTable(string Sql, params SqlParameter[] parameters) { using (SqlConnection conn = new SqlConnection(connStr)) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = Sql; cmd.Parameters.AddRange(parameters); DataSet dataset = new DataSet(); SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.Fill(dataset); return dataset.Tables[0];//用于查询信息 } } } public static int ExecuteNonQuery(string Sql, params SqlParameter[] parameters) { using (SqlConnection conn = new SqlConnection(connStr)) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = Sql; cmd.Parameters.AddRange(parameters); return cmd.ExecuteNonQuery(); }//用于修改，增加，删除一条信息 } } }}在数据库创建新的数据库命名TestDB创建新的表：Person修改配置文件web.config下面是web.config中的内容：?xml version=1.0 encoding=utf-8?!-- 有?D关?如¨?何?配?置? ASP.NET 应?|用??程¨?序¨°的ì?详¨o细?消?息?é，ê?请?访¤?问¨o /fwlink/?LinkId=169433 --configuration system.web compilation debug=true targetFramework=4.0 / /system.webconnectionStringsadd name=connStr connectionString=Data Source=.;Initial Catalog=TestDB;User Id=sa;Password=123;//connectionStrings/configuration创建新的Web窗体：命名Person.aspx下面是前台页面的代码：%@ Page Language=C# AutoEventWireup=true CodeBehind=Person.aspx.cs Inherits=WebApp.Person %!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN /TR/xhtml1/DTD/xhtml1-transiti