签名问题(在线提问)
我是一个新手,照书上做的一例子,部分代码如下:
sub memberdata_add(sender as object,e as DataGridCommandEventArgs)
dim addusercommand as sqlcommand
dim delmember as string
dim conn as sqlconnection
dim newuserin as string
conn=new sqlconnection(sqlserver)
conn.open()
newuserin="insert into memberdata values(@firstname,@lastname,@address1,@address2,@city,@state,@zip)"
addusercommand=new sqlcommand(newuserin,conn)
addusercommand.parameters.add(new sqlparameter("@firstname",sqldbtype.nvarchar,20))
addusercommand.parameters("@firstname").value=firstname.value
addusercommand=new sqlcommand(newuserin,conn)
addusercommand.parameters.add(new sqlparameter("@lastname",sqldbtype.nvarchar,20))
addusercommand.parameters("@lastname").value=lastname.value
addusercommand=new sqlcommand(newuserin,conn)
addusercommand.parameters.add(new sqlparameter("@address1",sqldbtype.nvarchar,20))
addusercommand.parameters("@address1").value=address1.value
addusercommand=new sqlcommand(newuserin,conn)
addusercommand.parameters.add(new sqlparameter("@address2",sqldbtype.nvarchar,20))
addusercommand.parameters("@address2").value=address2.value
addusercommand=new sqlcommand(newuserin,conn)
addusercommand.parameters.add(new sqlparameter("@city",sqldbtype.nvarchar,20))
addusercommand.parameters("@city").value=city.value
addusercommand=new sqlcommand(newuserin,conn)
addusercommand.parameters.add(new sqlparameter("@state",sqldbtype.nvarchar,20))
addusercommand.parameters("@state").value=state.value
addusercommand=new sqlcommand(newuserin,conn)
addusercommand.parameters.add(new sqlparameter("@zip",sqldbtype.nvarchar,20))
addusercommand.parameters("@zip").value=zip.value
addusercommand.executereader()
panelreset()
bindmemberdata()
end sub
<TD vAlign="top" align="center" colSpan="2"><BR>
<BR><INPUT type="submit" value="提交" runat="server" onserverclick="memberdata_add"/>
但运行后提示出错,信息是:
编译器错误信息: BC30408: 方法“Public Sub memberdata_add(sender As Object, e As System.Web.UI.WebControls.DataGridCommandEventArgs)”没有与委托“Delegate Sub EventHandler(sender As Object, e As System.EventArgs)”相同的签名。