работа с SQL БД в ADO.NET с нуля, используем C#

using System;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
 
public partial class _Default : System.Web.UI.Page 
{
protected void Page_Load(object sender, EventArgs e)
{

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Data;
 
namespace DataBaseApplication
{
 
    public class OrganizationTable : DataTable
    {
        public OrganizationTable()
        {
            this.Columns.Add("id", typeof(System.Int32));
            this.Columns.Add("name", typeof(System.String));
            this.Columns.Add("email", typeof(System.String));
            this.Columns.Add("internet", typeof(System.String));
            this.Columns.Add("commonPhoneNumber", typeof(System.String));
            this.Columns.Add("commonPhoneInfo", typeof(System.String));
            this.Columns.Add("context", typeof(System.String));
            this.Columns.Add("priority", typeof(System.Int32));
            this.Columns.Add("isSelected", typeof(System.Boolean));
            this.Columns.Add("bannerIsInList", typeof(System.Boolean));
            this.Columns.Add("getsDisc", typeof(System.Boolean));
 
 
        }

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Data;
 
namespace DataBaseApplication
{
    public static class OrganizationsCommand
    {
        public static OleDbCommand UpdateCommand()
        {
            OleDbCommand updateCommand = new OleDbCommand();
            updateCommand.CommandText = @"UPDATE Organizations
                                           SET name=@name, email=@email, internet=@internet,
                                           commonPhoneNumber=@commonPhoneNumber, commonPhoneInfo=@commonPhoneInfo,
                                           context=@context, priority=@priority, isSelected=@isSelected, 
                                           bannerIsInList=@bannerIsInList,getsDisc=@getsDisc
                                           WHERE id=@id";
            updateCommand.CommandType = CommandType.Text;
            updateCommand.Parameters.Add("@name", OleDbType.Char, 0, "name");
            updateCommand.Parameters.Add("@email", OleDbType.Char, 0, "email");
            updateCommand.Parameters.Add("@internet", OleDbType.Char, 0, "internet");
            updateCommand.Parameters.Add("@commonPhoneNumber", OleDbType.Char, 0, "commonPhoneNumber");
            updateCommand.Parameters.Add("@commonPhoneInfo", OleDbType.Char, 0, "commonPhoneInfo");
            updateCommand.Parameters.Add("@context", OleDbType.Char, 0, "commonPhoneInfo");
            updateCommand.Parameters.Add("@priority", OleDbType.Integer, 0, "priority");
            updateCommand.Parameters.Add("@isSelected", OleDbType.Boolean, 0, "isSelected");
            updateCommand.Parameters.Add("@bannerIsInList", OleDbType.Boolean, 0, "bannerIsInList");
            updateCommand.Parameters.Add("@getsDisc", OleDbType.Boolean, 0, "getsDisc");
            updateCommand.Parameters.Add("@id", OleDbType.Integer, 0, "id");
            return (updateCommand);
 
        }
        public static OleDbCommand DeleteCommand()
        {
            OleDbCommand deleteCommand = new OleDbCommand();
            //deleteCommand.CommandText = @"DELETE * FROM Organizations
            //                                                        WHERE id=204724";
            deleteCommand.CommandText = @"DELETE * FROM Organizations WHERE id=@id";
            deleteCommand.CommandType = CommandType.Text;
            deleteCommand.Parameters.Add("@id", OleDbType.Integer, 0, "id");
            return (deleteCommand);
        }
        public static OleDbCommand InsertCommand()
        {
            OleDbCommand insertCommand = new OleDbCommand();
            insertCommand.CommandText = @"INSERT INTO Organizations (id,name,email,internet,
                                            commonPhoneNumber,commonPhoneInfo,context,priority,isSelected,
                                            bannerIsInList,getsDisc) VALUES (@id,@name,@email,@internet,
                                            @commonPhoneNumber,@commonPhoneInfo,@context,@priority,
                                            @isSelected,@bannerIsInList,@getsDisc)";
            insertCommand.CommandType = CommandType.Text;
            insertCommand.Parameters.Add("@id", OleDbType.Integer, 0, "id");
            insertCommand.Parameters.Add("@name", OleDbType.Char, 0, "name");
            insertCommand.Parameters.Add("@email", OleDbType.Char, 0, "email");
            insertCommand.Parameters.Add("@internet", OleDbType.Char, 0, "internet");
            insertCommand.Parameters.Add("@commonPhoneNumber", OleDbType.Char, 0, "commonPhoneNumber");
            insertCommand.Parameters.Add("@commonPhoneInfo", OleDbType.Char, 0, "commonPhoneInfo");
            insertCommand.Parameters.Add("@context", OleDbType.Char, 0, "context");
            insertCommand.Parameters.Add("@priority", OleDbType.Integer, 0, "priority");
            insertCommand.Parameters.Add("@isSelected", OleDbType.Boolean, 0, "isSelected");
            insertCommand.Parameters.Add("@bannerIsInList", OleDbType.Boolean, 0, "bannerIsInList");
            insertCommand.Parameters.Add("@getsDisc", OleDbType.Boolean, 0, "getsDisc");
            return insertCommand;
        }
 
    }
}

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Data;
 
 
namespace DataBaseApplication
{
 
 
    public class Program
    {
        static void Main(string[] args)
        {
            //TesterCount.Test();
 
            string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;
                                      Data Source=E:\Advertisement.mdb;
                                      Persist Security Info=True";
            OleDbConnection conn = new OleDbConnection(connectionString);
 
            string selectText = @"SELECT * FROM Organizations";
 
            OleDbDataAdapter adpter = new OleDbDataAdapter(selectText, conn);
 
            adpter.DeleteCommand = OrganizationsCommand.DeleteCommand();
            adpter.InsertCommand = OrganizationsCommand.InsertCommand();
            adpter.UpdateCommand = OrganizationsCommand.UpdateCommand();
 
            adpter.DeleteCommand.Connection = conn;
            adpter.InsertCommand.Connection = conn;
            adpter.UpdateCommand.Connection = conn;
 
            OrganizationTable ogrtbl = new OrganizationTable();
            adpter.Fill(ogrtbl);
            
            DataRow dataRow = ogrtbl.NewRow();
            dataRow["id"] = 7777737;
            dataRow["name"] = "Работает";
            dataRow["email"] = "@mail.ru";
            dataRow["internet"] = "www.  .ru";
            dataRow["commonPhoneNumber"] = "000000";
            dataRow["commonPhoneInfo"] = "+++++++++";
            dataRow["context"] = "---";
            dataRow["priority"] = 3;
            dataRow["isSelected"] = false;
            dataRow["bannerIsInList"] = false;
            dataRow["getsDisc"] = false;
 
            //ogrtbl.Rows.Add(dataRow);
 
 
            adpter.Update(ogrtbl);
 
        }
    }
}