How to use the function in the expression that adds a column in the data table
Dim MyTable As New DataTable MyTable.Columns.Add("Name") MyTable.Columns.Add("Age", GetType(Integer)) MyTable.Rows.Add("Ali", 9) MyTable.Rows.Add("Amir", 15) MyTable.Rows.Add("Mansour", 18) …
![](https://techprofile.blob.core.windows.net/images/hBj0LQgf0UCJ70ENoTldCA.png?8DB7E4)
![](https://techprofile.blob.core.windows.net/images/hBj0LQgf0UCJ70ENoTldCA.png?8DB7E4)
Can't get the name of directories sorted by name
Hello experts, I need to get the name of directories sorted by name, just like what is shown in the Windows explorer. 3 folders are in a path, Windows show them in the below order: 0_35_33 7_07_10 18_16_40 But Directory.GetDirectories and…
I created a macro to open an email template, I want to add additional code so that it automatically attaches a specific file, can this be done?
I am fairly new to the macro scene but I was able to create a macro to open an email template, I want to add additional code so that it automatically attaches a specific file, can this be done? I know that you can nest macros and I believe that's what I…
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…
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
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…
ProgID or CLSID for vb.net apps?
Hello, When registering a file type extension for an app written in vb.net framework…
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…
Get a Total from rows in a Grid into another Grid - DevExpress Grid Control
How do I get the total number of Credits in Grid2 from each Student ID in Grid1 using VB.Net? Grid1 Student ID CourseNumber Credit Description 99 1 4 Desc99 99 …
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.
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…