<
asp
:
RequiredFieldValidator
ID
="RequiredFieldValidator3"
runat
="server"
ControlToValidate
="TextBox3"
ErrorMessage
="*"></
asp
:
RequiredFieldValidator
></
td
>
</
tr
>
<
tr
>
<
td
style
="text-align: center"
colspan
="3">
<
asp
:
Button
ID
="Button1"
runat
="server"
Text
="提交新闻"
OnClick
="Button1_Click"
/></
td
>
</
tr
>
</
table
>
</
div
>
</
form
>
</
body
>
</
html
>
Web.config
<
connectionStrings
>
<
add
name
=
"
connection
"
connectionString
=
"
server=(local);
database=news;uid=sa;pwd=
"
/>
</
connectionStrings
>
提交新闻后台代码
protected
void
Button1_Click(
object
sender,
EventArgs
e)
{
SqlConnection
conn =
new
SqlConnection
(
ConfigurationManager
.ConnectionStrings[
"connection"
].ConnectionString);
SqlCommand
insertcmd =
new
SqlCommand
(
"insert into news(新闻标题,新闻内容,作
者)values(@新闻标题,@新闻内容,@作者)"
, conn);
//为每个数据库字段设置参数
insertcmd.Parameters.Add(
"@新闻标题"
,
SqlDbType
.VarChar, 200);
insertcmd.Parameters.Add(
"@新闻内容"
,
SqlDbType
.VarChar);
insertcmd.Parameters.Add(
"@作者"
,
SqlDbType
.VarChar, 20);
//为每个参数赋值
insertcmd.Parameters[
"@新闻标题"
].Value = TextBox1.Text;
insertcmd.Parameters[
"@新闻内容"
].Value = TextBox2.Text;
insertcmd.Parameters[
"@作者"
].Value = TextBox3.Text;