大家帮我看看这样写错在哪里??
mycon.ConnectionString = PublicVar.GstrCon;
SqlCommand cmd = new SqlCommand("GetMailbox",mycon);
mycon.ConnectionString = PublicVar.GstrCon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
cmd.Parameters.Add("@EmpID",SqlDbType.Int);
cmd.Parameters["@EmpID"].Value = empid;
cmd.Parameters.Add("@MailboxID",SqlDbType.Int);
cmd.Parameters["@MailboxID"].Value = mailboxid;
SqlDataReader myReader;
myReader = cmd.ExecuteReader();
string smtp= myReader["@smtp"].ToString().Trim();
string user = myReader["@user"].ToString().Trim();
cmd.Connection.Close();
cmd.Dispose();
我的存储过程这样定义的:
CREATE procedure GetMailbox (@EmpID int,@MailboxID int) as
declare @smtp char(50)
declare @user char(20)
declare @userpwd char(20)
declare @mailbox char(100)
declare @smtpport int
declare @pop char(50)
declare @popport int
select @smtp = smtpserver,@user = username,@userpwd = userpwd,
@mailbox = mailbox,@smtpport = smtpport,@pop = popserver,@popport = popport
from mailbox
where empid = @EmpID and mailboxid = @MailboxID
return
go