DeleteCommand="DELETE FROM [users] WHERE (([username] = ?) OR ([username] IS NULL AND ? IS NULL)) AND (([password] = ?) OR ([password] IS NULL AND ? IS NULL)) AND (([Right] = ?) OR ([Right] IS NULL AND ? IS NULL)) AND (([Money] = ?) OR ([Money] IS NULL AND ? IS NULL)) AND (([Label] = ?) OR ([Label] IS NULL AND ? IS NULL))"
这是向导自动生成的
GridView中有username,password,Right,Money,Label这几个字段,在调用删除功能的时候出现"至少一个参数没有被指定值"错误,这是为什么,还有DeleteCommand中的sql语句是什么意思
DeleteCommand是用来给你的操作界面做删除绑定的,也就是界面上点删除时,将执行你这个DeleteCommand,从sql来看,是删除用户
然而,执行这个DeleteCommand这前,需要给他传递几个参数,就是?号的那些,一般是通过sqlCommandParameters来增加参数并传给DeleteCommand