<?xml version="1.0" encoding="iso-8859-9" ?>
<?xml-stylesheet type="text/xsl" href="RSS_xslt_style.asp" version="1.0" ?>
<rss version="2.0" xmlns:WebWizForums="https://syndication.webwiz.net/rss_namespace/">
 <channel>
  <title>Clomosy | Forum : SQL LİSTVİEW BAĞLANTI</title>
  <link>https://forum.clomosy.com.tr/</link>
  <description><![CDATA[XML içerik linki; Clomosy | Forum : Genel &#304;&#351;lemler : SQL LİSTVİEW BAĞLANTI]]></description>
  <copyright>Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved.</copyright>
  <pubDate>Mon, 04 May 2026 13:00:45 +0000</pubDate>
  <lastBuildDate>Tue, 03 Sep 2024 15:27:44 +0000</lastBuildDate>
  <docs>http://blogs.law.harvard.edu/tech/rss</docs>
  <generator>Web Wiz Forums 12.07</generator>
  <ttl>360</ttl>
  <WebWizForums:feedURL>https://forum.clomosy.com.tr/RSS_post_feed.asp?TID=815</WebWizForums:feedURL>
  <image>
   <title><![CDATA[Clomosy | Forum]]></title>
   <url>https://forum.clomosy.com.tr/forum_images/logo.png</url>
   <link>https://forum.clomosy.com.tr/</link>
  </image>
  <item>
   <title><![CDATA[SQL LİSTVİEW BAĞLANTI : Merhaba Cafer,A&#351;a&#287;&#305;daki linki...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=815&amp;PID=1785#1785</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=106">Developer</a><br /><strong>Konu:</strong> 815<br /><strong>Gönderim Zamanı:</strong> 03&nbsp;Eylül&nbsp;2024 Saat 15:27<br /><br />Merhaba Cafer,<div>Aşağıdaki linki inceler misin?</div><div><a href="https://www.docs.clomosy.com/index.php/TclListView" target="_blank" rel="nofollow">https://www.docs.clomosy.com/index.php/TclListView</a></div><div><br></div>]]>
   </description>
   <pubDate>Tue, 03 Sep 2024 15:27:44 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=815&amp;PID=1785#1785</guid>
  </item> 
  <item>
   <title><![CDATA[SQL LİSTVİEW BAĞLANTI : var IlanForm: TclForm; IlansearchEdit:...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=815&amp;PID=1482#1482</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=205">cafer kosker</a><br /><strong>Konu:</strong> 815<br /><strong>Gönderim Zamanı:</strong> 06&nbsp;Ağustos&nbsp;2024 Saat 17:31<br /><br /><div>var</div><div>&nbsp; IlanForm: TclForm;</div><div>&nbsp; IlansearchEdit: TclProSearchEdit;</div><div>&nbsp; IlansearchPanel, TopPanel, HorzPanel: TclProPanel;</div><div>&nbsp; CategoryScrollBox: TclHorzScrollBox;</div><div>&nbsp; ButtonPanel: TclProPanel;</div><div>&nbsp; CategoryButton: TclProButton;</div><div>&nbsp; CategoryLabel: TclProLabel;</div><div>&nbsp; counter: Integer;</div><div>&nbsp; ImageURLs: array&#091;0..11&#093; of string;</div><div>&nbsp; CategoryNames: array&#091;0..11&#093; of string;</div><div>&nbsp; IlanListView : TClProListView;</div><div>&nbsp; IlanDesignerPanel : TClProListViewDesignerPanel;</div><div>&nbsp; IlanPicture,IlanYildizImg : TclProImage;</div><div>&nbsp; IlanName,IlanKonum,IlanPrice,IlanTarih,IlanYildiz,IlanPuan,IlanLabelGece : TclProLabel;</div><div>&nbsp; IlanQuery: TClSqlQuery;</div><div><br></div><div>void CreateIlanListView;</div><div>{</div><div>&nbsp; IlanListView = IlanForm.AddNewProListView(IlanForm, 'IlanListView');</div><div>&nbsp; IlanListView.Height = IlanForm.clHeight - TopPanel.Height - HorzPanel.Height;</div><div>&nbsp; IlanListView.Width = 200;</div><div>&nbsp; IlanListView.Align = alClient;</div><div>&nbsp; IlanListView.clProSettings.BorderColor = clAlphaColor.clHexToColor('#070807');</div><div>&nbsp; IlanListView.ListType = 'Cart';</div><div>&nbsp; IlanListView.clProSettings.ItemSpace = 50;</div><div>&nbsp; IlanListView.clProSettings.ItemHeight = 300;</div><div>&nbsp; IlanListView.clProSettings.BorderWidth = 1;</div><div>&nbsp; IlanListView.SetclProSettings(IlanListView.clProSettings);</div><div>&nbsp; IlansearchEdit.TargetListView = IlanListView;</div><div>}</div><div><br></div><div>void CreateListDesignerPanel;</div><div>{</div><div>&nbsp; IlanDesignerPanel = IlanForm.AddNewProListViewDesignerPanel(IlanListView, 'IlanDesignerPanel');</div><div>&nbsp; IlanDesignerPanel.Align = alClient;</div><div>&nbsp; IlanDesignerPanel.Height = 300;</div><div>&nbsp; IlanDesignerPanel.Width = 70;</div><div>&nbsp; IlanDesignerPanel.Margins.Top = 10;</div><div>&nbsp; IlanDesignerPanel.Margins.Bottom = 10;</div><div>&nbsp; IlanDesignerPanel.Margins.Right = 10;</div><div>&nbsp; IlanDesignerPanel.Margins.Left = 10;</div><div>&nbsp; IlanDesignerPanel.clProSettings.BackgroundColor = clAlphaColor.clHexToColor('#5AB2FF');</div><div>&nbsp; IlanDesignerPanel.clProSettings.RoundHeight = 10;</div><div>&nbsp; IlanDesignerPanel.clProSettings.RoundWidth = 10;</div><div>&nbsp; IlanListView.SetDesignerPanel(IlanDesignerPanel);</div><div>&nbsp; IlanDesignerPanel.SetclProSettings(IlanDesignerPanel.clProSettings);</div><div>}</div><div><br></div><div>void ResimEkle;</div><div>{</div><div>&nbsp; IlanPicture = IlanForm.AddNewProImage(IlanDesignerPanel, 'IlanPicture');</div><div>&nbsp; IlanDesignerPanel.AddPanelObject(IlanPicture, clImage1);</div><div>&nbsp; IlanPicture.Align = alCenter;</div><div>&nbsp; IlanPicture.Width = 300;</div><div>&nbsp; IlanPicture.Height = 200;</div><div>&nbsp; IlanPicture.clProSettings.PictureAutoFit = True;</div><div>&nbsp; IlanPicture.clProSettings.PictureStretch = True;</div><div>&nbsp; IlanPicture.SetclProSettings(IlanPicture.clProSettings);</div><div>}</div><div><br></div><div>void KonumEkle;</div><div>{</div><div>&nbsp; IlanKonum = IlanForm.AddNewProLabel(IlanDesignerPanel, 'IlanKonum', 'Konum');</div><div>&nbsp; IlanDesignerPanel.AddPanelObject(IlanKonum, clText);</div><div>&nbsp; IlanKonum.Align = alBottom;</div><div>&nbsp; IlanKonum.Properties.AutoSize = True;</div><div>&nbsp; IlanKonum.clProSettings.FontSize = 12;</div><div>&nbsp; IlanKonum.SetclProSettings(IlanKonum.clProSettings);</div><div>}</div><div><br></div><div>void TarihEkle;</div><div>{</div><div>&nbsp; IlanTarih = IlanForm.AddNewProLabel(IlanDesignerPanel, 'IlanTarih', 'Tarih');</div><div>&nbsp; IlanDesignerPanel.AddPanelObject(IlanTarih, clText1);</div><div>&nbsp; IlanTarih.Align = alBottom;</div><div>&nbsp; IlanTarih.Properties.AutoSize = True;</div><div>&nbsp; IlanTarih.clProSettings.FontSize = 12;</div><div>&nbsp; IlanTarih.SetclProSettings(IlanTarih.clProSettings);</div><div>}</div><div><br></div><div>void FiyatEkle;</div><div>{</div><div>&nbsp; IlanPrice = IlanForm.AddNewProLabel(IlanDesignerPanel, 'IlanPrice', 'Fiyat');</div><div>&nbsp; IlanDesignerPanel.AddPanelObject(IlanPrice, clText2);</div><div>&nbsp; IlanPrice.Align = alBottom;</div><div>&nbsp; IlanPrice.Properties.AutoSize = True;</div><div>&nbsp; IlanPrice.clProSettings.FontSize = 12;</div><div>&nbsp; IlanPrice.clProSettings.TextSettings.Font.Style = &#091;fsBold&#093;;</div><div>&nbsp; IlanPrice.SetclProSettings(IlanPrice.clProSettings);</div><div>}</div><div><br></div><div>void YildizImgEkle;</div><div>{</div><div>&nbsp; IlanYildizImg = IlanForm.AddNewProImage(IlanDesignerPanel, 'IlanYildizImg');</div><div>&nbsp; IlanDesignerPanel.AddPanelObject(IlanYildizImg, clImage2);</div><div>&nbsp; IlanYildizImg.Align = alRight;</div><div>&nbsp; IlanYildizImg.Height = 30;</div><div>&nbsp; IlanYildizImg.Width = 30;</div><div>&nbsp; IlanYildizImg.clProSettings.PictureAutoFit = True;</div><div>&nbsp; IlanYildizImg.clProSettings.PictureStretch = True;</div><div>&nbsp; IlanYildizImg.clProSettings.PictureSource = '<a href="https://i.imgur.com/sfqqu3E.png" target="_blank" rel="nofollow">https://i.imgur.com/sfqqu3E.png</a>';</div><div>&nbsp; IlanYildizImg.SetclProSettings(IlanYildizImg.clProSettings);</div><div>}</div><div><br></div><div>void YildizEkle;</div><div>{</div><div>&nbsp; IlanYildiz = IlanForm.AddNewProLabel(IlanDesignerPanel, 'IlanYildiz', 'Yıldız');</div><div>&nbsp; IlanDesignerPanel.AddPanelObject(IlanYildiz, clText3);</div><div>&nbsp; IlanYildiz.Align = alRight;</div><div>&nbsp; IlanYildiz.Properties.AutoSize = True;</div><div>&nbsp; IlanYildiz.clProSettings.FontSize = 12;</div><div>&nbsp; IlanYildiz.SetclProSettings(IlanYildiz.clProSettings);</div><div>}</div><div><br></div><div>void LoadIlanlarFromDatabase(CategoryFilter: string);</div><div>{</div><div>&nbsp; try</div><div>&nbsp;&nbsp;</div><div>&nbsp; &nbsp; IlanQuery.Connection = Clomosy.DBSQLServerConnection;</div><div>&nbsp; &nbsp; if (CategoryFilter == '')&nbsp;</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; IlanQuery.SQL.Text = 'SELECT Adres as FOOTER_TEXT, Konum as FOOTER_TEXT, Tarih as FOOTER_TEXT, Fiyat as FOOTER_TEXT, Puan as FOOTER_TEXT &nbsp;FROM Ilanlar';</div><div>&nbsp; &nbsp; }</div><div>&nbsp; &nbsp; else</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; IlanQuery.SQL.Text = 'SELECT Adres as FOOTER_TEXT, Konum as FOOTER_TEXT, Tarih as FOOTER_TEXT, Fiyat as FOOTER_TEXT, Puan as FOOTER_TEXT * FROM Ilanlar WHERE Kategori = ' + QuotedStr(CategoryFilter);</div><div>&nbsp; &nbsp; }</div><div>&nbsp; &nbsp; IlanQuery.Open;</div><div>&nbsp; &nbsp; if (IlanQuery.Found)</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; IlanListView.ClLoadProListViewDataFromDataset(IlanQuery);</div><div>&nbsp; &nbsp; }</div><div>&nbsp; &nbsp; else</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Kayıt Bulunamadı!');</div><div>&nbsp; &nbsp; }</div><div>&nbsp; finally</div><div>&nbsp; &nbsp; IlanQuery.Close;</div><div>&nbsp; &nbsp; IlanQuery.Free;</div><div>&nbsp; }</div><div>}</div><div>/*</div><div>void CategoryButtonClick(Sender: TObject);</div><div>{</div><div>&nbsp; LoadIlanlarFromDatabase(IntToStr(TClProButton(Sender)));</div><div>}</div><div>*/</div><div>{</div><div>&nbsp; IlanForm = TclForm.Create(Self);</div><div>&nbsp;&nbsp;</div><div>&nbsp; IlanQuery = TClSqlQuery.Create(nil);</div><div>&nbsp; Clomosy.DBSQLServerConnect('SQL Server', '172.16.222.176', 'SA', 'reallyStrongPwd123', 'Clomosy', 1433);</div><div><br></div><div>&nbsp; TopPanel = IlanForm.AddNewProPanel(IlanForm, 'TopPanel');</div><div>&nbsp; TopPanel.Align = alTop;</div><div>&nbsp; TopPanel.Height = 150;</div><div>&nbsp; TopPanel.Width = 300;</div><div>&nbsp; TopPanel.Margins.Top = 10;</div><div>&nbsp; TopPanel.clProSettings.BorderColor = clAlphaColor.clHexToColor('#070807');</div><div>&nbsp; TopPanel.clProSettings.BorderWidth = 1;</div><div>&nbsp; TopPanel.clProSettings.IsTransparent = True;</div><div>&nbsp; TopPanel.SetclProSettings(TopPanel.clProSettings);</div><div><br></div><div>&nbsp; // Arama Paneli oluşturma</div><div>&nbsp; IlansearchPanel = IlanForm.AddNewProPanel(TopPanel, 'IlansearchPanel');</div><div>&nbsp; IlansearchPanel.Align = alTop;</div><div>&nbsp; IlansearchPanel.Height = 60;</div><div>&nbsp; IlansearchPanel.Width = 300;</div><div>&nbsp; IlansearchPanel.Margins.Left = 20;</div><div>&nbsp; IlansearchPanel.Margins.Right = 20;</div><div>&nbsp; IlansearchPanel.Margins.Top = 10;</div><div>&nbsp; IlansearchPanel.clProSettings.RoundHeight = 30;</div><div>&nbsp; IlansearchPanel.clProSettings.RoundWidth = 30;</div><div>&nbsp; IlansearchPanel.clProSettings.BorderColor = clAlphaColor.clHexToColor('#070807');</div><div>&nbsp; IlansearchPanel.clProSettings.BorderWidth = 1;</div><div>&nbsp; IlansearchPanel.clProSettings.IsTransparent = True;</div><div>&nbsp; IlansearchPanel.SetclProSettings(IlansearchPanel.clProSettings);</div><div><br></div><div>&nbsp; // Arama Edit alanı oluşturma</div><div>&nbsp; IlansearchEdit = IlanForm.AddNewProSearchEdit(IlansearchPanel, 'IlansearchEdit', 'Nereye gitmek istiyorsunuz?');</div><div>&nbsp; IlansearchEdit.Align = alClient;</div><div>&nbsp; IlansearchEdit.Margins.Top = 15;</div><div>&nbsp; IlansearchEdit.Margins.Left = 15;</div><div>&nbsp; IlansearchEdit.Margins.Right = 15;</div><div>&nbsp; IlansearchEdit.Margins.Bottom = 10;</div><div>&nbsp; IlansearchEdit.Height = 35;</div><div>&nbsp; IlansearchEdit.SetclProSettings(IlansearchEdit.clProSettings);</div><div><br></div><div>&nbsp; HorzPanel = IlanForm.AddNewProPanel(TopPanel, 'HorzPanel');</div><div>&nbsp; HorzPanel.Align = alTop;</div><div>&nbsp; HorzPanel.Height = 80; // Yüksekliği arttırarak buton ve etiket için alan bırakıyoruz</div><div>&nbsp; HorzPanel.Width = 70;</div><div>&nbsp; HorzPanel.Margins.Top = 10;</div><div>&nbsp; HorzPanel.clProSettings.IsTransparent = True;</div><div>&nbsp; HorzPanel.SetclProSettings(HorzPanel.clProSettings);</div><div><br></div><div>&nbsp; // HorizontalScrollBox oluşturma</div><div>&nbsp; CategoryScrollBox = IlanForm.AddNewHorzScrollBox(HorzPanel, 'CategoryScrollBox');</div><div>&nbsp; CategoryScrollBox.Align = alClient;</div><div>&nbsp; CategoryScrollBox.Height = 100; &nbsp;// Yüksekliği arttırarak butonun altına label eklemek için alan bırakıyoruz</div><div>&nbsp; CategoryScrollBox.Width = 300;</div><div><br></div><div>&nbsp; // Resim URL'lerinin ve Kategori İsimlerinin tanımlanması</div><div>&nbsp; ImageURLs&#091;0&#093; = '<a href="https://i.imgur.com/rQOm9Uv.png" target="_blank" rel="nofollow">https://i.imgur.com/rQOm9Uv.png</a>';</div><div>&nbsp; ImageURLs&#091;1&#093; = '<a href="https://i.imgur.com/mOSXbt0.png" target="_blank" rel="nofollow">https://i.imgur.com/mOSXbt0.png</a>';</div><div>&nbsp; ImageURLs&#091;2&#093; = '<a href="https://i.imgur.com/i1YL3D3.png" target="_blank" rel="nofollow">https://i.imgur.com/i1YL3D3.png</a>';</div><div>&nbsp; ImageURLs&#091;3&#093; = '<a href="https://i.imgur.com/XGpNyoc.png" target="_blank" rel="nofollow">https://i.imgur.com/XGpNyoc.png</a>';</div><div>&nbsp; ImageURLs&#091;4&#093; = '<a href="https://i.imgur.com/rrL8Yhn.png" target="_blank" rel="nofollow">https://i.imgur.com/rrL8Yhn.png</a>';</div><div>&nbsp; ImageURLs&#091;5&#093; = '<a href="https://i.imgur.com/C2wBjUE.png" target="_blank" rel="nofollow">https://i.imgur.com/C2wBjUE.png</a>';</div><div>&nbsp; ImageURLs&#091;6&#093; = '<a href="https://i.imgur.com/bkxANR8.png" target="_blank" rel="nofollow">https://i.imgur.com/bkxANR8.png</a>';</div><div>&nbsp; ImageURLs&#091;7&#093; = '<a href="https://i.imgur.com/QZ8vfPg.png" target="_blank" rel="nofollow">https://i.imgur.com/QZ8vfPg.png</a>';</div><div>&nbsp; ImageURLs&#091;8&#093; = '<a href="https://i.imgur.com/PSbHzMr.png" target="_blank" rel="nofollow">https://i.imgur.com/PSbHzMr.png</a>';</div><div>&nbsp; ImageURLs&#091;9&#093; = '<a href="https://i.imgur.com/0Otuk1o.png" target="_blank" rel="nofollow">https://i.imgur.com/0Otuk1o.png</a>';</div><div>&nbsp; ImageURLs&#091;10&#093; = '<a href="https://i.imgur.com/FY0fFLU.png" target="_blank" rel="nofollow">https://i.imgur.com/FY0fFLU.png</a>';</div><div>&nbsp; ImageURLs&#091;11&#093; = '<a href="https://i.imgur.com/jMvyQaW.png" target="_blank" rel="nofollow">https://i.imgur.com/jMvyQaW.png</a>';</div><div><br></div><div>&nbsp; CategoryNames&#091;0&#093; = 'Efsaneler';</div><div>&nbsp; CategoryNames&#091;1&#093; = 'Muhteşem havuzlar';</div><div>&nbsp; CategoryNames&#091;2&#093; = 'Denize sıfır';</div><div>&nbsp; CategoryNames&#091;3&#093; = 'Üçgen evler';</div><div>&nbsp; CategoryNames&#091;4&#093; = 'Tasarım';</div><div>&nbsp; CategoryNames&#091;5&#093; = 'Kırsal';</div><div>&nbsp; CategoryNames&#091;6&#093; = 'Güzel manzaralar';</div><div>&nbsp; CategoryNames&#091;7&#093; = 'Küçük evler';</div><div>&nbsp; CategoryNames&#091;8&#093; = 'Tekneler';</div><div>&nbsp; CategoryNames&#091;9&#093; = 'Şatolar';</div><div>&nbsp; CategoryNames&#091;10&#093; = 'Göl yakınında';</div><div>&nbsp; CategoryNames&#091;11&#093; = 'Olağanüstü';</div><div><br></div><div>&nbsp; for counter = 0 to 11&nbsp;</div><div>&nbsp; {</div><div>&nbsp; &nbsp; // Panel oluşturma</div><div>&nbsp; &nbsp; ButtonPanel = IlanForm.AddNewProPanel(CategoryScrollBox, 'ButtonPanel' + IntToStr(counter));</div><div>&nbsp; &nbsp; ButtonPanel.Align = alLeft;</div><div>&nbsp; &nbsp; ButtonPanel.Margins.Right = 5;</div><div>&nbsp; &nbsp; ButtonPanel.Margins.Top = 2;</div><div>&nbsp; &nbsp; ButtonPanel.Margins.Bottom = 2;</div><div>&nbsp; &nbsp; ButtonPanel.Width = 90;</div><div>&nbsp; &nbsp; ButtonPanel.Height = 180;</div><div>&nbsp; &nbsp; ButtonPanel.clProSettings.IsTransparent = True;</div><div>&nbsp; &nbsp; ButtonPanel.SetclProSettings(ButtonPanel.clProSettings);</div><div><br></div><div>&nbsp; &nbsp; // Buton oluşturma</div><div>&nbsp; &nbsp; CategoryButton = IlanForm.AddNewProButton(ButtonPanel, 'CategoryButton' + IntToStr(counter), '');</div><div>&nbsp; &nbsp; CategoryButton.Align = alTop;</div><div>&nbsp; &nbsp; CategoryButton.Width = 38;</div><div>&nbsp; &nbsp; CategoryButton.Height = 38;</div><div>&nbsp; &nbsp; CategoryButton.clProSettings.PictureSource = ImageURLs&#091;counter&#093;;</div><div>&nbsp; &nbsp; CategoryButton.clProSettings.PictureAutoFit = True;</div><div>&nbsp; &nbsp; CategoryButton.clProSettings.PictureStretch = False;</div><div>&nbsp; &nbsp; CategoryButton.clProSettings.IsTransparent = True;</div><div>&nbsp; &nbsp; CategoryButton.Padding.Top = 30;</div><div>&nbsp; &nbsp; CategoryButton.Padding.Right = 30;</div><div>&nbsp; &nbsp; CategoryButton.Padding.Bottom = 30;</div><div>&nbsp; &nbsp; CategoryButton.Padding.Left = 30;</div><div>&nbsp; &nbsp; CategoryButton.Hint = CategoryNames&#091;counter&#093;;</div><div>&nbsp; &nbsp; CategoryButton.SetclProSettings(CategoryButton.clProSettings);</div><div>&nbsp; &nbsp; IlanForm.AddNewEvent(CategoryButton, tbeOnClick, 'CategoryButtonClick');</div><div><br></div><div><br></div><div>&nbsp; &nbsp; // Label oluşturma</div><div>&nbsp; &nbsp; CategoryLabel = IlanForm.AddNewProLabel(ButtonPanel, 'CategoryLabel' + IntToStr(counter), CategoryNames&#091;counter&#093;);</div><div>&nbsp; &nbsp; CategoryLabel.Align = alBottom;</div><div>&nbsp; &nbsp; CategoryLabel.Margins.Top = 20;</div><div>&nbsp; &nbsp; CategoryLabel.Margins.Bottom = 10;</div><div>&nbsp; &nbsp; CategoryLabel.Width = 100;</div><div>&nbsp; &nbsp; CategoryLabel.Height = 20;</div><div>&nbsp; &nbsp; CategoryLabel.clProSettings.FontSize = 10;</div><div>&nbsp; &nbsp; CategoryLabel.clProSettings.IsTransparent = True;</div><div>&nbsp; &nbsp; CategoryLabel.clProSettings.FontHorzAlign = palCenter;</div><div>&nbsp; &nbsp; CategoryLabel.Padding.Top = 2; &nbsp; &nbsp;// Üst padding</div><div>&nbsp; &nbsp; CategoryLabel.Padding.Right = 2; &nbsp;// Sağ padding</div><div>&nbsp; &nbsp; CategoryLabel.Padding.Bottom = 2; // Alt padding</div><div>&nbsp; &nbsp; CategoryLabel.Padding.Left = 2; &nbsp; // Sol padding</div><div>&nbsp; &nbsp; CategoryLabel.SetclProSettings(CategoryLabel.clProSettings);</div><div>&nbsp; &nbsp;&nbsp;</div><div>&nbsp; &nbsp;&nbsp;</div><div>&nbsp; &nbsp;&nbsp;</div><div>&nbsp; }</div><div><br></div><div>&nbsp; CreateIlanListView;</div><div>&nbsp; CreateListDesignerPanel;</div><div>&nbsp; ResimEkle;</div><div>&nbsp; KonumEkle;</div><div>&nbsp; TarihEkle;</div><div>&nbsp; FiyatEkle;</div><div>&nbsp; YildizImgEkle;</div><div>&nbsp; YildizEkle;</div><div>&nbsp; LoadIlanlarFromDatabase('');</div><div><br></div><div>&nbsp; // Formu çalıştırma</div><div>&nbsp; IlanForm.Run;</div><div>}</div>]]>
   </description>
   <pubDate>Tue, 06 Aug 2024 17:31:07 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=815&amp;PID=1482#1482</guid>
  </item> 
  <item>
   <title><![CDATA[SQL LİSTVİEW BAĞLANTI : Merhaba CaferVeritaban&#305;ndan &#231;ekebilirsin...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=815&amp;PID=1481#1481</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=106">Developer</a><br /><strong>Konu:</strong> 815<br /><strong>Gönderim Zamanı:</strong> 06&nbsp;Ağustos&nbsp;2024 Saat 17:28<br /><br />Merhaba Cafer&nbsp;<div>Veritabanından çekebilirsin bir sıkıntı olmaz. DesignerPanel ile ilgili kodları da yükler misin?</div>]]>
   </description>
   <pubDate>Tue, 06 Aug 2024 17:28:41 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=815&amp;PID=1481#1481</guid>
  </item> 
  <item>
   <title><![CDATA[SQL LİSTVİEW BAĞLANTI : https://hizliresim.com/2a2hssn...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=815&amp;PID=1444#1444</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=205">cafer kosker</a><br /><strong>Konu:</strong> 815<br /><strong>Gönderim Zamanı:</strong> 06&nbsp;Ağustos&nbsp;2024 Saat 10:23<br /><br /><a href="https://hizliresim.com/2a2hssn" target="_blank" rel="nofollow">https://hizliresim.com/2a2hssn</a> &nbsp; &nbsp;<b><i><font color="#cc3333">Veritabanı</font></i></b>]]>
   </description>
   <pubDate>Tue, 06 Aug 2024 10:23:50 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=815&amp;PID=1444#1444</guid>
  </item> 
  <item>
   <title><![CDATA[SQL LİSTVİEW BAĞLANTI : https://hizliresim.com/gnkl8m4 ...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=815&amp;PID=1443#1443</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=205">cafer kosker</a><br /><strong>Konu:</strong> 815<br /><strong>Gönderim Zamanı:</strong> 06&nbsp;Ağustos&nbsp;2024 Saat 10:21<br /><br /><a href="https://hizliresim.com/gnkl8m4%20" target="_blank" rel="nofollow">https://hizliresim.com/gnkl8m4</a>
]]>
   </description>
   <pubDate>Tue, 06 Aug 2024 10:21:12 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=815&amp;PID=1443#1443</guid>
  </item> 
  <item>
   <title><![CDATA[SQL LİSTVİEW BAĞLANTI : void LoadIlanlarFromDatabase(CategoryFilter:...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=815&amp;PID=1442#1442</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=205">cafer kosker</a><br /><strong>Konu:</strong> 815<br /><strong>Gönderim Zamanı:</strong> 06&nbsp;Ağustos&nbsp;2024 Saat 10:17<br /><br /><div>void LoadIlanlarFromDatabase(CategoryFilter: string);</div><div>{</div><div>&nbsp; IlanQuery = TClSqlQuery.Create(nil);</div><div>&nbsp; Clomosy.DBSQLServerConnect('SQL Server', '172.16.222.176', 'SA', 'reallyStrongPwd123', 'Clomosy', 1433);</div><div>&nbsp; IlanQuery.Connection = Clomosy.DBSQLServerConnection;</div><div>&nbsp; try</div><div>&nbsp; &nbsp; if (CategoryFilter == '')&nbsp;</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; IlanQuery.SQL.Text = 'SELECT * FROM Ilanlar';</div><div>&nbsp; &nbsp; }</div><div>&nbsp; &nbsp; else</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; IlanQuery.SQL.Text = 'SELECT * FROM Ilanlar WHERE Kategori = ' + QuotedStr(CategoryFilter);</div><div>&nbsp; &nbsp; }</div><div>&nbsp; &nbsp; IlanQuery.Open;</div><div>&nbsp; &nbsp; if (IlanQuery.Found)</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; IlanListView.ClLoadProListViewDataFromDataset(IlanQuery);</div><div>&nbsp; &nbsp; }</div><div>&nbsp; &nbsp; else</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Kayıt Bulunamadı!');</div><div>&nbsp; &nbsp; }</div><div>&nbsp; finally</div><div>&nbsp; &nbsp; IlanQuery.Close;</div><div>&nbsp; &nbsp; IlanQuery.Free;</div><div>&nbsp; }</div><div>}</div><div><br></div><div>Sql e insert ettiğim verileri çekemedim designer panel oluşuyor fakat resim adres konum vb veriler designer panel üzerinde oluşmadı ve resim çekmekte sıkıntı oluyor galiba resimleri veritabanına link olarak yükledim &nbsp;veritabanından çekerken sıkıntı yaratır mı?</div><div><br></div>]]>
   </description>
   <pubDate>Tue, 06 Aug 2024 10:17:55 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=815&amp;PID=1442#1442</guid>
  </item> 
 </channel>
</rss>