<

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;