efficient way to add csv to database
Hello I read a csv text file line by line and use oldb sql command insert into table to add each line's fields to the table's row. But it takes a very long time, I wonder if there's faster achievements, please advise the most efficient and fastest way to…
Having issue with Keyword not supported: 'trust server certificate in Visual Studio VB
Hi. I'm trying to run VB code in visual studio form project but get an error when code is trying to run. Error is: "System.ArgumentException: 'Keyword not supported: 'trust server certificate'.'". The line in code affected is: Data…
How to Get address datagridview cells row by row to an array Linq
I do not want to address this way. Is there another way of LINQ? And if there is no way with linq, with a function that obtains cell addresses row by row Dim AddressCells As DataGridViewCell() = {dgv.Rows(0).Cells(0), dgv.Rows(0).Cells(1),…
No more support for Web forms in Visual Studio 2022?
Hi, In new Visual Studio there is no more option to create Web Forms web application? Are MVC only future architecture Visual Studio will support for WEB pages? Thx
How to get the highest parent(The form in which the user control is located) of an object(user control)
When I want to reach the highest parent(meaning the same form) in my fake user control , these are returned due to the placement of the user control in (TableLayoutPanel, Panel, TabControl,...).
vb.net Unit Test Project .NET Framework 4.8 has stopped seeing all subroutines and function in the project being tested.
I have created a vb.net project using .NET Framework 4.8 with a single public subroutine. Also, created a Unit Test project within the same solution and set the references in the Unit Test project pointing to the project being tested. I was able to…
Get encoding from Encoding.EncodingName
Hello I need to get the Encoding from a string which is a valid string : Encoding.EncodingName ie: Korean (EUC) or Central European (Windows) Having this string, how to get the proper encoding? Encoding.GetEncoding("Central European (Windows)")…
Working with Access database via OleDbReader
Hey all I have no problem when all my access mdb are string! I'm using Access database engine 2010 to connect to mdb. The problem occurs when I have Boolean / Integer / Date fields: New OleDbCommand("INSERT INTO tableblah (strfield, intfield,…
Error 429 only if Outlook is already open when try to automate an email
Good day Gurus of .Net Since I started trying to get my app to be option strict compliant, I've suddenly started getting error 429 Unable to create active x component BUT only when Outlook is already open. I have the following code to get an instance of…
How to lose the focus of the selected cells when it is done with the 'Clipboard.Clear()' command in Visual Basic?
hi Private Sub tsmFillNumberMerged_Click(sender As Object, e As EventArgs) Handles tsmFillNumberMerged.Click 'Trying to (Fill Auto Namber) cells when they are merging If Clipboard.GetText IsNot Nothing Then Dim sttClip As…
VB.NET SQL Connection and SQL Command Error BC3002
Hello, I'm in the process of converting VBA to VB.NET with SQL statements. One of the changes is utilizing the "ExecuteNonQuery". Since I'm still learning the syntax, I simply copied the VB.NET statements from a web-site. But I'm getting 2…
Check self signature status
Hello Using VB.net or C# .net framework 4.0, is it possible to add a self check for the digital signature of assembly file? So assembly file should check itself to make sure if it's signed using my code signing certificate and if not, or file is modified…
Binding Errors in a Simple Project
I have carved out a simple project from a larger one to demonstrate the binding errors I am getting so the names I use might seem ... odd. The following is the ENTIRE project: Window…
How to add a MaskedTextBox On The ToolStrip
hi . Is such a thing possible?
Allow firewall via registry instead of netsh?
Hello Going to allow an app through Windows firewall in vb.net Instead of using: netsh advfirewall firewall add rule name="blah" dir=in action=allow program="C:\Program Files\blah\App.exe" enable=yes May I just add this registry…
How to Get Description of Column_Flags by function GetSchema
hi . What are these numbers and how can they be translated? Dim cn As New OleDb.OleDbConnection(Conn_String_Access) cn.Open() Dim dtSheama As New DataTable dtSheama = cn.GetSchema("Tables") 'indexes'columns'Tables
RemoveRegistry Table in MSI
Hello In MSI project installer, I need to remove these 2 values from…
Why VB.Net projects that were working OK suddenly fails to start now?
Hi all, I have written many trial projects using VS 2013, VS 2019 and they were working fine for few years; Since the 1st week of March 2024, when I click "Start Debugging" / "Start without Debugging" any of those projects in Visual…
For Each Drive in batch file
Hello These commands inside a .bat batch file will disable bit locker for C:, D:... manage-bde -off C: manage-bde -off D: ... Is it possible that using batch file (not powershell) I loop through existing drives and run the above command for each drive in…
ADD Column will not show CheckBox
Hello, Using Access database engine + oledbreader on mdb, this code will add a new boolean yes/no column: New OleDbCommand("ALTER TABLE BlahTable ADD Column BlahOption BIT NOT NULL", strConnection) :: ExecuteNonQuery This will add a yes/no…