添加记录成功，可数据库里没有啊？急～～～
namespace mobile
{
public class sp
{
public string additem_interview(string ComName,string ComJobKind,string ComStation,string ComEducationNeed,
string ComPay,string ComAgeNeed,string ComDetail,string Comtelphone,string ComType,string AreaNumber,string IssueName)
{
SqlConnection sqlconn=new SqlConnection("server=localhost;uid=sa;pwd=1234;database=123");
SqlCommand mycommand=new SqlCommand("sp_item_isp_interview",sqlconn);
mycommand.CommandType=CommandType.StoredProcedure;
SqlParameter parameterAreaNumber=new SqlParameter("@AreaNumber",SqlDbType.NVarChar,20);
parameterAreaNumber.Value=AreaNumber;
mycommand.Parameters.Add(parameterAreaNumber);
SqlParameter parameterComName=new SqlParameter("@ComName",SqlDbType.NVarChar,50);
parameterComName.Value=ComName;
mycommand.Parameters.Add(parameterComName);
SqlParameter parameterComJobKind=new SqlParameter("@ComJobKind",SqlDbType.SmallInt,4);
parameterComJobKind.Value=ComJobKind;
mycommand.Parameters.Add(parameterComJobKind);
SqlParameter parameterComStation=new SqlParameter("@ComStation",SqlDbType.NVarChar,50);
parameterComStation.Value=ComStation;
mycommand.Parameters.Add(parameterComStation);
SqlParameter parameterComEducationNeed=new SqlParameter("@ComEducationNeed",SqlDbType.SmallInt,4);
parameterComEducationNeed.Value=ComEducationNeed;
mycommand.Parameters.Add(parameterComEducationNeed);
SqlParameter parameterComPay=new SqlParameter("@ComPay",SqlDbType.SmallInt,4);
parameterComPay.Value=ComPay;
mycommand.Parameters.Add(parameterComPay);
SqlParameter parameterComDetail=new SqlParameter("@ComDetail",SqlDbType.Text,200);
parameterComDetail.Value=ComDetail;
mycommand.Parameters.Add(parameterComDetail);
SqlParameter parameterComAgeNeed=new SqlParameter("@ComAgeNeed",SqlDbType.SmallInt,4);
parameterComAgeNeed.Value=ComAgeNeed;
mycommand.Parameters.Add(parameterComAgeNeed);
SqlParameter parameterComtelphone=new SqlParameter("@Comtelphone",SqlDbType.NVarChar,20);
parameterComtelphone.Value=Comtelphone;
mycommand.Parameters.Add(parameterComtelphone);
SqlParameter parameterComType=new SqlParameter("@ComType",SqlDbType.TinyInt,1);
parameterComType.Value=ComType;
mycommand.Parameters.Add(parameterComType);
SqlParameter parameterIssueName=new SqlParameter("@IssueName",SqlDbType.NVarChar,20);
parameterIssueName.Value=IssueName;
mycommand.Parameters.Add(parameterIssueName);
try
{
sqlconn.Open();
mycommand.ExecuteNonQuery();
sqlconn.Close();
return "1";
}
catch(SqlException SQLexc)
{
return SQLexc.ToString();
}
}
}
}
存储过程是
ALTER PROCEDURE sp_item_isp_interview
/*
(
@parameter1 datatype = default value,
@parameter2 datatype OUTPUT
)
*/
(
@ComName Varchar(50),@ComJobKind smallint,@ComStation Varchar(50),@ComEducationNeed smallint,
@ComPay smallint,@ComAgeNeed smallint,@ComDetail text,@Comtelphone Varchar(20),@ComType tinyint,@AreaNumber VarChar(20),@IssueName varchar(20)
)
AS
/* SET NOCOUNT ON */
insert into ywishcominviteinfo(ComName,ComJobKind,ComStation,ComEducationNeed,
ComPay,ComAgeNeed,ComDetail,Comtelphone,ComType,AreaNumber,pingbi,IssueName)
values(@ComName,@ComJobKind,@ComStation,@ComEducationNeed,
@ComPay,@ComAgeNeed,@ComDetail,@Comtelphone,@ComType,@AreaNumber,0,@IssueName)
RETURN
麻烦大家帮忙看下．是什么原因啊？谢谢～～
问题点数：20、回复次数：0Top
