Форум программистов [Powered by Invision Power Board]

Код

private void btn_Add_in_Db_Click(object sender, EventArgs e)
        {
            
            try
            {
                oleDbConnection1 = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Data\FEEDER.mdb");
                
                //open the bridge between the application and the datasource
                this.oleDbConnection1.Open();

                this.oleDbDataAdapter2.InsertCommand.CommandText = string.Format(
                    "INSERT INTO [Storage] ( Name, Item_number_details,ReceptionDate,Received) " +
                    "VALUES ( '{0}','{1}', '{2}', '{3}');",
                    txt_Name.Text,
                    txt_Item_num_det.Text,
                    txt_ReceptionDate.Text,
                    txt_Received.Text                

                    );

                this.oleDbDataAdapter2.InsertCommand.Connection = oleDbConnection1;

                //execute the qurey 
                this.oleDbDataAdapter2.InsertCommand.ExecuteNonQuery();

                //close the connection
                this.oleDbConnection1.Close();

                MessageBox.Show("Record inserted Successfully", " Warning !!! ",
                MessageBoxButtons.OK, MessageBoxIcon.Information); //inform the user

                //clear the form 
                this.txt_Name.Text = "";
                this.txt_Item_num_det.Text = "";
                this.txt_ReceptionDate.Text = "";
                this.txt_Received.Text = "";
                
                this.txt_Name.Focus();

                //show the qurey
                //this.qurey_label.Text = "";
                //this.qurey_label.Text = oleDbDataAdapter1.InsertCommand.CommandText.ToString();

            }
            catch (System.Data.OleDb.OleDbException exp)
            {
                //close the connection
                this.oleDbConnection1.Close();

                MessageBox.Show(exp.ToString());
            }
        }
Код

private void btn_View_DB_Click(object sender, EventArgs e)
        {
            //CalcColumns();
            oleDbConnection1 = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Data\FEEDER.mdb");
            // Создаем адаптер
            oleDbDataAdapter2 = new OleDbDataAdapter("SELECT * FROM Storage", oleDbConnection1);

            // Создаем таблицу db
            table1 = new System.Data.DataTable("Storage");
            table1.Columns.Add("idDetail", typeof(string));
            table1.Columns.Add("Name", typeof(string));
            table1.Columns.Add("Item_number_details", typeof(string));
            table1.Columns.Add("ReceptionDate", typeof(string));
            table1.Columns.Add("Received", typeof(string));
            table1.Columns.Add("Spent", typeof(string));
            table1.Columns.Add("Remained", typeof(string));

            
            oleDbDataAdapter2.Fill(table1);




            dataGrid1.DataSource = table1;
            this.oleDbConnection1.Close();
        }