T-SQL语句实现GRIDVIEW的增删改查的实例练习
来源:互联网 发布:匡恩网络 圈钱公司 编辑:程序博客网 时间:2024/05/16 00:42
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;
namespace CommandExercise
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bind();
}
}
protected void btnAddStu_Click(object sender, EventArgs e) //增
{
string stuId = txtStuId.Text;
string stuname = txtStuName.Text;
string stuclass = txtStuClass.Text;
string strSql ="insert stuform values("+stuId+",'"+stuname+"','"+stuclass+"')";
string connectString = ConfigurationManager.ConnectionStrings["数据库连接"].ConnectionString;
SqlConnection con = new SqlConnection();
con.ConnectionString = connectString;
con.Open();
SqlCommand com = new SqlCommand(strSql, con);
int sum = com.ExecuteNonQuery();
if (sum > 0)
{
bind();
txtStuClass.Text = txtStuId.Text = txtStuName.Text = "";
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('添加失败!')</script>");
}
con.Close();
}
protected void bind()
{
string connectString = @"Data Source=GANG;Initial Catalog=stu;Persist Security Info=True;User ID=aspuser;password=000000";
string strSql = "select * from stuform";
SqlConnection con = new SqlConnection();
con.ConnectionString = connectString;
con.Open();
SqlCommand com = new SqlCommand(strSql, con);
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = com;
DataSet ds = new DataSet();
sda.Fill(ds);
con.Close();
gvShowStu.DataSource = ds;
gvShowStu.DataBind();
}
protected void btnDeleStu_Click(object sender, EventArgs e) //删
{
string stuid = txtDeleStuId.Text;
string strSql = "delete from stuform where StuID=" + stuid;
string connectString = ConfigurationManager.ConnectionStrings["数据库连接"].ConnectionString;
SqlConnection con = new SqlConnection();
con.ConnectionString = connectString;
con.Open();
SqlCommand com = new SqlCommand(strSql, con);
int sum = com.ExecuteNonQuery();
if (sum > 0)
{
bind();
txtDeleStuId.Text = "";
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('删除失败!')</script>");
}
con.Close();
}
protected void btnSearchStu_Click(object sender, EventArgs e) //查
{
string stuid = txtSearchStuID.Text;
string strSql = "select * from stuform where StuID=" + stuid;
string connectString = ConfigurationManager.ConnectionStrings["数据库连接"].ConnectionString;
SqlConnection con = new SqlConnection();
con.ConnectionString = connectString;
con.Open();
SqlCommand com = new SqlCommand(strSql,con);
SqlDataReader sdr = com.ExecuteReader();
sdr.Read();
lblName.Text = sdr["StuName"].ToString();
lblClass.Text = sdr["StuClass"].ToString();
con.Close();
sdr.Close();
}
protected void btnUpdateStu_Click(object sender, EventArgs e)//改
{
string strid = txtUpdateID.Text;
string strName = txtUpdateName.Text;
string strClass = txtUpdateClass.Text;
string strSql="update stuform set StuName='"+strName+"',StuClass='"+strClass+"'where StuID="+strid;
string connectString = ConfigurationManager.ConnectionStrings["数据库连接"].ConnectionString;
SqlConnection con = new SqlConnection();
con.ConnectionString = connectString;
con.Open();
SqlCommand com = new SqlCommand(strSql,con);
int sum = com.ExecuteNonQuery();
if (sum > 0)
{
bind();
txtUpdateClass.Text = txtUpdateID.Text = txtUpdateName.Text = "";
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('修改失败!')</script>");
}
con.Close();
}
}
}
- T-SQL语句实现GRIDVIEW的增删改查的实例练习
- T-SQL语句增删查改语句
- SQL server的增删改查练习
- Android SQL语句实现数据库的增删改查
- SQL语句的增删改查
- sql的增删改查语句
- SQL语句的增删改查
- 增删查改的sql语句
- SQL语句的增删改查
- 执行SQL语句的增删改查
- sql语句的增删改查
- Oracle实现数据增删改的sql语句实例
- GridView 的增删改查
- SSH实现的增删改查实例
- S1SH实现的增删改查实例
- SSH实现的增删改查实例
- SSH实现的增删改查实例
- hibernate 的sql语句以及hql语句增删改查
- php教程:经典PHP代码
- 《C++面向对象程序设计》第一次实验
- 手机病毒“僵尸网络”进入高发期
- 流水账
- 业内分析人士认为
- T-SQL语句实现GRIDVIEW的增删改查的实例练习
- 你的网站添加X-UA-Compatible meta标签了吗?
- Ruby语法解释:attr_reader,attr_writer和attr_accessor
- error LNK2001: unresolved external symbol _main解决办法
- 复杂事件处理和SOA,BI的联系
- 什么是类,什么是对象,类和对象之间的关系
- JavaScript创建简单购物车对象
- WEB IM URLs (Official Web sites)
- 用Qt中的QDomDocument类处理XML文件