protected void Page_Load(object sender, EventArgs e) { AdvertDisplay cn = new AdvertDisplay(); if (cn.con.State == ConnectionState.Closed) { cn.con.Open(); } SqlCommand cmd = cn.con.CreateCommand(); string query = string.Format("SELECT * FROM advert WHERE ID='"+ Request.QueryString["id"] +"'"); string producttype = string.Format("Select category FROM Advert WHERE ID='" + Request.QueryString["id"] + "'"); cmd.CommandType = CommandType.Text; cmd.CommandType = CommandType.Text; cmd.CommandText = producttype; cattype = (string)cmd.ExecuteScalar(); cmd.CommandText = query; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dta = new DataTable(); da.Fill(dta); ListView2.DataSource = dta; ListView2.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { AdvertDisplay advertConnection = new AdvertDisplay(); advertConnection.OpenAdvertConnection("Real Estate"); DataTable advertDataTable = advertConnection.GetAdvertDataTable(); lvRealEstate.DataSource = advertDataTable; lvRealEstate.DataBind(); advertConnection.CloseAdvertConnection(); }
public void BindList() { AdvertDisplay cn = new AdvertDisplay(); if (cn.con.State == ConnectionState.Closed) { cn.con.Open(); } SqlCommand cmd = cn.con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "select image1,Adtitle,price,phone,id from advert where category='Vehicle'"; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); ListView1.DataSource = dt; ListView1.DataBind(); cn.con.Close(); da.Dispose(); dt.Clear(); }
public void BindList() { // SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=ForSale;User ID=sa;password=pa55"); // Adsconnection cn = new Adsconnection(); AdvertDisplay cn = new AdvertDisplay(); if (cn.con.State == ConnectionState.Closed) { cn.con.Open(); } SqlCommand cmd = cn.con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT TOP(6) image1,Adtitle,price,phone,id FROM advert ORDER BY NEWID()"; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); lvsidebar.DataSource = dt; lvsidebar.DataBind(); cn.con.Close(); da.Dispose(); dt.Clear(); }
public void CloseAdvertConnection() { AdvertDisplay advertConnection = new AdvertDisplay(); con.Close(); }