We have a SQL query that returns the sample data below.
JobNo Attorney Email Resource
12345 John Smith JSmith@gmail.com Bob
12345 John Smith JSmith@gmail.com Kate
34832 Tom Parks TParks@gmail.com Jake
83747 Gary Day GDay@yahoo.com Shane
We are building a program to send out emails to attorneys notifying them who the resource is going to be at a particular job.
So far the program can successfully send an email to each row the SQL query returns. However this is causing a problem because as you can see from the sample query, John Smith will receive two emails. Our goal is to only send a single email to each attorney.
How do we select 2 rows from C# DataGridView by searching the DataGrid?