form表单提交无反应

Question

问题:
1 Page.RegisterStartupScript("s", "<script>alert('hello world!'" + sqlstr + " )</script>"); 为什么没反应?
2 if(!ispostback) 可以得到 response.write()的结果,但是if(ispostback)就得不到.我是想页面第一次加载就不必弹出那些信息了.
3.if  (Request.Form["submit"] == "提交") {}的写法可不可以?
4.连接数据库 sqlstr 写法行不行?
新手菜鸟啊,求各位指点一下.能将代码修改一下最好不过了,感激不尽呀!.拜托了cs:
protected void Page_Load(object sender, EventArgs e)
    {        if (IsPostBack)//  ??
        {
            if (true)//(Request.Form["submit"] == "提交")
            {
                /*if (Request.Form["reqname"] =="")
                 {
                     this.Page.ClientScript.RegisterStartupScript(this.GetType(), "skey", "<script language='JavaScript'>alert('需求名称不能为空!');</script>');", true);                     this.Page.RegisterStartupScript("ss", "<script language='JavaScript'>alert('需求名称不能为空!');</script>"); //为什么这句没有执行成功
                    Response.Write ("'Your name is 'Request.Form['reqname'].ToString()");
                    // Response.Write("<script language='JavaScript'>alert('错误:需求名称不能为空!');</script>");  
                
                 }else{
                     if (Request.Form["proposer"] == "" || Request.Form["requirements"] == "")
                     { }
                     //   Response.Write("<script language='JavaScript'>alert('资料填写不完整,请重新输入!');</script>");
                     else
                     {
                        */
                //////////
                string sqlstr = "insert into gcgl_require (";//填写字段
                string str2 = "";//填写值
                if (Request.Form["reqname"] != "" && Request.Form["proposer"] != "")
                {//空就会出错
                    sqlstr = sqlstr + "requirename,proposer";
                    str2 = "'" + Request.Form["reqname"].ToString() + "','" + Request.Form["proposer"].ToString() + "'";
                }
                if (Request.Form["propose_time"] != "")
                {
                    sqlstr += ",propose_time";
                    str2 += ",'" + Request.Form["propose_time"].ToString() + "'";
                }
                if (Request.Form["dep"] != null)
                {
                    sqlstr = sqlstr + ",proposer_dep";
                    str2 = ",'" + Request.Form["dep"].ToString() + "'";
                }
                if (Request.Form["status"] != null)
                {
                    sqlstr += ",status";
                    str2 += ",'" + Request.Form["status"].ToString() + "'";
                }
                if (Request.Form["stat_re"] != null)
                {
                    sqlstr += ",stat_re";
                    str2 += ",'" + Request.Form["stat_re"].ToString() + "'";
                }
                if (Request.Form["servicecenter"] != null)
                {
                    sqlstr += ",servicecenter";
                    str2 += ",'" + Request.Form["servicecenter"].ToString() + "'";
                }
                if (Request.Form["burg"] != null)
                {
                    sqlstr += ",burg";
                    str2 += ",'" + Request.Form["burg"].ToString() + "'";
                }
                if (Request.Form["spot"] != null)
                {
                    sqlstr += ",spot";
                    str2 += ",'" + Request.Form["spot"].ToString() + "'";
                }
                if (Request.Form["spotcode"] != null)
                {
                    sqlstr += ",spotcode";
                    str2 += ",'" + Request.Form["spotcode"].ToString() + "'";
                }
                if (Request.Form["spotattr"] != null)
                {
                    sqlstr += ",spotattr";
                    str2 += ",'" + Request.Form["spotattr"].ToString() + "'";
                }
                if (Request.Form["requiretype"] != null)
                {
                    sqlstr += ",requiretype";
                    str2 += ",'" + Request.Form["requiretype"].ToString() + "'";
                }
                if (Request.Form["built_model"] != null)
                {
                    sqlstr += ",built_model";
                    str2 += ",'" + Request.Form["built_model"].ToString() + "'";
                }
                if (Request.Form["projattr"] != null)
                {
                    sqlstr += ",projattr";
                    str2 += ",'" + Request.Form["projattr"].ToString() + "'";
                }
                if (Request.Form["approach_cdt"] != null)
                {
                    sqlstr += ",approach_cdt";
                    str2 += ",'" + Request.Form["approach_cdt"].ToString() + "'";
                }
                if (Request.Form["requirements"] != null)
                {
                    sqlstr += ",requirements";
                    str2 += ",'" + Request.Form["requirements"].ToString() + "'";
                }
                if (Request.Form["deadline"] != null)
                {
                    sqlstr += ",deadline";
                    str2 += ",'" + Request.Form["deadline"].ToString() + "'";
                }
                sqlstr = sqlstr + ") values (" + str2 + ")"; 
                Response.Write (sqlstr);
                Response.Write("<script language='JavaScript'>alert('测试到这里了!');</script>");
                Page.RegisterStartupScript("s", "<script>alert('hello world!'" + sqlstr + " )</script>");                //连接数据库
                 /*  OracleConnection sqlcon = new OracleConnection(ConfigurationManager.ConnectionStrings["connection"].ConnectionString);
                  sqlcon.Open();
                  OracleString oracleRowId;
                  OracleCommand cmd = new OracleCommand(sqlstr, sqlcon);
                  cmd.ExecuteOracleNonQuery(out oracleRowId);
                  sqlcon.Close();
                  this.Page.RegisterStartupScript("ss", "<script>alert('需求成功添加到数据库!')</script>");
                */
                // Response.Write("<script language='JavaScript'>alert('成功添加数据!');</script>");  
            }        }
    }aspx:
  <form  id="form1" method="post"    >
    <br><br>
    <table cellpadding="1px" style="width:980px;font-size:13px;;"  > 
        <tr> 
            <td  class="frmt"> 需求名称: <input type="text" name="reqname" class="frml"  value='<%=Request.Form["reqname"]%>'>*</td>
            <td class="frmt"> 需求ID: <input type="text" name="reqid" class=frml value="<%=Request.Form["reqid"]%>"/>&nbsp;</td>
                     
         <tr><td class="frmt">需求提起人: <input type="text"name="proposer"  class=frml value="<%=Request.Form["proposer"]%>">*</td><br> 
            <td  class="frmt"> 所在部门: <input type="text" name="dep" class=frml value="<%=Request.Form["dep"]%>">&nbsp;</td>
            
            <td class="frmt">需求提交时间: <input type="text"name="propose_time"  class=frml  value="<%=Request.Form["propose_time"]%>" onclick="this.value=setday(this)" />&nbsp; </td><br>
          <tr><td class="frmt">需求状态: <input type="text"name="status"  class=frml value="<%=Request.Form["status"]%>">&nbsp;</td><br> 
            <td  class="frmt" style="height:60px;"> 状态备注: <textarea name="stat_re" rows="5" cols="30" class=frml style="height:auto" value="<%=Request.Form["stat_re"]%>"></textarea>&nbsp;</td>
            
          <tr><td class="frmt"> 营销中心：<input type=text name="servicecenter" class=frml value="<%=Request.Form["servicecenter"]%>">*</td>
                <td class="frmt"> 城区/镇/农村：<input type=text name="burg" class=frml value="<%=Request.Form["burg"]%>">*</td>
                <td class="frmt"> 小区：<input type=text name="spot" class=frml value="<%=Request.Form["spot"]%>">*</td>
           <tr><td class="frmt"> 小区编码：<input type=text name="spotcode" class=frml value="<%=Request.Form["spotcode"]%>">&nbsp; </td>
                <td class="frmt"> 场景属性：<input type=text name="spotattr" class=frml value="<%=Request.Form["spotattr"]%>">&nbsp;</td>
               
          <tr><td class="frmt"> 项目类型：<input type=text name="requiretype" class=frml value="<%=Request.Form["requiretype"]%>">*</td>
                <td class="frmt"> 建设模式：<input type=text name="built_model" class=frml value="<%=Request.Form["built_model"]%>">*</td>
                <td class="frmt"> 项目性质：<input type=text name="projattr" class=frml value="<%=Request.Form["projattr"]%>">*</td>
          <tr><td class="frmt"> 是否具备进场条件：<input type=text name="approach_cdt" class=frml value="<%=Request.Form["approach_cdt"]%>">*</td>
                <td class="frmt"> 建设需求：<input type=text name="requirements" class=frml value="<%=Request.Form["requirements"]%>">*</td>
                <td class="frmt"> 完成时间需求：<input type=text name="deadline" class=frml onclick="this.value=setday(this)"  value="<%=Request.Form["deadline"]%>">&nbsp;</td>
        <tr>
              
             
            </tr></table><div id= "mydivdiv1"style=" padding: 13px 0 0 200px;">
<input type="submit" value="提交"/>
<!--<input type="reset" value="重置">-->
<input type="button" name="yourhiddeninfo" value="reset！" onclick="window.location.reload('rqin.aspx')">
</div>
</form>

Answer 1

1\ispostback不是针对提交,而是针对回传的事件
2\this.Page.RegisterStartupScript("ss", "<script language='JavaScript'>alert('需求名称不能为空!');</script>"); //为什么这句没有执行成功
要在这里加入return;
如:
this.Page.RegisterStartupScript("ss", "<script language='JavaScript'>alert('需求名称不能为空!');</script>");
return;
3\.if  (Request.Form["submit"] == "提交")这样写有可能在没有提交动作时会出错(直接加载页面,没有提交),正确写法

Answer 2

if  (Request.Form["submit"] !=null && Request.Form["submit"]== "提交")

Answer 3

修改之后仍然执行不了this.Page.RegisterStartupScript("ss", "<script language='JavaScript'>alert('需求名称不能为空!');</script>"); 点解啊

Answer 4

<input type="submit" name="submit" value="提交"/>
Request.Form里面的关键字是控件的name属性

Answer 5

 string sqlstr = "insert into gcgl_require (";//填写字段
                string str2 = "";//填写值
                if (Request.Form["reqname"] != null && Request.Form["proposer"] != null)
                {//空就会出错
                    sqlstr = sqlstr + "requirename,proposer";
                    str2 = "'" + Request.Form["reqname"].ToString() + "','" + Request.Form["proposer"].ToString() + "'";
                }
                if (Request.Form["propose_time"] != null)
                {
                    sqlstr += ",propose_time";
                    str2 += ",'" + Request.Form["propose_time"].ToString() + "'";
                }
                if (Request.Form["dep"] != null)
                {
                    sqlstr = sqlstr + ",proposer_dep";
                    str2 = ",'" + Request.Form["dep"].ToString() + "'";
                }
                if (Request.Form["status"] != null)
                {
                    sqlstr += ",status";
                    str2 += ",'" + Request.Form["status"].ToString() + "'";
                }
                if (Request.Form["stat_re"] != null)
                {
                    sqlstr += ",stat_re";
                    str2 += ",'" + Request.Form["stat_re"].ToString() + "'";
                }
                if (Request.Form["deadline"] != null)
                {
                    sqlstr += ",deadline";
                    str2 += ",'" + Request.Form["deadline"].ToString() + "'";
                }
                sqlstr = sqlstr + ") values (" + str2 + ")"; 
               
                Response.Write("<script language='JavaScript'>alert('测试到这里了!');</script>");
                Page.RegisterStartupScript("s", "<script language='JavaScript'>alert('hello world!'" + sqlstr + " )</script>");
               
是想写一个insert into 语句的,可是结果出来就变成了
insert into gcgl_require (requirename,proposer,propose_time,proposer_dep,status,stat_re,deadline) values (,'','','','') 
字段名和值不一致了,即sqlstr 表单中有没有填值,每一步的+=都执行了,而值却不是,少了好几段,请问为什么呢,错误出在哪儿,该怎样改正?

Answer 6

        if (Request.Form["dep"] != null)
                {
                    sqlstr = sqlstr + ",proposer_dep";
                    str2 += ",'" + Request.Form["dep"].ToString() + "'";
                }

Answer 7

哪里有问题?你的代码少了一个"+"
str2 += ",'" + Request.Form["dep"].ToString() + "'";

Answer 8

,sorry 少了一个 + 号了

Answer 9

修改之后仍然执行不了this.Page.RegisterStartupScript("ss", "<script language='JavaScript'>alert('需求名称不能为空!');</script>"); 点解啊页面上是用局部刷新的控件了吗