遇到的问题好奇怪,请大虾搭救
在网页里有若干文本框,大多数是必填的,用ReqiredFieldValidator控制这些文本框必须有内容,举个例子如下
<asp:textbox id=txtName width=165 runat=server AutoPostBack=False></asp:textbox><asp:RequiredFieldValidator id=TypeReq ControlToValidate=txtName Display=Dynamic Font-Name=宋体 font-size=9 runat=server ErrorMessage=此项必填 />
用一个按钮(ID是btnAdd)将所有触发文本框信息提交数据库的事件<asp:Button ID=btnAdd text="添加" onclick=btnAdd_click Runat=server></asp:Button>
<script runat=server>
sub btnAdd_click(sender as object,e as eventargs)
dim provider,SQL,ConnStr as string
provider="Microsoft.Jet.OLEDB.4.0;"
ConnStr = "Provider="+Provider+"Data Source="+Server.MapPath( "/db/PurchaseInfo.mdb" )+";Persist Security Info=False;User ID=;Jet OLEDB:Database password=111"
SQL="select * from price"
dim cm as new oledbcommand()
dim con as new oledbconnection()
con.connectionstring=ConnStr
dim cmd as oledbDataAdapter
cmd=new OLEDbDataAdapter(SQL,Connstr)
dim ds as dataset=new dataset()
cmd.fill(ds,"price")
dim dt as DataTable=ds.tables("price")
con.open()
cm.connection=con
cm.commandtext="insert into price(名称,材料类型,材质,规格型号,单位,单价,单价是否含运费,现/期货) values('"& txtName.text &"','c','d','e','f',2,'g','h')"
cm.ExecuteNonQuery()
con.close
response.write("succeed!")
end sub
现在奇怪的地方就在于我未给任何textbox输内容,点“添加”按钮,所有RequiredFieldValidator显示,可是这条空白信息还是提交到了数据库形成一个新的纪录,我不知道自己哪里写错了,请指教~~~