Bir markaya ait ürün yoksa labele yazdırma YARDIM

 
  protected void Page_Load(object sender, EventArgs e) 
          { 
              try 
              { 
                  MyConnection.Open(); 
                  if (Request.QueryString["id"] == null || Request.QueryString["id"] == "") 
                  { 
                      Response.Redirect("Default.aspx"); 
                  } 
                  else 
                  { 
                      string MarkaId = Request.QueryString["id"].ToString(); 
                      SqlCommand Markalar = new SqlCommand("Select Marka From Markalar Where Id = '" + MarkaId + "'", MyConnection); 
                       
                      if (Markalar.ExecuteScalar() == null) 
                      { 
                           LblMarkaSonuc.Text = "Böyle Bir Marka Yok"; 
                      } 
                      else 
                      { 
                          LblMarka.Text = Markalar.ExecuteScalar().ToString(); 
                          UrunListele(); 
                      } 
                  } 
              } 
              catch (Exception Ex) 
              { 
                  LblHata.Text = "Markalar Listelenemedi" + Ex.Message; 
              } 
              finally 
              { 
                  MyConnection.Close(); 
              } 
          } 
          public void UrunListele() 
          { 
              try 
              { 
   
                  string MarkaId = Request.QueryString["Id"].ToString(); 
                  SqlDataAdapter da = new SqlDataAdapter("Select Id, Urunadi,Fiyat,VitrinFotografi From Urunler Where Urunler.MarkaId = '" + MarkaId + "'", MyConnection); 
                  DataSet ds = new DataSet(); 
                  da.Fill(ds); 
   
                      RptUrunler.DataSource = ds; 
                      RptUrunler.DataBind(); 
   
              } 
              catch (Exception Ex) 
              { 
                  LblHata.Text = "Urunler Getirilemedi " + Ex.Message; 
              } 
              finally 
              { 
                  MyConnection.Close(); 
              } 
          } 
  

 
  if(ds.tables[0].rows.count>0) 
  { 
  RptUrunler.DataSource = ds; 
  RptUrunler.DataBind(); 
  } 
  else 
  { 
  LblMarkaSonuc.Text = "Böyle Bir Marka Yok"; 
  }