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();
}
