command.CommandText=@"insert into Users(FName,LName,Properties,Group_ID,Premissions,EMail,WeBб
ICQ,AboutUser,Subscripte,Login,Pwd,Country,Sity,Status,WhereKnow,RegisterDate)values(@FName,@LName,@Prop,@Group,@Prem,@EMail,@WeB,@ICQ,@AboutUser,@Subscribe,@Login,@Pwd,@Country,@Sity,@Status,@WhereKnow,GetDate());";

command.Parameters.Add("@FName",RegData.FName);
command.Parameters.Add("@LName",RegData.LName);
command.Parameters.Add("@Prop",1);
command.Parameters.Add("@Group",1);
command.Parameters.Add("@Prem",1);
command.Parameters.Add("@EMail",RegData.Email);
command.Parameters.Add("@Web",RegData.Web);
command.Parameters.Add("@ICQ",RegData.ICQ);
command.Parameters.Add("@AboutUser",RegData.About);
command.Parameters.Add("@Subscribe",RegData.Subscribe);
command.Parameters.Add("@Login",RegData.Login);
command.Parameters.Add("@Pwd",RegData.Pwd);
command.Parameters.Add("@Country",RegData.Country);
command.Parameters.Add("@Sity",RegData.City);
command.Parameters.Add("@Status",1);
command.Parameters.Add("@WhereKnow",RegData.WhereKnow);
сommand.ExecuteNonQuery();

Система матюкается

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Prepared statement '(@FName nvarchar(4000),@LName nvarchar(4000),@Prop int,@Group in' expects parameter @FName, which was not supplied. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at tors.ForumService.Register(Reg RegData) in c:\inetpub\wwwroot\tors\forumservice.asmx.cs:line 110 --- End of inner exception stack trace ---


C ув. Tors

command - это SqlCommand
Таблица:

create table Users
(
Usr_ID int IDENTITY(0,1) not null
PRIMARY KEY,
FName varchar(60) not null,
LName varchar(60) not null,
Email varchar(40) not null,
WEB varchar(40),
ICQ varchar(15),
AboutUser varchar(5000),
Subscripte varchar(1000),
Login varchar(10) not null,
Pwd varchar(10) not null,
Premissions int not null,
Group_ID int not null
FOREIGN KEY REFERENCES UserGroup(Group_ID),
Properties int not null,
Country varchar(15),
City varchar(15),
Status int,
WhereKnow int,
RegisterDate datetime
);

C ув. Tors