Integer equivalent in Access
Hello I work with Access mdb with OleDbRader (Access Database Engine) in vb.net and need to set the data type to Integer (NOT Long Integer) so: Dim cmd As New OleDbCommand("ALTER TABLE Blah ALTER Column colm ???",…
FileIO.TextFieldParser
Hello, Dim Blah As New FileIO.TextFieldParser(src) MyTextParser.TextFieldType / .SetDelimiters / .TrimWhiteSpace etc While Not MyTextParser.EndOfData Blah.ReadFields()... End While Before entering the While loop, how can I get how many times this…
DataGridView RowCount vs Rows.Count
Hello, RowCount: Gets or sets the number of rows displayed in the DataGridView Rows.Count: Returns the number of rows What does it mean, when they can have different values? The only condition I can imagine is if a row is invisible, then RowCount does…
Query is too complex.
Hello To delete many selected records at once: In a loop I populate question marks: QuestionMarks = QuestionMarks + "?, " Then: "DELETE FROM table WHERE theID = ? AND fld IN (" + QuestionMarks + ")" And: For Each MyRow As…
How to get specific image coordinates from within bitmap
hi Is there a special (Library/Class) for such an achievement? which can find and return the coordinates by giving a symbol of a specific image from within the larger image
Select from table
Hello Using Access mdb with OleDbRader (Access Database Engine) to select all: "SELECT * FROM tabke WHERE clmn = 'blah'" This might return 100 items, how can I use select to read from number 5 to 50, for example? Possible? Thank you all
.Net problem/Question
I haven't programmed in .Net, last used VB 6 several years ago. I'm trying to make a Windows Form application in VB.Net, and it won't let me use the "Add New Data Source" option to connect my database to the project. When I click "Add New…
How to Joint elements from within the array with specified Step and the array result LINQ
hi Dim ByStep as integer=3 Dim MyArray as Integer()={2,5,4,0,0,4,24,6,5,2,5} need Result As String()={"254","004","2465","25"}
Visual Studio 2022 - VB.Net Desktop application error message hindering functionality
My desktop application developed with Visual Studio 2022 - VB.Net codes, generated an error message that is hindering the functionality of the application. Please see the message below: Severity Code Description Project File Line Suppression…
ToUpper and ToLower first char and first word
Hello, Going to convert the first letter of each word to upper and lower case, to upper is simple, but to lower? System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(---) And to convert the first word of string to upper and lower case, no…
WebClient Timeout
Hello, I used many WebClient : OpenRead, UploadValues, DownloadString, DownloadStringAsync, DownloadFileAsync in my app. Need to set a timeout for each one and found this code, added the Dispose sub myself, needed to check if it's fine to use it? A class…
Structure member name conflict rules
Hello When using Structures: Public Structure Blah Public Name As String Public Home As String End Structure I have 2 strings: Name and Home, does it matter for the variable names inside the Structure to be unique? ie if I have another string…
Rename mdb column
Hello I use Access Database Engine and OleDbReader to work with mdb and accdb files, need to rename a column: "ALTER TABLE xc RENAME Column old new LONG" Searched and found ADE might not support it, what if I add a new column and drop the old…
Create accdb or mdb from code
Hello I can create a new xls or xlsx Excel file with this: "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\x.xls;Extended Properties=""Excel 8.0""" Using ExcelConnection As New OleDbConnection(AboveString) But how to…
How to automatically jump to another cell after hitting enter
Hello All, is there a way to automatically move from the current cell to a specified cell after pressing enter or tab? For example: After entering data in cell H2 and pressing enter, cell H3 is selected. If I press tab, then cell I2 is selected. …
DirectoryInfo GetDirectories Reverse
Hello, Using this code and need to reverse the list returned by GetDirectories: Dim di As New DirectoryInfo(path) Dim di2 As DirectoryInfo() = di.GetDirectories How to reverse di2 list? Thanks :)
Get enum string from integer
Hello I have this enum: Friend Enum Blah As Integer Zero = 0 One = 1 Two = 2 End Enum I will get an integer and need to return the related string. ie will need to convert 1 to One. Select Case InputInteger Case 0 …
How to get the handle of the mouse cursor icon with API (GetCursorInfo)
hi I need a function to put in the timer and check the status of the mouse cursor every 500 milliseconds. Private Declare Function GetCursorInfo Lib "user32" (ByRef pCI As cursorInfo) As Integer Public Structure POINTAPI Dim x…
How to create the Left/Right MouseDown And MouseUp click event of Global type(Anywhere from Windows with API)
hi .Require mouse events via API functions