Click here to Skip to main content
15,868,016 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am trying to bind database table data to a wpf form using dapper. I can do this with entity framework 6.

 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.


What I have tried:

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;

      }
Posted
Updated 20-Feb-22 22:20pm

1 solution

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900