温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:明博静态新闻文章发布系统源码
当前文件:
MinbelNews/Admin/InsertExample.aspx,打开代码结构图
MinbelNews/Admin/InsertExample.aspx,打开代码结构图1<%@ Page validateRequest="false" Language="C#" %> 2
<%@ Import Namespace="System.Data.OleDb" %> 3
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 4
5
<script runat="server"> 6
7
protected void btnAdd_Click(object sender, EventArgs e) 8
{ 9
string strTitle = txtTitle.Text.Trim(); 10
string strE_Memo = txtE_Memo.Text.Trim(); 11
if (strTitle == "" || strE_Memo=="") 12
{ 13
return; 14
} 15
try 16
{ 17
CsharpBean cb = new CsharpBean(); 18
OleDbConnection ConnAcc = new OleDbConnection(cb.MyConn); //OleDb链接类的实例化 19
ConnAcc.Open();//打开数据库 20
string strSQL = "Insert into FileExample (Name,E_Memo) Values ('" + strTitle + "','" + strE_Memo + "');";//SQL语句 21
OleDbCommand cmd = new OleDbCommand(strSQL, ConnAcc);//创建Command命令对象 22
cmd.ExecuteNonQuery();//执行命令 23
ConnAcc.Close();//关闭数据库 24
Response.Write("Insert sucess"); 25
} 26
catch (Exception ex) 27
{ 28
Response.Write("错误,错误原因:" + ex.Message); 29
Response.End(); 30
} 31
} 32
</script> 33
34
<html xmlns="http://www.w3.org/1999/xhtml" > 35
<head runat="server"> 36
<title>无标题页</title> 37
</head> 38
<body> 39
<form id="form1" runat="server"> 40
<div> 41
名称<br /> 42
<asp:TextBox ID="txtTitle" runat="server" Width="217px"></asp:TextBox> 43
<asp:Button ID="btnAdd" runat="server" OnClick="btnAdd_Click" Text=" 增加 " /><br /> 44
内容<br /> 45
<asp:TextBox ID="txtE_Memo" runat="server" Rows="30" TextMode="MultiLine" Width="609px"></asp:TextBox></div> 46
</form> 47
</body> 48
</html> 49





}
}