[ValidateInput(false)]

本文介绍了如何通过[ValidateInput(false)]属性或者<httpRuntime requestValidationMode=2.0 />来配置ASP.NET应用程序中的请求验证模式。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

[ValidateInput(false)]

<httpRuntime requestValidationMode="2.0" />

转载于:https://www.cnblogs.com/tgdjw/p/4601018.html

以下代码运行报错,显示没有end sub,代码如下:Sub AddRecord() Dim ws As Worksheet Set ws = ThisWorkbook.Sheets("数据表") ' 自动生成表头 If ws.Range("A1") = "" Then ws.Range("A1:J1") = Array("记录时间", "记录人", "设备ID", "Chamber ID", "备件名称", _ "PN", "SN", "安装日期", "下机日期", "备注") End If Dim lastRow As Long lastRow = ws.Cells(ws.Rows.Count, 1).End(xlUp).Row + 1 ' 输入验证函数 Function ValidateInput(prompt As String, Optional allowBlank As Boolean = False) As String Do While True Dim userInput As String userInput = Trim(InputBox(prompt)) If allowBlank Or userInput <> "" Then ValidateInput = userInput Exit Do Else MsgBox "此项为必填内容,请重新输入!" End If Loop End Function ' 日期验证函数 Function ValidateDate(prompt As String) As Date Do While True On Error Resume Next Dim inputDate As Date inputDate = CDate(ValidateInput(prompt & "(格式:yyyy/mm/dd)")) If Err.Number = 0 Then ValidateDate = inputDate Exit Do Else Err.Clear MsgBox "日期格式错误,请使用yyyy/mm/dd格式" End If Loop End Function ' 记录核心信息 With ws .Cells(lastRow, 1) = Now() .Cells(lastRow, 2) = ValidateInput("记录人员") .Cells(lastRow, 3) = ValidateInput("设备ID") .Cells(lastRow, 4) = ValidateInput("Chamber ID") .Cells(lastRow, 5) = ValidateInput("备件名称") .Cells(lastRow, 6) = ValidateInput("PN码") ' SN唯一性验证 Do While True Dim sn As String sn = ValidateInput("SN码") If Application.CountIf(ws.Columns(7), sn) = 0 Then .Cells(lastRow, 7) = sn Exit Do Else MsgBox "该SN码已存在,请检查!" End If Loop ' 日期处理 .Cells(lastRow, 8) = ValidateDate("安装日期") .Cells(lastRow, 9) = ValidateDate("下机日期(未下机请留空)", True) .Cells(lastRow, 10) = ValidateInput("备注", True) End With End Sub
03-21
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值