How to fetch image from database using jquery

 

---

here is my default.aspx.cs page

private void BindDummyItem()
{
DataTable dummy = new DataTable();
dummy.Columns.Add("Id");
dummy.Columns.Add("Title");
dummy.Columns.Add("Price");
dummy.Columns.Add("Description");
dummy.Columns.Add("Image");
dummy.Columns.Add("City");
dummy.Columns.Add("Location");
int count = dlProducts.RepeatColumns == 0 ? 1 : dlProducts.RepeatColumns;
for (int i = 0; i < count; i++)
{
dummy.Rows.Add();
}
dlProducts.DataSource = dummy;
dlProducts.DataBind();
this.RepeatColumns = dlProducts.RepeatColumns == 0 ? 1 : dlProducts.RepeatColumns;
}
[WebMethod]
public static string GetProducts(int start, int end)
{
//System.Threading.Thread.Sleep(2000);
string strConnString = ConfigurationManager.ConnectionStrings["Constr"].ConnectionString;
DataSet ds = new DataSet();
using (SqlConnection con = new SqlConnection(strConnString))
{
string query = "select Id,C_id,S_id,Title,Description,Image,Contact,Price,Name,Email,City,Location,IsActive from [findeasy].[To_Let_Table] where (Price BETWEEN @Start AND @End) OR (@Start = 0 AND @End = 0)";
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
cmd.Parameters.AddWithValue("@Start", start);
cmd.Parameters.AddWithValue("@End", end);
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
sda.Fill(ds, "To_Let_Table");
}
}
}
DataTable dt = new DataTable();
dt.TableName = "Range";
using (SqlConnection con = new SqlConnection(strConnString))
{
string query = "SELECT MIN(Price) [Min], MAX(Price) [Max] FROM [findeasy].[To_Let_Table]";
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
sda.Fill(dt);
}
}
}
ds.Tables.Add(dt);
return ds.GetXml();
}
public string FormatImage(object img)// for image showing in grid view ../ before image
{
string path = "";
if (img != null && !String.IsNullOrEmpty(img.ToString()))
{
path = "../" + img.ToString();
}
return path;
}