Comments by Swayam231 (Top 81 by date)

protected void Page_Load(object sender, EventArgs e)
{

string strConn = "Data Source=SWAYAM;Initial Catalog=Swayam;Integrated Security=SSPI; ";
SqlConnection con = new SqlConnection(strConn);
con.Open();
//panel1
string st = "select top 1 name,author,price from image4 order by Row_id desc";
SqlCommand cmd = new SqlCommand(st, con);
SqlDataReader sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
string name = "";
string author = "";
string price = "";

if (sdr.Read())
{
name = sdr["name"].ToString();
author = sdr["author"].ToString();
price = sdr["price"].ToString();

}
sdr.Close();
con.Close();

//panel2
SqlConnection con2 = new SqlConnection(strConn);
con2.Open();
string st2="Select name, author, price from image4 where Row_id=(select max(Row_id)-1 from image4)";
SqlCommand cmd2 = new SqlCommand(st2, con2);
SqlDataReader sdr2 = cmd2.ExecuteReader(CommandBehavior.CloseConnection);
string name2="";
string author2="";
string price2="";

if (sdr2.Read())
{
name2 = sdr2["name"].ToString();
author2 = sdr2["author"].ToString();
price2 = sdr2["price"].ToString();
}
sdr2.Close();
con2.Close();

//panel3
SqlConnection con3 = new SqlConnection(strConn);
con3.Open();
string st3 = "Select name, author, price from image4 where Row_id=(select max(Row_id)-2 from image4)";
SqlCommand cmd3 = new SqlCommand(st3, con3);
SqlDataReader sdr3 = cmd3.ExecuteReader(CommandBehavior.CloseConnection);
string name3 = "";
string author3 = "";
string price3 = "";

if (sdr3.Read())
{
name3 = sdr3["name"].ToString();
author3 = sdr3["author"].ToString();
price3 = sdr3["price"].ToString();
}
sdr3.Close();
con3.Close();

Label1.Text = name;
Label2.Text = author;
Label3.Text = "Rs."+ price;
Label4.Text = name2;
Label5.Text = author2;
Label6.Text = "Rs."+ price2;
Label7.Text = name3;
Label8.Text = author3;
Label9.Text = "Rs."+ price3;
Image1.ImageUrl="~/Image handler.ashx?pid=0";
Image2.ImageUrl = "~/Image handler.ashx?pid=1";
Image3.ImageUrl = "~/Image handler.ashx?pid=2";
}

thanks buddy...
i feel that u edit that ms. to mr. !!!
I already did that check answer

Those are codes written in two different pages buddy not in the same one...
One is generic handler.ashx and the other is default.aspx.. You just can't write lbl.text=name!!!