GridView'e Veri Ekleme

Sorgu kulanarak GridViewe veri ekleme


protected void Button4_Click(object sender, EventArgs e)
    {
       /* OleDbConnection db_baglanti;

        db_baglanti = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; DATA Source=" + Server.MapPath("aspnet.accdb"));
   */
        OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.Oledb.12.0;Data Source=" + Server.MapPath("deneme.accdb"));
      
    try
            {
                OleDbCommand cmd = new OleDbCommand();
                con.Open();
                cmd.Connection = con;
              //  db_baglanti.Open();
                OleDbCommand db_komut = new OleDbCommand("Insert INTO cihaz_bilgileri ( cihaz_adi, seri_no, o_cihaz, grnt_belgesi,grnt_bitist,p_bakimt, c_durum, dgr_t, dgr_sonuc) Values( '" + txt_urun_adi.Text + "','" + txt_seri_no.Text + "','" + txt_ortak.Text + "','" + txt_garant_blg.Text + "','" + clr_gr_bl_bitis_tarihi.SelectedDate + "','" + clr_planli_baki_tarihi.SelectedDate + "','" + txt_cihz_durum.Text + "','" + clr_dglndrm_trh.SelectedDate + "','" + txt_sonuc.Text + "')", con);
               db_komut.ExecuteNonQuery();
              //  db_baglanti.Close();
                con.Close();
                Label3.Text = "Kayıt Eklendi";
                GridView3.DataBind();
               
            }
            catch
            {
                Response.Write("Bağlantıda sorun var !!!");
            }