C#網(wǎng)站開發(fā)基礎(chǔ)之增刪改查.docx

基于c#的增刪改查創(chuàng)建空的A空的應(yīng)用程序，右鍵創(chuàng)建一個新類 命名SqlHelper這是SqlHelper.cs中的內(nèi)容：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.ConnectionStringsconnStr.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.Tables0;/用于查詢信息 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(); /用于修改，增加，刪除一條信息 在數(shù)據(jù)庫創(chuàng)建新的數(shù)據(jù)庫命名TestDB創(chuàng)建新的表：Person修改配置文件web.config下面是web.config中的內(nèi)容： 創(chuàng)建新的Web窗體：命名Person.aspx下面是前臺頁面的代碼： .style3 height: 10px; .style4 height: 10px; width: 18px; .style5 width: 18px; 姓?名?：o 年齡?：o 身份Y證：o 愛?好?：o 與他相對應(yīng)的后臺Person.aspx.cs下面是后臺代碼：using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data;using System.Data.SqlClient;using System.Configuration;namespace WebApp public partial class Person : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) /點擊查詢觸發(fā)的事件 protected void btn_Click(object sender, EventArgs e) string name = QueryName.Text; /調(diào)用SqlHelper中的方法 DataTable dt= SqlHelper.ExecuteDataTable(select *from Person where Name=Name , new SqlParameter(Name, name); /new SqlParameter(Age, Age), new SqlParameter(IdCard, IdCard), new SqlParameter(Hobby, Hobby); txtName.Text = dt.Rows0name.ToString(); txtAge.Text = dt.Rows0age.ToString(); txtIdCard.Text = dt.Rows0IdCard.ToString();/讓數(shù)據(jù)庫中的值顯示到前臺與之相對應(yīng)的文本框中 txtHobby.Text = dt.Rows0Hobby.ToString(); protected void btnDelete_Click(object sender, EventArgs e) string name = QueryName.Text; int s = SqlHelper.ExecuteNonQuery(delete from Person where Name=Name ,new SqlParameter(Name,name);/實現(xiàn)刪除功能 下面是增加功能的實現(xiàn)：創(chuàng)建新的web窗體PersonEdit.aspx下面是前臺頁面的代碼： .style1 width: 51px; 姓?名?：o 年齡?：o 身份Y證：o 愛?好?：o 在與之相對應(yīng)的后臺PersonEdit.aspx.cs中編寫如下代碼：using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data;using System.Data.SqlClient;namespace WebApp public partial class PersonEdit : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) protected void btnAdd_Click(object sender, EventArgs e) string name = Name.Text; string age = Age.Text; string idcard = IdCard.Text; string hobby = Hobby.Text; int num=SqlHelper.ExecuteNonQuery /調(diào)用sqlhelper中的方法 (Insert into Person(Name,Age,IdCard,Hobby) values(Name,Age,IdCard,Hobby), new SqlParameter(Name, name) , new SqlParameter(Age, age)