using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
namespace demo3
{
public partial class insertDeleteUpdateTable : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnInsert_Click(object sender, EventArgs e)
{
//1连接字符串
string constr = "data source=.;initial catalog=School;User ID=sa;Password=842674";
//2创建连接对象
using (SqlConnection con = new SqlConnection(constr))
{
//con.ConnectionString = constr;
//打开连接
con.Open();
//拼接sql语句
string sql = string.Format("insert into class3(cname,cdesc) values('{0}','{1}')", txtClassName.Text.Trim(), txtClassDesc.Text.Trim());
//3创建命令对象
using (SqlCommand cmd = new SqlCommand(sql, con))
{
//cmd.Connection = con;
//cmd.CommandText = sql;
int r = cmd.ExecuteNonQuery();//执行insert,delete ,update正合适
//它的返回值就是执行命令后影响数据表中记录的条数。(正整数0---n)
this.Response.Write("插入"+r+"行");
}
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
//1连接字符串
string constr = "data source=.;initial catalog=School;User ID=sa;Password=842674";
//2创建连接对象
using (SqlConnection con = new SqlConnection(constr))
{
//con.ConnectionString = constr;
//打开连接
con.Open();
//拼接sql语句
string sql = string.Format("delete from class3 where id={0}", txtId.Text.Trim());
//3创建命令对象
using (SqlCommand cmd = new SqlCommand(sql, con))
{
//cmd.Connection = con;
//cmd.CommandText = sql;
int t = cmd.ExecuteNonQuery();//执行insert,delete ,update正合适
//它的返回值就是执行命令后影响数据表中记录的条数。(正整数0---n)
this.Response.Write("删除" + t + "行。");
}
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
//1连接字符串
string constr = "data source=.;initial catalog=School;User ID=sa;Password=842674";
//2创建连接对象
using (SqlConnection con = new SqlConnection(constr))
{
//con.ConnectionString = constr;
//打开连接
//拼接sql语句
string sql = string.Format("update class3 set cname='{0}',cdesc='{1}' where id={2}", txtUpdateCname.Text.Trim(), txtUpdateCdesc.Text.Trim(), txtUpdateId.Text.Trim());
//3创建命令对象
using (SqlCommand cmd = new SqlCommand(sql, con))
{
//cmd.Connection = con;
//cmd.CommandText = sql;
con.Open();//
int t = cmd.ExecuteNonQuery();//执行insert,delete ,update正合适
//它的返回值就是执行命令后影响数据表中记录的条数。(正整数0---n)
this.Response.Write("修改了" + t + "行。");
}
}
}
}
}