how to retrieve the images from database and display it on webpage in slider in asp.net.This images can be added or removed dynamically from admin.

Following code will give the idea for showing image from database



string roll_no = "Your Search Parameter"
string sConn = System.Configuration.ConfigurationManager.ConnectionStrings["YOUR_CONNECTIONSTRING_NAME"].ToString();
SqlConnection objConn = new SqlConnection(sConn);
objConn.Open();
string sTSQL = "select img from Images where Roll_no=@roll_no";
SqlCommand objCmd = new SqlCommand(sTSQL, objConn);
objCmd.CommandType = CommandType.Text;
objCmd.Parameters.AddWithValue("@roll_no", roll_no.ToString());
object data = objCmd.ExecuteScalar(); //THIS WILL TAKE YOUR IMAGE AS OBJECT
objConn.Close();
objCmd.Dispose();
context.Response.BinaryWrite((byte[])data);//THIS WILL WRITE YOUR IMAGE ON SCREEN


-------------------------------------------------------------------------
Image1.ImageUrl = "ImageHandler.ashx?roll_no=" + txtrollno.Text; //IMAGE URL


=>ImageHandler.ashx // THIS IS A HANDLER WHERE ALL THE ABOVE CODE TO BE WRITTEN
STEPS TO CREATE HANDLER :-
ADD NEW ITEMS =>SELECT GENERIC HANDLER.