form表单提交无反应

[breadsundae]

问题:
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_remark"] != null)
{
sqlstr += ",stat_remark";
str2 += ",'" + Request.Form["stat_remark"].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"]%>"/> </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"]%>"> </td>

<td class="frmt">需求提交时间: <input type="text"name="propose_time" class=frml value="<%=Request.Form["propose_time"]%>" onclick="this.value=setday(this)" />  </td><br>
<tr><td class="frmt">需求状态: <input type="text"name="status" class=frml value="<%=Request.Form["status"]%>"> </td><br>
<td class="frmt" style="height:60px;"> 状态备注: <textarea name="stat_remark" rows="5" cols="30" class=frml style="height:auto" value="<%=Request.Form["stat_remark"]%>"></textarea> </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"]%>">  </td>
<td class="frmt"> 场景属性：<input type=text name="spotattr" class=frml value="<%=Request.Form["spotattr"]%>"> </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"]%>"> </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>

[breadsundae]

引用 4 楼 liuchaolin 的回复:

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

谢谢啊!太感谢了

[breadsundae]

引用 1 楼 liuchaolin 的回复:

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"] == "提交")这样写有可能在没有提交动作时会出错(直接加载页面,没有提交),正确写法

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_remark"] != null) { sqlstr += ",stat_remark"; str2 += ",'" + Request.Form["stat_remark"].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_remark,deadline) values (,'','','','') 字段名和值不一致了,即sqlstr 表单中有没有填值,每一步的+=都执行了,而值却不是,少了好几段,请问为什么呢,错误出在哪儿,该怎样改正?

[md5e]

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

[hu_hujun]

华丽的飘过

[breadsundae]

引用 7 楼 liuchaolin 的回复:

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

哪里有问题?

[md5e]

引用 9 楼 breadsundae 的回复:

[quote=引用 7 楼 liuchaolin 的回复:] if (Request.Form["dep"] != null) { sqlstr = sqlstr + ",proposer_dep"; str2 += ",'" + Request.Form["dep"].ToString() + "'"; }

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

[breadsundae]

引用 7 楼 liuchaolin 的回复:

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

,sorry 少了一个 + 号了

[某些人]

引用 3 楼 breadsundae 的回复:

[quote=引用 2 楼 liuchaolin 的回复:] if (Request.Form["submit"] !=null && Request.Form["submit"]== "提交")

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

[md5e]

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"] == "提交")这样写有可能在没有提交动作时会出错(直接加载页面,没有提交),正确写法

[md5e]

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

[breadsundae]

引用 2 楼 liuchaolin 的回复:

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

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

[md5e]

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