try
    {
      //賦予sql字符串數(shù)據(jù)
      string strsql1 = "insert into yhxx (zh,mima) values ('" + Tet_zh.Text + "','" + Tet_mima.Text + "')";
      //創(chuàng)建字符串對象
      mycom = new SqlCommand(strsql1, myconn);
      mycom.ExecuteNonQuery();
      //關閉數(shù)據(jù)庫
      myconn.Close();
      Response.Write("<script>alert('添加成功！！')</script>");
      //保存賬號
      //str = Tet_zh.Text;
      //保存用戶名
      Application["name"] = Tet_zh.Text;
      //如果成功了成功轉入
      Response.Redirect("Useradd.aspx");
    }
    catch (Exception ex)
    {
      Response.Write("<script>alert('用戶已存在??！')</script>");
    }

protected void tianjia()
  {
    //添加用戶信息
    try
    {
      //賦予sql字符串數(shù)據(jù)
      
      string strsql1 = "update yhxx set xm='"+Tet_xm.Text+"',xb='"+tet_xb.Text+"',qq='"+Tet_qq.Text+"',Email='"+Tet_email.Text+"',dizhi='"+tet_home.Text+"',enjioy='"+Tet_enjoy.Text+"' where zh='"+Application["name"]+"'";
      // 創(chuàng)建字符串對象
      mycom = new SqlCommand(strsql1, myconn);
      mycom.ExecuteNonQuery();
      //關閉數(shù)據(jù)庫
      myconn.Close();
      Response.Write("<script>alert('添加成功?。?)</script>");
      Response.Redirect("denglu.aspx");
    }
    catch (Exception ex)
    {
      Response.Write("<script>alert('添加失?。?！')</script>"+ex.Message.ToString());
    }
  }

 //普通用戶登錄,管理員登錄雷同
    try
    {
      string sql = "select * from yhxx where zh='"+Tet_zh.Text+"' and mima='"+Tet_mm.Text+"' and yhlb='"+tet_dz.Text+"'";
      //創(chuàng)建命令對象
      SqlCommand com = new SqlCommand(sql,myconn);
      //創(chuàng)建讀取對象
      SqlDataReader dr = com.ExecuteReader();
      //成功彈出提示框
      //MessageBox.Show("讀取成功?。?);
      if (dr.Read())
      {
        dr.Close();
        myconn.Close();
        Application["name1"] = Tet_zh.Text;
        Response.Redirect("index.aspx");
      }
      else
      {
        Response.Write("<script>alert('用戶名或密碼有誤??！')</script>");
      }

    }
    catch (Exception ex)
    {
      Response.Write("<script>alert('登錄失?。?！')</script>");
    }

try
    {
      //打開數(shù)據(jù)庫
      myconn.Open();
    }
    catch (Exception ex)
    {
      Response.Write("<script>alert('數(shù)據(jù)庫打開失敗')</script>");
    }
    try
    {
      //創(chuàng)建數(shù)據(jù)字符串
      if (tet_name.Text == "")
      {
        Response.Write("<script>alert('名稱不能為空！')</script>");
      }
      else
      {
        string strsql3 = "select BookID as 圖書編號,BookName as 圖書名稱,"
                + "Booklb as 圖書類別,Bookzz as 圖書作者,Booklr as 圖書內容,"
                + "Bookfm as 圖書封面,Bookjg as 圖書價格,Bookzt as 圖書借閱狀態(tài) "
                + " from Bookxx where BookName='" + tet_name.Text + "'";
        mycom = new SqlCommand(strsql3, myconn);
        //打開數(shù)據(jù)庫
        //myconn.Open();
        //
        myread = mycom.ExecuteReader();
        GridView1.DataSource = myread;
        GridView1.DataBind();
        GridView1.Visible = true;
        //關閉數(shù)據(jù)
        myread.Close();
        myconn.Close();
      }
    }
    catch (Exception ex)
    {
      Response.Write("<script>alert('查詢失??！')</script>" + ex.Message.ToString());
    }

1.先添加圖書
 if (myread.Read())
    {
      if (tet_zt.Text == "0")
      {
        //添加借閱信息表
        myread.Close();
        string strsql5 = "insert into Bookjyxx (ISBookID,ISBookname,ISBookzt,ISname,ISid) " +
        " values (" + Tet_Bookid.Text + ",'" + tet_Name.Text + "'," + tet_zt.Text + ",'" + Tet_xm.Text + "'," + Tet_ID.Text + ")";
        mycom = new SqlCommand(strsql5, myconn);
        mycom.ExecuteNonQuery();
        //關閉
        myconn.Close();
        myread.Close();
    //////////////////////////////////////
        xiugai();
        chaxun();
      }
      if (tet_zt.Text == "1")
      {
        Response.Write("<script>alert('該書正在借閱中')</script>");
        chaxun();
      }
 2.再分別修改借閱狀態(tài)
       //創(chuàng)建
    //先修改圖書表狀態(tài)信息
    string strsql7 = "update Bookxx set Bookzt='1' where BookID='" + Tet_Bookid.Text + "'";
    mycom = new SqlCommand(strsql7, myconn);
    myconn.Close();
    myconn.Open();
    mycom.ExecuteNonQuery();
    //再修改借閱狀態(tài)表信息
    string strsql8 = "update Bookjyxx set ISBookzt='1' where ISBookID='" + Tet_Bookid.Text + "'";
    mycom = new SqlCommand(strsql8, myconn);
    mycom.ExecuteNonQuery();
    Response.Write("<script>alert('借閱成功！')</script>");
    //關閉
    myconn.Close();

//刪除他的借閱圖書信息
    string strsql3="delete from bookjyxx where ISid='"+Tet_id.Text+"'";
    mycom = new SqlCommand(strsql3, myconn);
    myconn.Open();
    mycom.ExecuteNonQuery();
    //////////////////////////////
    //刷新信息
    //查詢信息
    string strsql4= "select ISname as 借閱者,ISid as 借閱證號碼,ISBookID as 借閱書籍編號,"
      + "ISBookname as 借閱數(shù)據(jù)名稱,ISBookzt as 借閱狀態(tài),ISdate as借閱日期 from Bookjyxx where ISid='" + Tet_id.Text + "'";
    mydata = new SqlDataAdapter(strsql4, myconn);
    DataSet set = new DataSet();
    mydata.Fill(set);
    GridView1.DataSource = set.Tables[0];
    GridView1.DataBind();
    GridView1.Visible = true;
    //修改狀態(tài)
    //先修改圖書表狀態(tài)信息
    string strsql7 = "update Bookxx set Bookzt='0' where BookID='" +tet_Bookid.Text+ "'";
    mycom = new SqlCommand(strsql7, myconn);
    mycom.ExecuteNonQuery();
    Response.Write("<script>alert('歸還成功!')</script>");
    //關閉
    myconn.Close();
    set.Clear();