AddBook.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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;

public partial class AddBook : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Request["no"] == null)
            {
                txtno.Visible = false;
                lbno.Visible = false;
                btnAdd.Enabled = true;
                txtbeijie.Visible = DropDownList1.Visible=lbbeijie.Visible=lbzhuangtai.Visible = false;
            }
            else
            {
                string str = "";
                //int i=Convert.ToInt32( Request["no"]);
                btnSave.Enabled = true;
                SqlConnection con = DB.con();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = con;
                con.Open();
                cmd.CommandText = "select * from book where no='" + Request["no"] + "'";
                SqlDataReader sqldatareader = cmd.ExecuteReader();
                while (sqldatareader.Read())
                {
                    txtno.Text = sqldatareader["no"].ToString();
                    txtnumber.Text = sqldatareader["number"].ToString();
                    txtname.Text = sqldatareader["name"].ToString();
                    txtwriter.Text = sqldatareader["writer"].ToString();
                    txtaddress.Text = sqldatareader["address"].ToString();
                    str = sqldatareader["zhuangtai"].ToString();
                    txtbeijie.Text = sqldatareader["beijie"].ToString();
                    //DropDownList1.SelectedValue = str;
                    if (str == "是")
                    {
                        DropDownList1.SelectedValue = "是";
                    }
                    else
                    {
                        DropDownList1.SelectedValue = "否";
                    }
                }
            }
        }
    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        if (txtnumber.Text != "" && txtname.Text != "")
        {
            lbname.Text = lbnumber.Text = "";