dcsimg

Search:

Type: Posts; User: schoemr

Page 1 of 13 1 2 3 4

Search: Search took 0.16 seconds.

  1. Replies
    24
    Views
    786

    VS 2017 Re: Working with CheckedListox and database

    Hi guys, thank you very much for your ideas :)

    This scenario:

    The guest house have a ordering system where guests can order breakfast (for next morning) There is a cut-off time which is before...
  2. Replies
    24
    Views
    786

    VS 2017 Re: Working with CheckedListox and database

    Thank you Goggy, I will try this :)
  3. Replies
    15
    Views
    351

    VS 2017 Re: Login Form - Access failed

    in VS there are better (easier) ways to connect to database. These older guys on vbforums is always fighting with me because I don't do some things in the old fashioned way :) But there is benefit to...
  4. Replies
    15
    Views
    351

    VS 2017 Re: Login Form - Access failed

    I am not sure about your connection - but if you are sure that your method is indeed open a connection, then you have to check if that username and associated password exist in the database. You can...
  5. Replies
    15
    Views
    351

    VS 2017 Re: Login Form - Access failed

    Hi, If I may ask are you using Visual studio?

    You are trying to login with a username and password that is already exist in database?
  6. Replies
    4
    Views
    181

    VS 2012 Re: Sign in Form trouble

    Hi,

    Also it is important to check if username ready exist as to prevent duplicates. But this may not be within the scope of your assignment..

    I am just not understand why you do Insert before...
  7. Replies
    24
    Views
    786

    VS 2017 Re: Working with CheckedListox and database

    Hi,

    I have implemented that select on the on the tblItems like so:


    SELECT ISNULL(tblUsers.UserName, '') AS Name, ISNULL(tblItems.Item, '') AS Selection
    FROM tblUsers LEFT...
  8. Replies
    24
    Views
    786

    VS 2017 Re: Working with CheckedListox and database

    Hi, oh, let me try again

    168993
  9. VS 2017 Re: Save datagridview column values to array and also retrieve from array

    I don't know....


    for i as integer = 0 to datagridview1.rows.count - 1
    DataGridView1.Rows(i).Cells(0).Value = .. ? GlobalVariable?
  10. VS 2017 Re: Save datagridview column values to array and also retrieve from array

    It is to keep history. It can happen that User A gets assigned to another area... I still wants to see what information that user captured whilst she was at say Area A (even though she now is...
  11. VS 2017 Re: Save datagridview column values to array and also retrieve from array

    Okay.... I see what you say (i think)


    sql = "SELECT * FROM tblAreas WHERE UserID='" & TextBox1.Text (assume user ID in TextBox1)


    Then:
  12. VS 2017 Re: Save datagridview column values to array and also retrieve from array

    Hello JMC,



    No, more than one users can have the same area...

    For every user I add areas. eg.

    User1 (Area A, B, C)
    User2 (Area A, C)
  13. VS 2017 Save datagridview column values to array and also retrieve from array

    Hi,

    Below is my complete login procedure.

    Please see how I store user details into global variable for use. I use this stored values in certain places whilst user is working on system e.g...
  14. Replies
    24
    Views
    786

    VS 2017 Re: Working with CheckedListox and database

    This is the schema:

    168967
  15. Replies
    24
    Views
    786

    VS 2017 Re: Working with CheckedListox and database

    Hi guys,

    Thank you very much for your guidance. I have created an example as per your replies and looks like this:

    168963

    In this picture above I can see that Mary have apples and lemons....
  16. Thread: Arrange data

    by schoemr
    Replies
    9
    Views
    320

    VS 2017 Re: Arrange data

    - Yes that is correct.

    Can you maybe give an example? Please? :)

    Say, I want to view this in a treeview?
  17. Replies
    24
    Views
    786

    VS 2017 Working with CheckedListox and database

    Hi,

    This question will probably involves more than one thread.

    I have in a SQL database tblUsers here I capture fields like FirstName, LastName, Phone, etc.

    I want to see for every user...
  18. Thread: Arrange data

    by schoemr
    Replies
    9
    Views
    320

    VS 2017 Re: Arrange data

    Hi Wes,

    I was hoping that there is a way to take all of this data (850 000) rows, import it into a table and from them have a hierarchy. I don't even know how many layers (levels) this will be...
  19. Thread: Arrange data

    by schoemr
    Replies
    9
    Views
    320

    VS 2017 Re: Arrange data

    Hi JMC,

    e.g I have 5 tables (looking at the picture) - (one to many)

    Then I create DGV's. If I click on "0" in first DGV, then 2nd DGV shows 1,2,3

    If I click "1" in 2nd DGV, then 3rd DGV...
  20. Thread: Arrange data

    by schoemr
    Replies
    9
    Views
    320

    VS 2017 Arrange data

    Hi,

    I have a very large table (850 000 rows) an it looks like the column on the left hand side of my picture.

    Column A contains all 850 000 rows and they are ALL unique.
    Every number in...
  21. VS 2017 Re: Update TableAdapter without losing focus in DGV selected row

    hi KPMC,

    Thank you million times for this. I gather you hate wizards :)


    COUNT(Child.TaskName) is work exactly what I need. (there is only one relation)
  22. Thread: PowerBI

    by schoemr
    Replies
    0
    Views
    156

    VS 2017 PowerBI

    Hi, is there a place on vbForums for PowerBI questions?
  23. VS 2017 [RESOLVED] Update TableAdapter without losing focus in DGV selected row

    Hi,

    I have two bound tables that is related (one to Many)

    tblUsers >> tblTasks

    Every user have many tasks.

    In the dataset designer for tblUsers I add unbound column and count # of tasks.
  24. Replies
    2
    Views
    237

    VS 2017 Re: Adding DGV column to array

    Hello Wes,

    Yes are indeed correct. I was making this too complicated :)

    Thank you very much, this method is what I needed. It is working perfectly! :)

    As for the error - I still don't...
  25. Replies
    2
    Views
    237

    VS 2017 [RESOLVED] Adding DGV column to array

    Hi,

    I have a 2 DGV where I remove all columns and only UserID remains

    If a UserID is in the 1st DGV then filter that UserID out in the 2nd DGV.

    e.g. If UserID 4 exist in DGV1 then do now...
  26. Replies
    7
    Views
    232

    VS 2017 Re: Update ID's in bound DGV

    Hi John,

    I have to apologize as I am the one needing help and I am the one not understanding :)

    To update cells that is not an ID is working perfect (I can update "NameOfTsk" all at once)
    ...
  27. Replies
    7
    Views
    232

    VS 2017 Re: Update ID's in bound DGV

    Hi John,

    I am getting this error:
    Unable to cast object of type 'System.Data.DataRowView' to type 'System.Data.DataRow
  28. Replies
    7
    Views
    232

    VS 2017 Re: Update ID's in bound DGV

    Hi kpmc :)

    It is still doing the same thing....
  29. Replies
    2
    Views
    158

    VS 2017 Re: Visual Studio 2017 crashes all the time

    Hi Karen,

    Thank you very much. I shall try this :)
  30. Replies
    7
    Views
    232

    VS 2017 Update ID's in bound DGV

    Hi,

    I have two related tables (one to many) tblUsers & tblTaskContext - for every user that is selected the first DGV, the 2nd DGV display tasks for that person.

    In this example User 7 have...
  31. Replies
    2
    Views
    158

    VS 2017 Visual Studio 2017 crashes all the time

    Hi,

    I am using VS 2017 community. It freeze and then close, and restart constantly. Like 10 times every hour.

    Does anyone else have this problem? I do some research and many people have this...
  32. VS 2019 Multiple Users and Multiple User Details on same form

    Hi,

    I have two tables that is one to many.

    I have a User (top grid) and in bottom grid the tasks for that User. In this example User 4 have completed 2 tasks.

    In this form on the left hand...
  33. Replies
    4
    Views
    149

    VS 2019 Re: [RESOLVED] Count when greater that zero

    Hi John, Yes I should. Thank you :)
  34. Replies
    4
    Views
    149

    VS 2019 Re: Count when greater that zero

    Thank you Funky!!! :)
  35. Replies
    4
    Views
    149

    VS 2019 [RESOLVED] Count when greater that zero

    Hi,

    In a datagridview I display users as well as total tasks every user have done. I have added a manual DataColumn in the dataset designer and set the source to Expr1:


    SELECT ...
  36. Replies
    3
    Views
    197

    VS 2019 Re: Zooming in/out on WinForm

    Hi Goggy, thank you for you reply. Not what I have in mind :)
  37. Replies
    3
    Views
    197

    VS 2019 Zooming in/out on WinForm

    Hi,

    It seems from what I research that it is not possible to zoom in/out of normal WinForm. So I am looking for maybe a clever method to implement some zoom in/out effect.

    My problem is that I...
  38. VS 2017 Re: [RESOLVED] Help with parameter for dlc report

    168207
  39. VS 2017 Re: [RESOLVED] Help with parameter for dlc report

    Hi, I have some report questions that to this day has never been answered.. I have struggled with RDLC reports for many days and many hours....So I understand what frustration RDLC report can bring....
  40. Replies
    7
    Views
    208

    VS 2017 Re: TableAdapter from split

    John, the fill of the datatable can only happen when the form is load..? I want to create a report and that report use a datatable that is not "loaded" - it is in the dataset designer.

    If I...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width