<?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 baglantı</title>
  <link>https://forum.clomosy.com.tr/</link>
  <description><![CDATA[XML içerik linki; Clomosy | Forum : Genel &#304;&#351;lemler : sql baglantı]]></description>
  <copyright>Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved.</copyright>
  <pubDate>Thu, 07 May 2026 22:40:58 +0000</pubDate>
  <lastBuildDate>Thu, 07 May 2026 19:22:58 +0000</lastBuildDate>
  <docs>http://blogs.law.harvard.edu/tech/rss</docs>
  <generator>Web Wiz Forums 12.07</generator>
  <ttl>30</ttl>
  <WebWizForums:feedURL>https://forum.clomosy.com.tr/RSS_post_feed.asp?TID=1486</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 baglantı : var MyForm, RegisterForm: TclForm;...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=1486&amp;PID=3402#3402</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=398">Esra Betül</a><br /><strong>Konu:</strong> 1486<br /><strong>Gönderim Zamanı:</strong> 07&nbsp;Mayıs&nbsp;2026 Saat 19:22<br /><br /><div>var</div><div>&nbsp; MyForm, RegisterForm: TclForm;</div><div>&nbsp; PnlLoginCard, PnlBottom, PnlRegCard: TclProPanel;</div><div>&nbsp; EdtUser, EdtPass, EdtRegUser, EdtRegMail, EdtRegPass, EdtRegPassAgain: TclProEdit;</div><div>&nbsp; BtnLogin, BtnRegister, BtnRegSubmit: TclProButton;</div><div>&nbsp; LblTitle, LblSubTitle, LblRegTitle: TclProLabel;</div><div><br></div><div>// --- 1. SQL KAYIT PROSEDÜRÜ ---</div><div>procedure OnRegSubmitClick;</div><div>var</div><div>&nbsp; sqlQuery: String;</div><div>begin</div><div>&nbsp; // Şifre kontrolü (Basit bir doğrulama ekledik)</div><div>&nbsp; if EdtRegPass.Text &lt;&gt; EdtRegPassAgain.Text then</div><div>&nbsp; begin</div><div>&nbsp; &nbsp; ShowMessage('Şifreler uyuşmuyor!');</div><div>&nbsp; &nbsp; Exit;</div><div>&nbsp; end;</div><div><br></div><div>&nbsp; // Veritabanı Bağlantısı</div><div>&nbsp; // Not: Parametre sıralaması ve doğruluğu sunucu ayarlarınıza göre değişebilir.</div><div>&nbsp; if Clomosy.DBSQLServerConnect('SQL Server', '10.53.180.120', 'sa', '123456', 'CLOSTEP', 1433) then</div><div>&nbsp; begin</div><div>&nbsp; &nbsp; try</div><div>&nbsp; &nbsp; &nbsp; sqlQuery := 'INSERT INTO TblKullanicilar (KullaniciAdi, Sifre, Eposta, KayitTarihi) VALUES (' +</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; QuotedStr(EdtRegUser.Text) + ', ' +</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; QuotedStr(EdtRegPass.Text) + ', ' +</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; QuotedStr(EdtRegMail.Text) + ', ' +</div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'GETDATE())';</div><div>&nbsp; &nbsp; &nbsp;&nbsp;</div><div>&nbsp; &nbsp; &nbsp; Clomosy.DBSQLServerQuery.Sql.Clear; // Önceki sorguyu temizlemek güvenlidir</div><div>&nbsp; &nbsp; &nbsp; Clomosy.DBSQLServerQuery.Sql.Add(sqlQuery);&nbsp;</div><div>&nbsp; &nbsp; &nbsp; Clomosy.DBSQLServerQuery.ExecSQL;</div><div>&nbsp; &nbsp; &nbsp;&nbsp;</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Kayıt başarıyla tamamlandı!');</div><div>&nbsp; &nbsp; &nbsp; RegisterForm.Close;</div><div>&nbsp; &nbsp; except</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('SQL Hatası: Veri kaydedilemedi. Tablo yapısını kontrol edin.');</div><div>&nbsp; &nbsp; end;</div><div>&nbsp; end</div><div>&nbsp; else</div><div>&nbsp; &nbsp; ShowMessage('Sunucu bağlantı hatası!');</div><div>end;</div><div><br></div><div>// --- 2. KAYIT FORMU OLUŞTURMA ---</div><div>procedure CreateRegisterForm;</div><div>begin</div><div>&nbsp; RegisterForm := TclForm.Create(Self);</div><div>&nbsp; RegisterForm.SetFormColor('#F3F4F6', '', clGNone);</div><div><br></div><div>&nbsp; PnlRegCard := RegisterForm.AddNewProPanel(RegisterForm, 'PnlRegCard');</div><div>&nbsp; PnlRegCard.Align := alCenter;</div><div>&nbsp; PnlRegCard.Width := 300;</div><div>&nbsp; PnlRegCard.Height := 420;</div><div>&nbsp; PnlRegCard.clProSettings.BackgroundColor := clAlphaColor.clHexToColor('#FFFFFF');</div><div>&nbsp; PnlRegCard.clProSettings.RoundHeight := 10;&nbsp;</div><div>&nbsp; PnlRegCard.clProSettings.RoundWidth := 10;</div><div>&nbsp; PnlRegCard.SetclProSettings(PnlRegCard.clProSettings);</div><div><br></div><div>&nbsp; LblRegTitle := RegisterForm.AddNewProLabel(PnlRegCard, 'LblRegTitle', 'Yeni Hesap Oluştur');</div><div>&nbsp; LblRegTitle.Align := alTop;&nbsp;</div><div>&nbsp; LblRegTitle.Height := 30;&nbsp;</div><div>&nbsp; LblRegTitle.Margins.Top := 20;</div><div>&nbsp; LblRegTitle.clProSettings.FontSize := 16;&nbsp;</div><div>&nbsp; LblRegTitle.clProSettings.FontHorzAlign := palCenter;</div><div>&nbsp; LblRegTitle.clProSettings.TextSettings.Font.Style := &#091;fsBold&#093;;</div><div>&nbsp; LblRegTitle.SetclProSettings(LblRegTitle.clProSettings);</div><div><br></div><div>&nbsp; EdtRegUser := RegisterForm.AddNewProEdit(PnlRegCard, 'EdtRegUser', 'Kullanıcı Adı');</div><div>&nbsp; EdtRegUser.Align := alTop; EdtRegUser.Height := 40;&nbsp;</div><div>&nbsp; EdtRegUser.Margins.Top := 20; EdtRegUser.Margins.Left := 20; EdtRegUser.Margins.Right := 20;</div><div><br></div><div>&nbsp; EdtRegMail := RegisterForm.AddNewProEdit(PnlRegCard, 'EdtRegMail', 'E-Posta Adresi');</div><div>&nbsp; EdtRegMail.Align := alTop; EdtRegMail.Height := 40;&nbsp;</div><div>&nbsp; EdtRegMail.Margins.Top := 10; EdtRegMail.Margins.Left := 20; EdtRegMail.Margins.Right := 20;</div><div><br></div><div>&nbsp; EdtRegPass := RegisterForm.AddNewProEdit(PnlRegCard, 'EdtRegPass', 'Şifre');</div><div>&nbsp; EdtRegPass.Align := alTop; EdtRegPass.Height := 40;&nbsp;</div><div>&nbsp; EdtRegPass.Margins.Top := 10; EdtRegPass.Margins.Left := 20; EdtRegPass.Margins.Right := 20;</div><div>&nbsp; EdtRegPass.Password := True;</div><div><br></div><div>&nbsp; EdtRegPassAgain := RegisterForm.AddNewProEdit(PnlRegCard, 'EdtRegPassAgain', 'Şifre Tekrar');</div><div>&nbsp; EdtRegPassAgain.Align := alTop; EdtRegPassAgain.Height := 40;&nbsp;</div><div>&nbsp; EdtRegPassAgain.Margins.Top := 10; EdtRegPassAgain.Margins.Left := 20; EdtRegPassAgain.Margins.Right := 20;</div><div>&nbsp; EdtRegPassAgain.Password := True;</div><div><br></div><div>&nbsp; BtnRegSubmit := RegisterForm.AddNewProButton(PnlRegCard, 'BtnRegSubmit', 'KAYIT OL');</div><div>&nbsp; BtnRegSubmit.Align := alBottom;&nbsp;</div><div>&nbsp; BtnRegSubmit.Height := 40;</div><div>&nbsp; BtnRegSubmit.Margins.Bottom := 30; BtnRegSubmit.Margins.Left := 20; BtnRegSubmit.Margins.Right := 20;</div><div>&nbsp; BtnRegSubmit.clProSettings.BackgroundColor := clAlphaColor.clHexToColor('#10B981');</div><div>&nbsp; BtnRegSubmit.clProSettings.FontColor := clAlphaColor.clWhite;</div><div>&nbsp; BtnRegSubmit.SetclProSettings(BtnRegSubmit.clProSettings);</div><div><br></div><div>&nbsp; RegisterForm.AddNewEvent(BtnRegSubmit, tbeOnClick, 'OnRegSubmitClick');</div><div>&nbsp; RegisterForm.Run;</div><div>end;</div><div><br></div><div>// --- 3. DİĞER YARDIMCI PROSEDÜRLER ---</div><div>procedure OnRegisterClick;</div><div>begin</div><div>&nbsp; CreateRegisterForm;</div><div>end;</div><div><br></div><div>procedure DrawCompactLogin(TargetForm: TclForm; CardW, CardH: Integer; TitleStr, SubTitleStr, BtnStr: String);</div><div>begin</div><div>&nbsp; TargetForm.SetFormColor('#F3F4F6', '', clGNone);</div><div>&nbsp;&nbsp;</div><div>&nbsp; PnlLoginCard := TargetForm.AddNewProPanel(TargetForm, 'PnlLoginCard');</div><div>&nbsp; PnlLoginCard.Align := alCenter;</div><div>&nbsp; PnlLoginCard.Width := CardW;&nbsp;</div><div>&nbsp; PnlLoginCard.Height := CardH;</div><div>&nbsp; PnlLoginCard.clProSettings.BackgroundColor := clAlphaColor.clHexToColor('#FFFFFF');</div><div>&nbsp; PnlLoginCard.clProSettings.RoundHeight := 10;&nbsp;</div><div>&nbsp; PnlLoginCard.clProSettings.RoundWidth := 10;</div><div>&nbsp; PnlLoginCard.SetclProSettings(PnlLoginCard.clProSettings);</div><div><br></div><div>&nbsp; LblTitle := TargetForm.AddNewProLabel(PnlLoginCard, 'LblTitle', TitleStr);</div><div>&nbsp; LblTitle.Align := alTop;&nbsp;</div><div>&nbsp; LblTitle.Height := 30;&nbsp;</div><div>&nbsp; LblTitle.Margins.Top := 20;</div><div>&nbsp; LblTitle.clProSettings.FontSize := 18;&nbsp;</div><div>&nbsp; LblTitle.clProSettings.FontHorzAlign := palCenter;</div><div>&nbsp; LblTitle.clProSettings.TextSettings.Font.Style := &#091;fsBold&#093;;</div><div>&nbsp; LblTitle.SetclProSettings(LblTitle.clProSettings);</div><div><br></div><div>&nbsp; EdtUser := TargetForm.AddNewProEdit(PnlLoginCard, 'EdtUser', 'Kullanıcı Adı');</div><div>&nbsp; EdtUser.Align := alTop; EdtUser.Height := 40;&nbsp;</div><div>&nbsp; EdtUser.Margins.Top := 15; EdtUser.Margins.Left := 20; EdtUser.Margins.Right := 20;</div><div><br></div><div>&nbsp; EdtPass := TargetForm.AddNewProEdit(PnlLoginCard, 'EdtPass', 'Şifre');</div><div>&nbsp; EdtPass.Align := alTop; EdtPass.Height := 40;&nbsp;</div><div>&nbsp; EdtPass.Margins.Top := 10; EdtPass.Margins.Left := 20; EdtPass.Margins.Right := 20;</div><div>&nbsp; EdtPass.Password := True;</div><div><br></div><div>&nbsp; PnlBottom := TargetForm.AddNewProPanel(PnlLoginCard, 'PnlBottom');</div><div>&nbsp; PnlBottom.Align := alBottom;&nbsp;</div><div>&nbsp; PnlBottom.Height := 100;</div><div><br></div><div>&nbsp; BtnLogin := TargetForm.AddNewProButton(PnlBottom, 'BtnLogin', BtnStr);</div><div>&nbsp; BtnLogin.Align := alTop;&nbsp;</div><div>&nbsp; BtnLogin.Height := 40;&nbsp;</div><div>&nbsp; BtnLogin.Margins.Left := 20;&nbsp;</div><div>&nbsp; BtnLogin.Margins.Right := 20;</div><div>&nbsp; BtnLogin.clProSettings.BackgroundColor := clAlphaColor.clHexToColor('#B91C1C');</div><div>&nbsp; BtnLogin.clProSettings.FontColor := clAlphaColor.clWhite;</div><div>&nbsp; BtnLogin.SetclProSettings(BtnLogin.clProSettings);</div><div><br></div><div>&nbsp; BtnRegister := TargetForm.AddNewProButton(PnlBottom, 'BtnRegister', 'Kayıt Ol');</div><div>&nbsp; BtnRegister.Align := alTop;&nbsp;</div><div>&nbsp; BtnRegister.Height := 30;</div><div>&nbsp; TargetForm.AddNewEvent(BtnRegister, tbeOnClick, 'OnRegisterClick');</div><div>end;</div><div><br></div><div>// --- ANA BLOK ---</div><div>begin</div><div>&nbsp; MyForm := TclForm.Create(Self);</div><div>&nbsp; DrawCompactLogin(MyForm, 300, 380, 'Giriş Yap', 'Hoş geldiniz!', 'GİRİŞ');</div><div>&nbsp; MyForm.Run;</div><div>end;&nbsp; &nbsp;bu kod bu şekilde doğru çalıyor. Süslü paranteze çevirince hata veriyor. Ne yapabiliriz. Diğer bir sorun da bu kodda yazdığımız IP adresi sadece benim telefonumdan açtığım internet bağlantısıyla açılıyor başka bir internet bağlantısıyla kod sunucu hatası veriyor. Araştırmalarımız sonucu buluta aktarmamız gerekiyormuş ancak onu yapamadık.</div><a href="https://static.cloudflareinsights.com/beac&#111;n.min.js/v8c78df7c7c0f484497ecbca7046644da1771523124516" target="_blank" rel="nofollow">https://static.cloudflareinsights.com/beacon.min.js/v8c78df7c7c0f484497ecbca7046644da1771523124516"</a> integrity="sha512-8DS7rgIrAmghBFwoOTujcf6D9rXvH8xm8JQ1Ja01h9QX8EzXldiszufYa4IFfKdLUKTTrnSFXLDkUEOTrZQ8Qg==" data-cf-beacon="{&quot;version&quot;:&quot;2024.11.0&quot;,&quot;token&quot;:&quot;439455f3e46c40b98dbd42a2f1a954d8&quot;,&quot;r&quot;:1,&quot;server_timing&quot;:{&quot;name&quot;:{&quot;cfCacheStatus&quot;:true,&quot;cfEdge&quot;:true,&quot;cfExtPri&quot;:true,&quot;cfL4&quot;:true,&quot;cfOrigin&quot;:true,&quot;cfSpeedBrain&quot;:true},&quot;location_startswith&quot;:null}}" crossorigin="anonymous">]]>
   </description>
   <pubDate>Thu, 07 May 2026 19:22:58 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=1486&amp;PID=3402#3402</guid>
  </item> 
 </channel>
</rss>