public void viewclinicdata()
 {
     Code cd = new Code();
     if (Request.QueryString["Clinic"] != null)
     {
         cd.id = Request.QueryString["Clinic"].ToString();
         DataSet ds = cd.View_Clinicddetails();
         if (ds != null && ds.Tables[0].Rows.Count > 0)
         {
             DropDownList1.SelectedValue = ds.Tables[0].Rows[0]["Speciality"].ToString();
             txtname.Value = ds.Tables[0].Rows[0]["Clinicname"].ToString();
             Text1.Value = ds.Tables[0].Rows[0]["Timings"].ToString();
             specialists.Value = ds.Tables[0].Rows[0]["Specialists"].ToString();
             Services.Value = ds.Tables[0].Rows[0]["Services"].ToString();
             insurance.Value = ds.Tables[0].Rows[0]["Insurance"].ToString();
             Text2.Value = ds.Tables[0].Rows[0]["Noofdoctors"].ToString();
             DropDownList2.SelectedValue = ds.Tables[0].Rows[0]["City"].ToString();
             cd.city = ds.Tables[0].Rows[0]["City"].ToString();
             DataSet ds1 = cd.viewlocations();
             if (ds1 != null && ds1.Tables[0].Rows.Count > 0)
             {
                 DropDownList3.DataTextField = "Name";
                 DropDownList3.DataValueField = "ID";
                 DropDownList3.DataSource = ds1;
                 DropDownList3.DataBind();
             }
             DropDownList3.SelectedValue = ds.Tables[0].Rows[0]["Location"].ToString();
             Text3.Value = ds.Tables[0].Rows[0]["Address"].ToString();
             Text4.Value = ds.Tables[0].Rows[0]["contact1"].ToString();
             Text5.Value = ds.Tables[0].Rows[0]["contact2"].ToString();
             Text6.Value = ds.Tables[0].Rows[0]["contact3"].ToString();
             Text7.Value = ds.Tables[0].Rows[0]["contact4"].ToString();
             Text8.Value = ds.Tables[0].Rows[0]["Emailid"].ToString();
             Text10.Value = ds.Tables[0].Rows[0]["Website"].ToString();
             Text13.Value = ds.Tables[0].Rows[0]["Establishedby"].ToString();
             Text14.Value = ds.Tables[0].Rows[0]["Establishedon"].ToString();
             TextArea1.Value = ds.Tables[0].Rows[0]["Aboutclinic"].ToString();
             Text9.Value = ds.Tables[0].Rows[0]["Userid"].ToString();
             Password1.Value = ds.Tables[0].Rows[0]["Password"].ToString();
             HiddenField1.Value = ds.Tables[0].Rows[0]["CID"].ToString();                
             // logo binding //                
             if (ds.Tables[0].Rows[0]["Logo"].ToString() != "")
             {
                 StringBuilder logo = new StringBuilder();
                 logo.Append("<span id='Img_" + ds.Tables[0].Rows[0]["CID"].ToString() + "'>");
                 logo.Append("<img class='thumbimg' src='../Logos/" + ds.Tables[0].Rows[0]["Logo"].ToString() + "' imagepath='" + ds.Tables[0].Rows[0]["Logo"].ToString() + "'>");
                 logo.Append("<a class='thmbrmiconremove' onclick='deleteimage(this)' href='javascript:'>X</a>");
                 logo.Append("</span>");
                 instutelogo.InnerHtml = logo.ToString();
             }
             // Gallery Binding //
             if (ds.Tables[1] != null && ds1.Tables[0].Rows.Count > 0)
             {
                 StringBuilder gallery = new StringBuilder();
                 for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
                 {
                     gallery.Append("<span id='Img_" + ds.Tables[1].Rows[i]["CID"].ToString() + "'>");
                     gallery.Append("<img class='galimag' src='../Gallery/" + ds.Tables[1].Rows[i]["Image"].ToString() + "' imagepath='" + ds.Tables[1].Rows[i]["Image"].ToString() + "'>");
                     gallery.Append("<a class='thmbrmiconremove' onclick='deleteimage(this)' href='javascript:'>X</a>");
                     gallery.Append("</span>");
                 }
                 paintinglogo.InnerHtml = gallery.ToString();
             }
         }
     }
 }