using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
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;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void BTQuery_Click(object sender, EventArgs e)
    {
        string connString;
        string bookID = TBbookID.Text;

        connString = "Initial Catalog=onlineBookstore;Data Source=(local);Integrated Security=SSPI;";
       
        using (SqlConnection Con = new SqlConnection(connString))
        {
            Con.Open();
            string sql = "select bookname,sellprice from bookinfo where bookID=@bookID";
            using (SqlCommand bookinfoCommand = new SqlCommand(sql, Con))
            {
                bookinfoCommand.Parameters.Add("@bookID", SqlDbType.VarChar, 25);
                bookinfoCommand.Parameters["@bookID"].Value = bookID;
                bookinfoCommand.CommandType = CommandType.Text;
                using (SqlDataReader a = bookinfoCommand.ExecuteReader())
                {
                    try
                    {
                        while (a.Read())
                        {
                            TBbookname.Text = (string)a["bookname"];
                            TBsellprice.Text = (string)a["sellprice"];
                        }
                        Con.Close();
                    }
                    catch
                    {
                        Console.WriteLine("发生错误:");
                    }
                }
            }
        }        
    }       
}