C# (CSharp) DbRequestHandlerHelper Examples

Example #1

File: AutoQueryWithReadOnlyForm.cs Project: j2vdeveloper/simple-datagridview-paging

        public AutoQueryWithReadOnlyForm()
        {
            InitializeComponent();

            dataGridViewPaging1.DbRequestHandler = DbRequestHandlerHelper.Create(
                new SQLiteConnection("Data Source=chinook.db"),
                "tracks");

            // OR
            // dataGridViewPaging1.DbRequestHandler = new DbRequestHandler
            // {
            //     Connection = new SQLiteConnection("Data Source=chinook.db"),
            //     TableName = "tracks"
            // };
        }

Example #2

        public AutoQueryWithEditableForm()
        {
            InitializeComponent();

            dataGridViewPaging1.DbRequestHandler = DbRequestHandlerHelper.Create(
                new SQLiteConnection("Data Source=chinook.db"),
                "tracks",
                new SQLiteCommandBuilder(new SQLiteDataAdapter()));

            //  OR
            //  dataGridViewPaging1.DbRequestHandler = new DbRequestHandler
            //  {
            //      Connection = new SQLiteConnection("Data Source=chinook.db"),
            //      TableName = "tracks",
            //      RowsStatementBuilder = new UpdatableRowsStatementBuilder().CommandBuilder(new SQLiteCommandBuilder(new SQLiteDataAdapter()))
            //  };
        }