form表单提交无反应
问题: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> --------------------编程问答-------------------- 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"] == "提交")这样写有可能在没有提交动作时会出错(直接加载页面,没有提交),正确写法
--------------------编程问答-------------------- if (Request.Form["submit"] !=null && Request.Form["submit"]== "提交") --------------------编程问答--------------------
修改之后仍然执行不了this.Page.RegisterStartupScript("ss", "<script language='JavaScript'>alert('需求名称不能为空!');</script>"); 点解啊 --------------------编程问答-------------------- <input type="submit" name="submit" value="提交"/>
Request.Form里面的关键字是控件的name属性 --------------------编程问答--------------------
谢谢啊!太感谢了 --------------------编程问答--------------------
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 表单中有没有填值,每一步的+=都执行了,而值却不是,少了好几段,请问为什么呢,错误出在哪儿,该怎样改正? --------------------编程问答-------------------- if (Request.Form["dep"] != null)
{
sqlstr = sqlstr + ",proposer_dep";
str2 += ",'" + Request.Form["dep"].ToString() + "'";
}
--------------------编程问答-------------------- 华丽的飘过 --------------------编程问答--------------------
哪里有问题? --------------------编程问答--------------------
你的代码少了一个"+"
str2 += ",'" + Request.Form["dep"].ToString() + "'";
--------------------编程问答-------------------- ,sorry 少了一个 + 号了 --------------------编程问答--------------------
页面上是用局部刷新的控件了吗
补充：.NET技术 , ASP.NET
