gridview字段长度限制 [英] gridview field length limitation
本文介绍了gridview字段长度限制的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
您好，我是一个菜鸟，只是想和2010 MSVWD Express拼凑一个小型用户前端.我使用带有表的sql服务器.带有gridview的前端asp.net vb网页. Gridview需要使用用户输入来更新表.我在限制用户可以在每个字段中输入的字符数方面遇到麻烦.如果他们在给定的字段中输入太多，则会出现错误.有人可以帮我解决这个问题吗?
这是我正在使用的代码:
Hello, I am a total noob and am just trying to cobble a small user front end together with 2010 MSVWD express. I use a sql server with a table. A front end asp.net vb web page with a gridview. Gridview needs to update a table with user input. I''m having trouble limiting the amount of characters the user can enter in each field. If they enter too many in a given field they get an error. Can anybody help me figure this out?
This is the code I''m using:
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="REWTSEquip1" EnableModelValidation="True" AllowPaging="True"
AutoGenerateEditButton="True" PageSize="4">
<columns>
<asp:BoundField DataField="MANUFACTURER" HeaderText="MANUFACTURER"
SortExpression="MANUFACTURER" />
<asp:BoundField DataField="MODEL" HeaderText="MODEL" SortExpression="MODEL"
/>
<asp:BoundField DataField="DESCRIPTION" HeaderText="DESCRIPTION"
SortExpression="DESCRIPTION" />
<asp:BoundField DataField="SERIAL" HeaderText="SERIAL"
SortExpression="SERIAL" />
<asp:BoundField DataField="EQUIP_ID" HeaderText="EQUIP_ID"
SortExpression="EQUIP_ID" />
<asp:BoundField DataField="CUSTOMER_NUMBER" HeaderText="CUSTOMER_NUMBER"
SortExpression="CUSTOMER_NUMBER" />
<asp:BoundField DataField="SERVICECOUNT" HeaderText="SERVICECOUNT"
SortExpression="SERVICECOUNT" />
<asp:BoundField DataField="LOCATION" HeaderText="LOCATION"
SortExpression="LOCATION" />
<asp:BoundField DataField="RECEIVED" HeaderText="RECEIVED"
SortExpression="RECEIVED" />
<asp:BoundField DataField="CONDITION" HeaderText="CONDITION"
SortExpression="CONDITION" />
<asp:BoundField DataField="TECHNICIAN" HeaderText="TECHNICIAN"
SortExpression="TECHNICIAN" />
<asp:BoundField DataField="NOTES" HeaderText="NOTES"
SortExpression="NOTES" />
<asp:BoundField DataField="DISPOSITION" HeaderText="DISPOSITION"
SortExpression="DISPOSITION" READONLY="true"/>
</columns>
<asp:SqlDataSource ID="REWTSEquip1" runat="server"
ConnectionString="<%$ ConnectionStrings:MyConnectionstring %>"
SelectCommand="usp_Process"
SelectCommandType="StoredProcedure"
InsertCommand="INSERT INTO REWTSEquipment(MANUFACTURER, MODEL, DESCRIPTION, SERIAL, EQUIP_ID, CUSTOMER_NUMBER, SERVICECOUNT, LOCATION, RECEIVED, CONDITION, TECHNICIAN, NOTES, DISPOSITION) VALUES (@MANUFACTURER, @MODEL, @DESCRIPTION, @SERIAL, @EQUIP_ID, @CUSTOMER_NUMBER, @SERVICECOUNT, @LOCATION, @RECEIVED, @CONDITION, @TECHNICIAN, @NOTES, @DISPOSITION)"
UpdateCommand="INSERT INTO REWTSEquipment(MANUFACTURER, MODEL, DESCRIPTION, SERIAL, EQUIP_ID, CUSTOMER_NUMBER, SERVICECOUNT, LOCATION, RECEIVED, CONDITION, TECHNICIAN, NOTES, DISPOSITION) VALUES (@MANUFACTURER, @MODEL, @DESCRIPTION, @SERIAL, @EQUIP_ID, @CUSTOMER_NUMBER, @SERVICECOUNT, @LOCATION, @RECEIVED, @CONDITION, @TECHNICIAN, @NOTES, @DISPOSITION)">
<insertparameters>
<asp:Parameter Name="MANUFACTURER" />
<asp:Parameter Name="MODEL" />
<asp:Parameter Name="DESCRIPTION" />
<asp:Parameter Name="SERIAL" />
<asp:Parameter Name="EQUIP_ID" />
<asp:Parameter Name="CUSTOMER_NUMBER" />
<asp:Parameter Name="SERVICECOUNT" />
<asp:Parameter Name="LOCATION" />
<asp:Parameter Name="RECEIVED" />
<asp:Parameter Name="CONDITION" />
<asp:Parameter Name="TECHNICIAN" />
<asp:Parameter Name="NOTES" />
<asp:Parameter Name="DISPOSITION" />
</insertparameters>
<SelectParameters>
<asp:QueryStringParameter Name="EQUIPID" QueryStringField="Equipid"
Type="String" />
</SelectParameters>
<updateparameters>
<asp:Parameter Name="MANUFACTURER" />
<asp:Parameter Name="MODEL" />
<asp:Parameter Name="DESCRIPTION" />
<asp:Parameter Name="SERIAL" />
<asp:Parameter Name="EQUIP_ID" />
<asp:Parameter Name="CUSTOMER_NUMBER" />
<asp:Parameter Name="SERVICECOUNT" />
<asp:Parameter Name="LOCATION" />
<asp:Parameter Name="RECEIVED" />
<asp:Parameter Name="CONDITION" />
<asp:Parameter Name="TECHNICIAN" />
<asp:Parameter Name="NOTES" />
<asp:Parameter Name="DISPOSITION" />
</updateparameters>
</form>
</body>
</html>
推荐答案
ConnectionStrings:MyConnectionstring％> SelectCommand ="usp_Process" SelectCommandType ="StoredProcedure" InsertCommand ="INSERT INTO REWTSEquipment(制造商，型号，描述，序列，EQUIP_ID，CUSTOMER_NUMBER，SERVICECOUNT，LOCATION，已接收，条件，技术人员，注释，处置)值(@ MANUFACTURER，@ MODEL，@ DESCRIPTION，@ SERIAL，@ SERIAL @ CUSTOMER_NUMBER，@ SERVICECOUNT，@ LOCATION，@ RECEIVED，@ CONDITION，@ TECHNICIAN，@ NOTES和@DISPOSITION)" UpdateCommand ="INSERT INTO REWTSEquipment(制造商，型号，描述，序列，EQUIP_ID，CUSTOMER_NUMBER，SERVICECOUNT，位置，接收，条件，技术人员，注释，处置)值(@ MANUFACTURER，@ MODEL，@ DESCRIPTION，@ SERIAL，@ SERIAL @ CUSTOMER_NUMBER，@ SERVICECOUNT，@ LOCATION，@ RECEIVED，@ CONDITION，@ TECHNICIAN，@ NOTES，@ DISPOSITION)> <插入参数> < asp:参数名称="MANUFACTURER"/> < asp:参数名称="MODEL"/> < asp:参数名称="DESCRIPTION"/> < asp:参数名称="SERIAL"/> < asp:参数名称="EQUIP_ID"/> < asp:参数名称="CUSTOMER_NUMBER"/> < asp:参数名称="SERVICECOUNT"/> < asp:参数名称="LOCATION"/> < asp:参数名称="RECEIVED"/> < asp:参数名称="CONDITION"/> < asp:参数名称="TECHNICIAN"/> < asp:参数名称="NOTES"/> < asp:参数名称="DISPOSITION"/> </insertparameters> < SelectParameters> < asp:QueryStringParameter Name ="EQUIPID" QueryStringField ="Equipid" 输入="String"/> </SelectParameters> < updateparameters> < asp:参数名称="MANUFACTURER"/> < asp:参数名称="MODEL"/> < asp:参数名称="DESCRIPTION"/> < asp:参数名称="SERIAL"/> < asp:参数名称="EQUIP_ID"/> < asp:参数名称="CUSTOMER_NUMBER"/> < asp:参数名称="SERVICECOUNT"/> < asp:参数名称="LOCATION"/> < asp:参数名称="RECEIVED"/> < asp:参数名称="CONDITION"/> < asp:参数名称="TECHNICIAN"/> < asp:参数名称="NOTES"/> < asp:参数名称="DISPOSITION"/> </updateparameters> </form> </body> </html>
ConnectionStrings:MyConnectionstring %>" SelectCommand="usp_Process" SelectCommandType="StoredProcedure" InsertCommand="INSERT INTO REWTSEquipment(MANUFACTURER, MODEL, DESCRIPTION, SERIAL, EQUIP_ID, CUSTOMER_NUMBER, SERVICECOUNT, LOCATION, RECEIVED, CONDITION, TECHNICIAN, NOTES, DISPOSITION) VALUES (@MANUFACTURER, @MODEL, @DESCRIPTION, @SERIAL, @EQUIP_ID, @CUSTOMER_NUMBER, @SERVICECOUNT, @LOCATION, @RECEIVED, @CONDITION, @TECHNICIAN, @NOTES, @DISPOSITION)" UpdateCommand="INSERT INTO REWTSEquipment(MANUFACTURER, MODEL, DESCRIPTION, SERIAL, EQUIP_ID, CUSTOMER_NUMBER, SERVICECOUNT, LOCATION, RECEIVED, CONDITION, TECHNICIAN, NOTES, DISPOSITION) VALUES (@MANUFACTURER, @MODEL, @DESCRIPTION, @SERIAL, @EQUIP_ID, @CUSTOMER_NUMBER, @SERVICECOUNT, @LOCATION, @RECEIVED, @CONDITION, @TECHNICIAN, @NOTES, @DISPOSITION)"> <insertparameters> <asp:Parameter Name="MANUFACTURER" /> <asp:Parameter Name="MODEL" /> <asp:Parameter Name="DESCRIPTION" /> <asp:Parameter Name="SERIAL" /> <asp:Parameter Name="EQUIP_ID" /> <asp:Parameter Name="CUSTOMER_NUMBER" /> <asp:Parameter Name="SERVICECOUNT" /> <asp:Parameter Name="LOCATION" /> <asp:Parameter Name="RECEIVED" /> <asp:Parameter Name="CONDITION" /> <asp:Parameter Name="TECHNICIAN" /> <asp:Parameter Name="NOTES" /> <asp:Parameter Name="DISPOSITION" /> </insertparameters> <SelectParameters> <asp:QueryStringParameter Name="EQUIPID" QueryStringField="Equipid" Type="String" /> </SelectParameters> <updateparameters> <asp:Parameter Name="MANUFACTURER" /> <asp:Parameter Name="MODEL" /> <asp:Parameter Name="DESCRIPTION" /> <asp:Parameter Name="SERIAL" /> <asp:Parameter Name="EQUIP_ID" /> <asp:Parameter Name="CUSTOMER_NUMBER" /> <asp:Parameter Name="SERVICECOUNT" /> <asp:Parameter Name="LOCATION" /> <asp:Parameter Name="RECEIVED" /> <asp:Parameter Name="CONDITION" /> <asp:Parameter Name="TECHNICIAN" /> <asp:Parameter Name="NOTES" /> <asp:Parameter Name="DISPOSITION" /> </updateparameters> </form> </body> </html>
您需要根据数据库字段的长度为字段设置maxlength.
You need to set maxlength for the fields based on database field length.
这篇关于gridview字段长度限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
