Search:

Type: Posts; User: kareninstructor

Page 1 of 13 1 2 3 4

Search: Search took 1.77 seconds.

  1. Re: Generate classes from SSMS in Visual Studio 2019

    I never heard of PetaPoco before, took a quick look at PetaPoco.Core.ttinclude and with that the PasteSQL is limited in that it only does SQL-Server unlike PetaPoco which does multiple databases.
    ...
  2. Replies
    3
    Views
    249

    Re: Clone and Rename - Install File

    This is really easy with Visual Studio 2010 and higher using Resharper extension.

    High level, copy the solution folder then paste, change the folder name. Open the solution, change the namespace...
  3. Generate classes from SSMS in Visual Studio 2019

    PasteSQL C# Classes

    This add-in will allow you to paste SQL create statements from SQL Server and create C# classes from the table. In SSMS, Right click on a table, Script Table as> Create to>...
  4. Replies
    0
    Views
    117

    Visual Studio Code tricks

    Open a GitHub repository in Visual Studio Code in your browser


    Open a GitHub repository (try one of yours first)
    Type a period character
    This starts VS Code
    On the left is a menu followed...
  5. Replies
    5
    Views
    267

    Re: Dictionary, more than one item

    For learning, another option is Lookup<TKey,TElement>

    In the following code written many years ago focus on Demo_3b while there are other examples which can be considered.


    Public Class...
  6. Re: Delete lines between specific 2 lines in text file using vb.net

    According to your last response the best option is to populate a .json file where each question has options like you presented, use Json.net or System.Text.Json to read/write to the file.


    Public...
  7. Re: Delete lines between specific 2 lines in text file using vb.net

    Consider using a comma-delimited file coupled with a concrete class which represents your data.

    Sample data in a file

    Id,Question,Explanation
    1,Question 1, answer 1
    2,Question 2, answer 2...
  8. VS 2019 Re: Cell value of First colum & last row in datagridview

    An alternative is to load the DataGridView by setting the DataSource be it a DataTable or a list. Let's say columns are EmployeeID, LastName, FirstName, Country in a DataTable and populated from a...
  9. Replies
    3
    Views
    207

    Re: Powrshell command and output

    The cheap way is using Process.Start. Since you have one variable that can be done with string interpolation. The following is a working proof of concept which gets the current IP.


    Imports...
  10. Replies
    6
    Views
    269

    Re: Basic url opening in VS 2019

    Note the OP has already done this in the initial post.
  11. Replies
    6
    Views
    269

    Re: Basic url opening in VS 2019

    If using .NET Core consider the following NuGet package (source)

    Install-Package MintPlayer.PlatformBrowser


    Option Infer On

    Dim browsers = PlatformBrowser.GetInstalledBrowsers()
    For Each...
  12. Replies
    6
    Views
    269

    Re: Basic url opening in VS 2019

    Here is an example targeting Chrome browser


    Imports Microsoft.Win32

    Public Class Form1
    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
    if Not...
  13. Re: Excel task not terminating

    Try the following pattern where adhering to the order of objects being disposed makes a difference in killing your Excel objects, otherwise these objects will dispose on a clean exit of the app while...
  14. Replies
    1
    Views
    221

    Re: Export to Excel From Datagridview

    This is simple to export columns in a DataGridView when using the DataSource of the DataGridView with a DataTable using SpreadSheetLight via NuGet.

    To get only needed columns, Crate a new...
  15. Replies
    16
    Views
    674

    Re: Strange DGV Behavior

    Perhaps the following might help.
  16. Replies
    4
    Views
    829

    Re: Visual Studio blank solution fix

    It's gotten exposure on Tweeter

    182415
  17. Replies
    2
    Views
    448

    Re: Time Picker ComboBox

    Agree in regards to you can work directly with the time portion via a DateTimePicker.
  18. Replies
    4
    Views
    829

    Re: Visual Studio blank solution fix

    Just had 20 developers install VS2019 developer's edition this week, none had the blank solution.
  19. Replies
    0
    Views
    156

    Remove Mark of the web - Recurse

    Some computers may have security setup to not trust some files download from the web such as a form resource file in a VB.NET or C# project. If there are many files one must right click on each file...
  20. Replies
    4
    Views
    829

    Visual Studio blank solution fix

    Visual Studio earlier versions provided an option to create a blank solution then in one or more updates this option has gone away. For those who are new to Visual Studio may want to create a new...
  21. Replies
    2
    Views
    448

    Time Picker ComboBox

    .NET Framework has a DateTimePicker but not a control to work with TimeSpan which is what TimePickerComboBox was created for.

    Developed with .NET Core 5.

    Simple example with using a data...
  22. Reusable code published in NuGet packages

    When developing many applications generally a developer finds certain methods are used over and over again.

    When this happens an option is to place code into a separate Visual Studio solution as...
  23. Replies
    3
    Views
    267

    VS 2019 Re: Get number of cell

    There is a free Excel library, SpreadSheetLight, on NuGet which can perform a case insensitive find against all used rows/columns in a WorkSheet.

    Notes

    Used rows/columns are provided via...
  24. Re: How soon may I have to give up VB.net (and VB6)?

    Been getting up to speed with Rider for working with VB.NET then I will have more contributions.
  25. Re: how do i disable FileSystemWatcher after file is found?

    Take a look a the following code sample. The class inherits FileSystemWatcher which in this case watches for specific files in the bin\debug folder and removes them.

    Simple start/stop watching

    ...
  26. Re: How soon may I have to give up VB.net (and VB6)?

    My last comment on this topic.

    Live in stone-age or not, that is your choice.
  27. Re: How soon may I have to give up VB.net (and VB6)?

    Totally agree
  28. Re: Max SQL Column value - VB issue executing command

    You need ExecuteScalar not ExecuteReader
  29. Re: How soon may I have to give up VB.net (and VB6)?

    That is not a good attitude if you are a developer with say five or more years left in the profession. Some developers will coast by on a given language but what happens when it's mandated to use...
  30. Re: Insert data from datagridview to SQL database

    We are not mind-readers, you need to elaborate on the issue as it doesn't work is lacking details


    First option, step through the code by setting a breakpoint in the code which is not working...
  31. Replies
    8
    Views
    562

    Re: Accessing class in class library

    An alternative is to create a new class which inherits BindingNavigator, create buttons there, setup properties, assign images then in your form setup events and conditions such as enabling and...
  32. Re: How soon may I have to give up VB.net (and VB6)?

    For new projects rather than contemplating this language or that language focus on personal or client needs followed by will the chosen language be suitable for the project.

    If a developer is...
  33. VS 2015 Re: Trying to import sleep function

    Use


    Declare Sub Sleep Lib "kernel32.dll" (Milliseconds As Integer)

    Works under VS2019, should work under VS2015
  34. Re: Get Connection String By Provider Error

    This is exactly what JMC was referring too. It's crystal clear, unsure why you don't understand?

    182136
  35. Replies
    4
    Views
    428

    Re: Entity Framework Core for VB.NET

    Check this course out.

    Course 20486-C: Developing ASP.NET MVC 5 Web Applications

    In this 5-day course, the professional web developers will learn to develop advanced ASP.NET Core MVC...
  36. Replies
    4
    Views
    428

    Re: Entity Framework Core for VB.NET

    If interested check out my code sample.
  37. Re: Deleting a row from the data source (datatable) of a datagridview

    Yes the code removed the DataRow from the DataTable
  38. Re: Deleting a row from the data source (datatable) of a datagridview

    Here is a code sample which does a soft delete, minor change to do a hard delete. Code sample written in VS2019, .NET Core 5, will work with older Frameworks.
  39. Re: Application interperting textbox context as SQL Code

    Here is an option which separates data operations from the form. Looks like both values for the UPDATE are strings, if not change the type in each command parameter.

    UpdateOrder returns a named...
  40. Replies
    20
    Views
    1,280

    Re: ConnectionStrings.com is gone!

    I have to empty the fricken cache, see it now.
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width