addnews2.aspx
来自「《精通ASP.NET网络编程》附带实例」· ASPX 代码 · 共 104 行
ASPX
104 行
<%@Page language="C#" Debug="True"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.SqlClient"%>
<html>
<head>
<title>网站新闻信息添加页面</title>
<style type="text/css">
<!--
table { font-size: 9pt}
body { font-size: 9pt}
-->
</style>
<Script Language="C#" runat="server">
void submit_Click(Object sender,EventArgs e)
{
//当单击提交按钮之后执行下面的代码
SqlConnection MyConnection;
SqlCommand MyCommand;
String ConnStr;
DateTime now= DateTime.Now;
//链接SQL Server数据库
MyConnection =new SqlConnection("Initial Catalog=mydb;Data Source=(local)\\NetSDK;Integrated Security=SSPI;");
MyConnection.Open();
String neirong2;
neirong2=Server.HtmlEncode(neirong.Text);
neirong2.Replace(" "," ");
if ((biaoti.Text=="")||(neirong2==""))
{
Label1.Text="标题或内容不能为空!";
}
else if (biaoti.Text.Length>=100)
{
Label1.Text="你的标题太长了!";
}
else if (img.Text.Length>=100)
{
Label1.Text="你的图片路径太长了!";
}
else
{
//将新记录插入到数据库中
ConnStr="insert into news(biaoti,zhaizi,neirong,shijian,img,counter) VALUES('"+biaoti.Text+"', '"+zhaizi.Text+"', '"+neirong2+"', '"+now.ToString()+"', '"+img.Text+"',0)";
MyCommand=new SqlCommand(ConnStr,MyConnection);
MyCommand.ExecuteNonQuery();
Label1.Text="增加成功!";
}
biaoti.Text="";
zhaizi.Text="";
neirong.Text="";
img.Text="";
}
void reset_Click(Object sender,EventArgs e)
{
//当单击取消按钮之后执行下面代码
biaoti.Text="";
zhaizi.Text="";
neirong.Text="";
img.Text="";
}
</Script>
</head>
<body >
<table width="550" border="1" cellspacing="0" cellpadding="0" align="center" bordercolorlight="#666666" bordercolordark="#FFFFFF">
<form runat=server>
<tr bgcolor="#CCCCCC">
<td colspan="2">网站新闻信息添加页面</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td width="78">标题:</td>
<td width="416"> <asp:TextBox id="biaoti" size="50" runat="server"/>
</td>
</tr>
<tr>
<td width="78">摘自:</td>
<td width="416"> <asp:TextBox id="zhaizi" size="30" runat="server"/> </td>
</tr>
<tr>
<td width="78">图片:</td>
<td width="416"><asp:TextBox id="img" size="30" runat="server"/></td>
</tr>
<tr>
<td width="78">内容:</td>
<td width="416"> <asp:TextBox id="neirong" Columns="60" Rows="15" TextMode="MultiLine" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2">
<div align="center">
<asp:Button id="submit" onClick=submit_Click runat="server" Text="提交"></asp:Button>
<asp:Button id="reset" onClick=reset_Click runat="server" Text="取消"></asp:Button>
</div>
</td>
</tr>
</form>
</table>
<p align="center"><asp:Label id="Label1" runat="server"/>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?