Display COUNT of how many rows in DB table in a DataGrid Column WPF C#

Question

I have been spinning my wheels trying to display how many rows there are in my DB into a DataGrid Column called 'JobsCount' using COUNT.

sqlCon.Open();
            string query = "SELECT UserName, COUNT(UserName) as count FROM tblJobs WHERE JobStatus != 'Booked' Group by UserName";
            SqlCommand cmd = new SqlCommand(query, sqlCon);

            using (SqlDataAdapter adapter = new SqlDataAdapter(cmd))
            {
                DataTable dt = new DataTable();

                adapter.Fill(dt);
                tblJobsBooked.ItemsSource = dt.DefaultView;
            }
            sqlCon.Close();

DataGrid Columns

<DataGrid.Columns>
  <DataGridTextColumn Header="User" Binding="{Binding UserName}"/>
  <DataGridTextColumn Header="Jobs Booked" Binding="{Binding JobsCount}" />
</DataGrid.Columns>

The COUNT should be calculated by UserName.

The databinding in your DataGridTextColumn binds to JobsCount whereas the column in the SQL statement is count — Peter Schneider
– Peter Schneider, Commented Nov 28, 2019 at 16:49

user1348592 · Accepted Answer · 2019-11-29 02:51:14Z

3

Change:

string query = "SELECT UserName, COUNT(UserName) as count FROM tblJobs WHERE JobStatus != 'Booked' Group by UserName";

To this:

string query = "SELECT UserName, COUNT(UserName) as JobsCount FROM tblJobs WHERE JobStatus != 'Booked' Group by UserName";

Collectives™ on Stack Overflow

Display COUNT of how many rows in DB table in a DataGrid Column WPF C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related