dcsimg

Search:

Type: Posts; User: kareninstructor

Page 1 of 13 1 2 3 4

Search: Search took 0.12 seconds.

  1. Re: VB.Net 2019 SQL to Load DGV

    Your best option is to update the field values to all one common casing then use DISTINCT. What you have tried is for SQL-Server not available with MS-Access database SQL.

    Microsoft Access SQL...
  2. Re: VB.Net 2019 SQL to Load DGV

    Your best option is to update the field values to all one common casing then use DISTINCT. What you have tried is for SQL-Server not available with MS-Access database SQL.

    Microsoft Access SQL...
  3. Re: SQL Unhanded Exception - How to raise the error? Help a DBA

    Consider using a Stored Procedure.

    Sample table


    CREATE TABLE [dbo].[LoanType](
    [LoanTypeID] [VARCHAR](20) NOT NULL,
    [LoanName] [VARCHAR](50) NOT NULL,
    PRIMARY KEY CLUSTERED
    (
  4. Re: [RESOLVED] VS 2017 is there a way to create a backup for sql database server to a

    Totally agree with a server base server being taken offline during normal usage time. But off hours this is fine or if the database is a localdb that is done say on closing of the application as we...
  5. Re: VS 2017 is there a way to create a backup for sql database server to a folder?

    You can run this in code, the USE is the default catalog of the database on your server specified in the connection object, remove the GO statements, use the TSQL in the command text. You need a...
  6. Re: VS 2017 is there a way to create a backup for sql database server to a folder?

    Hello,

    Look at using SQL-Server Management Objects (SMO)

    Microsoft docs for backup and restore...
  7. Replies
    7
    Views
    345

    VS 2017 Re: Number all rows in datagriodview

    Try using ROW_NUMBER if SQL-Server



    SELECT ROW_NUMBER() OVER(ORDER BY dbo.Contacts.LastName) RowIndex,
    ContactId,
    FirstName,
    LastName
    FROM dbo.Contacts;
  8. Re: Opinion on best method - How to load a DGV and Filter via comboboxes

    Using Entity Framework would be a good option. For writing joins in Entity Framework first create the query in SSMS (SQL-Server Management Studio) or by creating the query by creating it from...
  9. VS 2017 Re: Looking for ideas on how to display datagridview with many rows

    See if the following may help. Basic logic to clone checked rows to the bottom DataGridView without duplicating.

    171211
  10. VS 2017 Re: Insert a child record for every existing parent ID

    A slightly modified version from Tyson where in the event this needed to be ran more than once the following ensures no duplicates. Also note the setting table should have a primary key.


    ...
  11. Re: Best way to capture a snapshot of a window

    Here is an option going to a PictureBox, both have overloads to save to disk.



    Option Infer On

    Namespace WindowsFormsApp1
    Partial Public Class Form1

    Private Sub...
  12. Replies
    4
    Views
    270

    VS 2015 Re: hello all

    Hello,

    See my GitHub repository for working with MS-Access databases on GitHub. Note there are several Microsoft TechNet article that go along with the repository listed as part 1, part 2 and part...
  13. Replies
    4
    Views
    270

    VS 2015 Re: hello all

    Hello,

    See my GitHub repository for working with MS-Access databases on GitHub. Note there are several Microsoft TechNet article that go along with the repository listed as part 1, part 2 and part...
  14. Replies
    2
    Views
    265

    Re: Excel and VB.net

    Using SpreadSheetLight (free via NuGet) there is a tad but more work than .paul. yet is a valid alternate as if data is not correct you can do asserts e.g. say if all data is perfect we use the...
  15. Entity Framework Core Visual Basic Support

    I'm sure that there are some VB.NET developers who might like to know where Microsoft is with EF Core, the following thread is a read in that direction.
  16. Re: Data annotation for window forms input validation

    Hello,

    I always write for the current Framework, don't try to make it available for earlier Frameworks so I can not say for sure. A safe answer is 4.5 Framework while the code may possibly run...
  17. Re: Data annotation for window forms input validation

    Hello,

    I always write for the current Framework, don't try to make it available for earlier Frameworks so I can not say for sure. A safe answer is 4.5 Framework while the code may possibly run...
  18. VS 2017 Re: Datagridview move cell value up/down

    Been away all day, just did a download without any issues extracting the solution. I just placed the solution on GitHub.

    https://github.com/karenpayneoregon/DataGridViewListBoxMoveRowsUpDown_VBNET
  19. VS 2017 Re: Datagridview move cell value up/down

    Been away all day, just did a download without any issues extracting the solution. I just placed the solution on GitHub.

    https://github.com/karenpayneoregon/DataGridViewListBoxMoveRowsUpDown_VBNET
  20. VS 2017 Re: Datagridview move cell value up/down

    Hello,

    Another idea is to work against a int column which not only permits ordering via up/down buttons but also remembers the order when showing the DataGridView each time.
    ...
  21. VS 2017 Re: Datagridview move cell value up/down

    Hello,

    Another idea is to work against a int column which not only permits ordering via up/down buttons but also remembers the order when showing the DataGridView each time.
    ...
  22. Re: Impossible to view the "open, save, cancel" prompt after clicking submit button

    Here is when using the browser developer tools is helpful to see if there are any errors thrown or to use Fiddler.
  23. Re: ISO Ideas for Filling DGV & Comboboxes from Stored Procedure / Entity Framework

    Hello,

    Here is another word of advise, unless there is a compelling reason to use stored procedures then don't. Other than enterprise applications that are dealing with mass amount of data I don't...
  24. Re: ISO Ideas for Filling DGV & Comboboxes from Stored Procedure / Entity Framework

    Hello,

    Here are a couple of tips

    Learn about AsNoTracking for read operations, no updating. You will need to have the following import System.Data.Entity. In some cases turning lazy loading off...
  25. Re: Modify code to do Merge for Excel Cells and save excel file in xlsx extension

    Hello,

    With how you are creating the file as already pointed out it's unwise and fragile performing this in a string. OpenXML is very fast yet for the newcomer to this method will be a daunting...
  26. Replies
    7
    Views
    356

    Re: Excel to gridview

    See my code sample which shows the basics to select a range in a worksheet then read the data via OleDb into a DataGridView.
    ...
  27. Replies
    7
    Views
    356

    Re: Excel to gridview

    See my code sample which shows the basics to select a range in a worksheet then read the data via OleDb into a DataGridView.
    ...
  28. VS 2017 Re: Correct way to use error provider?

    The second one. See how I'm setting controls here

    https://github.com/karenpayneoregon/ClassValidationVisualBasic/blob/master/BasicClassValidation/Forms/ContactForm.vb#L50

    Then above it clearing...
  29. VS 2017 Re: Working with CheckedListox and database

    Hello,

    A consideration.

    The following is in SQL-Server but can be done in MS-Access and other databases. The current design may be expanded upon, it's now simply a basic sample. What is not...
  30. Re: .NET 5 - Please give your opinion (especially the Mods and the experienced VB Dev

    Hello,

    Back in March I attended a session at Microsoft by Kathleen Dollard on the future of VB.NET. From this conversation I can say if you stay with the current .NET Framework (which excludes...
  31. Replies
    2
    Views
    338

    VS 2017 Re: Encrypt/Decrypt Binary data

    Hello,
    Encryption is part of SQL-Server

    https://www.red-gate.com/simple-talk/sql/sql-development/encrypting-sql-server-using-encryption-hierarchy-protect-column-data/
    ...
  32. Data annotation for window forms input validation

    A common practice for company or paid for applications is to register a user with a first and last name and password or user name and password some will have a confirm password. With the information...
  33. Re: Renaming file with error Access to the path is denied.

    See the following thread
    http://www.vbforums.com/showthread.php?562813-RESOLVED-how-to-make-program-run-as-admin
  34. VS 2019 Re: Load data into Datagridview

    Have you considered OleDb



    Public Function GetRange(ByVal SheetName As String, ByVal Range As String) As DataTable
    Dim dt As New DataTable

    Using cn As New OleDbConnection With...
  35. VS 2019 Re: Load data into Datagridview

    Have you considered OleDb



    Public Function GetRange(ByVal SheetName As String, ByVal Range As String) As DataTable
    Dim dt As New DataTable

    Using cn As New OleDbConnection With...
  36. Re: Try\Catch makes Excel hang in Task Manager

    I've seen quickness with private variable for Excel automation. Have not done anything in ages with Excel automation, dumped it years ago for Open XML for Excel.

    Anyways it would be interesting to...
  37. Replies
    22
    Views
    874

    Re: Connect VB.Net to MS SQL Server

    Try the following

    1. In Solution Explorer select the very top node, right click, select "Manage NuGet packages for solution".
    2. Select "Browse" tab.
    3. In the only text box type in...
  38. Replies
    22
    Views
    874

    Re: Connect VB.Net to MS SQL Server

    Try the following

    1. In Solution Explorer select the very top node, right click, select "Manage NuGet packages for solution".
    2. Select "Browse" tab.
    3. In the only text box type in...
  39. Replies
    22
    Views
    874

    Re: Connect VB.Net to MS SQL Server

    Here is how you get to the data source window

    169481

    After running the wizard, app.config

    169483
  40. Replies
    22
    Views
    874

    Re: Connect VB.Net to MS SQL Server

    Create a new windows form project, under the view menu of the IDE select "Data sources", click "Add new Data Source", on the window which you setup the connection click the test connection button...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width