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 DetailsOfSearch : System.Web.UI.Page
{
    string com;
    OleDbConnection conn;
    connection objconn = new connection();
    protected void Page_Load(object sender, EventArgs e)
    {
        conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Domains\nid.edu\db\database.mdb;Persist Security Info=True");        
        //conn=objconn.getconn();
        lbltitle.Text = Request.QueryString["email"];
        if (!IsPostBack)
        {
            griddetailview();
        }
    }
    protected void griddetailview()
    {
        OleDbCommand cmd = new OleDbCommand("select G_TITLE + ' ' + FIRST_NAME + ' ' + LAST_NAME AS Name,Discipline,yr_splsn,email,bus_title,bus_ADD1 +' '+ bus_ADD2 +' '+ Bus_Add3 as b_Address,organisatn,bus_city,bus_citycd,bus_county,bus_State,bus_phone,bus_fax,HM_ADD1 + ' ' + HM_ADD2 + ' ' + HM_ADD3 AS Address,hm_city,hm_city,hm_city_cd,hm_state,hm_country,hm_phone from MemberMaster where email='" + lbltitle.Text + "'", conn);
        //OleDbCommand cmd = new OleDbCommand("select YR_SPLSN,bus_title,organisatn, HM_ADD1 + ' ' + HM_ADD2 + ' ' + HM_ADD3 AS Address,HM_CITY,HM_STATE,HM_COUNTRY,EMAIL,bus_ADD1 +' '+ bus_ADD2 +' '+ Bus_Add3 as b_Address,bus_city,bus_state,bus_country,bus_phone,bus_fax,bus_p,hm_p,hm_phone,Discipline, G_TITLE + ' ' + FIRST_NAME + ' ' + LAST_NAME AS Name from MemberMaster where email='" + lbltitle.Text + "'", conn);
        OleDbDataAdapter dap = new OleDbDataAdapter(cmd);
        DataTable dt = new DataTable();
        dap.Fill(dt);

        detailGrid.DataSource = dt;
        detailGrid.DataBind();
        
    }
}