中文字段時sp的寫法

[derek]

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();

[gshope]

@mtcode nvarchar(20),@mtname nvarchar(50) AS insert into materials (資材代碼,名稱) values (@mtcode,@mtname)

[derek]

剛剛查看了一下sql2000 sp中的原句發現原來我copy後不小心刪調了 values (@mtcode,@mtname) 中的右括號, 數據庫中的sp是有此括號的. 問題應該不在此, 況且少了括好也存不了檔.

[derek]

selfup

[derek]

我把中文字段改為字母組合也是不行! 難道sqlCommandBuilder是使用有甚麼條件或根本就不能這樣用?
請用過SqlCommandBuilder的朋友指點迷津, 或給各例子參考參考!
謝過!