*****************************************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();
}
}