UPDATE fields
Hello, This works when using insert into: Using command As New OleDbCommand("INSERT INTO Table (Column1) VALUES (?)", connection) command.Parameters.AddWithValue("@param1", field1) command.ExecuteNonQuery() …
WebView2 fit to page
I am using a WebView2 control in a WinForms app. It is working fine. However, I'd like the "Fit to Page" button sizing to be the default when a PDF file is displayed in the WebView2 control. How do I make this the default setting in my VB.net…
How do I add a CAPTCHA to a web site written with ASP.NET/VB
A bot seems to be using my web site to send out emails via AmazonSES. I want to add a CAPTCHA to it to prevent this. I came across https://stackoverflow.com/questions/71515717/how-to-add-captcha-in-asp-net-project which appears to be what I want, but…
How to convert normal date to solar date(PersianCalendar)
with System.Globalization.PersianCalendar NameSpace Need function to convert to solar date
Opening a Window Using Its Name
From my MainWindow I am trying to open another window knowing only its name. In my MainWindow ViewModel, I have: Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (lpClassName As String, lpWindowName As String) As…
Declaration expected
Public Module GlobalVariables Public gDataGridShowing Public gDatabase As String ```End Module Public Class Form1 gDatabase = "ganswind" **<<< error "Declaration expected"** Function HideMenuPoints(ByVal…
How to disable "the attachment is open. don't forget to save the file if you made any changes" error in outlook auto save macro. Every time any new attachment received i got this error
I have a remote system which was working fine for last 3 years but suddenly i am started to received attached error when any new item received in Outlook. My outlook have macro which save all the attachement in specified folders but this error have…
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)")…
How to get the range index of repeated elements. LINQ
Thank Dim MyArray as String()={"A","A","A","B","B","C","A","A"} 'Need Result as Array 0-2 3-4 5-5 6-7
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…