[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();
}}}
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();
}}}
解决方案 »
- PDFLibNet类库转图片。10页pdf,转换出来只有几页
- C#学习多线程编程,总是不得劲啊
- 100 分 求 c# 多个客户端连接一个服务端解决方案
- cache可否查询和分目录
- share point 中使用自定义列表的问题。
- 用C#如何实现获取本机的物理地址?
- 发送HTML邮件时如何将图片作为邮件体(不是挂附件)发送?
- c#做web开发时, 用外加的ocx问题.
- 窗体问题~在线等待
- 如何实现两个表之间的关联?
- DataGridColumnStyle类中哪个事件是在keyup是发生?
- 兄弟们,谁能提供在C#中将SQL中的数据导出生成HTML文件的方法,thank you very much!
sqlCommand.CommandType=CommandType.StoredProcedure;
SqlParameter para=new SqlParameter("@参数",参数类型);