为什么调用存储过程会出现这样的结果?

[qm0445]

我写了个调用存储过程的程序可是我一调用就出现空白网页为什么会这样？
就是出现500错误
这是我写的存储过程
CREATE PROCEDURE dbo.AddBooking
(
@iFlight int,
@sPassengerID varchar(20),
@iTravelClassID int,
@iBookingID int output
)
AS
begin
set nocount on
insert into Bookings
(flight_id,passenger_id,travel_class_id)
values
(@iFlight,@sPassengerID,@iTravelClassID)
select @iBookingID=@@identity

end
GO
下面是我写的程序
[WebMethod(EnableSession=false)]
public int AddBooking(int flightID,string passengerID,int travelClassID)
{
SqlConnection sqlConnection;
SqlCommand sqlCommand;
SqlDataAdapter sqlDataAdapter;
DataSet dataSet;
sqlConnection=new SqlConnection("data source=minth-190;initial catalog=AirlineServiceProvider;password=sa;persist security info=True;user id=sa;workstation id=MINTH-100;packet size=4096");
try
{
sqlConnection.Open();
SqlParameter paramfilghtID=new SqlParameter("@iFlight",SqlDbType.Int);
paramfilghtID.Value=flightID;
sqlCommand.Parameters.Add(paramfilghtID);
SqlParameter paramPassengerID=new SqlParameter"@sPassengerID",SqlDbType.VarChar,20);
paramPassengerID.Value=passengerID;
sqlCommand.Parameters.Add(paramPassengerID);
SqlParameter paramTravelClassID=new SqlParameter("@iTravelClassID",SqlDbType.Int);
paramTravelClassID.Value=travelClassID;
sqlCommand.Parameters.Add(paramTravelClassID);
SqlParameter paramBookingID=new SqlParameter("@iBooingID",SqlDbType.Int);
paramBookingID.Direction=ParameterDirection.Output;
sqlCommand.Parameters.Add(paramBookingID);
qlCommand.ExecuteNonQuery();
int bookingID=Convert.ToInt32(sqlCommand.Parameters["@iBooingID"].Value);
return bookingID;
}
catch(Exception exx)
{
throw exx;
}
finally
{
if(sqlConnection.State==ConnectionState.Open)
{
sqlConnection.Close();
}}}
我是写了个WEB服务的方法在通过客户端调用！谢谢！我 很着急！

[CMIC]

[WebMethod(EnableSession=false)]
public int AddBooking(int flightID,string passengerID,int travelClassID)
{
SqlConnection sqlConnection;
SqlCommand sqlCommand;
SqlDataAdapter sqlDataAdapter;
DataSet dataSet;
sqlConnection=new SqlConnection("data source=minth-190;initial catalog=AirlineServiceProvider;password=sa;persist security info=True;user id=sa;workstation id=MINTH-100;packet size=4096");
try
{
sqlConnection.Open();

sqlCommand=new SqlCommand("AddBooking");
sqlCommand.CommandType=CommandType.StoredProcedure;
//加入这两句
SqlParameter paramfilghtID=new SqlParameter("@iFlight",SqlDbType.Int);
paramfilghtID.Value=flightID;
sqlCommand.Parameters.Add(paramfilghtID);
SqlParameter paramPassengerID=new SqlParameter"@sPassengerID",SqlDbType.VarChar,20);
paramPassengerID.Value=passengerID;
sqlCommand.Parameters.Add(paramPassengerID);
SqlParameter paramTravelClassID=new SqlParameter("@iTravelClassID",SqlDbType.Int);
paramTravelClassID.Value=travelClassID;
sqlCommand.Parameters.Add(paramTravelClassID);
SqlParameter paramBookingID=new SqlParameter("@iBooingID",SqlDbType.Int);
paramBookingID.Direction=ParameterDirection.Output;
sqlCommand.Parameters.Add(paramBookingID);
qlCommand.ExecuteNonQuery();
int bookingID=Convert.ToInt32(sqlCommand.Parameters["@iBooingID"].Value);
return bookingID;
}
catch(Exception exx)
{
throw exx;
}
finally
{
if(sqlConnection.State==ConnectionState.Open)
{
sqlConnection.Close();
}}}

[qm0445]

我早就加过了可是没用呀!

[qm0445]

UP

[qm0445]

没人知道吗？

[91bct]

看看是不是少了如下两句：
sqlCommand.CommandType=CommandType.StoredProcedure;
SqlParameter para=new SqlParameter("@参数",参数类型);

[qm0445]

兄弟我都试过了就是不行呀！真是奇怪的事情！

[东村的三小子]

在查询分析器下先试一下，可能环境有问题。

[JJ77]

500的错误,我怀疑不是Sql上的,可能是运行环境的问题

[qm0445]

呵呵我已经解决了！谢
！大家！