|
作者: huixiecn [huixiecn] 论坛用户 | 登录 |
我的SQL有name, depart, tel, location, prblmtype, prblmdscrp字段,现在在利用dreamweaver2004,选择asp.net VB语言,编写了了如下代码的动态网页,目的是将对应的字段内容填到SQL数据库中,一切都很顺利,可是当我试图填入汉字的时候,系统无法识别。请教高手解决。 <%@ Page Language="VB" ContentType="text/html" ResponseEncoding="gb2312" %> <%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %> <MM:Insert runat="server" CommandText='<%# "INSERT INTO dbo.dll_serreq (name, depart, tel, location, prblmtype, prblmdscrp) VALUES (@name, @depart, @tel, @location, @prblmtype, @prblmdscrp)" %>' ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_consql") %>' DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_consql") %>' Expression='<%# Request.Form("MM_insert") = "frmrqstion" %>' CreateDataSet="false" Debug="true" > <Parameters> <Parameter Name="@name" Value='<%# IIf((Request.Form("txtName1") <> Nothing), Request.Form("txtName1"), "") %>' Type="VarChar" /> <Parameter Name="@depart" Value='<%# IIf((Request.Form("txtPart") <> Nothing), Request.Form("txtPart"), "") %>' Type="VarChar" /> <Parameter Name="@tel" Value='<%# IIf((Request.Form("txtTel") <> Nothing), Request.Form("txtTel"), "") %>' Type="VarChar" /> <Parameter Name="@location" Value='<%# IIf((Request.Form("txtPlace") <> Nothing), Request.Form("txtPlace"), "") %>' Type="VarChar" /> <Parameter Name="@prblmtype" Value='<%# IIf((Request.Form("RadioGroup1") <> Nothing), Request.Form("RadioGroup1"), "") %>' Type="VarChar" /> <Parameter Name="@prblmdscrp" Value='<%# IIf((Request.Form("textareadscrp") <> Nothing), Request.Form("textareadscrp"), "") %>' Type="VarChar" /> </Parameters> </MM:Insert> <MM:PageBind runat="server" PostBackBind="true" /> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>新的服务申请表</title> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <style type="text/css"> <!-- .style1 {color: #00FF33} .style2 { font-size: 36px; color: #04419C; } .style3 {color: #FF0000} .style4 {color: #0000FF} .style5 {color: #0033FF} .style9 {color: #00FF00} --> </style> </head> <body> <table width="800" border="0" align="center" cellspacing="0"> <tr> <td height="100" colspan="3"><table width="800" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="307" height="55" bgcolor="#04419C"> </td> <td width="90" bgcolor="#FFFFFF"><img src="../image/menu_left02.gif" width="73" height="66"></td> <td width="397"><div align="right"><img src="../image/jnlog.gif" width="300" height="30"></div></td> </tr> <tr bgcolor="#00FF00"> <td height="3" colspan="3"></td> </tr> <tr> <td height="50" colspan="3"><div align="center" class="style2">新的服务申请表</div></td> </tr> </table></td> </tr> <tr> <td height="10" colspan="3"> </td> </tr> <tr> <td height="400" colspan="3"> <form runat='server' method='POST' action="" enctype="multipart/form-data" name='frmrqstion' id="frmrqstion"> <table width="800" height="408" border="1" cellspacing="1"> <tr> <td width="178"><div align="right">申请部门:</div></td> <td width="617"> <input name="txtPart" type="text" id="txtPart"> <span class="style3">*</span></td> </tr> <tr> <td><div align="right">申请人:</div></td> <td> <input name="txtName1" type="text"> <span class="style3">*</span></td> </tr> <tr> <td height="50"><div align="right">电话:</div></td> <td><input name="txtTel" type="text" > <span class="style3">*</span></td> </tr> <tr> <td><div align="right">设备位置:</div></td> <td><input name="txtPlace" type="text" id="txtPlace3"> <span class="style3">*</span></td> </tr> <tr> <td><div align="right">问题类别:</div></td> <td><p> <label> <input name="RadioGroup1" type="radio" value="test" checked> 信息交流平台</label> <label> <input type="radio" name="RadioGroup1" value="software"> 软件</label> <label> <input type="radio" name="RadioGroup1" value="hardware"> 硬件</label> <br> </p></td> </tr> <tr> <td height="108"><div align="right">问题描述:</div></td> <td><textarea name="textareadscrp" cols="80" rows="5" id="textarea3">请详细描述</textarea> <span class="style3">*</span> </td> </tr> <tr> <td colspan="2"><div align="center"> <input type="submit" name="Submit" value="提交"> <input type="reset" name="Submit2" value="重置"> </div></td> </tr> </table> <div align="center"></div> <input type="hidden" name="MM_insert" value="frmrqstion"> </form></td> </tr> <tr bgcolor="#0033FF"> <td width="180" height="16"> <div align="center"><span class="style4"><span class="style5"><span class="style4"></span></span></span></div></td> <td width="422" bgcolor="#0033FF"><div align="right"><a href="servicemain.aspx" class="style9">服务中心首页</a></div></td> <td width="197"><div align="center"><a href="http://0.0.0.0/" class="style9">e江南首页</a></div></td> </tr> <tr> <td height="10" colspan="3"> <div align="center">本站由计算所主办 </div></td> </tr> <tr> <td height="10" colspan="3"> <div align="center">联系电话</div></td> </tr> </table> </body> </html> |
地主 发表时间: 04-02-22 15:01 |
|
20CN网络安全小组版权所有
Copyright © 2000-2010 20CN Security Group. All Rights Reserved.
论坛程序编写:NetDemon
粤ICP备05087286号