and display database records on the form and also navigate each records as in using CurrencyManager? The code below is not in dapper, but just for understanding. Thank you I am just a learner.
SqlConnection OrdersConnection; SqlCommand Orderscommand; SqlDataAdapter OrdersAdapter; DataTable OrdersTable; CurrencyManager OrdersManager; // connect to sales database OrdersConnection = new SqlConnection("Data Source=SQL2K14;Initial Catalog=;Integrated Security=True"); OrdersConnection.Open(); // establish Orders command object // establish Orders command object Orderscommand = new SqlCommand("SELECT * FROM Orders ORDER BY OrderID", OrdersConnection); // establish Products data adapter/data table OrdersAdapter = new SqlDataAdapter(); OrdersAdapter.SelectCommand = Orderscommand; OrdersTable = new DataTable(); OrdersAdapter.Fill(OrdersTable); // bind controls to data table textOrderID.DataBindings.Add("Text", OrdersTable, "OrderID"); textCustomerID.DataBindings.Add("Text", OrdersTable, "CustomerID"); OrderDate.DataBindings.Add("Text", OrdersTable, "OrderDate"); private void btnFirst_Click(object sender, EventArgs e) { OrdersManager.Position = 0; } private void btnPrevious_Click(object sender, EventArgs e) { OrdersManager.Position--; } private void btnNext_Click(object sender, EventArgs e) { OrdersManager.Position++; } private void btnLast_Click(object sender, EventArgs e) { OrdersManager.Position = OrdersManager.Count - 1; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)