关于数据的插入

请看我的代码 .aspx代码
<form runat="server">
姓名: <input id="aname" type="text" runat="server" />
称呼: <input id="called" type="text" runat="server" />
留言: <textarea id="content" runat="server"> </textarea>
<asp:Button runat="server" class="button_submit" OnClick="Submit_Click" />
</form>
.aspx.cs代码
protected void Submit_Click(object sender, EventArgs e)
    {

        string nc_comment = Request.Params["content"];
        string strConnection = ConfigurationSettings.AppSettings["dns"];
        SqlConnection objConnection = new SqlConnection(strConnection);
        string insertStr = " INSERT INTO thread(aname,content,called) VALUES ";
        insertStr += "(@aname,@content,@called)";
        SqlCommand insertCommand = new SqlCommand(insertStr, objConnection);
        insertCommand.Parameters.Add(new SqlParameter("@aname", OleDbType.VarChar));
        insertCommand.Parameters["@aname"].Value = aname;
        insertCommand.Parameters.Add(new SqlParameter("@called", OleDbType.VarChar));
        insertCommand.Parameters["@called"].Value = called;
        insertCommand.Parameters.Add(new SqlParameter("@content", OleDbType.VarChar));
        insertCommand.Parameters["@content"].Value = content;
        objConnection.Open();
        insertCommand.ExecuteNonQuery();
        objConnection.Close();
        Response.Redirect("thanks.aspx");

    } 我想实现的是，当别人在姓名处没有输入内容的时候，我默认给他一个“待定”的名字，输入了，就获取输入的值，当称呼没有输入的时候，就留空，输入了，就获取值，当留言没有填写的时候，提示他没有填写，并不能提交到数据库，填写了，就获取，并和上面的一同写入数据库，就请问，这里正确的的写法是什么呢？谢谢

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

可以给Submit写一个客户端脚本来验证你说的这些控件的录入的值。如果成功则返回True则执行服务器上的这个Submit_click事件，不符合规则则返回False以不执行服务器上的这个方法。
如：
function checkData(){
    var name = document.getElementById("<%=txtName.ClientID %>");
    if (name.value.trim()=="")
    {
        return false
    }
    ....
    return true;
}
    protected void Submit_Click(object sender, EventArgs e)
    {        if (this.content.Value == "")
        {
            Response.Write("<script lanage='javascript'>alert('content不能为空')</script>");
            return;
        }
        string nc_comment = Request.Params["content"];
        string strConnection = ConfigurationSettings.AppSettings["dns"];
        SqlConnection objConnection = new SqlConnection(strConnection);
        string insertStr = " INSERT INTO thread(aname,content,called) VALUES ";
        insertStr += "(@aname,@content,@called)";
        SqlCommand insertCommand = new SqlCommand(insertStr, objConnection);
        insertCommand.Parameters.Add(new SqlParameter("@aname", OleDbType.VarChar));
        insertCommand.Parameters["@aname"].Value = (this.aname.Value == "") ? "待定" : this.aname.Value;
        insertCommand.Parameters.Add(new SqlParameter("@called", OleDbType.VarChar));
        insertCommand.Parameters["@called"].Value = this.called.Value;
        insertCommand.Parameters.Add(new SqlParameter("@content", OleDbType.VarChar));
        insertCommand.Parameters["@content"].Value = this.content.Value;
        objConnection.Open();
        insertCommand.ExecuteNonQuery();
        objConnection.Close();
        Response.Redirect("thanks.aspx");    }
1.用client.click 把值放到url里传递.
2.写道cookies里.服务器端直接读cookies.
3......
参考.net专题网站：地球黑匣子网 http://www.dqhxz.com
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="Youyou_MyWeb_gamelist_Default" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
    <style type="text/css">

</style>
<script type="text/javascript" language="javascript">window.onload=function(){
s('aname','请输入的你的姓名','刘德华');
s('called','请输入你的心得','');
}
function $(id){return document.getElementById(id)}//参数1，id，
//参数2，v，提示语句
//参数3，默认值,为空表示没有默认值
function s(id,v,defaultV){
with($(id)){
className='a1';
value=v;
onfocus=function(){if(value==v)value='';className='a2'}
onblur=function(){if(value==''){value=defaultV;className='a1'}}
}
}function subPage()
{
    var content = $("content");
    var msg = $("lblMessage");
    if(content.value == '')
    {
        alert("留言不能为空！");
        msg.innerText = "留言不能为空！";
        return false;
     }else
     {
        msg.innerText = "";
        return true;
     }
}
</script>
</head>
<body>    <form id="Form2" runat="server">
姓名: <input id="aname" type="text" runat="server" /> (默认给他一个“待定”的名字)
        <br />
称呼: <input id="called" type="text" runat="server" />
        <br />
留言: <textarea id="content" runat="server"> </textarea>
        <asp:Label ID="lblMessage" runat="server" ForeColor="red"></asp:Label><br />
<asp:Button ID="Button1" OnClientClick="return subPage();" Text="提交" runat="server" class="button_submit" OnClick="Submit_Click" />
</form>
</body>
</html>
private string _name = "本.拉登";
public string Name
{
   get{return _name;}
   set{_name = value;}
}
string sql = "insert into ......name = '"+ Name +"'"
insertCommand.Parameters["@aname"].Value = (aname=="" || aname==null)?"待定":aname;
insertCommand.Parameters["@called"].Value = (called=="" || called==null)?"":called;
if (this.content.Value == "" || this.content.Value == null)
{
    Response.Write("<script lanage='javascript'>alert('content不能为空')</script>");
    return;
}
if (this.content.Value == "" ¦ ¦ this.content.Value == null)
{
    Response.Write(" <script lanage='javascript'>alert('content不能为空') </script>");
    return;
}这样的方式能可以，但是
insertCommand.Parameters["@aname"].Value = (aname=="" ¦ ¦ aname==null)?"待定":aname;
这个是不行的请问还有其他的写法吗？