<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-9096531315361652031</id><updated>2025-10-23T11:34:36.580+03:00</updated><category term="Devexpres gridview"/><category term="5.5.1 authentication required"/><category term="A page can have only one server-side Form tag"/><category term="C#  IIS Ugulama çalıştırma"/><category term="C# Kısayol atama"/><category term="C# Tuşa basılma olayı"/><category term="C# keyPress event"/><category term="C# substring error"/><category term="CS1061 hatası"/><category term="Compiler Error Message: CS1061"/><category term="Devexpres gridview rowcount"/><category term="Devexpress GridView dan Kayıt okuma."/><category term="ERR_CONNECTION_RESET"/><category term="Form tag"/><category term="Gmail"/><category term="Gmail 5.5.1 error"/><category term="Gmail message send error"/><category term="Grid üzerinde veri okumak"/><category term="IIS izinler"/><category term="IIS klasöre izin vermek"/><category term="IIS permission"/><category term="ISS uygulama Ayarları"/><category term="Index and length must refer to a location within the string exception"/><category term="Index and length must refer to a location within the string. Parameter name: length"/><category term="Interop type cannot be embedded. com nesnesi hatası"/><category term="Invalid attempt to call Read when reader is closed"/><category term="KeyPress olayı"/><category term="Keypress Kullanımı"/><category term="Saving changes is not permitted."/><category term="Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created."/><category term="Session Class"/><category term="Sql Server Error"/><category term="Sql restore error"/><category term="Sql script run"/><category term="There are fewer columns in the INSERT statement than values specified in the VALUES clause.Sql Insert error"/><category term="Visual Studio save changes to following items"/><category term="X86 And x64 Application"/><category term="access could not be obtained"/><category term="asp.net  Fileupload Error"/><category term="asp.net combobox doldurma"/><category term="asp.net derleme hatası"/><category term="asp.net dropdown"/><category term="asp.net fileupload ERR_Reset"/><category term="button shortcut key"/><category term="c# dropdownlist fill"/><category term="c# içerisinden sql çalıştırmak."/><category term="c# ta keyPress"/><category term="cannot declare instance members in a static class"/><category term="denem.sln kaydetme mesajı"/><category term="dropdownlist fill"/><category term="gridview kayıt sayısı öğrenme"/><category term="keydown olayı"/><category term="keypreview"/><category term="kısayol tuşu"/><category term="okuma İşlemi"/><category term="only one server-side Form tag"/><category term="save changes to following items devenv.sln"/><category term="send message error"/><category term="session da class saklamak"/><category term="static class exception"/><category term="statik class hatası nedir"/><category term="statik class hatası çözümü"/><category term="visual studio açılırken kaydetme mesajı"/><title type='text'>Yazılım Notları</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://hakancavus.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://hakancavus.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Admin</name><uri>http://www.blogger.com/profile/04412617293982531750</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>21</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-9096531315361652031.post-437713831343218320</id><published>2016-04-27T00:12:00.002+03:00</published><updated>2016-04-27T00:12:46.368+03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="There are fewer columns in the INSERT statement than values specified in the VALUES clause.Sql Insert error"/><title type='text'>There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.</title><content type='html'>&amp;nbsp;Sql Cümlemiz içerisinde Kayıt eklenecek kolon sayısı ile gönderilen veri sayısının eşit olmadığı durumlarda karşımıza gelen hata mesajıdır.&lt;br /&gt;
&lt;br /&gt;
Ayrıca yaptığımız kodlama içerinde sql cümlemize parametre geçiyorsak ve bu parametreler içerisinde virgüllü (235,82) gibi bir değer varsa bu durumda aynı hataya sebep olmaktadır.&lt;br /&gt;
parametremizi c# için =&amp;gt;&lt;br /&gt;
Command.Parameters.AddWithValue(&quot;@Oran&quot;, SatisOrani);&lt;br /&gt;
Şeklinde yollarsak virgülün sebep olduğu hatayı ortadan kaldırmış oluruz.&lt;br /&gt;
&lt;br /&gt;
İyi Çalışmalar &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.&lt;br /&gt;
&lt;br /&gt;</content><link rel='replies' type='application/atom+xml' href='http://hakancavus.blogspot.com/feeds/437713831343218320/comments/default' title='Kayıt Yorumları'/><link rel='replies' type='text/html' href='http://hakancavus.blogspot.com/2016/04/there-are-fewer-columns-in-insert.html#comment-form' title='0 Yorum'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/437713831343218320'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/437713831343218320'/><link rel='alternate' type='text/html' href='http://hakancavus.blogspot.com/2016/04/there-are-fewer-columns-in-insert.html' title='There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.'/><author><name>Admin</name><uri>http://www.blogger.com/profile/04412617293982531750</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9096531315361652031.post-1447292776365988361</id><published>2016-04-06T14:54:00.000+03:00</published><updated>2016-04-06T14:54:36.756+03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="C# keyPress event"/><category scheme="http://www.blogger.com/atom/ns#" term="c# ta keyPress"/><category scheme="http://www.blogger.com/atom/ns#" term="C# Tuşa basılma olayı"/><category scheme="http://www.blogger.com/atom/ns#" term="Keypress Kullanımı"/><category scheme="http://www.blogger.com/atom/ns#" term="KeyPress olayı"/><title type='text'>C# Tuşa Basma Olayı Kullanımı (KeyPress Event) Kullanımı</title><content type='html'>C# ta Bir tuşa basıldığında devreye giren olaydır. basit bir örnekle kullanımını açıklayalım.&lt;br /&gt;
&lt;br /&gt;
private void textBox1_KeyPress(object sender, KeyPressEventArgs e)&lt;br /&gt;
        {&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; // Basılan tuşun Karakter kodu alınarak&amp;nbsp; 47 ile 58 arasında olup olamadığı kontrol ediliyor.&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;
  if ((int)e.KeyChar &amp;gt;= 47 &amp;amp;&amp;amp; (int)e.KeyChar &amp;lt;= 57) &lt;br /&gt;            {&lt;br /&gt;
&amp;nbsp;&amp;nbsp; // 47 -58 kodlu tuşalara basıldıysa text içeriğine yazılır. &lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; e.Handled = false; &lt;br /&gt;            }&lt;br /&gt;
&amp;nbsp; // backspace tuşuna basıldı ise kontrol edilir. &lt;br /&gt;
&amp;nbsp;else if ((int)e.KeyChar == 8)&lt;br /&gt;
            {&lt;br /&gt;&amp;nbsp;&amp;nbsp; e.Handled = false; // yazılan değer silinebilir.&lt;br /&gt;            }&lt;br /&gt;
&amp;nbsp;else&lt;br /&gt;            {&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; // Belirttiğimiz kodlar dışında bir tuşsa text içeriğine yazılmaz &lt;br /&gt;
&amp;nbsp; &amp;nbsp; e.Handled = true;&lt;br /&gt;
&amp;nbsp;}&lt;br /&gt;
&lt;br /&gt;
iyi Çalışmalar&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
C# Tuşa Basma Olayı Kullanımı (KeyPress Event) Kullanımı</content><link rel='replies' type='application/atom+xml' href='http://hakancavus.blogspot.com/feeds/1447292776365988361/comments/default' title='Kayıt Yorumları'/><link rel='replies' type='text/html' href='http://hakancavus.blogspot.com/2016/04/c-tusa-basma-olay-kullanm-keypress.html#comment-form' title='0 Yorum'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/1447292776365988361'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/1447292776365988361'/><link rel='alternate' type='text/html' href='http://hakancavus.blogspot.com/2016/04/c-tusa-basma-olay-kullanm-keypress.html' title='C# Tuşa Basma Olayı Kullanımı (KeyPress Event) Kullanımı'/><author><name>Admin</name><uri>http://www.blogger.com/profile/04412617293982531750</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9096531315361652031.post-1645767353449815321</id><published>2015-10-12T17:10:00.003+03:00</published><updated>2015-10-13T10:29:10.297+03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Saving changes is not permitted."/><category scheme="http://www.blogger.com/atom/ns#" term="Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created."/><category scheme="http://www.blogger.com/atom/ns#" term="Sql Server Error"/><title type='text'>MsSql Server Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.</title><content type='html'>&lt;span style=&quot;-webkit-text-stroke-width: 0px; background-color: white; color: #5e6066; display: inline !important; float: none; font-family: &#39;Segoe UI&#39;, sans-serif; font-size: 13.3333px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 15.3333px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;&quot;&gt;Sql Server Managament Studio içerisinden &lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;-webkit-text-stroke-width: 0px; background-color: white; color: #5e6066; display: inline !important; float: none; font-family: &#39;Segoe UI&#39;, sans-serif; font-size: 13.3333px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 15.3333px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;&quot;&gt;Tools =&amp;gt; Options Menüsüne girelim. Açılan pencerede Designer menüsüne Sonra da altındaki Table And Database Designer alt Menüsüne Tıklayalım. Gelen Seçeneklerden &quot;prevent saving changes that require table re-creation&quot; checkbox&amp;nbsp; kutusunda ki işareti kaldıralım. Sorunumuz çözülmüştür.&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;-webkit-text-stroke-width: 0px; background-color: white; color: #5e6066; display: inline !important; float: none; font-family: &#39;Segoe UI&#39;, sans-serif; font-size: 13.3333px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 15.3333px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;-webkit-text-stroke-width: 0px; background-color: white; color: #5e6066; display: inline !important; float: none; font-family: &#39;Segoe UI&#39;, sans-serif; font-size: 13.3333px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 15.3333px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;br /&gt;
&lt;span style=&quot;-webkit-text-stroke-width: 0px; background-color: white; color: #5e6066; display: inline !important; float: none; font-family: &#39;Segoe UI&#39;, sans-serif; font-size: 13.3333px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 15.3333px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;&quot;&gt;Tools =&amp;gt; Options=&amp;gt;&lt;/span&gt;&lt;span style=&quot;-webkit-text-stroke-width: 0px; background-color: white; color: #5e6066; display: inline !important; float: none; font-family: &#39;Segoe UI&#39;, sans-serif; font-size: 13.3333px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 15.3333px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;&quot;&gt;Designer=&amp;gt;&lt;/span&gt;&lt;span style=&quot;-webkit-text-stroke-width: 0px; background-color: white; color: #5e6066; display: inline !important; float: none; font-family: &#39;Segoe UI&#39;, sans-serif; font-size: 13.3333px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 15.3333px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;&quot;&gt;Table And Database Designer=&amp;gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;-webkit-text-stroke-width: 0px; background-color: white; color: #5e6066; display: inline !important; float: none; font-family: &#39;Segoe UI&#39;, sans-serif; font-size: 13.3333px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 15.3333px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;&quot;&gt;&lt;span style=&quot;-webkit-text-stroke-width: 0px; background-color: white; color: #5e6066; display: inline !important; float: none; font-family: &#39;Segoe UI&#39;, sans-serif; font-size: 13.3333px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 15.3333px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;&quot;&gt;prevent saving changes that require table re-creation&amp;nbsp; (unselect)&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;-webkit-text-stroke-width: 0px; background-color: white; color: #5e6066; display: inline !important; float: none; font-family: &#39;Segoe UI&#39;, sans-serif; font-size: 13.3333px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 15.3333px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;&quot;&gt;&lt;span style=&quot;-webkit-text-stroke-width: 0px; background-color: white; color: #5e6066; display: inline !important; float: none; font-family: &#39;Segoe UI&#39;, sans-serif; font-size: 13.3333px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 15.3333px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;&quot;&gt;Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. YOu have either made changes to a table that can&#39;t be re-created or enabled the option Prevent saving changes that require the tables to be re-created.&amp;nbsp;&lt;/span&gt; &lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://hakancavus.blogspot.com/feeds/1645767353449815321/comments/default' title='Kayıt Yorumları'/><link rel='replies' type='text/html' href='http://hakancavus.blogspot.com/2015/10/mssql-server-saving-changes-is-not.html#comment-form' title='0 Yorum'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/1645767353449815321'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/1645767353449815321'/><link rel='alternate' type='text/html' href='http://hakancavus.blogspot.com/2015/10/mssql-server-saving-changes-is-not.html' title='MsSql Server Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.'/><author><name>Admin</name><uri>http://www.blogger.com/profile/04412617293982531750</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9096531315361652031.post-2696158142556271602</id><published>2015-09-10T14:38:00.000+03:00</published><updated>2015-09-10T14:38:45.318+03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="cannot declare instance members in a static class"/><category scheme="http://www.blogger.com/atom/ns#" term="static class exception"/><category scheme="http://www.blogger.com/atom/ns#" term="statik class hatası nedir"/><category scheme="http://www.blogger.com/atom/ns#" term="statik class hatası çözümü"/><title type='text'>c#  cannot declare instance members in a static class hatası çözümü</title><content type='html'>&amp;nbsp; public static class TypeSelector&lt;br /&gt;
&amp;nbsp; {&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; // Class içeriği Kodlar&lt;br /&gt;
&amp;nbsp; }&lt;br /&gt;
&lt;br /&gt;
Yukarı daki gibi örnek bir&amp;nbsp; static class tanımlaması yaptığımızda bu class içerisinde oluşturacağımız metodlar, değişkenler nesneler vb. yapıları tanımlarken bunların içerisinde static ifadesini kullanmak zorundayız.&lt;br /&gt;
&lt;br /&gt;
örenek:&lt;br /&gt;
&lt;br /&gt;
int A;&amp;nbsp; =&amp;gt; static int A;&lt;br /&gt;
&lt;br /&gt;
HesapIslemiClass&amp;nbsp; Hesaplar=new&amp;nbsp; HesapIslemiClass();&lt;br /&gt;
=&amp;gt; static HesapIslemiClass&amp;nbsp; Hesaplar=new&amp;nbsp; HesapIslemiClass();&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;Tanımlamalarınızı bu yönde kontrol ederek hataya ulaşabilirsiniz. iyi çalışmalar&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
! cannot declare instance members in a static class </content><link rel='replies' type='application/atom+xml' href='http://hakancavus.blogspot.com/feeds/2696158142556271602/comments/default' title='Kayıt Yorumları'/><link rel='replies' type='text/html' href='http://hakancavus.blogspot.com/2015/09/c-cannot-declare-instance-members-in.html#comment-form' title='0 Yorum'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/2696158142556271602'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/2696158142556271602'/><link rel='alternate' type='text/html' href='http://hakancavus.blogspot.com/2015/09/c-cannot-declare-instance-members-in.html' title='c#  cannot declare instance members in a static class hatası çözümü'/><author><name>Admin</name><uri>http://www.blogger.com/profile/04412617293982531750</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9096531315361652031.post-397503803493190103</id><published>2015-09-09T12:34:00.001+03:00</published><updated>2021-10-15T15:55:57.831+03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="denem.sln kaydetme mesajı"/><category scheme="http://www.blogger.com/atom/ns#" term="save changes to following items devenv.sln"/><category scheme="http://www.blogger.com/atom/ns#" term="visual studio açılırken kaydetme mesajı"/><category scheme="http://www.blogger.com/atom/ns#" term="Visual Studio save changes to following items"/><title type='text'>Visual Studio save changes to following items devenv.sln dialogs.  Open solution or projects</title><content type='html'>Visual studio programımızı açtığımızda karşımıza denev.sln kayıt penceri çıkıyorsa&lt;br /&gt;
&amp;nbsp;(save changes to following items devenv.sln)&lt;br /&gt;
&lt;br /&gt;
aşağıdaki yolda bulunan .exe yi yönetici olarak çalıştırmaya ayarlayınız.&lt;br /&gt;
&lt;br /&gt;
&lt;span face=&quot;Consolas, Menlo, Monaco, &#39;Lucida Console&#39;, &#39;Liberation Mono&#39;, &#39;DejaVu Sans Mono&#39;, &#39;Bitstream Vera Sans Mono&#39;, &#39;Courier New&#39;, monospace, sans-serif&quot; style=&quot;-webkit-text-stroke-width: 0px; background-color: #eeeeee; color: #222222; display: inline; float: none; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 16.9px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 1; word-spacing: 0px;&quot;&gt;C:\Program Files (x86)\Common Files\microsoft shared\MSEnv\vslauncher.exe&lt;/span&gt;&lt;br /&gt;
&lt;span face=&quot;Consolas, Menlo, Monaco, &#39;Lucida Console&#39;, &#39;Liberation Mono&#39;, &#39;DejaVu Sans Mono&#39;, &#39;Bitstream Vera Sans Mono&#39;, &#39;Courier New&#39;, monospace, sans-serif&quot; style=&quot;-webkit-text-stroke-width: 0px; background-color: #eeeeee; color: #222222; display: inline; float: none; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 16.9px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 1; word-spacing: 0px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span face=&quot;Consolas, Menlo, Monaco, &#39;Lucida Console&#39;, &#39;Liberation Mono&#39;, &#39;DejaVu Sans Mono&#39;, &#39;Bitstream Vera Sans Mono&#39;, &#39;Courier New&#39;, monospace, sans-serif&quot; style=&quot;-webkit-text-stroke-width: 0px; background-color: #eeeeee; color: #222222; display: inline; float: none; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 16.9px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 1; word-spacing: 0px;&quot;&gt;&lt;span style=&quot;background-color: white;&quot;&gt;Sorununuz ortadan kalkacaktır. iyi çalışmalar.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;span face=&quot;Consolas, Menlo, Monaco, &#39;Lucida Console&#39;, &#39;Liberation Mono&#39;, &#39;DejaVu Sans Mono&#39;, &#39;Bitstream Vera Sans Mono&#39;, &#39;Courier New&#39;, monospace, sans-serif&quot; style=&quot;-webkit-text-stroke-width: 0px; background-color: #eeeeee; color: #222222; display: inline; float: none; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 16.9px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 1; word-spacing: 0px;&quot;&gt;&lt;span style=&quot;background-color: white;&quot;&gt;! save changes to following items devenv.sln &lt;/span&gt;&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://hakancavus.blogspot.com/feeds/397503803493190103/comments/default' title='Kayıt Yorumları'/><link rel='replies' type='text/html' href='http://hakancavus.blogspot.com/2015/09/visual-studio-save-changes-to-following.html#comment-form' title='0 Yorum'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/397503803493190103'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/397503803493190103'/><link rel='alternate' type='text/html' href='http://hakancavus.blogspot.com/2015/09/visual-studio-save-changes-to-following.html' title='Visual Studio save changes to following items devenv.sln dialogs.  Open solution or projects'/><author><name>Admin</name><uri>http://www.blogger.com/profile/04412617293982531750</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9096531315361652031.post-2548166328605478180</id><published>2015-09-07T11:08:00.002+03:00</published><updated>2015-09-10T14:39:57.051+03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="C# substring error"/><category scheme="http://www.blogger.com/atom/ns#" term="Index and length must refer to a location within the string exception"/><category scheme="http://www.blogger.com/atom/ns#" term="Index and length must refer to a location within the string. Parameter name: length"/><title type='text'>C# Substring Method Index and length must refer to a location within the string. Parameter name: length </title><content type='html'>Substring metodu kullanılırken verdiğimiz parametre değerlerine dikkat etmemiz gerekmektedir.&lt;br /&gt;
Hangi sıradaki (örn: 2. karakter) karakterden sonra 5 karakter al gibi bir ifadede&lt;br /&gt;
&lt;br /&gt;
kelime.Substring(2,5);&lt;br /&gt;
&lt;br /&gt;
ifadesinde almak istediğimiz karakter adedi kadar&amp;nbsp; karakterin kelimede olması gerekmekte.&lt;br /&gt;
&lt;br /&gt;
örneğin ;&lt;br /&gt;
&lt;br /&gt;
Kelime=&quot;Kutu&quot;;&lt;br /&gt;
&lt;br /&gt;
string A= Kelime.Substring(2,5);&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; =&amp;gt; Exception alırız.&lt;br /&gt;
&lt;br /&gt;
Çünki &quot;t&quot; harfinden sonra 5 karakter bulunmamaktadır.&lt;br /&gt;
&lt;br /&gt;
iyi çalışmalar.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
! Substring Index and length must refer to a location within the string. Parameter name: length&amp;nbsp; </content><link rel='replies' type='application/atom+xml' href='http://hakancavus.blogspot.com/feeds/2548166328605478180/comments/default' title='Kayıt Yorumları'/><link rel='replies' type='text/html' href='http://hakancavus.blogspot.com/2015/09/c-substring-method-index-and-length.html#comment-form' title='0 Yorum'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/2548166328605478180'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/2548166328605478180'/><link rel='alternate' type='text/html' href='http://hakancavus.blogspot.com/2015/09/c-substring-method-index-and-length.html' title='C# Substring Method Index and length must refer to a location within the string. Parameter name: length '/><author><name>Admin</name><uri>http://www.blogger.com/profile/04412617293982531750</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9096531315361652031.post-9025108847784569303</id><published>2015-05-18T17:08:00.003+03:00</published><updated>2015-05-18T17:08:38.255+03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="asp.net  Fileupload Error"/><category scheme="http://www.blogger.com/atom/ns#" term="asp.net fileupload ERR_Reset"/><category scheme="http://www.blogger.com/atom/ns#" term="ERR_CONNECTION_RESET"/><title type='text'>Asp.Net ERR_CONNECTION_RESET</title><content type='html'>Genellikle fileupload nesnesi kullanılırken karşılaşılan bir sorundur. upload etmek istediğimiz dosyanın boyutu 4 mb dan büyük ise bunun la ilgili gerekli ayarlamaları web.config sayfamızdan yapmalıyız. aksi takdirde&amp;nbsp; ERR_CONNECTION_RESET hatası ile karşılaşırız.&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&amp;lt;system.web&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;compilation debug=&quot;true&quot; targetFramework=&quot;4.0&quot; /&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;span style=&quot;color: #38761d;&quot;&gt;&amp;nbsp;&lt;span style=&quot;color: #6aa84f;&quot;&gt; &amp;lt;httpRuntime executionTimeout=&quot;500&quot; maxRequestLength=&quot;5242880&quot;/&amp;gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/system.web&amp;gt;&lt;br /&gt;
&lt;br /&gt;
yukarıda ki yeşil renkli satırı&amp;nbsp; system.web taglarımız arasına ekleyeceğiz.&lt;br /&gt;
timeout zamanı ve byte cinsinden maksimum dosya boyutu sınırı tanımlıyoruz.&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: #38761d;&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;5242880 byte = 5 Mb&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: #38761d;&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;iyi çalışmalar. &lt;/span&gt;&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://hakancavus.blogspot.com/feeds/9025108847784569303/comments/default' title='Kayıt Yorumları'/><link rel='replies' type='text/html' href='http://hakancavus.blogspot.com/2015/05/aspnet-errconnectionreset.html#comment-form' title='0 Yorum'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/9025108847784569303'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/9025108847784569303'/><link rel='alternate' type='text/html' href='http://hakancavus.blogspot.com/2015/05/aspnet-errconnectionreset.html' title='Asp.Net ERR_CONNECTION_RESET'/><author><name>Admin</name><uri>http://www.blogger.com/profile/04412617293982531750</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9096531315361652031.post-8844524224290005430</id><published>2015-05-14T14:55:00.002+03:00</published><updated>2015-05-14T14:55:54.353+03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="5.5.1 authentication required"/><category scheme="http://www.blogger.com/atom/ns#" term="Gmail"/><category scheme="http://www.blogger.com/atom/ns#" term="Gmail 5.5.1 error"/><category scheme="http://www.blogger.com/atom/ns#" term="Gmail message send error"/><category scheme="http://www.blogger.com/atom/ns#" term="send message error"/><title type='text'>5.5.1 authentication required hatası Gmail Mail gönderme</title><content type='html'>Mail gönderim kodunuz çalışıyordu ama artık maillerin gönderilemediğini farkettiniz. Google getirdiği yeni bir güvenlik ayarıyla gmail uygulamaları dışındaki oturumlardan mail gönderimini engelledi. Bu sorunu aşmak için Gmail hesabınıza giriş yapıp ayarlara geliniz.&amp;nbsp; Hesaplar ve içe aktarma işlemi sekmesini seçiniz. Burada hesap ayarlarını değiştir kısmının yanındaki diğer google hesabı ayarları linkine basarak hesap ayarları sayfaya erişin. Hesap ayarları sayfasında oturum açma Bölümü altındaki Daha az güvenli uygulamalar için erişim ayarını aktif hale getireceğiz. böylece mail gönderme sorunumuzu aşmış olacağız. iyi çalışmalar. </content><link rel='replies' type='application/atom+xml' href='http://hakancavus.blogspot.com/feeds/8844524224290005430/comments/default' title='Kayıt Yorumları'/><link rel='replies' type='text/html' href='http://hakancavus.blogspot.com/2015/05/551-authentication-required-hatas-gmail.html#comment-form' title='0 Yorum'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/8844524224290005430'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/8844524224290005430'/><link rel='alternate' type='text/html' href='http://hakancavus.blogspot.com/2015/05/551-authentication-required-hatas-gmail.html' title='5.5.1 authentication required hatası Gmail Mail gönderme'/><author><name>Admin</name><uri>http://www.blogger.com/profile/04412617293982531750</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9096531315361652031.post-2183289948852390117</id><published>2015-05-12T17:35:00.004+03:00</published><updated>2015-05-15T14:28:20.345+03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="access could not be obtained"/><category scheme="http://www.blogger.com/atom/ns#" term="Sql restore error"/><title type='text'>exclusive access could not be obtained because the database is in use</title><content type='html'>Üzerinde işlem yapmaya çalıştığınız database in aktif olarak kullanımda olduğunu belirten hatadır. Genelde databese backup yükleme ve restore işlemlerinde karşılaşılır.Bir program yada servis o database e bağlı durumdadır.bu veritabanına bağlanabilecek olası uygulamalar kapatılarak işleminizi tekrarlayın.&lt;br /&gt;
iyi çalışmalar... </content><link rel='replies' type='application/atom+xml' href='http://hakancavus.blogspot.com/feeds/2183289948852390117/comments/default' title='Kayıt Yorumları'/><link rel='replies' type='text/html' href='http://hakancavus.blogspot.com/2015/05/exclusive-access-could-not-be-obtained.html#comment-form' title='2 Yorum'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/2183289948852390117'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/2183289948852390117'/><link rel='alternate' type='text/html' href='http://hakancavus.blogspot.com/2015/05/exclusive-access-could-not-be-obtained.html' title='exclusive access could not be obtained because the database is in use'/><author><name>Admin</name><uri>http://www.blogger.com/profile/04412617293982531750</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9096531315361652031.post-5288202317078058873</id><published>2015-04-16T12:00:00.001+03:00</published><updated>2015-04-16T23:35:37.583+03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Invalid attempt to call Read when reader is closed"/><title type='text'>Invalid attempt to call Read when reader is closed.</title><content type='html'>Senaryomuz veritabanımızdan çektiğimiz kayıtlarla bir combobox doldurmak olsun.&lt;br /&gt;
Bu işlem için datareader döndüren bir methodumuz var. bu methodda sql bağlantimiz datareader geri döndürüldükten sonra kapatılması gerekmektedir. aksi takdir. bu hatayı alırız.(Invalid attempt to call Read when reader is closed.) ayrıca combobox doldurma işlemi için aşağıdaki metodlardan faydalanabilirsiniz. iyi çalışmalar.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
public static SqlDataReader ReturnQueryDataReader(SqlCommand command)&lt;br /&gt;
{&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; SqlConnection Baglanti = new SqlConnection(ConnectionHelper.GetConnectionString());&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; if (Baglanti.State == ConnectionState.Closed)&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Baglanti.Open();&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; command.Connection = Baglanti;&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; SqlDataReader dr = command.ExecuteReader();&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;span style=&quot;color: #274e13;&quot;&gt;&amp;nbsp;&lt;span style=&quot;color: #38761d;&quot;&gt; return dr;&lt;/span&gt;&lt;/span&gt;&amp;nbsp;&amp;nbsp; // Bağlantı kapatılmadan önce değer döndürülmeli..&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Baglanti.Close();&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
public static void FillCombobox(ComboBoxEdit ComboName,int CategoryId )&lt;br /&gt;
{&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; string Sql =&quot;Select Distinct KOD From KODS Where CATEGORY=&quot; + CategoryId + &quot; &quot;);&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; SqlCommand Command = new SqlCommand(Sql);&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; SqlDataReader Dr = DatabaseHelper.ReturnQueryDataReader(Command);&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; while (Dr.Read())&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; {&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ComboName.Properties.Items.Add(Dr[0].ToString());&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; }&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Dr.Close();&lt;br /&gt;
&amp;nbsp;&amp;nbsp; }&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;</content><link rel='replies' type='application/atom+xml' href='http://hakancavus.blogspot.com/feeds/5288202317078058873/comments/default' title='Kayıt Yorumları'/><link rel='replies' type='text/html' href='http://hakancavus.blogspot.com/2015/04/invalid-attempt-to-call-read-when.html#comment-form' title='0 Yorum'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/5288202317078058873'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/5288202317078058873'/><link rel='alternate' type='text/html' href='http://hakancavus.blogspot.com/2015/04/invalid-attempt-to-call-read-when.html' title='Invalid attempt to call Read when reader is closed.'/><author><name>Admin</name><uri>http://www.blogger.com/profile/04412617293982531750</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9096531315361652031.post-1517311951544871226</id><published>2015-04-01T10:44:00.001+03:00</published><updated>2015-04-01T10:44:07.034+03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="A page can have only one server-side Form tag"/><category scheme="http://www.blogger.com/atom/ns#" term="Form tag"/><category scheme="http://www.blogger.com/atom/ns#" term="only one server-side Form tag"/><title type='text'>A page can have only one server-side Form tag.</title><content type='html'>bu sorun Sayfanızda 2 adet form tagı kullanmanızdan kaynaklanır.&lt;br /&gt;
en çok karşılaşılan yerlerin başında bir masterpage e bağlı alt sayfa içerisinde form tagı kullanmaktan kaynaklanır. alt sayfanızda ki &amp;lt;form&amp;gt; &amp;lt;/form&amp;gt;&amp;nbsp; tagını silerseniz sorununuz çözülecektir.&lt;br /&gt;
&lt;br /&gt;
iyi çalışmalar.</content><link rel='replies' type='application/atom+xml' href='http://hakancavus.blogspot.com/feeds/1517311951544871226/comments/default' title='Kayıt Yorumları'/><link rel='replies' type='text/html' href='http://hakancavus.blogspot.com/2015/04/a-page-can-have-only-one-server-side.html#comment-form' title='0 Yorum'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/1517311951544871226'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/1517311951544871226'/><link rel='alternate' type='text/html' href='http://hakancavus.blogspot.com/2015/04/a-page-can-have-only-one-server-side.html' title='A page can have only one server-side Form tag.'/><author><name>Admin</name><uri>http://www.blogger.com/profile/04412617293982531750</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9096531315361652031.post-3886049464034867057</id><published>2015-03-30T17:25:00.005+03:00</published><updated>2015-03-30T17:25:54.427+03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Interop type cannot be embedded. com nesnesi hatası"/><title type='text'>Interop type cannot be embedded. Use the applicable interface instead  com nesnesi hatası</title><content type='html'>&lt;span style=&quot;-webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: monospace; font-size: small; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 1; word-spacing: 0px;&quot;&gt;&lt;span style=&quot;-webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: monospace; font-size: small; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 1; word-spacing: 0px;&quot;&gt;Framework verisyonunuzu değiştirdiğinizde bu hata ile karşılaşabilirsiniz. (3.5 tan 4.0 a yükseltme) vb.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;-webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: monospace; font-size: small; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 1; word-spacing: 0px;&quot;&gt;&lt;span style=&quot;-webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: monospace; font-size: small; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 1; word-spacing: 0px;&quot;&gt;hata veren kodunuzu aşağıda ki şekilde düzeltip projenizi tekrar derleyin.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;-webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: monospace; font-size: small; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 1; word-spacing: 0px;&quot;&gt;&lt;span style=&quot;-webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: monospace; font-size: small; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 1; word-spacing: 0px;&quot;&gt;(class ifadesi kaldırılacak.)  iyi çalışmalar&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;-webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: monospace; font-size: small; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 1; word-spacing: 0px;&quot;&gt;&lt;span style=&quot;-webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: monospace; font-size: small; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 1; word-spacing: 0px;&quot;&gt;Myproject.ApplicationClass xlapp = new &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;-webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: monospace; font-size: small; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 1; word-spacing: 0px;&quot;&gt;&lt;span style=&quot;-webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: monospace; font-size: small; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 1; word-spacing: 0px;&quot;&gt;&lt;span style=&quot;-webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: monospace; font-size: small; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 1; word-spacing: 0px;&quot;&gt;&lt;span style=&quot;-webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: monospace; font-size: small; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 1; word-spacing: 0px;&quot;&gt;Myproject&lt;/span&gt;&lt;/span&gt;.ApplicationClass();&lt;/span&gt; &lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;-webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: monospace; font-size: small; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 1; word-spacing: 0px;&quot;&gt;&lt;span style=&quot;-webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: monospace; font-size: small; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 1; word-spacing: 0px;&quot;&gt;&lt;span style=&quot;-webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: monospace; font-size: small; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 1; word-spacing: 0px;&quot;&gt;Myproject&lt;/span&gt;&lt;/span&gt;.Application xlapp = new &lt;/span&gt;&lt;span style=&quot;-webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: monospace; font-size: small; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 1; word-spacing: 0px;&quot;&gt;&lt;span style=&quot;-webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: monospace; font-size: small; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 1; word-spacing: 0px;&quot;&gt;&lt;span style=&quot;-webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: monospace; font-size: small; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 1; word-spacing: 0px;&quot;&gt;Myproject&lt;/span&gt;&lt;/span&gt;.Application();&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://hakancavus.blogspot.com/feeds/3886049464034867057/comments/default' title='Kayıt Yorumları'/><link rel='replies' type='text/html' href='http://hakancavus.blogspot.com/2015/03/interop-type-cannot-be-embedded-use.html#comment-form' title='0 Yorum'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/3886049464034867057'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/3886049464034867057'/><link rel='alternate' type='text/html' href='http://hakancavus.blogspot.com/2015/03/interop-type-cannot-be-embedded-use.html' title='Interop type cannot be embedded. Use the applicable interface instead  com nesnesi hatası'/><author><name>Admin</name><uri>http://www.blogger.com/profile/04412617293982531750</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9096531315361652031.post-9114326469490510052</id><published>2015-03-30T15:17:00.000+03:00</published><updated>2015-03-30T15:17:15.557+03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="asp.net derleme hatası"/><category scheme="http://www.blogger.com/atom/ns#" term="Compiler Error Message: CS1061"/><category scheme="http://www.blogger.com/atom/ns#" term="CS1061 hatası"/><title type='text'>Compiler Error Message: CS1061 Asp.Net </title><content type='html'>Sayfanızın aşağıdaki bölümüde ki&lt;br /&gt;
&lt;br /&gt;
&amp;lt;%@ Page Title=&quot;&quot; Language=&quot;C#&quot; MasterPageFile=&quot;~/template.Master&quot; AutoEventWireup=&quot;true&quot;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; CodeBehind=&quot;tahsilat.aspx.cs&quot; Inherits=&quot;Proje.Tahsilat.tahsilat&quot; CodeFile=&quot;~/tahsilat.aspx.cs&quot; %&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
CodeFile=&quot;~/tahsilat.aspx.cs&quot;&amp;nbsp; kısmı sayfanızda olmayabilir. bunu ekleyerek tekrar deneyin. Bu şekilde hatayı giderdim. iyi çalışmalar&lt;br /&gt;
&lt;br /&gt;
Compiler Error Message: CS1061&amp;nbsp; çözüm</content><link rel='replies' type='application/atom+xml' href='http://hakancavus.blogspot.com/feeds/9114326469490510052/comments/default' title='Kayıt Yorumları'/><link rel='replies' type='text/html' href='http://hakancavus.blogspot.com/2015/03/compiler-error-message-cs1061-aspnet.html#comment-form' title='0 Yorum'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/9114326469490510052'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/9114326469490510052'/><link rel='alternate' type='text/html' href='http://hakancavus.blogspot.com/2015/03/compiler-error-message-cs1061-aspnet.html' title='Compiler Error Message: CS1061 Asp.Net '/><author><name>Admin</name><uri>http://www.blogger.com/profile/04412617293982531750</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9096531315361652031.post-630351873653449234</id><published>2014-12-11T15:26:00.000+02:00</published><updated>2014-12-11T17:25:01.249+02:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Session Class"/><category scheme="http://www.blogger.com/atom/ns#" term="session da class saklamak"/><title type='text'>Asp.Net Session Kullanımı Class ı session da Saklamak</title><content type='html'>Session lar Web sayfalarımız üzerinde saklamamız gereken verileri tutabileceğimiz bir yapıdır.&lt;br /&gt;
en basit örnekle Session[Deger]=&quot;Araba&quot;;&amp;nbsp; şeklinde bir session oluşturursak.&lt;br /&gt;
Başka bir kod bloğu içerisinde&amp;nbsp; Textbox1.text=Session[Deger].toString();&amp;nbsp; şeklinde bu&amp;nbsp; tanımladığımız sessionı kullanabiliriz.&lt;br /&gt;
&lt;br /&gt;
Daha farklı olarak çeşitli verileri de yine session da saklayabiliriz.&lt;br /&gt;
örneğin bi web sayfamızın üyelik sistemi var ve site içerisinde login olan kullanıcıya ait bilgiler çeşitli işlemlerde kullanılıyor. şöyle düşünün kullanıcımıza ait 10 adet bilgi var bunları veritabanından çektik. ve sessionda tutucaz. aklımıza şöyle bir tanımlama gelebilir. üst tarafta kullandığımız yöntem gibi tektek 10 adet session oluşturabiliriz ama bu doğru yöntem olmaz&amp;nbsp; &lt;br /&gt;
Session[Deger]=&quot;Ad&quot;;&lt;br /&gt;
Session[Deger]=&quot;soyad&quot;;&lt;br /&gt;
Session[Deger]=&quot;UyeNo&quot;; &amp;nbsp; Vb Gibi 10 adet tanımlama yaparsak kontrolü kaybederiz. &lt;br /&gt;
&lt;br /&gt;
Bunun yerine bir clas oluşturup çektiğimiz kullanıcı bilgilerini bu class içerisine doldurup sessionda saklarsak işimiz kolaylaşacaktır. şimdi bu işlemi aşama aşama görelim.&lt;br /&gt;
&lt;br /&gt;
1- classımızı oluşturalım.&lt;br /&gt;
public class UyeBilgiClass&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; {&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; public string Ad;&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; public string Soyad;&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; public string FirmaAdi;&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; public string Email;&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; public string Gsm;&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
2- Class içerisine bilgileri doldurup session üzerine atmak&lt;br /&gt;
&lt;br /&gt;
Bu kısımda fazla ayrıntıya&amp;nbsp; girmeyeceğim. çok farklı yöntemlerle yapılabilecek bir işlem. ben datatable a çektiğim veri üzerinde göstereceğim&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;Protected void BtnUyeGirisi_Click(object sender, EventArgs e)&lt;br /&gt;
{&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; UyeBilgiClass Uye= new UyeBilgiClass();&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; DataTable dt = GetUyeBilgileri(UyeId); // GetUyeBilgileri Bana üye bilgilerini&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; //datatable olarak döndüren bir metoddur.&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Uye.Ad=dt.Rows[0][&quot;Ad&quot;].ToString();&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Uye.Soyad=dt.Rows[0][&quot;Soyad&quot;].ToString();&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Uye.FirmaAdi=dt.Rows[0][&quot;FirmaAdi&quot;].ToString();&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Uye.Email=dt.Rows[0][&quot;Email&quot;].ToString(); &lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Uye.Gsm=dt.Rows[0][&quot;Gsm&quot;].ToString();&lt;br /&gt;
&amp;nbsp; &amp;nbsp; // Datatable daki bilgileri classımızdaki alanlara atadık&lt;br /&gt;
&amp;nbsp;&amp;nbsp; HttpContext.Current.Session[&quot;UyeBilgi&quot;] = Uye;&lt;br /&gt;
&amp;nbsp;&amp;nbsp; // classımızı sessiona atıyoruz.UyeBilgi ismin biz belirleyerek yazıyoruz. kendimiz istediğimiz bir&amp;nbsp;&amp;nbsp; //isim belirleyebiliriz. &lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
3- Şimdide sessionda buluna üye bilgilerini nasıl okuyup kullanıcaz onu görelim&lt;br /&gt;
Bunun için bize üye classımızı döndüren bir metod gerekiyor&lt;br /&gt;
public static UyeBilgiClass GetUyeSessionClass()&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; {&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;  UyeBilgiClass Uye= new UyeBilgiClass();&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Uye= ( UyeBilgiClass)HttpContext.Current.Session[&quot;UyeBilgi&quot;];&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; return Uye;&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; }&lt;br /&gt;
sessionlara ihtiyacımız olduğunda bu metod aracılığıyle verilerimizi alıcaz.&lt;br /&gt;
ama henüz işimiz bitmedi.çektiğimiz bilgileri textboxlara yazdırarak işlemi tamamlayalım&lt;br /&gt;
öncelikle classımızın tanımlamasını yapalım. değişken tanımlaması yapar gibi diyebilirim.&lt;br /&gt;
private  UyeBilgiClass Uye;&lt;br /&gt;
&lt;br /&gt;
Protected void BtnBilgileriYaz_Click(object sender, EventArgs e)&lt;br /&gt;
{&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Uye= new UyeBilgiClass ();&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; Uye= GetUyeSessionClass();&lt;br /&gt;
// Artık uye classımız içerisinde bilgilerimiz mevcut &lt;br /&gt;
Textbox1.text=Uye.Ad;&lt;br /&gt;
textbox2.Text=Uye.Soyad;&amp;nbsp; //Vb. Şekilde erişim sağlayabilriz.&lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
bu şekilde işlemimizi tamamladık. Faydalı olması dileğiyle..&lt;br /&gt;
------------------------------------------------------------------------------&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; </content><link rel='replies' type='application/atom+xml' href='http://hakancavus.blogspot.com/feeds/630351873653449234/comments/default' title='Kayıt Yorumları'/><link rel='replies' type='text/html' href='http://hakancavus.blogspot.com/2014/12/aspnet-session-kullanm-class-session-da.html#comment-form' title='0 Yorum'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/630351873653449234'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/630351873653449234'/><link rel='alternate' type='text/html' href='http://hakancavus.blogspot.com/2014/12/aspnet-session-kullanm-class-session-da.html' title='Asp.Net Session Kullanımı Class ı session da Saklamak'/><author><name>Admin</name><uri>http://www.blogger.com/profile/04412617293982531750</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9096531315361652031.post-804596154244620173</id><published>2012-10-11T22:58:00.000+03:00</published><updated>2012-10-11T23:28:08.961+03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="asp.net combobox doldurma"/><category scheme="http://www.blogger.com/atom/ns#" term="asp.net dropdown"/><category scheme="http://www.blogger.com/atom/ns#" term="c# dropdownlist fill"/><category scheme="http://www.blogger.com/atom/ns#" term="dropdownlist fill"/><title type='text'>C# Asp.Net Dropdownlist Veri Tabanından Doldurmak</title><content type='html'>Asp.net te açılır kutumuzu veri tabanından çekeceğimiz bilgiler ile aşağıda yazacağım metodları kullanarak&amp;nbsp; doldurabiliriz. Örnek olarak ürünlerimizi barındıran bir web sitemiz olduğunu ve bu ürünleri sitemize ekler iken&amp;nbsp; kategorisini seçtiğimiz dropdownlist i düşünelim.şimdi bu dropdownliste kategorileri nasıl doldurduğumuzu görelim.&lt;br /&gt;
&lt;br /&gt;
öncelikle&amp;nbsp; veri tabanından çektiğimiz kategorileri tutacak bir dataset oluşturur ve verileri buna doldururuz.&lt;br /&gt;
bize sonuç olarak dataset döndüren DatasetDoldur isminde bir fonksiyonumuz var ve bu fonksiyon parametre olarak sql cümlesi alıyor.daha sonra bu cümle çalışıyor ve kategorilerimizi bize dataset olarak döndürüyor. &lt;br /&gt;&lt;br /&gt;
public DataSet DatasetDoldur(string sql)&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; {&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; DataSet ds = new DataSet();&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; SqlDataAdapter da = new SqlDataAdapter(sql, Helper.BaglantiGetir());&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; da.Fill(ds);&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; return ds;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; } &lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;ikinci olarakta DropdownDoldur isminde bir metodumuz var.Bu metod içerisinde sql cümlemizi tanımlayabiliriz. burada bilmemiz gerekenler&amp;nbsp; DataTextField ve DataValueField ifadelerinin ne anlama geldiğidir.datatextfield bizim dropdownlist imizin görünen kısmını ifade eder. örneğin kategoriler düşünürsek gıda ,tekstil vs. dropdownlist açtığımızda bunlar görünür. ama genelde işlemler kategorilerin adı üzerinden değil benzersiz olan genelde ID dediğimiz anahtarlar üzerinden yapıldığından dolayı örneğin ben gıda kategorisini seçtiğimde bunun id si 7 olsun. Bu 7 değerinide datavaluefield kısmında saklanır.&lt;br /&gt;
datasource kısmı ise veri kaynağımızı gösterdiğimiz yerdir buradada datasetdoldur fonksiyonumuzu çağırarak dönecek datatable ı veri kaynağımız olarak gösteririz.&lt;br /&gt;
&lt;br /&gt;
public void DropdownDoldur()&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; {&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; string Sorgu = &quot;Select KategoriId,KategoriAdi From TblKategoriler&quot;;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; DropdownKategori.DataTextField = &quot;KategoriAdi&quot;;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp; DropdownKategori.DataValueField = &quot;KategoriId&quot;;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp; DropdownKategori.DataSource = DatasetDoldur(Sorgu);&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; DropdownKategori.DataBind();&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; }&lt;br /&gt;
&lt;br /&gt;
iyi çalışmalar. &lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; </content><link rel='replies' type='application/atom+xml' href='http://hakancavus.blogspot.com/feeds/804596154244620173/comments/default' title='Kayıt Yorumları'/><link rel='replies' type='text/html' href='http://hakancavus.blogspot.com/2012/10/c-aspnet-dropdownlist-veri-tabanndan.html#comment-form' title='2 Yorum'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/804596154244620173'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/804596154244620173'/><link rel='alternate' type='text/html' href='http://hakancavus.blogspot.com/2012/10/c-aspnet-dropdownlist-veri-tabanndan.html' title='C# Asp.Net Dropdownlist Veri Tabanından Doldurmak'/><author><name>Admin</name><uri>http://www.blogger.com/profile/04412617293982531750</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9096531315361652031.post-1384632295659903197</id><published>2012-06-25T17:51:00.001+03:00</published><updated>2014-11-29T23:50:56.425+02:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Devexpres gridview"/><category scheme="http://www.blogger.com/atom/ns#" term="Devexpress GridView dan Kayıt okuma."/><category scheme="http://www.blogger.com/atom/ns#" term="Grid üzerinde veri okumak"/><category scheme="http://www.blogger.com/atom/ns#" term="okuma İşlemi"/><title type='text'>C# Devexpress Gridview üzerinden kayıt okumak</title><content type='html'>C# Devexpress Gidview üzerinden satır ve kolon bazında okuma yapmak istiyorsak aşğıdaki yapıyı kullanabiliriz.&lt;br /&gt;
&lt;br /&gt;
kodumuzun çalışma mantığını açıklarsak şu şekildedir.&lt;br /&gt;
&lt;br /&gt;
1. döngümüz gridimiz üzerindeki satır sayısını alarak, işlemimizin satır sayımız kadar tekrarlanmasını sağlar. rowhandle ise bizim satır numaramız olur.&lt;br /&gt;
&lt;br /&gt;
2. döngüde ise satırımızdaki kolon sayısı kadar döncek bir döngü kurulmuştur. &lt;br /&gt;
&lt;br /&gt;
ikinci döngü her arttığında object tipte tanımlanmış v değişkenine kolondan&amp;nbsp; okunan değer GetRowCellValue metoduyla alınır.bu metod parametre olarak satır numarasını ve konumlanılan kolonun adresini alır.&lt;br /&gt;
&lt;br /&gt;
for (int i = 0; i &amp;lt; GridView.RowCount; i++)&amp;nbsp; // 1. döngü&lt;br /&gt;
&amp;nbsp;{&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; int rowHandle =&amp;nbsp; GridView.GetVisibleRowHandle(i);&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; if ( GridView.IsDataRow(rowHandle))&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; {&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; for (int c = 0; c &amp;lt;&amp;nbsp; GridView.VisibleColumns.Count; c++) // 2. döngü&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; {&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; object v=&amp;nbsp; GridView.GetRowCellValue(rowHandle,&amp;nbsp; GridView.VisibleColumns[c]);&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; if (c == 0)&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ad= v.ToString();&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; if (c == 1)&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; soyad= v.ToString();&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; if (c == 2)&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; telefon= v.ToString();&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; }&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; }&lt;br /&gt;
&amp;nbsp;&amp;nbsp; // bu kısımda bilgiler kullanılarak işlem yapılabilir. örneğin okunan bilgileri veritabanına kaydetme. &lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
yukarıdaki kodu incelediğimizde grid üzerinde değer okuyacağımız 3 adet kolon olduğu varsayılmıştır. Kolon numaralarımız sıfır(0) dan başladığı için daha önce tanımlayacağımız ad değişkenine ad kolonundaki değer alınır yine aynı şekilde soyad değişkeninede 1 kolondaki soyad bilgisi ve telefonda 2 kolondan alınır. Bu aşamada grid üzerinde bulunan satılarımızdan birindeki bilgileri elde etmiş oluruz. 2. döngüden çıkıldıktan sonra elde ettiğimiz bilgiler ile ilgi bir işlem yukarıda yazdığım alanda yapabilir. Çünki programımızın 1. döngüye tekrar dönmemesi gerekir. aksi takdirde program bir sonraki satırı okumaya geçer ve elde ettiğimiz diğer bilgiler kaybolur.kodu geliştirmek sizin elinizde farklı şekillerde de kullanabilirsiniz.&lt;br /&gt;
&lt;br /&gt;
İyi Çalışmalar.. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;</content><link rel='replies' type='application/atom+xml' href='http://hakancavus.blogspot.com/feeds/1384632295659903197/comments/default' title='Kayıt Yorumları'/><link rel='replies' type='text/html' href='http://hakancavus.blogspot.com/2012/06/c-devexpress-gridview-uzerinden-kayt.html#comment-form' title='1 Yorum'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/1384632295659903197'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/1384632295659903197'/><link rel='alternate' type='text/html' href='http://hakancavus.blogspot.com/2012/06/c-devexpress-gridview-uzerinden-kayt.html' title='C# Devexpress Gridview üzerinden kayıt okumak'/><author><name>Admin</name><uri>http://www.blogger.com/profile/04412617293982531750</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9096531315361652031.post-6673067598884034273</id><published>2012-06-12T22:26:00.001+03:00</published><updated>2015-04-24T10:21:31.047+03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="button shortcut key"/><category scheme="http://www.blogger.com/atom/ns#" term="C# Kısayol atama"/><category scheme="http://www.blogger.com/atom/ns#" term="keydown olayı"/><category scheme="http://www.blogger.com/atom/ns#" term="keypreview"/><category scheme="http://www.blogger.com/atom/ns#" term="kısayol tuşu"/><title type='text'>C# ta Butona Kısayol Tuşu Atamak(Keydown event)</title><content type='html'>C# ta Butonlarımıza klavye kısayolları ekleyebiliriz. Örneğin form üzerinde kaydetme işlemimizi gerçekleştiren BtnKaydet isimli bir butonumuz olsun ve bu butonun kısayoluda F5 tuşu olsun.&lt;br /&gt;
ilk olarak işe formumuzun basılan tuşları yakalayabilmesi için Properties kısmından Keypreview özelliğini true yapalım. daha sonra formumuzun keydown olayında aşağıdaki kodu yazalım.&lt;br /&gt;
&lt;br /&gt;
if(e.KeyCode==Keys.F5)&lt;br /&gt;
{&lt;br /&gt;
&amp;nbsp;BtnKaydet.PerformClick();&lt;br /&gt;
} &lt;br /&gt;
&lt;br /&gt;
bu kod çalıştırıldığında ve F5 tuşuna basıldığın da BtnKaydet Butonumuz için yazdığımız kod çalşıtırılacaktır.&lt;br /&gt;
&lt;br /&gt;
iyi çalışmalar.&lt;br /&gt;
&lt;br /&gt;</content><link rel='replies' type='application/atom+xml' href='http://hakancavus.blogspot.com/feeds/6673067598884034273/comments/default' title='Kayıt Yorumları'/><link rel='replies' type='text/html' href='http://hakancavus.blogspot.com/2012/06/c-ta-butona-ksayol-tusu-atamakkeydown.html#comment-form' title='9 Yorum'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/6673067598884034273'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/6673067598884034273'/><link rel='alternate' type='text/html' href='http://hakancavus.blogspot.com/2012/06/c-ta-butona-ksayol-tusu-atamakkeydown.html' title='C# ta Butona Kısayol Tuşu Atamak(Keydown event)'/><author><name>Admin</name><uri>http://www.blogger.com/profile/04412617293982531750</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>9</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9096531315361652031.post-6648253557596260986</id><published>2012-06-12T22:10:00.002+03:00</published><updated>2012-06-13T01:13:21.541+03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Devexpres gridview"/><category scheme="http://www.blogger.com/atom/ns#" term="Devexpres gridview rowcount"/><category scheme="http://www.blogger.com/atom/ns#" term="gridview kayıt sayısı öğrenme"/><title type='text'>C# Devexpress GridView Kayıt Sayısını Almak</title><content type='html'>Devexpress gridimizdeki kayıt sayısını bulmak için aşağıdaki kodu kullanabiliriz.&lt;br /&gt;
GridView ımızın ismi MusterilerView olsun &lt;br /&gt;
&lt;br /&gt;
int kayitsayisi; // kayıt sayısını tutacak değişkenimiz&lt;br /&gt;
kayitsayisi=convert.ToInt32(MusterilerView.RowCount);&lt;br /&gt;
&lt;br /&gt;
İyi çalışmlar.</content><link rel='replies' type='application/atom+xml' href='http://hakancavus.blogspot.com/feeds/6648253557596260986/comments/default' title='Kayıt Yorumları'/><link rel='replies' type='text/html' href='http://hakancavus.blogspot.com/2012/06/c-devexpress-gridview-kayt-saysn-almak.html#comment-form' title='0 Yorum'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/6648253557596260986'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/6648253557596260986'/><link rel='alternate' type='text/html' href='http://hakancavus.blogspot.com/2012/06/c-devexpress-gridview-kayt-saysn-almak.html' title='C# Devexpress GridView Kayıt Sayısını Almak'/><author><name>Admin</name><uri>http://www.blogger.com/profile/04412617293982531750</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9096531315361652031.post-114043700713462655</id><published>2012-01-28T00:31:00.000+02:00</published><updated>2012-06-16T12:02:55.819+03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="c# içerisinden sql çalıştırmak."/><category scheme="http://www.blogger.com/atom/ns#" term="Sql script run"/><title type='text'>C# ile Sql Script Çalıştırmak</title><content type='html'>Bazen programlarımızda sql scriptleri program üzerinden çalıştırmaya ihtiyac duyabiliriz. Bu durumda fiziksel bir yol üzerinde bulunan sql scriptimizi program içerisinden okuyarak ve metodumuz ile çalıştırarak işlemi gerçekleştirebiliriz.&lt;br /&gt;
&lt;br /&gt;
okuma işlemimizi fileinfo sınıfını kullanarak aşağıdaki şekilde scripti string bir değişken içerisine aktararak gerçekleştiriyoruz. burada scriptimizin bulunduğu yolu veriyoruz ve ReadToEnd ile okunmasını sağlıyoruz.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
FileInfo file = new FileInfo(&quot;C:\\Script.sql&quot;);&lt;br /&gt;
string scripttext = file.OpenText().ReadToEnd();&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;u&gt;Metodumuz&lt;/u&gt;&lt;br /&gt;
&lt;br /&gt;
protected virtual void ExecuteScript(SqlConnection connection, string script)&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; {&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; string[] commandTextArray = script.Split(new string[] { &quot;GO&quot; }, StringSplitOptions.RemoveEmptyEntries);&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; connection.Open();&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; foreach (string commandText in commandTextArray)&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; {&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; if (commandText.Trim() == string.Empty) continue;&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; SqlCommand command = new SqlCommand(commandText, connection);&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; command.ExecuteNonQuery();&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; }&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; connection.Close();&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; } &lt;br /&gt;
&lt;br /&gt;
Okuma işlemi gerçekleştirildikten sonra metodumuzu kullanabiliriz.&lt;br /&gt;
&lt;br /&gt;
ExecuteScript(baglanti, scripttext);&lt;br /&gt;
&lt;br /&gt;
Not: bağlantımız örnek olarak &amp;nbsp;sqlconnection baglanti=new sqlconnection(); şeklinde tanımlanmış bir bağlantı olabilir. Kolay gelsin...&lt;br /&gt;
&lt;br /&gt;</content><link rel='replies' type='application/atom+xml' href='http://hakancavus.blogspot.com/feeds/114043700713462655/comments/default' title='Kayıt Yorumları'/><link rel='replies' type='text/html' href='http://hakancavus.blogspot.com/2012/01/c-ile-sql-script-calstrmak.html#comment-form' title='0 Yorum'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/114043700713462655'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/114043700713462655'/><link rel='alternate' type='text/html' href='http://hakancavus.blogspot.com/2012/01/c-ile-sql-script-calstrmak.html' title='C# ile Sql Script Çalıştırmak'/><author><name>Admin</name><uri>http://www.blogger.com/profile/04412617293982531750</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9096531315361652031.post-6301754562982198782</id><published>2012-01-27T23:43:00.002+02:00</published><updated>2015-02-23T14:45:09.306+02:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="IIS izinler"/><category scheme="http://www.blogger.com/atom/ns#" term="IIS klasöre izin vermek"/><category scheme="http://www.blogger.com/atom/ns#" term="IIS permission"/><title type='text'>C# IIS üzerindeki Klasörlere izin vermek (kod ile)</title><content type='html'>Bazı uygulamalarımızda ISS üzerindeki kullanacağımız klasörlerimize uygulama tarafında izinler vermemeiz gerekebilir bunun için aşağıda bahsedeceğim &amp;nbsp;yapıyı kullanarak çözüm üretebilirsiniz. öncelikle aşağıdaki metodu kullanacağımızı belirteyim. ve sonrasında da biraz açıklayalım.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
public void YazimIzniVer(string HesapAdi, string klasorYolu)&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; {&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; try&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; {&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; if (Directory.Exists(klasorYolu))&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; {&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; var klasor = new DirectoryInfo(klasorYolu);&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; var klasorGuvenligi = klasor.GetAccessControl();&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; var rule = new FileSystemAccessRule(HesapAdi, FileSystemRights.FullControl, InheritanceFlags.None | InheritanceFlags.ContainerInherit | InheritanceFlags.ObjectInherit, PropagationFlags.None, AccessControlType.Allow);&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; klasorGuvenligi.SetAccessRule(rule);&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; klasor.SetAccessControl(klasorGuvenligi);&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; }&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; }&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; catch (Exception)&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; {&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; MessageBox.Show(&quot;klasör izni verilemedi.&quot;);&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; }&lt;br /&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; }&lt;br /&gt;
&lt;br /&gt;
metodumuz içerisine 2 değer almaktadır HesapAdi ve KlasorYolu. &amp;nbsp;Hesap adımız kullanılan IIS versiyonuna göre değişmektedir. IIS 7 için IIS_IUSRS &amp;nbsp;ve IIS 6 için de IIS_WPG bizim hesap adlarımızdır.&lt;br /&gt;
&lt;br /&gt;
bu metod içerisinde bir noktaya değinicem. aşağıdaki satırda&lt;br /&gt;
&lt;br /&gt;
var rule = new FileSystemAccessRule(HesapAdi, FileSystemRights.FullControl, InheritanceFlags.None | InheritanceFlags.ContainerInherit | InheritanceFlags.ObjectInherit, PropagationFlags.None, AccessControlType.Allow);
&lt;br /&gt;
&lt;br /&gt;
FileSystemRights.FullControl kısmı bizim vereceğimiz izni belirtmektedir. biz bura da tam yetki vermişiz siz kendinize uygun olanı kullanabilirsiniz.&lt;br /&gt;
&lt;br /&gt;
şimdide bu metodumuzu nasıl kullanıcaz örnek bir satırda bunu görelim.&lt;br /&gt;
&lt;br /&gt;
YazimIzniVer(&quot;IIS_IUSRS&quot;, &quot;C:\\inetpub\\wwwroot\\uygulamaklasorunuz\\image&quot;);&lt;br /&gt;
&lt;br /&gt;
evet görünen şekilde metodumuza ilk olarak IIS 7 versiyonuna göre hesap adımızı verdik daha sonrada klasör yolumuzu. siz klasör yolunu bir değişken olarakta buraya atayabilirsiniz.&lt;br /&gt;
&lt;br /&gt;
kodumuz çalıştığında image klasörüne belirlediğimiz izin verilecektir. Kolay gelsin...</content><link rel='replies' type='application/atom+xml' href='http://hakancavus.blogspot.com/feeds/6301754562982198782/comments/default' title='Kayıt Yorumları'/><link rel='replies' type='text/html' href='http://hakancavus.blogspot.com/2012/01/c-iis-uzerindeki-klasorlere-izin-vermek.html#comment-form' title='0 Yorum'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/6301754562982198782'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/6301754562982198782'/><link rel='alternate' type='text/html' href='http://hakancavus.blogspot.com/2012/01/c-iis-uzerindeki-klasorlere-izin-vermek.html' title='C# IIS üzerindeki Klasörlere izin vermek (kod ile)'/><author><name>Admin</name><uri>http://www.blogger.com/profile/04412617293982531750</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-9096531315361652031.post-2802561936664187677</id><published>2012-01-27T22:54:00.000+02:00</published><updated>2012-06-12T22:39:00.225+03:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="C#  IIS Ugulama çalıştırma"/><category scheme="http://www.blogger.com/atom/ns#" term="ISS uygulama Ayarları"/><category scheme="http://www.blogger.com/atom/ns#" term="X86 And x64 Application"/><title type='text'>64 BIT OS üzerindeki IIS te 32 BIT Uygulamaları Çalıştırmak</title><content type='html'>Geliştirdiğiniz 32 bit (x86) uygulamanızı 64 işletim sistemi üzerinde ki &amp;nbsp;IIS sunucusunda çalıştırmak istediğinizde beklemediğiniz bir hata alabilirsiniz. Bu hatayı almamak için IIS sunucunuzun 32 bit uygulamaları çalıştıma özelliğini aktif etmeniz gerekmektedir. Bu işlem için ISS sunucunuzun arayüz programını girin application pools menüsüne tıklayın açılan pencerede sağtıklayıp ayarlara girin ve ilgili özelliği true yapın. iyi çalışmalar.</content><link rel='replies' type='application/atom+xml' href='http://hakancavus.blogspot.com/feeds/2802561936664187677/comments/default' title='Kayıt Yorumları'/><link rel='replies' type='text/html' href='http://hakancavus.blogspot.com/2012/01/64-bit-os-uzerindeki-iis-te-32-bit.html#comment-form' title='0 Yorum'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/2802561936664187677'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9096531315361652031/posts/default/2802561936664187677'/><link rel='alternate' type='text/html' href='http://hakancavus.blogspot.com/2012/01/64-bit-os-uzerindeki-iis-te-32-bit.html' title='64 BIT OS üzerindeki IIS te 32 BIT Uygulamaları Çalıştırmak'/><author><name>Admin</name><uri>http://www.blogger.com/profile/04412617293982531750</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>