SETUP:
I have 1 database, 1 table and a few columns. I have setup a datagridview to allow for me to filter, by date, the records I want shown. (Example: search all records for 04/23/12 and it will return every record that contains that date.)
ISSUE:
When I press the search button and it displays two columns of info based on my search I want the data, no matter how many records there are, to be copied & pasted to a multi-line textbox of just one column.
Example:
When the form loads it fills the datagridview with all records
sopID(primary) | DATE | CASE NUMBER
1 04/21/12 17102652
2 04/23/12 17104852
3 04/23/12 17102264
4 04/25/12 17126854
Then, I enter search of 04/23/12 and press find and it returns
sopID(primary) | DATE | CASE NUMBER
2 04/23/12 17104852
3 04/23/12 17102264
All of this is working correctly. What I then want in the mulitline textbox is just the case number.
17104852
17102264
I have been able to send only the selected cell so far but I want it to be auto and multiple. As soon as they hit find I want the data to populate in the grid for verification and the result to populate a multiline textbox to the right on the same form.
Any help with this would be greatly appreciated.
I have 1 database, 1 table and a few columns. I have setup a datagridview to allow for me to filter, by date, the records I want shown. (Example: search all records for 04/23/12 and it will return every record that contains that date.)
ISSUE:
When I press the search button and it displays two columns of info based on my search I want the data, no matter how many records there are, to be copied & pasted to a multi-line textbox of just one column.
Example:
When the form loads it fills the datagridview with all records
sopID(primary) | DATE | CASE NUMBER
1 04/21/12 17102652
2 04/23/12 17104852
3 04/23/12 17102264
4 04/25/12 17126854
Then, I enter search of 04/23/12 and press find and it returns
sopID(primary) | DATE | CASE NUMBER
2 04/23/12 17104852
3 04/23/12 17102264
All of this is working correctly. What I then want in the mulitline textbox is just the case number.
17104852
17102264
I have been able to send only the selected cell so far but I want it to be auto and multiple. As soon as they hit find I want the data to populate in the grid for verification and the result to populate a multiline textbox to the right on the same form.
Any help with this would be greatly appreciated.