assaultkitty
asked on
Airline file
using System;
using System.Collections.Generic ;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack
&& enrollmentForm.ActiveViewI ndex == 0)
hiddenPassword.Value = password.Text;
}
protected void Page_LoadComplete(
object sender, EventArgs e)
{
if (Page.IsPostBack
&& enrollmentForm.ActiveViewI ndex == 3)
{
SqlConnection dbConnection
= new SqlConnection(
"Data Source=.\\SQLEXPRESS; AttachDbFilename=C:\\Cours e Technology\\CIS Programming\\ASP .NET Programming\\Data Files\\Chapter.09\\Chapter \\SkywardA viation.md f; Integrated Security=True; User Instance=True");
}
try
{
dbConnection.Open();
SqlCommand sqlCommand = new SqlCommand(
"INSERT INTO FrequentFlyers (last, first,
phone, email, password, cardType,
expireMonth, expireYear, cardnumber,
cardholder, address, city, state, zip,
travelerType, homeAirport, class, seat,
meal) VALUES("
+ "'" + lastName.Text + "',"
+ "'" + firstName.Text + "',"
+ "'" + telephone.Text + "',"
+ "'" + email.Text + "',"
+ "'" + hiddenPassword.Value + "',"
+ "'" + creditcard.Text + "',"
+ "'" + expireMonth.Text + "',"
+ "'" + expireYear.Text + "',"
+ "'" + cardnumber.Text + "',"
+ "'" + cardholder.Text + "',"
+ "'" + address.Text + "',"
+ "'" + city.Text + "',"
+ "'" + state.Text + "',"
+ "'" + zip.Text + "',"
+ "'" + travelerType.Text + "',"
+ "'" + homeAirport.Text + "',"
+ "'" + serviceClass.Text + "',"
+ "'" + seatPreference.Text + "',"
+ "'" + mealRequest.Text + "',)",
dbConnection);
sqlCommand.ExecuteNonQuery ();
SqlCommand = new SqlCommand(
"SELECT IDENT_CURRENT('FrequentFly ers')",
dbConnection);
SqlDataReader lastID=
SqlCommand.ExecuteReader() ;
if(lastID.read())
successString.Text +=
"<h3>Enrollment Sucessful</h3>
<p>Your frequent flyer number is " + lastID.GetValue(0) + ".</p>";
}
catch (SqlException exception)
{
successString.Text += "<p>Error code "
+ exception.Number
+ ": " + exception.Message + "</p>";
}
dbConnection.Close();
}
}
Dear expert I get an error when I run this file. First, the + sign at the .Text are giving me errors. Can you help me this is homework?
homework-image.pdf
using System.Collections.Generic
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack
&& enrollmentForm.ActiveViewI
hiddenPassword.Value = password.Text;
}
protected void Page_LoadComplete(
object sender, EventArgs e)
{
if (Page.IsPostBack
&& enrollmentForm.ActiveViewI
{
SqlConnection dbConnection
= new SqlConnection(
"Data Source=.\\SQLEXPRESS; AttachDbFilename=C:\\Cours
}
try
{
dbConnection.Open();
SqlCommand sqlCommand = new SqlCommand(
"INSERT INTO FrequentFlyers (last, first,
phone, email, password, cardType,
expireMonth, expireYear, cardnumber,
cardholder, address, city, state, zip,
travelerType, homeAirport, class, seat,
meal) VALUES("
+ "'" + lastName.Text + "',"
+ "'" + firstName.Text + "',"
+ "'" + telephone.Text + "',"
+ "'" + email.Text + "',"
+ "'" + hiddenPassword.Value + "',"
+ "'" + creditcard.Text + "',"
+ "'" + expireMonth.Text + "',"
+ "'" + expireYear.Text + "',"
+ "'" + cardnumber.Text + "',"
+ "'" + cardholder.Text + "',"
+ "'" + address.Text + "',"
+ "'" + city.Text + "',"
+ "'" + state.Text + "',"
+ "'" + zip.Text + "',"
+ "'" + travelerType.Text + "',"
+ "'" + homeAirport.Text + "',"
+ "'" + serviceClass.Text + "',"
+ "'" + seatPreference.Text + "',"
+ "'" + mealRequest.Text + "',)",
dbConnection);
sqlCommand.ExecuteNonQuery
SqlCommand = new SqlCommand(
"SELECT IDENT_CURRENT('FrequentFly
dbConnection);
SqlDataReader lastID=
SqlCommand.ExecuteReader()
if(lastID.read())
successString.Text +=
"<h3>Enrollment Sucessful</h3>
<p>Your frequent flyer number is " + lastID.GetValue(0) + ".</p>";
}
catch (SqlException exception)
{
successString.Text += "<p>Error code "
+ exception.Number
+ ": " + exception.Message + "</p>";
}
dbConnection.Close();
}
}
Dear expert I get an error when I run this file. First, the + sign at the .Text are giving me errors. Can you help me this is homework?
homework-image.pdf
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER