sqldatasource里面的参数如下:<asp:SqlDataSource ID="Sql_dormitoryupdate" runat="server"
ConnectionString="<%$ ConnectionStrings:DormitorySystemConnectionString %>"
SelectCommand="seach_all_dormitory" SelectCommandType="StoredProcedure"
UpdateCommand="update_dormitory" UpdateCommandType="StoredProcedure">
<SelectParameters>
<asp:ControlParameter ControlID="seach" DefaultValue="%" Name="all"
PropertyName="Text" Type="String" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="roomnumber" Type="String" />
<asp:Parameter Name="bednumber" Type="String" />
<asp:Parameter Name="upordown" Type="String" />
<asp:Parameter Name="areaname" Type="String" />
</UpdateParameters></asp:SqlDataSource>
后台代码如下: protected void transfers_RowUpdated(object sender, GridViewUpdatedEventArgs e)
{
this.Sql_dormitoryupdate.UpdateParameters["name"].DefaultValue = this.transfers.SelectedDataKey["Name"].ToString();
this.Sql_dormitoryupdate.UpdateParameters["roomnumber"].DefaultValue = this.transfers.SelectedDataKey["RoomNumber"].ToString();
this.Sql_dormitoryupdate.UpdateParameters["bednumber"].DefaultValue =this.transfers .SelectedDataKey ["BedNumber"].ToString ();
this.Sql_dormitoryupdate.UpdateParameters["upordown"].DefaultValue = this.transfers.SelectedDataKey["UpOrDowm"].ToString();
this.Sql_dormitoryupdate.UpdateParameters["areaname"].DefaultValue = this.transfers.SelectedDataKey["AreaName"].ToString(); this.Sql_dormitoryupdate.Update();
}
存储过程如下:
ALTER PROCEDURE [dbo].[update_dormitory]
@name nvarchar(50),
@roomnumber nvarchar(50),
@bednumber nvarchar(50),
@upordown nvarchar(50),
@areaname nvarchar(50)AS
BEGIN
declare @area_id int
select @area_id =ResourceID from DormitoryArea where AreaName =@areaname
update Dormitory
set Accommodation_ResourceID =6,
Name =@name,
Sex =NULL,
Company =NULL,
GraduateTime =NULL,
CheckinTime =NULL,
LeaveTime =NULL,
PhoneNumber =NULL,
Re =NULL,
flgDeleted ='N'
where DormitoryArea_ResourceID=@area_id and RoomNumber =@roomnumber and BedNumber =@bednumber and UpOrDowm =@upordown
END执行,出现为过程或函数 update_dormitory 指定了过多的参数。望高手指点,谢谢
ConnectionString="<%$ ConnectionStrings:DormitorySystemConnectionString %>"
SelectCommand="seach_all_dormitory" SelectCommandType="StoredProcedure"
UpdateCommand="update_dormitory" UpdateCommandType="StoredProcedure">
<SelectParameters>
<asp:ControlParameter ControlID="seach" DefaultValue="%" Name="all"
PropertyName="Text" Type="String" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="roomnumber" Type="String" />
<asp:Parameter Name="bednumber" Type="String" />
<asp:Parameter Name="upordown" Type="String" />
<asp:Parameter Name="areaname" Type="String" />
</UpdateParameters></asp:SqlDataSource>
后台代码如下: protected void transfers_RowUpdated(object sender, GridViewUpdatedEventArgs e)
{
this.Sql_dormitoryupdate.UpdateParameters["name"].DefaultValue = this.transfers.SelectedDataKey["Name"].ToString();
this.Sql_dormitoryupdate.UpdateParameters["roomnumber"].DefaultValue = this.transfers.SelectedDataKey["RoomNumber"].ToString();
this.Sql_dormitoryupdate.UpdateParameters["bednumber"].DefaultValue =this.transfers .SelectedDataKey ["BedNumber"].ToString ();
this.Sql_dormitoryupdate.UpdateParameters["upordown"].DefaultValue = this.transfers.SelectedDataKey["UpOrDowm"].ToString();
this.Sql_dormitoryupdate.UpdateParameters["areaname"].DefaultValue = this.transfers.SelectedDataKey["AreaName"].ToString(); this.Sql_dormitoryupdate.Update();
}
存储过程如下:
ALTER PROCEDURE [dbo].[update_dormitory]
@name nvarchar(50),
@roomnumber nvarchar(50),
@bednumber nvarchar(50),
@upordown nvarchar(50),
@areaname nvarchar(50)AS
BEGIN
declare @area_id int
select @area_id =ResourceID from DormitoryArea where AreaName =@areaname
update Dormitory
set Accommodation_ResourceID =6,
Name =@name,
Sex =NULL,
Company =NULL,
GraduateTime =NULL,
CheckinTime =NULL,
LeaveTime =NULL,
PhoneNumber =NULL,
Re =NULL,
flgDeleted ='N'
where DormitoryArea_ResourceID=@area_id and RoomNumber =@roomnumber and BedNumber =@bednumber and UpOrDowm =@upordown
END执行,出现为过程或函数 update_dormitory 指定了过多的参数。望高手指点,谢谢
解决方案 »
- ibatis参数问题
- asp.net,先呈现页面,再执行C#函数填充数据
- 同一个页面使用neatupload(上传大文件),和FileUpload(WEB控件),FileUpload上传不了文件了,急~解决就给分
- 一个关于parent使用的问题
- 关于Response.Redirect方法下载文件的问题
- 那位兄弟有obout_ASPTreeView.dll的注册号
- 求助!顺祝大家圣诞快乐!来者有分!
- 请问判断数据库中3天内的新纪录加"new"的图标,有关时间比较的语法怎么写(vb.net)
- oracle里面用select语句,如何限制返回记录的条数,在sql server里面可以用top 5来实现,不知oracle里面应该如何实现了,
- ASP.NET 中的上传文件能有多大,有什么限制
- GridView数据绑定事件
- 存储过程调用超时
<UpdateParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="roomnumber" Type="String" />
<asp:Parameter Name="bednumber" Type="String" />
<asp:Parameter Name="upordown" Type="String" />
<asp:Parameter Name="areaname" Type="String" />
</UpdateParameters>试试
控件,最简单的是用sqlhelper这个类自己写代码来操作