01.
using
System;
02.
using
System.Collections.Generic;
03.
using
System.Linq;
04.
using
System.Web;
05.
using
System.Web.UI;
06.
using
System.Web.UI.WebControls;
07.
using
System.Data;
08.
using
System.Diagnostics;
09.
using
System.Data.SqlClient;
10.
using
System.Text;
11.
12.
namespace
AspNetWebboardCS
13.
{
14.
public
partial
class
NewQuestion : System.Web.UI.Page
15.
{
16.
protected
void
Page_Load(
object
sender, EventArgs e)
17.
{
18.
19.
}
20.
21.
protected
void
btnSave_Click(
object
sender, EventArgs e)
22.
{
23.
SqlConnection objConn =
null
;
24.
StringBuilder strSQL =
new
StringBuilder();
25.
SqlCommand objCmd =
null
;
26.
27.
string
strConnString =
null
;
28.
strConnString =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\\database.mdb"
;
29.
objConn =
new
SqlConnection(strConnString);
30.
objConn.Open();
31.
32.
33.
strSQL.Append(
" INSERT INTO webboard (CreateDate,Question,Details,Name,[View],Reply) "
);
34.
strSQL.Append(
" VALUES "
);
35.
strSQL.Append(
" (@sCreateDate,@sQuestion,@sDetails,@sName,@sView,@sReply) "
);
36.
objCmd =
new
SqlCommand(strSQL.ToString(), objConn);
37.
objCmd.Parameters.Add(
"@sCreateDate"
, SqlDbType.Date).Value = DateTime.Now.ToString();
38.
objCmd.Parameters.Add(
"@sQuestion"
, SqlDbType.VarChar).Value =
this
.txtQuestion.Text;
39.
objCmd.Parameters.Add(
"@sDetails"
, SqlDbType.VarChar).Value =
this
.txtDetails.Text;
40.
objCmd.Parameters.Add(
"@sName"
, SqlDbType.VarChar).Value =
this
.txtName.Text;
41.
objCmd.Parameters.Add(
"@sView"
, SqlDbType.Integer).Value = 0;
42.
objCmd.Parameters.Add(
"@sReply"
, SqlDbType.Integer).Value = 0;
43.
objCmd.ExecuteNonQuery();
44.
45.
objConn.Close();
46.
objConn =
null
;
47.
48.
Response.Redirect(
"Webboard.aspx"
);
49.
}
50.
}
51.
}