?? detail.aspx
字號:
<%@ page language="C#"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<Html><Body BgColor="White">
<script runat="server">
// Insert page code here
//
void Button1_Click(Object sender, EventArgs e) {
//設(shè)置連接字符串
OleDbConnection Conn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;"+
"Data Source="+Server.MapPath("../db/workflow.mdb"));
// 打開連接
Conn.Open();
// 構(gòu)造SQL語句,該語句用于往Customers表中插入一條記錄
String strSQL="Update workstep set scomment='"+TextBox1.Text+"' where wname='"+Request["id"]+"' and srole='"+Session["username"]+"'";
// 創(chuàng)建Command對象
OleDbCommand Comm=new OleDbCommand(strSQL,Conn);
// 執(zhí)行ExecuteNonQuery()方法
Comm.ExecuteNonQuery();
// 關(guān)閉連接
Conn.Close();
Response.Write("操作成功!");
}
</script>
<%
OleDbConnection Conn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;"+
"Data Source="+Server.MapPath("../db/workflow.mdb"));
Conn.Open();
String strSQL="select * from workflow where wname='"+Request["id"]+"'";
OleDbCommand Comm=new OleDbCommand(strSQL,Conn);
// 執(zhí)行ExecuteReader()方法
OleDbDataReader dr=Comm.ExecuteReader();
string html=" ";
while(dr.Read())
{
html+="<TR>";
html+="<td>工作名稱:</td><TD>" + dr["wname"].ToString() + "<br></TD>";
html+="<td>工作內(nèi)容:</td><TD>" + dr["wcontent"].ToString() + "<br></TD>";
html+="</TR>";
}
Response.Write(html);
%>
<form runat="server">
<p>
<asp:Label id="Label1" runat="server">你的意見</asp:Label>
<asp:TextBox id="TextBox1" runat="server" TextMode="MultiLine" Height="97px" Width="215px"></asp:TextBox>
</p>
<p>
<asp:Button id="Button1" onclick="Button1_Click" runat="server" Text="完畢"></asp:Button>
</p>
<p>
</p>
<!-- Insert content here -->
</form>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -