shiyan.aspx.cs

可以实现图书信息的管理笑话寻和山下湖


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.ComponentModel;
using System.Drawing;
using System.Web.SessionState;
using System.Diagnostics;
using System.Data.SqlClient;

public partial class Web_shiyan : System.Web.UI.Page
{
   // BaseClass bc = new BaseClass();
    protected void Page_Load(object sender, EventArgs e)
    {

        if (!Page.IsPostBack)
        {
            SqlConnection strcon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings

    ["db_KnowledgeConnectionString"].ToString());


            strcon.Open();
            //SqlDataAdapter sada = new SqlDataAdapter("select * from tb_Keyword",strcon);
            SqlDataAdapter sda = new SqlDataAdapter("select * from tb_Keyword  WHERE Keyword_id=" + Request["Keyword_id"].ToString() + "", strcon);
            DataSet ds = new DataSet();
            sda.Fill(ds, "tb_Keyword");

            DataRowView rowview = ds.Tables["tb_Keyword"].DefaultView[0];
            TextBox2.Text = rowview["Keyword_name"].ToString();

            ds.Clear();
            strcon.Close();
        }

    }

    protected void Button2_Click(object sender, EventArgs e)
    {

             SqlConnection sqlCon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings

           ["db_KnowledgeConnectionString"].ToString());
             try
             {
                 sqlCon.Open();
                 SqlCommand sqlCmd = new SqlCommand("Update tb_Keyword SET Keyword_name=@Keyword_name WHERE Keyword_id=@Keyword_id", sqlCon);
                 sqlCmd.Parameters.Add("keyword_id", SqlDbType.Int, 10);
                 sqlCmd.Parameters.Add("keyword_name", SqlDbType.VarChar, 50);
                 sqlCmd.Parameters["keyword_id"].Value = Request.QueryString["keyword_id"];
                 sqlCmd.Parameters["keyword_name"].Value = this.TextBox2.Text;
                 sqlCmd.ExecuteNonQuery();


             }
             finally
             {
                 sqlCon.Close();

             }
             Page.Response.Redirect("~/Web/ListKey.aspx"); 
        }

    
    
}