Search:
Type: Posts; User: kmoorman
Search:
Search took 0.02 seconds.
-
The_Grudge,
If that Select statement with alias needs to follow oracle conventions then an alias with spaces will require double-quotes around it.
Kerry Moorman
-
Psychlotron,
One way to make the comboboxes independent of each other is to assign each combobox a new binding context. For example:
ComboBox1.BindingContext = New BindingContext
Do that for...
-
etac,
You should be able to save the jpg image to a memory stream as a bmp, and then load it from the memory stream:
Dim myJpgImage As Image = Image.FromFile("Abstract3.jpg")
...
-
patricio2626,
If you read the documentation for Remove you will see that it returns a new string with the characters removed. So:
endFileName = endFileName.Remove(slashIndex, 1)
Kerry...
-
Max,
From your message, you know the folder. So you can use Directory.GetFiles and supply a pattern to match the files in the folder.
You will get back an array containing the file names:
...
-
sweizone,
Each item in a combobox bound to a dt.DefaultView is of type DataRowView, so that is exactly what you should expect to get back from SeletedItem.
What is it that you were hoping to...
-
patricio2626,
I don't think you will need a DirectoryInfo object.
Just supply the complete path to your folder as the first argument to Directory.GetFiles, and the filename pattern as the...
-
patricio2626,
You could use Directory.GetFiles to retrieve all the files in a particular folder that match a pattern. For example:
Dim myFiles As String ()
Dim myPattern As String = year +...
-
nabbster,
If framework version 1.1 is definitely available on the target machine, re-writing the app using VB2003 would be much easier than re-writing in VB6.
Kerry Moorman
-
nabbster,
What framework version is available on the targe machine?
Kerry Moorman
-
Wesley008,
You are never executing the Insert command.
After you have added all the parameters and before you close the connection:
Command.ExecuteNonQuery()
Kerry Moorman
-
MrNorth,
Does this do what you need?
Dim myPath As String = Application.StartupPath
myPath = Directory.GetParent(myPath).FullName
myPath =...
-
BCyber,
Your only options are to go back to the lab computer and retrieve the form or create it again from scratch.
In the future you need to be very careful to save all files in the project as...
-
FunkyDexter,
Does this article help you at all?
http://www.codeproject.com/KB/dotnet/targetnet2fromvs2008.aspx
Kerry Moorman
-
DeanMc,
It is not clear to me what you mean when you say that a "control preforms event X" and "triggers group events for certain controls".
Are you just looking for a way to have one handler...
-
ashlewis,
You might want to describe what you are trying to do after each keystroke. You might get suggestions on other ways to accomplish the task.
Kerry Moorman
-
Stogie03,
Well, it says in all your posts: "VB version: Visual Studio 2008-Professional", which is .Net, not VBA.
You might get more appropriate responses in a VBA newsgroup.
Kerry Moorman
-
Stogie03,
You probably already know this, but ADO.Net represents the data access classes used natively in .Net.
The ADO you are using is the "classic" version for pre-.Net solutions.
Kerry...
-
sfaiz,
When you are processing the data in your datareader you are placing values into an object you are referencing with the Me keyword and then adding that object to the arraylist:
...
-
sfaiz,
One option would be to use a criteria similar to this:
where OpeningDateTime >= #9/13/2008# And OpeningDateTime < #9/14/2008#
This should select all rows with a date portion of...
-
sfaiz,
You should supply your criteria values, AuctionStatus and OpeningDateTime, using parameters instead of concatenating them into an sql string.
Also, if the database is keeping the...
-
sfaiz,
One option would be to bind the arraylist to the datagridview:
ReportDGV.DataSource = resultList
Kerry Moorman
-
Kal2219,
Normally, opening a connection to an Access database does not lock the database, since you would usually want your app to be multi-user.
I don't see any settings in your connection...
-
dbassettt74,
You could place the common functionality in an interface and have both controls implement the interface.
Kerry Moorman
-
mrmojorisin,
Your question is not clear to me.
But if you have two parameter placeholders, the "?" characters, then you will need to supply two parameters for the query, even if both...
-
noahssite,
You are describing OCR software, optical character recognition.
You might Google for that term. I think there may be one or more open source ocr projects that you could look at.
...
-
FunkyDexter,
I don't have a solution to your particular problem.
But I will point out that with VS2008 you can target a particular framework. It sounds like your app could target the 20.0...
-
Aspnot,
All the newer versions of SQL Server cache adhoc queries right along side stored procedures. Its not that stored procedures got slower, its that adhoc queries got faster.
Here are a...
-
techgnome,
But my comment about performance pertained to stored procedures, not parameters. Here is my original comment:
"Although there are good reasons to use stored procedures, performance...
-
techgnome,
Assuming you meant stored procedures, not parameters, why do you think that there is a performance reason for using them?
Kerry Moorman
-
Aspnot,
Although there are good reasons to use stored procedures, performance in SQL Server is not one of them.
Kerry Moorman
-
si_the_geek,
Very nice, and definitely the way to go.
Kerry Moorman
-
sfaiz,
Probably the easiest way would be to query the database again, selecting userid where bid equals the max bid you previously retrieved and auction id equals the appropriate value.
Kerry...
-
sfaiz,
Seems like it should be something like:
SELECT MAX(BidAmount) from Bid Where AuctionID='" & AucID & "'
Of course, you should use a parameter for AuctionID instead of building the sql...
-
penno90,
If customerID is an autonumber or identity column then it is not possible for the datatable to generate and display the "actual ID that will be assigned in the database", since that value...
-
RockStarEnergy,
What does your documentation say about the argument to GetUpperBound?
Kerry Moorman
-
Nitesh,
Try:
DateTime.TryParseExact(strETD, "yyyy/MM/dd hh:mm:ss tt", Nothing, Globalization.DateTimeStyles.None, ETD)
Kerry Moorman
-
afshin_tt,
You could wrap those assignment statements in an If statement that checks the row count:
If dsMon.Tables(0).Rows.Count > 0 Then
Kerry Moorman
-
.paul.,
Untested, but maybe something like:
If (x.number = y.number, x.display.CompareTo(y.display), x.number.CompareTo(y.number))
Kerry Moorman
-
TetovaBoy,
What do you mean, "so if some one can help"? Two different responses have given you links to examples that do exactly what you say you want to do.
If you are too much of a beginner...
|
Click Here to Expand Forum to Full Width
|