3 Şubat 2011 Perşembe

C# Veritabanı Tarihine 1 Gün kalanları Sırala

Merhaba arkadaşlar elimde bir tane Combobox var içerisinde yani Items ında textler var.Ben hangisi seçip butona tıklarsam swich yöntemi ile o alanların yani tarih alanlarının 1 gün kalanları DataGirdViewda listelemesi için.

private void btn1Gun_Click(object sender, EventArgs e)
        {
            try
            {
                switch (cmdSorgu.Text)
                {
                    case "Sigorta Tarihine Göre":

                        string zaman = DateTime.Today.AddDays(1).ToShortDateString();
                        OleDbCommand komutmusterdoldur = new OleDbCommand("SELECT * FROM Araclar WHERE SigortaBitisTarihi like'" + zaman + "'", baglanti);
                        OleDbDataAdapter damusteridoldur = new OleDbDataAdapter(komutmusterdoldur);
                        DataSet dsmusteridoldur = new DataSet();
                        damusteridoldur.Fill(dsmusteridoldur, "Araclar");
                        SonucList.DataSource = dsmusteridoldur.Tables[0];
                        SonucList.Columns[0].Visible = false;
                        SonucList.Columns[3].Visible = false;
                        SonucList.Columns[5].Visible = false;
                        SonucList.Columns[6].Visible = false;
                        SonucList.Columns[7].Visible = false;
                        SonucList.Columns[8].Visible = false;
                        SonucList.Columns[9].Visible = false;
                        SonucList.Columns[10].Visible = false;
                        SonucList.Columns[1].HeaderText = "Marka";
                        SonucList.Columns[2].HeaderText = "Model";
                        SonucList.Columns[4].HeaderText = "Plaka";
                        SonucList.Columns[11].HeaderText = "Sigorta Bitiş";
                        SonucList.Columns[12].HeaderText = "Muayene Bitiş";
                        SonucList.Columns[13].HeaderText = "Kasko Bitiş";
                        SonucList.Columns[14].HeaderText = "Emisyon Bitiş";
                        SonucList.Columns[15].HeaderText = "İzin Bitiş";
                        SonucList.Columns[16].HeaderText = "Durum";
                        baglanti.Close();

                        break;
                    case "Muayene Tarihine Göre":

                        zaman = DateTime.Today.AddDays(1).ToShortDateString();
                        OleDbCommand komutmusterdoldur2 = new OleDbCommand("SELECT * FROM Araclar WHERE MuayeneBitisTarihi like'" + zaman + "'", baglanti);
                        OleDbDataAdapter damusteridoldur2 = new OleDbDataAdapter(komutmusterdoldur2);
                        DataSet dsmusteridoldur2 = new DataSet();
                        damusteridoldur2.Fill(dsmusteridoldur2, "Araclar");
                        SonucList.DataSource = dsmusteridoldur2.Tables[0];
                        SonucList.Columns[0].Visible = false;
                        SonucList.Columns[3].Visible = false;
                        SonucList.Columns[5].Visible = false;
                        SonucList.Columns[6].Visible = false;
                        SonucList.Columns[7].Visible = false;
                        SonucList.Columns[8].Visible = false;
                        SonucList.Columns[9].Visible = false;
                        SonucList.Columns[10].Visible = false;
                        SonucList.Columns[1].HeaderText = "Marka";
                        SonucList.Columns[2].HeaderText = "Model";
                        SonucList.Columns[4].HeaderText = "Plaka";
                        SonucList.Columns[11].HeaderText = "Sigorta Bitiş";
                        SonucList.Columns[12].HeaderText = "Muayene Bitiş";
                        SonucList.Columns[13].HeaderText = "Kasko Bitiş";
                        SonucList.Columns[14].HeaderText = "Emisyon Bitiş";
                        SonucList.Columns[15].HeaderText = "İzin Bitiş";
                        SonucList.Columns[16].HeaderText = "Durum";
                        baglanti.Close();


                        break;

                    case "Emisyon Tarihine Göre":

                        zaman = DateTime.Today.AddDays(1).ToShortDateString();
                        OleDbCommand komutmusterdoldur3 = new OleDbCommand("SELECT * FROM Araclar WHERE EmisyonBitisTarihi like'" + zaman + "'", baglanti);
                        OleDbDataAdapter damusteridoldur3 = new OleDbDataAdapter(komutmusterdoldur3);
                        DataSet dsmusteridoldur3 = new DataSet();
                        damusteridoldur3.Fill(dsmusteridoldur3, "Araclar");
                        SonucList.DataSource = dsmusteridoldur3.Tables[0];
                        SonucList.Columns[0].Visible = false;
                        SonucList.Columns[3].Visible = false;
                        SonucList.Columns[5].Visible = false;
                        SonucList.Columns[6].Visible = false;
                        SonucList.Columns[7].Visible = false;
                        SonucList.Columns[8].Visible = false;
                        SonucList.Columns[9].Visible = false;
                        SonucList.Columns[10].Visible = false;
                        SonucList.Columns[1].HeaderText = "Marka";
                        SonucList.Columns[2].HeaderText = "Model";
                        SonucList.Columns[4].HeaderText = "Plaka";
                        SonucList.Columns[11].HeaderText = "Sigorta Bitiş";
                        SonucList.Columns[12].HeaderText = "Muayene Bitiş";
                        SonucList.Columns[13].HeaderText = "Kasko Bitiş";
                        SonucList.Columns[14].HeaderText = "Emisyon Bitiş";
                        SonucList.Columns[15].HeaderText = "İzin Bitiş";
                        SonucList.Columns[16].HeaderText = "Durum";
                        baglanti.Close();


                        break;

                    case "İzin Tarihine Göre":

                        zaman = DateTime.Today.AddDays(1).ToShortDateString();
                        OleDbCommand komutmusterdoldur4 = new OleDbCommand("SELECT * FROM Araclar WHERE İzinBitisTarihi like'" + zaman + "'", baglanti);
                        OleDbDataAdapter damusteridoldur4 = new OleDbDataAdapter(komutmusterdoldur4);
                        DataSet dsmusteridoldur4 = new DataSet();
                        damusteridoldur4.Fill(dsmusteridoldur4, "Araclar");
                        SonucList.DataSource = dsmusteridoldur4.Tables[0];
                        SonucList.Columns[0].Visible = false;
                        SonucList.Columns[3].Visible = false;
                        SonucList.Columns[5].Visible = false;
                        SonucList.Columns[6].Visible = false;
                        SonucList.Columns[7].Visible = false;
                        SonucList.Columns[8].Visible = false;
                        SonucList.Columns[9].Visible = false;
                        SonucList.Columns[10].Visible = false;
                        SonucList.Columns[1].HeaderText = "Marka";
                        SonucList.Columns[2].HeaderText = "Model";
                        SonucList.Columns[4].HeaderText = "Plaka";
                        SonucList.Columns[11].HeaderText = "Sigorta Bitiş";
                        SonucList.Columns[12].HeaderText = "Muayene Bitiş";
                        SonucList.Columns[13].HeaderText = "Kasko Bitiş";
                        SonucList.Columns[14].HeaderText = "Emisyon Bitiş";
                        SonucList.Columns[15].HeaderText = "İzin Bitiş";
                        SonucList.Columns[16].HeaderText = "Durum";
                        baglanti.Close();

                        break;

                    default:
                        break;

                }
            }
            catch
            {
                MessageBox.Show("Sorgunuz sonuçlanmadı !");
            }
        }

Hiç yorum yok:

Yorum Gönder