Search:

Type: Posts; User: Yippiekaiaii

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    654

    Problem populating a dataviewgrid

    Hello All

    I have created some code to populate a datagridview from an access database.

    When I run it however the grid doesn't have any data in it (it doesn't error though).

    Can anyone see...
  2. Tutorial for creating an access db input form

    Hello All

    Does anyone have a good link to a tutorial that teaches you how to create an input form that adds records to an access database please.

    I dont want to use datagridviews for this btw.
  3. Replies
    8
    Views
    1,021

    Re: VB2010 SQL question

    Ah so you mean the table that holds the distinct values is populated by the programming when the record is completed. I hadnt thought of that.

    I will give that a go.
  4. Replies
    8
    Views
    1,021

    Re: VB2010 SQL question

    Its no secret, I just didnt want to bore you with too much information.

    The records in the field are going to change frequently but will still have repeating values as they work on contract work,...
  5. Replies
    8
    Views
    1,021

    Re: VB2010 SQL question

    I dont want to do this because the way the table is going to be used by the user.

    I tried clearing the dataset before I loaded it into the combobox but it didnt do anything.

    This is my code:
    ...
  6. Replies
    8
    Views
    1,021

    VB2010 SQL question

    I have a combobox that I am populating with the contents of a dataset (from an access database).

    The field that it is showing has lots of values that repeat.

    I want to remove the repeats of the...
  7. Re: Problem Connecting to an SQL database using wizard

    When I go through the data connection wizard it doesnt seem give me options for entering an instance name or database name. It just asks me for a database file name?
  8. Problem Connecting to an SQL database using wizard

    I have created an SQL Server 2012 database using the Server Managment studio and I want to connect to in in VB2010.

    When I run the connection wizard and locate the .mdf file it always tells me...
  9. Re: Question about the update function on a data adaptor

    I see, can you tell me how to build them myself?
  10. Re: Question about the update function on a data adaptor

    Yes I have the wrong data adaptor on the update method, but that is because I changed it when I was testing and forgot to change it back. It still doesnt work when it has the daorder adaptor.
  11. Question about the update function on a data adaptor

    I am working on a simple programme that has a dataset linked combobox that changes the contents of a datagridview when the SelectedIndexChanged event on the combobox occurs. (ie you select a client...
  12. Re: Copy a record from one datagrid view to another

    That programme does almost exactly what i am after.

    It uses some code I havent come across yet though.

    You have used this code at the start:


    WithEvents bsThird As New BindingSource
  13. Re: Copy a record from one datagrid view to another

    Will this only work if they have exactly that same data structure?
  14. Re: Copy a record from one datagrid view to another

    Correct I have two bound datagridviews.

    The first is a catalogue of products and the second represents an order for which I want to add products from the catalogue to.

    I want to be able to...
  15. Copy a record from one datagrid view to another

    Hello All

    I am writing a programme that copies the selected row in one datagridview to a new row in a second datagridview when a button is clicked.

    Can someone tell me the best way to go about...
  16. Replies
    5
    Views
    632

    Re: Datagrid Help

    As mentioned in my original post this is what I am trying to find out.
  17. Replies
    5
    Views
    632

    Re: Datagrid Help

    Yes that is what I mean.
  18. Replies
    5
    Views
    632

    Datagrid Help

    Hello All

    Are there any good tutorials on the internet that give a full demonstration of how to work with datagrids? The ones I have found with a google search seem to show me how to a datagrid to...
  19. Replies
    11
    Views
    2,059

    Re: VB2010 ADO.NET SQL Query

    Thanks all for your help. I managed to get it to work with the following:


    Dim dafilter As New OleDbDataAdapter("SELECT * from Customers where customerid='" & Filter.Text & "'", cs)
  20. Replies
    11
    Views
    2,059

    Re: VB2010 ADO.NET SQL Query

    In your SQL statement: "SELECT * from Customers where customerid = @CustID;"

    what is the @ sign for before CustID?
  21. Replies
    11
    Views
    2,059

    Re: VB2010 ADO.NET SQL Query

    Appologies if I am not posting enough info. I am new to posting and new to this prog language so I dont know what is relevant yet.


    Public Class Form1

    Dim cs As New...
  22. Replies
    11
    Views
    2,059

    Re: VB2010 ADO.NET SQL Query

    That gives me a different error:

    No value given for one or more required parameters.
  23. Replies
    11
    Views
    2,059

    VB2010 ADO.NET SQL Query

    Hello All

    I am self learning VB201 and am working on a practice app using ADO.NET to connect to an Access database.

    I have the following code for my data adapter in which I want to select the...
Results 1 to 23 of 23



Click Here to Expand Forum to Full Width