Search results

  1. T

    How to get a DataTable using parameters?

    Thanks for the quick response JohnH. Here's what I have so far: Dim daAccess As New OleDbDataAdapter() Dim dtBeginDate As Date = Today().Date.AddYears(-1) Dim SQL_RecentWorkOrders As String = "SELECT workorders.CustID as WO_CustID, " +...
  2. T

    How to get a DataTable using parameters?

    I saw another post where jmcilhinney graciously helped another programmer with fixing a coding issue and suggested using parameters. The link to his blog in his post was very helpful and I'm trying to change my code in to use parameters instead of the previous method. In my previous method, I...
  3. T

    Selecting Datagridview cell data in reference to row index

    If this is copied from your code, I found a syntax error at this line: lnk.Text = "C:\" & names(x)".jpg" It should be: lnk.Text = "C:\" & names(x) & ".jpg"
  4. T

    How do I set the column names in a DataTable as a datasource to a ComboBox?

    Awesome! That worked great. I need to do some reading now on lists and enumerations in .Net. Much appreciated.
  5. T

    How do I set the column names in a DataTable as a datasource to a ComboBox?

    Thanks for the reply and the tip regarding best practices. I am still getting the following error: "Complex DataBinding accepts as a data source either an IList or an IListSource" Here is my current code now: FilterColumns.DisplayMember = "ColumnName"...
  6. T

    How do I set the column names in a DataTable as a datasource to a ComboBox?

    I'm trying to setup a form to search for data within an existing DataTable. Please help me fill in the blanks below: FilterColumnsComboBox.DataSource = WOTable.Columns? FilterColumnsComboBox.DisplayMember = ??? FilterColumnsComboBox.ValueMember = ??? I could hard-code in the column names...
  7. T

    Child list for field .. .cannot be created in joined tables

    Menthos, Thanks for the advice. I also wonder.. would it be better practice to pull in the two tables seperately into the dataset then setup a reference within the dataset? Is that very difficult? Thanks again
  8. T

    Child list for field .. .cannot be created in joined tables

    My original query for data from the database was: Dim SQL_RecentWorkOrders As String = "Select * from workorder WHERE date>#" + dtToday.AddYears(-YearsToGoBack).ToString + "# ORDER BY worknum DESC" The updated query is as follows: Dim SQL_RecentWorkOrders As...
  9. T

    Question ComboBox with AutoComplete - Text entered moves position of selected item?

    I found that my problem was binding to the same database field that I was using as my data source. Once I removed the binding the behavior went away.
  10. T

    Question ComboBox with AutoComplete - Text entered moves position of selected item?

    I have an Access database I have to retrieve Work Order information from. I have a ComboBox to list the work order numbers and various text boxes to show the data for the selected row of data based on the data shown in the ComboBox. I want the user to be able to be able to select the number...
Top Bottom