Search results for query: *

  1. H

    Parsing City, State, Zip Lines

    Thanks to you all for your input. Looks like the best answer would be to get the source data in a structured format.
  2. H

    Parsing City, State, Zip Lines

    I have a text file with names, addresses, city-state-zip lines, and extra lines. Each record doesn't necessarily occupy a certain number of lines such as six lines (as in a label format that always has 6 lines). Is there a way to be able to detect the line that has the City, State, Zip no...
  3. H

    Resolved Sending Up and Down Arrows to DataGridView

    JohnH - thanks for your help and reply! HLeyes
  4. H

    Resolved Sending Up and Down Arrows to DataGridView

    I have a form with a textbox and a datagridview. As I type in the textbox, it filters a list of vendors and fills the grid with those vendors that start with whatever has been entered into the text box. For example, I type in "b" in the textbox, and the grid fills with the vendors that start...
  5. H

    Question Select # records from each group in LINQ

    JohnH - thank you for that! That's exactly what I needed. The capabilities of LINQ amaze me every day. HLeyes
  6. H

    Question Select # records from each group in LINQ

    I have a list of customers and invoices. The number of invoices per customer could be one or many. I am looking for a LINQ statement that would produce a list that would have only a specific number of records for each customer - let's say three per customer, whether the customer has one or a...
  7. H

    Fastest Fill and Display for DataGridView

    I am using VS 2015 with C#, and I am binding a DataGridView with a list from a SQL Server database. There are only a half-dozen records, but the grid still seems to display and show those records "sluggishly". My laptop has a lot of power, so I don't think that's the issue. Is there any...
  8. H

    DataReader - Handling Null Values

    I am using a SQL Server database and C#. When retrieving data with a datareader, there are some fields that are null. What is the best way to handle a null value? In VB.Net, there was a single line test that would return an empty value if it was null, otherwise the non-null value would...
  9. H

    Single Event for Multiple Controls

    Let's say that I have 10 textboxes on my form, and by tabbing, I move from one to the next for data input. As each textbox receives focus, I want the background to turn a certain color for visual highlighting. I could set that property individually for each control as the cursor enters and...
  10. H

    Text Box Databinding

    I have form1 that has customer information textboxes that are databound to CustomerItem. If have a button on form1 for a test that works fine to retrieve the data that is displayed properly in the textoxes: private void btnRead_Click(object sender, EventArgs e) {...
  11. H

    DataTable As DataSource for Visual Studio Report Writer

    Using VS 2012 and Community 2015. I am coding my connection to the database, and also creating a datatable with code to populate a datagridview. I see that it's fairly easy to create a report based on a connection made through the Server Explorer, and a dataset created by adding the dataset...
  12. H

    Populating DataGridView with a Class

    Thanks for the reply.
  13. H

    Database Connection On Other Forms

    Thanks for the response. Good info!
  14. H

    Populating DataGridView with a Class

    Can someone directly me to a brief example of a class and method that will populate a DataGridView from a SQL Server database. I have methods in a class that will retrieve data for data binding with text boxes, but I'd like to see an example for use with a DataGridView. Thanks in advance, HL...
  15. H

    Database Connection On Other Forms

    Hi all, I can connect to and open a database on a single form. How can I access that same database connection on another form (which might be the editing form for a selected record from the first form)? Is there a way to make a database connection "public" to be viewed on all forms? Thanks...
Back
Top Bottom