基于c#的增刪改查創(chuàng)建空的Asp.net 空的應(yīng)用程序，右鍵創(chuàng)建一個(gè)新類 命名SqlHelper這是SqlHelper.cs 中的內(nèi)容：using System;using System.Col

基于c#的增刪改查

創(chuàng)建空的Asp.net 空的應(yīng)用程序，右鍵創(chuàng)建一個(gè)新類 命名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 .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();

}//用于修改，增加，刪除一條信息

}

}

}

}

在數(shù)據(jù)庫創(chuàng)建新的數(shù)據(jù)庫命名TestDB

創(chuàng)建新的表：Person

修改配置文件web.config

下面是web.config 中的內(nèi)容：

創(chuàng)建新的Web 窗體：

命名Person.aspx

下面是前臺(tái)頁面的代碼：

<@ Page Language ="C#" AutoEventWireup ="true"

CodeBehind ="Person.aspx.cs" Inherits ="WebApp.Person" >

與他相對(duì)應(yīng)的后臺(tái)Person.aspx.cs

下面是后臺(tái)代碼：

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)

{

}

//點(diǎn)擊查詢觸發(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.Rows[0]["name" ].ToString();

txtAge.Text = dt.Rows[0]["age" ].ToString();

txtIdCard.Text = dt.Rows[0]["IdCard" ].ToString();//讓數(shù)據(jù)庫中的值顯示到前臺(tái)與之相對(duì)應(yīng)的文本框中

txtHobby.Text = dt.Rows[0]["Hobby" ].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));//實(shí)現(xiàn)刪除功能 }

}

}

下面是增加功能的實(shí)現(xiàn)：

創(chuàng)建新的web 窗體PersonEdit.aspx 下面是前臺(tái)頁面的代碼：

<@ Page Language ="C#" AutoEventWireup ="true"

CodeBehind ="PersonEdit.aspx.cs" Inherits ="WebApp.PersonEdit" >

在與之相對(duì)應(yīng)的后臺(tái)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)

, new SqlParameter ("@IdCard", idcard)

, new SqlParameter ("@Hobby", hobby));//實(shí)現(xiàn)增加的功能

//Response.Redirect("PersonEdit.aspx");

}

protected void btnUpdate_Click(object sender, EventArgs e) {

}

}

}