中文字段時sp的寫法
derek 2003-10-15 02:30:16 materials有以下兩各中文字段: 資材代碼,名稱
以下sp的寫法有沒問題?
更新數據庫時出現錯誤:
Procedure 'materials_insert' experts parameter '@mtcode',which was not supplied.
CREATE PROCEDURE [dbo].[materials_insert]
@mtcode nvarchar(20),@mtname nvarchar(50) AS insert into materials (資材代碼,名稱) values @mtcode,@mtname)
GO
CREATE PROCEDURE [dbo].[materials_update] @mtcode nvarchar(20),@mtname nvarchar(50) @Original_mtid int
AS update materials SET 資材代碼=@mtcode, 名稱=@mtname where mtid=@Original_mtid
GO
有關代碼段如下;
this.selectcmd.CommandType =CommandType.StoredProcedure;
this.deletecmd.CommandType =CommandType.StoredProcedure;
this.insertcmd.CommandType =CommandType.StoredProcedure;
this.updatecmd.CommandType =CommandType.StoredProcedure;
this.selectcmd.CommandText="[materials_select]";
this.insertcmd.CommandText ="[materials_insert]";
this.deletecmd.CommandText="[materials_delete]";
this.updatecmd.CommandText ="[materials_update]";
System.Data.SqlClient.SqlCommandBuilder cmdbuilder=new System.Data.SqlClient.SqlCommandBuilder(this.da);
this.conn.Open();
this.da.Fill(this.ds,"materials");
this.conn.Close();