Alt 17. May 2008, 03:42 AM   #1 (permalink)
Amatör
 
McDroPp - ait Kullanıcı Resmi (Avatar)
 
Üyelik tarihi: Mar 2008
Nerden: C# SQl Server 2008 İnformation Technology's Server Secretary And Aspx To lınk Tecnolojıes,Mybb
Mesajlar: 51
Standart Visual C#.NET'te Veritabanı İşlemleri - 2

Visual C#.NET de Veritabanı İşlemleri-2
--------------------------------------------------------------------------------
Veritabanımızda ekle-sil-yenile-bul-güncelle-exel'e gönder işlemlerini yapmamızı sağlar.
using System;
using System.Drawing;
using System.Drawing.Printing;
using System.IO;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.OleDb;
using System.Runtime.InteropServices;
using Office = Microsoft.Office.Core;


namespace ocx
{
/// <summary>
/// Summary description for Form1.
/// </summary>
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.DataGrid dataGrid1;
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.TextBox textBox2;
private System.Windows.Forms.TextBox textBox3;
private System.Windows.Forms.TextBox textBox4;
private System.Windows.Forms.TextBox textBox5;
private System.Windows.Forms.TextBox textBox6;
private System.Windows.Forms.TextBox textBox7;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.Label label3;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.Label label5;
private System.Windows.Forms.Label label6;
private System.Windows.Forms.Label label7;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.GroupBox groupBox1;
private System.Windows.Forms.Button temizle;
private System.Windows.Forms.Button sil;
private System.Windows.Forms.Button kayit;
private System.Windows.Forms.Button bul;
private System.Windows.Forms.Button güncelle;
private System.Windows.Forms.Button button2;
private System.Windows.Forms.Button button4;
private System.Windows.Forms.Timer timer1;
private System.ComponentModel.IContainer components;

public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();


//
// TODO: Add any constructor code after InitializeComponent call
//
}

/// <summary>
/// Clean up any resources being used.
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}

#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typ eof(Form1));
this.dataGrid1 = new System.Windows.Forms.DataGrid();
this.textBox1 = new System.Windows.Forms.TextBox();
this.textBox2 = new System.Windows.Forms.TextBox();
this.textBox3 = new System.Windows.Forms.TextBox();
this.textBox4 = new System.Windows.Forms.TextBox();
this.textBox5 = new System.Windows.Forms.TextBox();
this.textBox6 = new System.Windows.Forms.TextBox();
this.textBox7 = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.label5 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.label7 = new System.Windows.Forms.Label();
this.button1 = new System.Windows.Forms.Button();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.button4 = new System.Windows.Forms.Button();
this.button2 = new System.Windows.Forms.Button();
this.temizle = new System.Windows.Forms.Button();
this.sil = new System.Windows.Forms.Button();
this.kayit = new System.Windows.Forms.Button();
this.bul = new System.Windows.Forms.Button();
this.güncelle = new System.Windows.Forms.Button();
this.timer1 = new System.Windows.Forms.Timer(this.components);
((System.ComponentModel.ISupportInitialize)(this.d ataGrid1)).BeginInit();
this.groupBox1.SuspendLayout();
this.SuspendLayout();
//
// dataGrid1
//
this.dataGrid1.BackgroundColor = System.Drawing.SystemColors.Info;
this.dataGrid1.CaptionBackColor = System.Drawing.Color.LightSkyBlue;
this.dataGrid1.CaptionForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.CaptionText = " KAYITLI PERSONELLER";
this.dataGrid1.DataMember = "";
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(8 104);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.Size = new System.Drawing.Size(520 160);
this.dataGrid1.TabIndex = 0;
this.dataGrid1.DoubleClick += new System.EventHandler(this.dataGrid1_DoubleClick);
this.dataGrid1.CurrentCellChanged += new System.EventHandler(this.dataGrid1_CurrentCellChan ged);
this.dataGrid1.Navigate += new System.Windows.Forms.NavigateEventHandler(this.dat aGrid1_Navigate);
//
// textBox1
//
this.textBox1.BackColor = System.Drawing.SystemColors.Info;
this.textBox1.Font = new System.Drawing.Font("Microsoft Sans Serif" 9F System.Drawing.FontStyle.Bold System.Drawing.GraphicsUnit.Point ((byte)(162)));
this.textBox1.ForeColor = System.Drawing.Color.Red;
this.textBox1.Location = new System.Drawing.Point(96 8);
this.textBox1.Name = "textBox1";
this.textBox1.ReadOnly = true;
this.textBox1.Size = new System.Drawing.Size(72 21);
this.textBox1.TabIndex = 2;
//
// textBox2
//
this.textBox2.Location = new System.Drawing.Point(96 32);
this.textBox2.Name = "textBox2";
this.textBox2.Size = new System.Drawing.Size(72 20);
this.textBox2.TabIndex = 3;
//
// textBox3
//
this.textBox3.Location = new System.Drawing.Point(96 56);
this.textBox3.Name = "textBox3";
this.textBox3.Size = new System.Drawing.Size(144 20);
this.textBox3.TabIndex = 4;
//
// textBox4
//
this.textBox4.Location = new System.Drawing.Point(96 80);
this.textBox4.Name = "textBox4";
this.textBox4.Size = new System.Drawing.Size(144 20);
this.textBox4.TabIndex = 5;
//
// textBox5
//
this.textBox5.Location = new System.Drawing.Point(336 8);
this.textBox5.Name = "textBox5";
this.textBox5.Size = new System.Drawing.Size(144 20);
this.textBox5.TabIndex = 6;
//
// textBox6
//
this.textBox6.Location = new System.Drawing.Point(336 32);
this.textBox6.Name = "textBox6";
this.textBox6.Size = new System.Drawing.Size(56 20);
this.textBox6.TabIndex = 7;
//
// textBox7
//
this.textBox7.Location = new System.Drawing.Point(336 56);
this.textBox7.Name = "textBox7";
this.textBox7.Size = new System.Drawing.Size(136 20);
this.textBox7.TabIndex = 8;
//
// label1
//
this.label1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this.label1.Location = new System.Drawing.Point(8 32);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(80 20);
this.label1.TabIndex = 13;
this.label1.Text = "Sicil";
this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label2
//
this.label2.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this.label2.Location = new System.Drawing.Point(8 56);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(80 20);
this.label2.TabIndex = 14;
this.label2.Text = "Adı";
this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label3
//
this.label3.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this.label3.Location = new System.Drawing.Point(8 80);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(80 20);
this.label3.TabIndex = 15;
this.label3.Text = "Soyadı";
this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label4
//
this.label4.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this.label4.Location = new System.Drawing.Point(248 8);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(80 20);
this.label4.TabIndex = 16;
this.label4.Text = "Ünvan";
this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label5
//
this.label5.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this.label5.Location = new System.Drawing.Point(248 32);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(80 20);
this.label5.TabIndex = 17;
this.label5.Text = "Hizmet Süresi";
this.label5.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label6
//
this.label6.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this.label6.Location = new System.Drawing.Point(248 56);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(80 20);
this.label6.TabIndex = 18;
this.label6.Text = "Servis";
this.label6.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label7
//
this.label7.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this.label7.Location = new System.Drawing.Point(8 8);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(80 20);
this.label7.TabIndex = 19;
this.label7.Text = "Sıra No";
this.label7.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// button1
//
this.button1.BackColor = System.Drawing.Color.AliceBlue;
this.button1.Location = new System.Drawing.Point(80 64);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(104 24);
this.button1.TabIndex = 20;
this.button1.Text = "Excel\'e Gönder";
this.button1.UseVisualStyleBackColor = false;
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// groupBox1
//
this.groupBox1.BackColor = System.Drawing.SystemColors.InactiveCaption;
this.groupBox1.Controls.Add(this.button4);
this.groupBox1.Controls.Add(this.button2);
this.groupBox1.Controls.Add(this.temizle);
this.groupBox1.Controls.Add(this.sil);
this.groupBox1.Controls.Add(this.kayit);
this.groupBox1.Controls.Add(this.bul);
this.groupBox1.Controls.Add(this.güncelle);
this.groupBox1.Controls.Add(this.button1);
this.groupBox1.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.groupBox1.Location = new System.Drawing.Point(96 280);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(432 96);
this.groupBox1.TabIndex = 22;
this.groupBox1.TabStop = false;
//
// button4
//
this.button4.BackColor = System.Drawing.Color.Bisque;
this.button4.Location = new System.Drawing.Point(8 16);
this.button4.Name = "button4";
this.button4.Size = new System.Drawing.Size(64 24);
this.button4.TabIndex = 27;
this.button4.Text = "Yenile";
this.button4.UseVisualStyleBackColor = false;
this.button4.Click += new System.EventHandler(this.button4_Click);
//
// button2
//
this.button2.BackColor = System.Drawing.Color.AliceBlue;
this.button2.Location = new System.Drawing.Point(216 64);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(112 24);
this.button2.TabIndex = 26;
this.button2.Text = "Excel\'den Al";
this.button2.UseVisualStyleBackColor = false;
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// temizle
//
this.temizle.BackColor = System.Drawing.Color.Bisque;
this.temizle.Location = new System.Drawing.Point(80 16);
this.temizle.Name = "temizle";
this.temizle.Size = new System.Drawing.Size(64 24);
this.temizle.TabIndex = 17;
this.temizle.Text = "Temizle";
this.temizle.UseVisualStyleBackColor = false;
this.temizle.Click += new System.EventHandler(this.temizle_Click);
//
// sil
//
this.sil.BackColor = System.Drawing.Color.Bisque;
this.sil.Location = new System.Drawing.Point(368 16);
this.sil.Name = "sil";
this.sil.Size = new System.Drawing.Size(56 24);
this.sil.TabIndex = 16;
this.sil.Text = "Sil";
this.sil.UseVisualStyleBackColor = false;
this.sil.Click += new System.EventHandler(this.sil_Click);
//
// kayit
//
this.kayit.BackColor = System.Drawing.Color.Bisque;
this.kayit.Location = new System.Drawing.Point(296 16);
this.kayit.Name = "kayit";
this.kayit.Size = new System.Drawing.Size(64 24);
this.kayit.TabIndex = 15;
this.kayit.Text = "Kayıt";
this.kayit.UseVisualStyleBackColor = false;
this.kayit.Click += new System.EventHandler(this.kayit_Click);
//
// bul
//
this.bul.BackColor = System.Drawing.Color.Bisque;
this.bul.Location = new System.Drawing.Point(152 16);
this.bul.Name = "bul";
this.bul.Size = new System.Drawing.Size(64 24);
this.bul.TabIndex = 14;
this.bul.Text = "Bul";
this.bul.UseVisualStyleBackColor = false;
this.bul.Click += new System.EventHandler(this.bul_Click);
//
// güncelle
//
this.güncelle.BackColor = System.Drawing.Color.Bisque;
this.güncelle.Location = new System.Drawing.Point(224 16);
this.güncelle.Name = "güncelle";
this.güncelle.Size = new System.Drawing.Size(64 24);
this.güncelle.TabIndex = 13;
this.güncelle.Text = "Güncelle";
this.güncelle.UseVisualStyleBackColor = false;
this.güncelle.Click += new System.EventHandler(this.güncelle_Click);
//
// timer1
//
this.timer1.Tick += new System.EventHandler(this.timer1_Tick);
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5 13);
this.BackColor = System.Drawing.SystemColors.Control;
this.ClientSize = new System.Drawing.Size(536 381);
this.Controls.Add(this.groupBox1);
this.Controls.Add(this.label7);
this.Controls.Add(this.label6);
this.Controls.Add(this.label5);
this.Controls.Add(this.label4);
this.Controls.Add(this.label3);
this.Controls.Add(this.label2);
this.Controls.Add(this.label1);
this.Controls.Add(this.textBox7);
this.Controls.Add(this.textBox6);
this.Controls.Add(this.textBox5);
this.Controls.Add(this.textBox4);
this.Controls.Add(this.textBox3);
this.Controls.Add(this.textBox2);
this.Controls.Add(this.textBox1);
this.Controls.Add(this.dataGrid1);
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this. Icon")));
this.IsMdiContainer = true;
this.MaximizeBox = false;
this.Name = "Form1";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScree n;
this.Text = "Form1";
this.Load += new System.EventHandler(this.Form1_Load);
((System.ComponentModel.ISupportInitialize)(this.d ataGrid1)).EndInit();
this.groupBox1.ResumeLayout(false);
this.ResumeLayout(false);
this.PerformLayout();

}
#endregion

/// <summary>
/// The main entry point for the application.
/// </summary>
[STAThread]
static void Main()
{
Application.Run(new Form1());
}

OleDbConnection odc;
OleDbDataAdapter adp;
DataSet dt;
OleDbCommandBuilder cb;// OleDbDataAdapter'i silme güncelleme ve kayıt'a hazır hale getirmek için
private void Form1_Load(object sender System.EventArgs e)
{
this.Text = " ** Hazırlayan: Ahmet Ali Süzen** ";
timer1.Interval = 100;
timer1.Enabled = true;

string baglanti = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath.ToString() + "\\Kutuk.mdb";
string sorgu="SELECT * FROM IZIN";
odc = new OleDbConnection(baglanti);
adp = new OleDbDataAdapter(sorguodc);
dt=new DataSet();

adp.Fill(dt "IZIN");
dataGrid1.ReadOnly=true;
dataGrid1.CaptionText="KAYITLI PERSONELLER";
dataGrid1.DataSource = dt.Tables[0];
}

private void dataGrid1_DoubleClick(object sender System.EventArgs e)
{
textBox1.DataBindings.Clear();
textBox2.DataBindings.Clear();
textBox3.DataBindings.Clear();
textBox4.DataBindings.Clear();
textBox5.DataBindings.Clear();
textBox6.DataBindings.Clear();
textBox7.DataBindings.Clear();
textBox1.DataBindings.Add("Text" dt.Tables[0]"ID");
textBox2.DataBindings.Add("Text" dt.Tables[0]"Sicil");
textBox3.DataBindings.Add("Text" dt.Tables[0]"Adi");
textBox4.DataBindings.Add("Text" dt.Tables[0]"Soyadi");
textBox5.DataBindings.Add("Text" dt.Tables[0]"Unvan");
textBox6.DataBindings.Add("Text" dt.Tables[0]"HizmetSuresi");
textBox7.DataBindings.Add("Text" dt.Tables[0]"Servis");
textBox2.Focus();
}

private void güncelle_Click(object sender System.EventArgs e)
{
CurrencyManager sonraki=
(CurrencyManager)this.BindingContext[dt.Tables["IZIN"]];
sonraki.EndCurrentEdit();
cb=new OleDbCommandBuilder(adp); // OleDbDataAdapter'i silme güncelleme ve kayıt'a hazır hale getirmek için
adp.Update(dt "IZIN");
dt.Clear();
adp.Fill(dt.Tables[0]);

dataGrid1.DataSource = dt.Tables[0];
MessageBox.Show (" Güncelleme tamamlandı!" "İŞLEM TAMAM");
}

private void bul_Click(object sender System.EventArgs e)
{
int kayit=0;
CurrencyManager yonet=
(CurrencyManager)this.BindingContext[dt.Tables["IZIN"]];
foreach(DataRow satir in dt.Tables[0].Rows)
{
if(satir["Sicil"].ToString()==textBox2.Text)
{
yonet.Position = kayit;
textBox1.DataBindings.Clear();
textBox2.DataBindings.Clear();
textBox3.DataBindings.Clear();
textBox4.DataBindings.Clear();
textBox5.DataBindings.Clear();
textBox6.DataBindings.Clear();
textBox7.DataBindings.Clear();
textBox1.DataBindings.Add("Text" dt.Tables[0]"ID");
textBox2.DataBindings.Add("Text" dt.Tables[0]"Sicil");
textBox3.DataBindings.Add("Text" dt.Tables[0]"Adi");
textBox4.DataBindings.Add("Text" dt.Tables[0]"Soyadi");
textBox5.DataBindings.Add("Text" dt.Tables[0]"Unvan");
textBox6.DataBindings.Add("Text" dt.Tables[0]"HizmetSuresi");
textBox7.DataBindings.Add("Text" dt.Tables[0]"Servis");
textBox2.Focus();
return;
}
kayit++;
if(kayit>dt.Tables["IZIN"].Rows.Count-1)
{
MessageBox.Show (" Aradığınız SİCİL NO'lu personele ait izin kaydı bulunamadı!");
textBox1.Focus();
}
}
}

private void kayit_Click(object sender System.EventArgs e)
{
System.Data.DataRow ekle;
cb=new OleDbCommandBuilder(adp); // OleDbDataAdapter'i silme güncelleme ve kayıt'a hazır hale getirmek için

ekle=dt.Tables["IZIN"].NewRow();

ekle["Sicil"]=textBox2.Text;
ekle["Adi"]=textBox3.Text;
ekle["Soyadi"]=textBox4.Text;
ekle["Unvan"]=textBox5.Text;
ekle["HizmetSuresi"]=textBox6.Text;
ekle["Servis"]=textBox7.Text;

dt.Tables["IZIN"].Rows.Add(ekle);
adp.Update(dt "IZIN");
dt.Clear();
adp.Fill(dt.Tables[0]);
dataGrid1.DataSource = dt.Tables[0];
MessageBox.Show (" Kayıt tamamlandı!" "İŞLEM TAMAM");
}

private void sil_Click(object sender System.EventArgs e)
{

CurrencyManager sonraki=
(CurrencyManager)this.BindingContext[dt.Tables["IZIN"]];
DialogResult uyar;
uyar=MessageBox.Show(this textBox2.Text +" Sicil'li Personel Kaydını Silmek istiyor musunuz?" "SİLME UYARISI" MessageBoxButtons.YesNo MessageBoxIcon.Stop MessageBoxDefaultButton.Button2);
if(uyar==DialogResult.Yes)
{
cb=new OleDbCommandBuilder(adp); // OleDbDataAdapter'i silme güncelleme ve kayıt'a hazır hale getirmek için
sonraki.RemoveAt(sonraki.Position);
adp.Update(dt "IZIN");
dt.Clear();
adp.Fill(dt.Tables[0]);
dataGrid1.DataSource = dt.Tables[0];
MessageBox.Show (" Kayıt silindi!" "İŞLEM TAMAM");
}
else
{
MessageBox.Show(" Silme işlemi İptal edildi!");
}
}

private void temizle_Click(object sender System.EventArgs e)
{
textBox1.DataBindings.Clear();
textBox2.DataBindings.Clear();
textBox3.DataBindings.Clear();
textBox4.DataBindings.Clear();
textBox5.DataBindings.Clear();
textBox6.DataBindings.Clear();
textBox7.DataBindings.Clear();
textBox1.Text="";
textBox2.Text="";
textBox3.Text="";
textBox4.Text="";
textBox5.Text="";
textBox6.Text="";
textBox7.Text="";

dt.Clear();
adp.Fill(dt.Tables[0]);
dataGrid1.DataSource = dt.Tables[0];

textBox2.Focus();
}

private void dataGrid1_CurrentCellChanged(object sender System.EventArgs e)
{
//dataGridde tıkladığımız satırın tümünün seçilmesi için
dataGrid1.UnSelect (dataGrid1.CurrentRowIndex );
int i=dataGrid1.CurrentRowIndex ;
try
{
dataGrid1.Select (i);
}
catch
{
dataGrid1.Select ();
}
}

private void kapandı2(object sender System.EventArgs e )
{
f2 = null;
}
ExcelExport f2;
private void button2_Click(object sender System.EventArgs e)
{
if (f2 == null) //form değişkeni bir nesneyi göstermiyorsa
{
f2 = new ExcelExport(); //Yeni form oluştur
f2.Closed += new EventHandler(kapandı2);
f2.Text="EXCEL SAYFASINDAN VERİ ÇEKME / VERİTABANINA İŞLEME";
f2.Show();
}
else
//form zaten varsa öne getir
f2.Text="EXCEL SAYFASINDAN VERİ ÇEKME / VERİTABANINA İŞLEME";
f2.Activate();

}

private void button4_Click(object sender System.EventArgs e)
{
dt.Clear();
adp.Fill(dt.Tables[0]);
dataGrid1.DataSource = dt.Tables[0];
}

private void button1_Click(object sender System.EventArgs e)
{
Excel.Application uygulama = new Excel.Application();
Excel.Workbook kitap=uygulama.Workbooks.Add(true);
Excel.Worksheet sayfa=(Excel.Worksheet) uygulama.ActiveSheet;
uygulama.Visible=true;
int rowIndex=1;
int colIndex=0;

foreach(DataColumn col in dt.Tables[0].Columns)
{
colIndex++;
sayfa.Cells[1 colIndex]=col.ColumnName;
}
foreach(DataRow row in dt.Tables[0].Rows)
{
rowIndex++;
colIndex=0;
foreach(DataColumn col in dt.Tables[0].Columns)
{
colIndex++;
sayfa.Cells[rowIndexcolIndex]=
row[col.ColumnName].ToString();
}
}
}

private void timer1_Tick(object sender System.EventArgs e)
{
this.Text = this.Text.Substring(1)
+ this.Text.Substring(01);
}

private void dataGrid1_Navigate(object sender NavigateEventArgs ne)
{

}
}
}
__________________
بِسْــــــــــــــــــــــمِ اﷲِارَّحْمَنِ ارَّحِيم

-------------------------------------------------

Bu Soysuzlar Bu Vatansızlar Sarsada Yurdumu Ben Yaratan'dan Alırım Asil Kanı ve Gücü.
-------------------------------------------------
McDroPp isimli Üye şimdilik offline konumundadır   Alıntı ile Cevapla
Cevapla

Seçenekler
Stil

Yetkileriniz
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is Açık
Smileler Açık
[IMG] Kodları Açık
HTML-KodlarıKapalı
Trackbacks are Kapalı
Pingbacks are Kapalı
Refbacks are Kapalı


Benzer Konular
Konu Konuyu Başlatan Forum Cevaplar Son Mesaj
Visual c# örnekleri fatih6761 C - C++ - C# - Visual C++ - Visual C# 0 31. October 2010 01:03 AM
Visual C#.NET'te BlackJack Oyunu McDroPp Örnek Kodlar 0 17. May 2008 03:43 AM
Visual C#.NET'te LCD Simülasyonu McDroPp Örnek Kodlar 0 17. May 2008 03:43 AM
Visual C#.NET'te Yılan Oyunu McDroPp Örnek Kodlar 0 17. May 2008 03:41 AM
C++ Klasör ve Dosya İşlemleri için Kullanabileceğiniz Bir Sınıf McDroPp Konu ve Anlatımlar 0 17. May 2008 03:17 AM