using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.OleDb; public partial class AddVessel : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { string conString = @"provider=Microsoft.Jet.OLEDB.4.0;user id=;password=; data source=" + Server.MapPath("./db/DataBank.mdb"); AddVesselDataSource.ConnectionString = conString; AddVesselDataSource.ProviderName = "System.Data.OleDb"; } protected void btnAddVessel_Click(object sender, EventArgs e) { AddVesselDataSource.InsertParameters["VesselName"].DefaultValue = txtVesselName.Text; AddVesselDataSource.InsertParameters["SEN"].DefaultValue = txtSEN.Text; AddVesselDataSource.InsertParameters["ETA"].DefaultValue = txtETA.Text; AddVesselDataSource.InsertParameters["CargoAndTonnage"].DefaultValue = txtCargo.Text; AddVesselDataSource.InsertParameters["BerthingProspect"].DefaultValue = txtBerthing.Text; AddVesselDataSource.InsertParameters["DischargeProspect"].DefaultValue = txtDischarge.Text; AddVesselDataSource.Insert(); Response.Redirect("VesselList.aspx"); /*txtVesselName.Text = ""; txtSEN.Text = " "; txtETA.Text = " "; txtCargo.Text = ""; txtBerthing.Text = ""; txtDischarge.Text = "";*/ } }