[RESOLVED] Insert problem

[popskie]

HI,

I have a problem during inserting my new record but if I change to select statement. I can display the datareader value. Do you have any idea?

        string contring;

        private void Form1_Load(object sender, EventArgs e)
        {
            contring = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Book1.xls;Extended Properties=""Excel 8.0;HDR=YES;IMEX=1""";		
        }

        private void button2_Click(object sender, EventArgs e)
        {            
            DbProviderFactory dpF = DbProviderFactories.GetFactory("System.Data.OleDb");
            {
                using (DbConnection dbCon= dpF.CreateConnection())
                {
                    dbCon.ConnectionString = contring;
                    DbCommand dbCom = dbCon.CreateCommand();                    

                    //dbCom.CommandText = "select * from [sheet1$]";
                    dbCom.CommandText = "insert into[sheet1$](first,second)values(\"unse\",\"unse\")";
                    dbCon.Open();
                    DbDataReader dreader = dbCom.ExecuteReader();
//                    while (dreader.Read())
   //                 {
      //                  MessageBox.Show(dreader["first"].ToString());
         //           }            


                    dbCon.Close();
                }

Thanks,
Popskie