实现新闻信息的修改和添加功能

*****************************************WebForm1.aspx前台
<form id="form1" runat="server">
    <div>
   新闻标题
    
        <asp:TextBox ID="txtNewsTitle" runat="server"></asp:TextBox>
        <asp:Button ID="btnQuery" runat="server" Text="查询" Xοnclick="btnQuery_Click1" /><a href="WebAdd.aspx">添加</a>
        <div id="divResult" runat="server"></div>
    </div>
    </form>
*******************************************************WebForm1.aspx后台
protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (!string.IsNullOrEmpty(Request.QueryString["key"]))
                {
                    txtNewsTitle.Text = Request.QueryString["key"];
                    DataLoad();
                }
                if (Request.QueryString["ispostback"]=="1")
                {
                    DataLoad();
                }
            }
        }

      
        private void DataLoad()
        {
        
            string strcon = @"Data Source=.;Initial Catalog=News;Persist Security Info=True;User ID=sa;Password=910809";
            SqlConnection conn = new SqlConnection(strcon);
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = "SELECT T1.Id,T1.NewsTitle,T1.NewsContent,T2.ClassName,T3.RealName,T4.Department_Name FROM T_News T1 INNER JOIN T_NewsClass T2 ON T1.ClassId=T2.ClassId INNER JOIN T_User T3 ON T1.NewsCreator=T3.UserId INNER JOIN Department T4 ON T3.Department=T4.Department_Id  WHERE T1.NewsTitle LIKE @newstitle Order by T1.Id DESC";
            cmd.Parameters.AddWithValue("@newstitle","%"+txtNewsTitle.Text+"%" );
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            adapter.Fill(dt);
            cmd.Dispose();
            conn.Dispose();
      
            StringBuilder sb1 = new StringBuilder();
            string newstitle = string.Empty;
            string newscontent = string.Empty;
            string newsclass = string.Empty;
            string creator = string.Empty;
            string department = string.Empty;
            sb1.Append("<table>");
            foreach (DataRow row in dt.Rows)
            {
                sb1.Append("<tr>");
                newstitle = row["NewsTitle"].ToString();
                newscontent = row["NewsContent"].ToString();
                newsclass = row["ClassName"].ToString();
                creator = row["RealName"].ToString();
                department = row["Department_Name"].ToString();
                sb1.Append("<td>" + newstitle + "</td>");
                sb1.Append("<td>" + newscontent + "</td>");
                sb1.Append("<td>" + newsclass + "</td>");
                sb1.Append("<td>" + creator + "</td>");
                sb1.Append("<td>" + department + "</td>");
               
                sb1.Append("<td><a href=WebUpdate.aspx?id=" + row["Id"].ToString() + "&key="+txtNewsTitle.Text+">修改</a></td>");
                sb1.Append("</tr>");
            }
            sb1.Append("</table>");
            divResult.InnerHtml = sb1.ToString();
           
        }

        protected void btnQuery_Click1(object sender, EventArgs e)
        {
      
            if (string.IsNullOrEmpty(txtNewsTitle.Text))
            {
                txtNewsTitle.Text = "请输入您要查询的数据";
                return;
            }
           

            DataLoad();
             }
       }

**********************************************WebUpdate.aspx前台
<form id="form1" runat="server">
    <div>
        <table>
            <tr>
                <td>
                    新闻标题
                </td>
                <td>
                    <asp:TextBox ID="txtNewsTitle" runat="server" Width="329px"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    新闻内容
                </td>
                <td>
                    <asp:TextBox ID="txtNewsContent" TextMode="MultiLine" runat="server"
                        Width="333px" Height="171px"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    新闻类别
                </td>
                <td>
                   
                    <asp:DropDownList ID="ddlClassName" runat="server">
                    </asp:DropDownList>
                   
                </td>
            </tr>
             <tr>
                <td>
                    创建者
                </td>
                <td>
                   
                    <asp:DropDownList ID="ddlCreator" runat="server">
                    </asp:DropDownList>
                   
                </td>
            </tr>
            <tr><td colspan="2" align="center">
                <asp:Button ID="btnUpdate" runat="server" Text="保存" Xοnclick="btnUpdate_Click" />
                </td></tr>
        </table>
    </div>
    </form>
*************************************************WebUpdate.aspx后台
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

namespace WebApplication1
{
    public partial class WebUpdate : System.Web.UI.Page
    {
        string newsid = string.Empty;
        string key = string.Empty;
        protected void Page_Load(object sender, EventArgs e)
        {
            newsid = Request.QueryString["id"];
            key = Request.QueryString["key"];
            if (!IsPostBack)
            {
              
                DataLoad(newsid);
            }          
        }

        private void DataLoad(string newsid)
        {
       
        
            string strcon = @"Data Source=.;Initial Catalog=News;Persist Security Info=True;User ID=sa;Password=910809";
            SqlConnection conn = new SqlConnection(strcon);
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = "SELECT T1.Id,T1.NewsTitle,T1.NewsContent,T2.ClassId,T2.ClassName,T3.UserId,T3.RealName,T4.Department_Name FROM T_News T1 INNER JOIN T_NewsClass T2 ON T1.ClassId=T2.ClassId INNER JOIN T_User T3 ON T1.NewsCreator=T3.UserId INNER JOIN Department T4 ON T3.Department=T4.Department_Id  WHERE T1.Id=@id";
            cmd.Parameters.AddWithValue("@id", newsid);
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            adapter.Fill(dt);
        
            txtNewsTitle.Text = dt.Rows[0]["NewsTitle"].ToString();
            txtNewsContent.Text = dt.Rows[0]["NewsContent"].ToString();
        
            cmd.Parameters.Clear();
            cmd.CommandText = "SELECT ClassId,ClassName FROM T_NewsClass";
            DataTable dtNewsClass = new DataTable();
            adapter.Fill(dtNewsClass);
            this.ddlClassName.DataSource = dtNewsClass;
            this.ddlClassName.DataTextField = "ClassName";
            this.ddlClassName.DataValueField = "ClassId";
            this.ddlClassName.DataBind();

            ddlClassName.Items.FindByValue(dt.Rows[0]["ClassId"].ToString()).Selected = true;
         
            cmd.Parameters.Clear();
            cmd.CommandText = "SELECT UserId,RealName FROM T_User";
            DataTable dtUser = new DataTable();
            adapter.Fill(dtUser);
            this.ddlCreator.DataSource = dtUser;
            this.ddlCreator.DataTextField = "RealName";
            this.ddlCreator.DataValueField = "UserId";
            this.ddlCreator.DataBind();

            ddlCreator.Items.FindByValue(dt.Rows[0]["UserId"].ToString()).Selected = true;
          
            cmd.Dispose();
            conn.Dispose();
        
        }
        //保存更改后的数据
        protected void btnUpdate_Click(object sender, EventArgs e)
        {
          
            string newstitle = txtNewsTitle.Text;
            string newscontent = txtNewsContent.Text;
            string classid = ddlClassName.SelectedItem.Value;
            string userid = ddlCreator.SelectedItem.Value;
          
            string strcon = @"Data Source=.;Initial Catalog=News;Persist Security Info=True;User ID=sa;Password=910809";
            SqlConnection conn = new SqlConnection(strcon);
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = "UPDATE T_News SET NewsTitle=@newstitle,NewsContent=@newscontent,ClassId=@classid,NewsCreator=@newscreator WHERE Id=@id";
            cmd.Parameters.AddWithValue("@newstitle",newstitle);
            cmd.Parameters.AddWithValue("@newscontent", newscontent);
            cmd.Parameters.AddWithValue("@classid", classid);
            cmd.Parameters.AddWithValue("@NewsCreator", userid);
            cmd.Parameters.AddWithValue("@id", newsid);
            if (cmd.ExecuteNonQuery()>0)
            {
                Response.Redirect("WebForm1.aspx?key="+key);
            }
      
        }
    }
}
*******************************************WebAdd.aspx前台
<body>
    <form id="form1" runat="server">
    <div>
        <table>
            <tr>
                <td>
                    新闻标题
                </td>
                <td>
                    <asp:TextBox ID="txtNewsTitle" runat="server" Width="329px"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    新闻内容
                </td>
                <td>
                    <asp:TextBox ID="txtNewsContent" TextMode="MultiLine" runat="server"
                        Width="333px" Height="171px"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    新闻类别
                </td>
                <td>
                   
                    <asp:DropDownList ID="ddlClassName" runat="server">
                    </asp:DropDownList>
                   
                </td>
            </tr>
             <tr>
                <td>
                    创建者
                </td>
                <td>
                   
                    <asp:DropDownList ID="ddlCreator" runat="server">
                    </asp:DropDownList>
                   
                </td>
            </tr>
            <tr><td colspan="2" align="center">
                <asp:Button ID="btnUpdate" runat="server" Text="保存" Xοnclick="btnUpdate_Click" />
                </td></tr>
        </table>
    </div>
    </form>
</body>
*********************************WebAdd.aspx后台
 protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                LoadClassName();
                LoadUsers();
            }
        }
        //保存
        protected void btnUpdate_Click(object sender, EventArgs e)
        {
        
            string newstitle = txtNewsTitle.Text;
            string newscontent = txtNewsContent.Text;
            string classid = ddlClassName.SelectedItem.Value;
            string userid = ddlCreator.SelectedItem.Value;
          
            string strcon = @"Data Source=.;Initial Catalog=News;Persist Security Info=True;User ID=sa;Password=910809";
            SqlConnection conn = new SqlConnection(strcon);
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = "INSERT INTO T_News(NewsTitle,NewsContent,NewsCreator,CreateTime,ClassId) VALUES(@newstitle,@newscontent,@newscreator,GETDATE(),@calssid)";
            cmd.Parameters.AddWithValue("@newstitle", newstitle);
            cmd.Parameters.AddWithValue("@newscontent", newscontent);
            cmd.Parameters.AddWithValue("@newscreator", userid);
            cmd.Parameters.AddWithValue("@calssid", classid);
            if (cmd.ExecuteNonQuery()>0)
            {
                Response.Redirect("WebForm1.aspx?ispostback=1");
            }           
            cmd.Dispose();
            conn.Close();
            conn.Dispose();
          
        }
        private void LoadClassName()
        {
            string strcon = @"Data Source=.;Initial Catalog=News;Persist Security Info=True;User ID=sa;Password=910809";
            SqlConnection conn = new SqlConnection(strcon);
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = "SELECT ClassId,ClassName From T_NewsClass";           
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            adapter.Fill(dt);
            cmd.Dispose();
            conn.Close();
            conn.Dispose();
            this.ddlClassName.DataSource = dt;
            this.ddlClassName.DataTextField = "ClassName";
            this.ddlClassName.DataValueField = "ClassId";
            this.ddlClassName.DataBind();
        }
        private void LoadUsers()
        {
            string strcon = @"Data Source=.;Initial Catalog=News;Persist Security Info=True;User ID=sa;Password=910809";
            SqlConnection conn = new SqlConnection(strcon);
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = "SELECT UserId,RealName From T_User";
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            adapter.Fill(dt);
            this.ddlCreator.DataSource = dt;
            this.ddlCreator.DataTextField = "RealName";
            this.ddlCreator.DataValueField = "UserId";
            this.ddlCreator.DataBind();
            cmd.Dispose();
            conn.Close();
            conn.Dispose();
        }

        }