Recent content by dukeofawesome

  1. D

    Retrieve Data to Populate Text Boxes

    Geez I'm an idiot. I had opened another instance of "Results" in a list box. My God what a tool I am!
  2. D

    Retrieve Data to Populate Text Boxes

    I have tried everything you have suggested. Here is where the dataset gets filled: Function sqlSelect(ByVal strSQL As String) da = New OleDbDataAdapter(strSQL, cnn) da.Fill(ds, "Results") Return ds End Function
  3. D

    Retrieve Data to Populate Text Boxes

    Yes that's what I mean sorry. Every field is empty other than the ID column. I have stepped through the code and can't see why this is ocurring. The dbs object is created in a class like so: Public Class clsDatabase Dim cnn As New OleDbConnection Dim dbProvider As String Dim...
  4. D

    Retrieve Data to Populate Text Boxes

    Hi, I am having an issue where for some reason the following code only returns the ID but no other fields. Can someone see where the problem lies? Dim lstVal As String = lstUSerID.SelectedValue.ToString Dim sstrSQL As String Dim cls As New clsGlobals sstrSQL = "SELECT...
  5. D

    Combo Box DisplayMember Value

    Thanks, you're a God!
  6. D

    Question Help With Data Classes & Concepts

    Like I said, if you can show me how a well structured DAL is done, I would love to see it. Is it a secret? :playful:
  7. D

    Question Help With Data Classes & Concepts

    The info regarding creating a Data Class that I have found over the past week is so cryptic, it's like it belongs to a secret club, and unless you're a member there is no way of finding out how to do it. I know the AddNew, Update and Delete methods are exactly the same, but I just pass a SQL...
  8. D

    Combo Box DisplayMember Value

    Hi Everyone, I am trying to get the value from a combo selection, more specifically, the DisplayMember. I have a combo box that is populated using the following code: Sub PopComboBox(objCombo As ComboBox, strSQL As String, ValMember As String, DispMember As String) dbs.ConnectDB()...
  9. D

    Question Help With Data Classes & Concepts

    I've managed to sort it out, thank you. For future reference if someone else need to get this working, here is my Class: Imports System.Data.OleDb Public Class clsDatabase Dim cnn As New OleDbConnection Dim dbProvider As String Dim dbSource As String Dim da As...
  10. D

    Question Help With Data Classes & Concepts

    Hi, After about 2 days of working on using a Data Class to return values from a database I'm finally getting somewhere. I can return data and read data without issue. What I'm having a major issue with is editing and writing data back to the database. My class looks like so: Imports...
  11. D

    Question Data Entity Model Not Showing Access Databases As An Option

    OK thanks. I feel a bit stupid... :ambivalence:
  12. D

    Question Data Entity Model Not Showing Access Databases As An Option

    Hi, the link is here: Entity Framework Code First to an Existing Database If you scroll down the page you will see screen shot with the various option that includes Access Databases. Here is the screen shot: i've even downloaded the latest Entity Framework from here: Download Entity...
  13. D

    Question Data Entity Model Not Showing Access Databases As An Option

    Hi, I am experimenting the Entity Data Model Wizard and when I get the options to "Choose The Data Source" the options for Microsoft Access are not listed. I watched the Microsoft Entityhow to video and it definitely has it listed. How can I list MS Access? Sorry if this is a stupid question...
  14. D

    My.Settings.Save() Not Saving

    Thanks John, that's most appreciated.
  15. D

    My.Settings.Save() Not Saving

    Hi John, Thanks for your reply. I can not see a settings.settings file in my project folder. I've got this working, but it's not how i evnisaged it working. The saved setting a placed in the C:\Users\<Username>\AppData\Local\<BusinessName>\<ProjectName>\<VersionNumber> folder. When the program...
Top Bottom