图书管理数据删除部份

最新推荐文章于 2024-08-06 14:38:09 发布

stevenjin

最新推荐文章于 2024-08-06 14:38:09 发布

阅读量528

点赞数

分类专栏： ASP.NET编程文章标签： object string security insert sql class

本文链接：https://blog.csdn.net/stevenjin/article/details/2534181

版权

ASP.NET编程专栏收录该内容

12 篇文章 0 订阅

订阅专栏

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class AddInfor : System.Web.UI.Page
{
    static string strconn = "Data Source=localhost;database=BOOKS;integrated security=SSPI";
    SqlConnection conn = new SqlConnection(strconn);
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            ShowData();
        }
    }
    private void ShowData()
            {
                string SQL = "SELECT * FROM BOOKSTORAGE";
                SqlCommand cmd = conn.CreateCommand();
                cmd.CommandText = SQL;
                conn.Open();
                GVInsert.DataSource=cmd.ExecuteReader();
                GVInsert.DataBind();
                conn.Close();
            }
    protected void OK_Click(object sender, EventArgs e)
    {

        string sqlInsert = "INSERT INTO BOOKSTORAGE(bk_name,bk_author,price,bk_content)" +
            "VALUES(@书名,@作者,@price,@bk_content)";
        SqlCommand insertCmd;
        insertCmd = conn.CreateCommand();
        conn.Open();
        insertCmd.CommandText = sqlInsert;
        insertCmd.Parameters.Add("@书名", SqlDbType.VarChar, 40);
        insertCmd.Parameters.Add("@作者", SqlDbType.VarChar, 40);
        insertCmd.Parameters.Add("@price", SqlDbType.Decimal, 20);
        insertCmd.Parameters.Add("@bk_content", SqlDbType.VarChar, 40);

        insertCmd.Parameters["@书名"].Value = TexBoxbk_name.Text;
        insertCmd.Parameters["@作者"].Value = TextBoxbk_author.Text;
        insertCmd.Parameters["@price"].Value = TextBoxprice.Text;
        insertCmd.Parameters["@bk_content"].Value = TextBoxbk_content.Text;

        insertCmd.ExecuteNonQuery();
        conn.Close();
        ShowData();
    }
    protected void btnReturn_Click(object sender, EventArgs e)
    {
        ShowData();
        Response.Redirect("Manager.aspx");
    }
}