Search:

Type: Posts; User: ktrammen

Search: Search took 0.01 seconds.

  1. Replies
    5
    Views
    2,065

    Re: Want a hyperlink control

    Thanks, yes, came across that. Overcomplicated because 99% of the time one only wants one link per control.


    Forgot about the tag property. But I always used to avoid it because it feels a bit...
  2. Replies
    5
    Views
    2,065

    Want a hyperlink control

    This is a quickie because I'm sure this has a very simple answer (yet I cannot see it).

    I want to put a hyperlink onto a Windows form. From hunting, there's this LinkLabel control that one is...
  3. Replies
    2
    Views
    2,879

    Want an array from ListBox's selected items

    I have a ListBox populated from a view, with ValueMember holding integers.

    I have the SelectionMode set to MultiSimple so multiple list items can be selected. I want to put the values of the...
  4. Re: Dynamically adding TextBoxes, buttons etc. How to detect which one clicked etc.?

    Yes, that's it. Many thanks yet again Shaggy.

    I had thought before that "sender" might be the object raising the event, but never worked out how it could be used.
  5. Dynamically adding TextBoxes, buttons etc. How to detect which one clicked etc.?

    I'm using Controls.Add to add controls at runtime. Although I name them at runtime, I want to know which control gets clicked, changed etc.

    Background: I'm generating controls from an array, laid...
  6. Re: Really, I want a parametrised view, but SQL Server doesn't allow this. Advice?

    After all that, I think I've just discovered it.:o Nearly 01h00 and I promised I would not work past midnight.:cry:

    In case anyone else should be looking for the answer, it's:

    ...
  7. Re: Really, I want a parametrised view, but SQL Server doesn't allow this. Advice?

    I created a table valued function easily enough. It takes a parameter.

    However, I would then need to pass that parameter in from VB, and I cannot find how I can do that. I have hunted through the...
  8. Referencing controls, variables etc. in a form known only by its name as a string

    I will have a large number of forms in my application. I want to store their names in a database, and when I want to open one of them, I simply want to use the name of the form. It's not...
  9. Replies
    12
    Views
    4,674

    Re: Custom date format

    Thought all DBMSs had a DateTime data type or similar (at least, I know SQL Server, Oracle and Access do). Anyway, many thanks for that! It works. I hadn't thought of converting the data type.
    ...
  10. Replies
    12
    Views
    4,674

    Re: Custom date format

    I know about date formats in VB.Net so I don't want to learn about them in C#. But thanks anyway.


    I came across one if not both of those in my searching. They don't tell me what I'm supposed to...
  11. Replies
    12
    Views
    4,674

    Custom date format

    I'm retrieving a date from a date column in the database, and want to apply my own, custom formats, like "dddd d MMMM yyyy", or just "ddd", etc. to display in a Label or a TextBox.

    I've found the...
  12. Really, I want a parametrised view, but SQL Server doesn't allow this. Advice?

    I have a DataGridView whose rows depend on user input. I can't use a filter on the DataGridView's binding source (source is too complex), and SQL Server doesn't allow parametrised views.

    I don't...
  13. Re: Want Ubuntu bootable USB stick. How do I create one from Win.10?

    Discovered later it was the F12 key. Now have a functioning spare laptop.:)
  14. Re: Want Ubuntu bootable USB stick. How do I create one from Win.10?

    I've discovered Rufus is now at https://rufus.akeo.ie/ so I've taken a chance and installed it.

    Now can't discover how to boot from a USB drive from my cheapo HP laptop (usual F8 on boot-up...
  15. [RESOLVED] Want Ubuntu bootable USB stick. How do I create one from Win.10?

    I have an old Windows 7 laptop that is now too slow to use, so I want to try Linux instead of throwing it away.

    Ubuntu seems to be the most recommended one, so I've downloaded the ISO onto my...
  16. Re: Executing stored procedure within transaction: proc runs even if transaction fail

    Yes, obviously (I used to know that, I'm so rusty!).:blush:
  17. [RESOLVED] Executing stored procedure within transaction: proc runs even if transaction fails?

    I have a T-SQL transaction that I've set up to fail, but it still seems to partially succeed.:eek: This seems contrary to what I read in this Stack Overflow thread. Am I missing something? I would...
  18. Replies
    16
    Views
    10,501

    Re: Synonyms for "Parent" and "Child"?

    Upstream/Downstream would work well -- thanks!
  19. Replies
    16
    Views
    10,501

    Synonyms for "Parent" and "Child"?

    Some English language advice needed, even though my English is better than that of most native English speakers...;)

    I'm developing something where things often have a parent-child relationship....
  20. Re: DataGridView: How to requery after data changed?

    That's the solution. Hadn't thought of going that far up the tree.

    I did this:


    MyDataDataSet.MyView.Clear()
    MyDataTableAdapter.Fill(MyDataDataSet)


    That's saved me a few hours --...
  21. [RESOLVED] DataGridView: How to requery after data changed?

    I put a DataGridView on a form at design time. The DataGridView is based on a database view, and at runtime I get it to show a subset of the view using the BindingSource's Filter property.

    I want...
  22. Re: DataGridView: getting "Object reference not set to an instance of an object"

    This was one of the first things I did (and I thought I'd indicated this in my OP), and it was precisely this that gave rise to the error, which gave rise to my OP...


    Yes, this works. A whole...
  23. [RESOLVED] DataGridView: getting "Object reference not set to an instance of an object"

    I want to dynamically change the source of data for a DataGridView. So I have been trying to use this Microsoft example as a basis.

    I've now spent about six hours spread spread over two and a half...
  24. How to actually call this function that uses SqlDataAdapter.UpdateCommand

    Sorry, been hunting around for an hour now and I am becoming mentally drained. I am hoping I can get this resolved today instead of wasting yet another week.

    I want make use of the VB code in...
  25. Re: Can't create SQL Server DB via SSMS - error 262

    OK, I decided to uninstall SSMS, and reinstall it via my personal account (I'm an administrator on the laptop). I still got the same error 262 when trying to create a database.

    I then logged in...
  26. Re: Can't create SQL Server DB via SSMS - error 262

    The server is simply on my laptop. I'm using (I think) Windows authentication - is that the same as integrated security?

    For the moment, I'm simply trying to get started, so am happy with an MDF...
  27. Re: Feasibility of building and using custom DBMS comprised of text files?

    I started thinking about these and other things after my earlier posts. In my own head I came up with solutions for some, and I found a readily available quicksort VB.NET example that worked...
  28. Can't create SQL Server DB via SSMS - error 262

    I'm trying and failing to create a SQL Server database.

    I first tried to create it via VS 2017 but that gave me Error 40 "Could not open a connection to SQL Server".

    Googling that error...
  29. Re: Feasibility of building and using custom DBMS comprised of text files?

    The issues at my end are ones that are issues for many other people. For example, the latest one is as described, for example,
    here, where many solutions are provided (under that link, and in...
  30. Feasibility of building and using custom DBMS comprised of text files?

    I'm having continual problems creating or using standard DB formats (PostgreSQL, Oracle, SQL Server, even Access and SQLite).

    Someone posted somewhere that they'd gone down the route of simply...
  31. Re: How portable is SQL Server? Want DB on laptop, but want to easily back up or move

    Thanks, will investigate.
  32. VS 2017 Can't seem to change BorderStyle for TextBox, RichTextBox - bug in VS?

    For TextBoxes and RichTextBoxes, the BorderStyle property can be set to None, FixedSingle, or Fixed3D.

    However, TextBoxes seem to only display as either None, or FixedSingle. (Fixed3D is displayed...
  33. How portable is SQL Server? Want DB on laptop, but want to easily back up or move.

    I have this MS Access database on my laptop, and am developing a VB.NET app as a front end. I'm quite happy about the DB being on my C: drive -- it's a single-user system (the user being me), plus I...
  34. Re: VB.NET. I just want to retrieve a column value, but can't discover the syntax!

    Yes, that's the answer. Many thanks!
  35. VB.NET. I just want to retrieve a column value, but can't discover the syntax!

    OK, I've been trying for an hour but I haven't found the answer (I'm a newbie with VB.NET).

    In the form load event, I have the following (Ds_Items is my DataSource, tab_Appliances is the table...
  36. VS 2017 Re: Forms added to solution are not shown in solution explorer

    I'm was having the same problem, and was about to ask if someone had found a solution, when I noticed this Show All Files tool at the top of the Solution Explorer. Now working for me!
Results 1 to 36 of 36



Click Here to Expand Forum to Full Width