How to fix "External component has thrown an exception" in Visual Studio 2019
#> Error : External component has thrown an exception #> Application Type : VB.net Console application. #> Visual Studio Version : Microsoft Visual Studio Professional 2019 #> Operation : I am getting the above error while opening the oledb…
How to find auto-increment indexes in access database
From visual studio 2022 I need to find in an access database the list of indexes that have an automatic increase. I tried with oledbconnection.getshema("indexes") but I did not succeed. Can anyone help me? Thank you Marco Dell'Oca
Datagridviewcombobox returns string instead of decimal causing a datagriderror event
I have a datagridview with a combobox column where I set the values of the combobox.items to decimal values. When I select a value I get the dateerror event, and when I look at the value for the combobox column, it is a string, not a decimal, which I…
OSVERSIONINFOEX dwBuildNumber
Hello experts, To detect Windows Server 2016 and onward, I use this code, my question is that am I using the correct build numbers to distinguish? Thanks :) If OSVERSIONINFOEX.dwMajorVersion = 10 Then If OSVERSIONINFOEX.wProductType =…
Regex.Matches return no duplicates?
Hello Dim blah As MatchCollection = Regex.Matches(text, "([a-zA-Z0-9_-.]+)@([a-zA-Z0-9_-.]+).([a-zA-Z]{2,9})", RegexOptions.CultureInvariant Or RegexOptions.IgnoreCase Or RegexOptions.Multiline) How may I force Regex.Matches not to return…
MatchCollection to List(Of String)
Hello Instead of: For Each Match As Match In MatchCollection StringList.Add(Match.Value) Next Is there a shorter and faster way to add all element values in MatchCollection to the StringList which is list of string? Thanks.
ProgID or CLSID for vb.net apps?
Hello, When registering a file type extension for an app written in vb.net framework…
RegistryKeyPermissionCheck.ReadWriteSubTree vs boolean Writable
Hello, When using Registry OpenSubKey, I can set either RegistryKeyPermissionCheck.ReadWriteSubTree or Writable boolean property = True. Using MyKey As RegistryKey = Registry.LocalMachine.OpenSubKey("App.Blah\DefaultIcon",…
Option Infer Off help
Hello, I am getting some errors when Option Infer Off and need to eliminate them, all becuase of data type declaration, since they belong to COM objects I've no idea set them to which data type? For Hhctrl.ocx: Dim Const HH_DISPLAY_TOPIC = &H0 Dim…
Run-time error -2147221164 (80040154) Class not registered
Hi, I applied this tutorial for using .Net in Micrsoft Office, I used Visual Studio 2022 Current and .Net Framework 4.7.2 and Microsoft Access 2016 I didn't see Intellisense when writing code, and when I execute I get the error: Class not…
2 simple questions about XmlDocument
Hello Dim doc As New XmlDocument Before .Load, using this property has any effect or is default and disregarded? Before .Load, using this property has any effect or is default and disregarded? doc.PreserveWhitespace = False Move on: doc.Load(…
How to pass a report parameter with multiple values from vb.net
I am currently using Visual Studio 2013 and I am writing a service that will allow someone to choose report settings and pass them into the SSRS 2016 report. I am coding this is VB.net. The issue I am having is one report parameter has been setup…
Error loading/reading file
Hello I've got the WDK installer and asked it to save files to my drive, now when I wanna read those files I'll get exceptions, when trying to load via OpenFileDialog: Never seen such scenario, how to gain permission via VB.net when reading such…
VerticalScroll.visible doesn't seem to be working on autoscroll
Hello, My Flow layout panel has panels in it that stretch the entire flow panel, the problem is that it has autoscroll on(and I want to keep it on), and when there'ss enough panels to get a vertical scroll bar, the ends of the panels are cut out and it…
XmlDocument to XmlReader?
Hello I used to load an XML file into an XDocument and keep it intact in memory, then pass it to another object when needed, since it only accepts XmlReader, I was using XDocument.CreateReader. Now am moving from XDocument to XmlDocument, just no idea…
Running total columns in DataGridView
Hi, I have a DataGridView with 4 columns & I am trying make the last 2 columns running totals, calculated by checking if the Type column value is A or B, then adding the Quantity column progressively as new rows are added. Please see table below to…
How to find where my code gets into an infinite loop
My Visual Basic code is getting stuck somewhere and never finishes. This only happens with one particular input, otherwise it works. I'd like to know at what routine the code is getting stuck. I looked for advice on the web, and it says that when…
How to sort a table without breaking column relationships when using "DefaultView.ToTable()"
How to preserve relationships between tables after sorting Related to the Designer.vb Part <Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _ Partial Class Form1 Inherits System.Windows.Forms.Form 'Form overrides dispose…
BC42017 Late bound resolution; runtime errors could occur
Hello friends, I am programming with VB.NET 2022. In this line of code: With BsQRequestPorductHeader TxtRequestPorductHeaderId.Text = .Current.Item("RequestPorductHeaderId").ToString TxtRequestPorductHeaderNum.Text =…
Disabling Highlighting on a ListView
Hello, I'm making a program to display a GUI with multiple icons showing the state of devices connected to a master device, so far It's going great except the Item I used to store them in, ListView, has an issue, When selected the icon and text…