untitled-2.aspx

来自「用VB实现」· ASPX 代码 · 共 64 行

ASPX
64
字号
<%@ Page Language="VB" ContentType="text/html" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<script runat="server">
    Dim strConn as String =  _ 
		           "Provider=Microsoft.Jet.OLEDB.4.0;" & _
				   "Data Source=" & Server.MapPath("Tbase.mdb") & ";" & _
				   "Persist Security Info=False"
	Dim objConn as  New System.Data.Oledb.oledbConnection(strConn) 
	
	Sub btnAddNew_Click(sender As Object, e As System.EventArgs)
	    Dim strSQL as String  =  _ 
		    "INSERT INTO " & _ 
			"T_Message(T_Title,T_Date,T_Name) "  & _ 
			"VALUES('" & txtT_Title.Text & "','" & txtT_Date.Text & "','" &  _
			            txtT_Name.Text & "')" 
			
		Dim ObjComm as New System.Data.Oledb.OleDbCommand(strSQL,objConn)
		
		objConn.Open()
		ObjComm.ExecuteNonQuery
		objConn.Close() 
			
	End Sub 	

</script>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>老师添加题目页面</title>
<style type="text/css">
<!--
body {
	background-color: #00FFFF;
}
.style1 {
	font-family: "宋体";
	font-size: 24px;
}
-->
</style></head>
<body>
<form runat ="server">
  <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="style1"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;添加题目信息</span></p>
  <p>&nbsp;</p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  <asp:Label ID="lblT_Title" runat="server" Text="题目标题"></asp:Label>
 <asp:TextBox ID="txtT_Title" runat="server" />
 <br> <br>
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <asp:Label ID="lblT_Date" runat="server" Text="发布日期"></asp:Label>
 <asp:TextBox ID="txtT_Date" runat="server" />
 <br> <br>
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <asp:Label ID="lblT_Name" runat="server" Text="发布人员"> </asp:Label>
 <asp:TextBox ID="txtT_Name" runat="server" />
 <br> 
 <br>
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <asp:Button ID="btnAddNew" Text="添加" runat="server"  OnClick="btnAddNew_Click"/>
</form> 
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?