string sConnectionString = "Data Source=.;Initial Catalog=ASPNETDB;Persist Security Info=True;User ID=niit;Password=niitsql";
SqlConnection objConn = new SqlConnection(sConnectionString);
objConn.Open();
string sSQL = "INSERT INTO Passenger " +
"(PnrNo, FlightNo,TravelDate,Name,Class,SeatPref,MealPref,Status) " +
"VALUES(@PnrNo,@FlightNo,@TravelDate,@Name,@Class,@SeatPref,@MealPref,@Status)";
SqlCommand insertCmd = new SqlCommand(sSQL, objConn);
/* try
{
insertCmd.ExecuteNonQuery();
}
catch (System.Exception en)
{ lblMessage.Text="订票失败";
}
*/
//Console.WriteLine("Record Added");
//insertCmd.Parameters.Add("@PnrNo", SqlDbType.Char,10);
insertCmd.Parameters.Add("@PnrNo", SqlDbType.Char, 10);
insertCmd.Parameters["@PnrNo"].Value = TtbID.Text; insertCmd.Parameters.Add("@FlightNo", SqlDbType.Char, 10);
insertCmd.Parameters["@FlightNo"].Value = DdlFlight.Text; insertCmd.Parameters.Add("@TravelDate", SqlDbType.DateTime);
insertCmd.Parameters["@TravelDate"].Value = DdtDate.Text; insertCmd.Parameters.Add("@Name", SqlDbType.Char, 10);
insertCmd.Parameters["@Name"].Value = TtbName.Text; insertCmd.Parameters.Add("@Class", SqlDbType.Char, 10);
insertCmd.Parameters["@Class"].Value = lstClass.Text; insertCmd.Parameters.Add("@SeatPref", SqlDbType.Char, 10);
insertCmd.Parameters["@SeatPref"].Value = lstSeat.Text; insertCmd.Parameters.Add("@MealPref", SqlDbType.Char, 10);
insertCmd.Parameters["@MealPref"].Value = lstMeal.Text; insertCmd.Parameters.Add("@Status", SqlDbType.Char, 10);
insertCmd.Parameters["@Status"].Value = lstOder.Text; /*
insertCmd.Connection.Close();
*/
objConn.Close(); try
{
//insertCmd.Connection.Open();
insertCmd.ExecuteNonQuery();
//insertCmd.Connection.Close();
} catch (System.Exception en)
{
lblMessage.Text = "订票失败";
}
}
}
SqlConnection objConn = new SqlConnection(sConnectionString);
objConn.Open();
string sSQL = "INSERT INTO Passenger " +
"(PnrNo, FlightNo,TravelDate,Name,Class,SeatPref,MealPref,Status) " +
"VALUES(@PnrNo,@FlightNo,@TravelDate,@Name,@Class,@SeatPref,@MealPref,@Status)";
SqlCommand insertCmd = new SqlCommand(sSQL, objConn);
/* try
{
insertCmd.ExecuteNonQuery();
}
catch (System.Exception en)
{ lblMessage.Text="订票失败";
}
*/
//Console.WriteLine("Record Added");
//insertCmd.Parameters.Add("@PnrNo", SqlDbType.Char,10);
insertCmd.Parameters.Add("@PnrNo", SqlDbType.Char, 10);
insertCmd.Parameters["@PnrNo"].Value = TtbID.Text; insertCmd.Parameters.Add("@FlightNo", SqlDbType.Char, 10);
insertCmd.Parameters["@FlightNo"].Value = DdlFlight.Text; insertCmd.Parameters.Add("@TravelDate", SqlDbType.DateTime);
insertCmd.Parameters["@TravelDate"].Value = DdtDate.Text; insertCmd.Parameters.Add("@Name", SqlDbType.Char, 10);
insertCmd.Parameters["@Name"].Value = TtbName.Text; insertCmd.Parameters.Add("@Class", SqlDbType.Char, 10);
insertCmd.Parameters["@Class"].Value = lstClass.Text; insertCmd.Parameters.Add("@SeatPref", SqlDbType.Char, 10);
insertCmd.Parameters["@SeatPref"].Value = lstSeat.Text; insertCmd.Parameters.Add("@MealPref", SqlDbType.Char, 10);
insertCmd.Parameters["@MealPref"].Value = lstMeal.Text; insertCmd.Parameters.Add("@Status", SqlDbType.Char, 10);
insertCmd.Parameters["@Status"].Value = lstOder.Text; /*
insertCmd.Connection.Close();
*/
objConn.Close(); try
{
//insertCmd.Connection.Open();
insertCmd.ExecuteNonQuery();
//insertCmd.Connection.Close();
} catch (System.Exception en)
{
lblMessage.Text = "订票失败";
}
}
}
哥子,这句话应该是没有问题的.是我对控件进行数据绑定的时候生成在web.config中的, 是VS2005自动连接SQL Server2005生成,然后我把它拷出来用的