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 Search : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
       
    }
   
    protected void btnSearchVessel_Click(object sender, EventArgs e)
    {
        string conString = @"provider=Microsoft.Jet.OLEDB.4.0;user id=;password=; data source=" + Server.MapPath("./db/DataBank.mdb");

        OleDbDataReader dr;
        OleDbCommand cmd;
        OleDbConnection conn = new OleDbConnection(conString);
        string query;

        if(dpSearchVessel.SelectedValue == "Vessel")
        {
            ContainerFormView.Visible = false;
            conn.Open();
            query = "SELECT * FROM Vessels WHERE VesselName='" + txtSearchVessel.Text + "'";
            cmd = new OleDbCommand(query,conn);
            dr = cmd.ExecuteReader();
            VesselFormView.DataSource = dr;
            VesselFormView.DataBind();
            VesselFormView.Visible = true;
            dr.Close();
            conn.Close();
        }
        else if(dpSearchVessel.SelectedValue == "Container")
        {
            VesselFormView.Visible = false;
            conn.Open();
            query = "SELECT * FROM Containers WHERE CustomRotationNumber ='" + txtSearchVessel.Text + "'";
            cmd = new OleDbCommand(query,conn);
            dr = cmd.ExecuteReader();
            ContainerFormView.DataSource = dr;
            ContainerFormView.DataBind();
            ContainerFormView.Visible = true;
            dr.Close();
            conn.Close();
        }
      
    }
}