Search:
Type: Posts; User: dminder
Search:
Search took 0.24 seconds.
-
You should be using parameters for your where clause. Setup an array with 2 elements, the first one is your filter column, the second one your filter value.
You setup a loop to go through the array...
-
You should actually use parameters in all of your queries.
MyCommand.Parameters.Add("@ParameterName", OLEDBTYpe).Value = MyValue
This stops you from having to remember all the syntax and...
-
Easier than a loop:
ListBox2.Items.AddRange(ListBox1.Items)
HTH :wave:
D
-
If there are no items at all in your listbox then you will get an out of range exception error. Your code should include:
If ListBox1.Items.Count > 0 AndAlso ListBox1.SelectedItems.Count > 0...
-
What is the first control in your Child Form that has its TabStop set to True? This would be the control with the lowest Tabindex number (that is not a label).
Second, what else is in your code...
-
Ok, where to begin. First - your image did not load. Second, you will have to query the database to find the information you are looking for:
Dim ds As New DataSet
Using cmd As New...
-
This should hopefully help you to understand a little more about the differences and when to use each one. I personally rarely use datareader, only because I often need to filter, sort and redisplay...
-
Wrap your Code in a Try...Catch Block. Add a Finally statement and then you can use one of the two options below:
Try
'Add your code in here
Catch ex As Exception...
-
It is absolutely my application, but is also is able to open various file types like XML, txt, XLS/xlsx, ect and I should be able to lock them from users even if they copy them to a datakey, another...
-
Hello again all. I am trying to figure out a way to implement password protection on documents that a program I am working on creates. They should remain with the document regardless of where it is...
-
I do not think this is your typical web browser question, so here goes....
I am trying to make a form that has 2 browsers in it. I want them both to be able to login to a site....say for example...
-
AHA!! got it!! Thank you so much!! You earned your creds today.
Oh and as for VB, I never stop using it. But looking at the jobs that pay something decent, need to be more "Agile". :p
D
-
Yeah i realized i was in the VB forum (old habits die hard) after I hit submit. That is why I put the edit on there.
I am not sure that I am following you there, where in the properties window do...
-
I am learning c# (finally) and am using VC# 2010 Express. Why do I have to manually declare events for them to trigger?? I have created my own form that I want to use as a Splash screen (see code...
-
You can use a select statement on the keycode to handle whatever keys are being pressed:
Select Case e.KeyCode
Case Keys.A To Keys.Z
Case Keys.Enter
Case Else
End Select
HTH!! ...
-
If you keep your statements simple you could 'technically' do this:
If Single.TryParse(TextBox1.Text.Trim & " " & ComboBox1.Text.Trim & " " & Textbox2.Text.Trim, 0.0) = True Then
...
-
What does the debugger show for "ds.Tables(0).Rows(1).Item(0)"? You can try adding a .ToString() at the end of your ds.Tables(0).Rows(1).Item(0) and see if that works.
The error is the key to the...
-
I am working on a project where I need to open microsoft word documents in a form with a panel (the document will be put into a panel). I have been working on this all week and am not having any...
-
Just to correct myself from above, I really botched up my code above. I have created 2 different methods to do this. They are not as involved as some of the other posts, but they are effective for...
-
I am going to guess and say that this is homework. Unless you are specifically told to loop through the string, you can use the following:
Private Sub test()
Dim Input As String =...
-
There is no specific variable to give you the folder path. You have to get it from the filename itself (which includes the full path):
Private Sub test()
Using OpenFileDialog1 As...
-
I have been looking into getting a new laptop for development cuz mine is pretty old and needs to be retired. I started looking around and saw a tablet comparison that showed some of these tablets...
-
That statement is so very inaccurate. You are programming in a .Net language and for best results, not to mention more functionality you should be using ADO.Net with DataTables, DataSets,...
-
If you are seeing the time portion of a date object then you have to have formatted it somewhere along the line....I have put/adjusted your code and have it returning a date in the format of...
-
Put the code that is in the Form Load into its own Sub or Function then when the form loads or you want to refresh it, you simply call that sub/Function.
HTH and Good Luck!! :wave:
D
-
Glad to be of help! :bigyello:
Remember to click on the scales by my name and rate my post!!
Thanks again and good luck!!
D
-
After looking back over the code, I noticed that I REALLY messed up on it. Here is a revised version that works - with checkboxes anyways!!
Private trigger As Boolean = True
Private...
-
Well we will still have to deal with where the tax amounts are stored. However, I can get you started with adding a class and getting the procedure setup. In your project go up to the top menu...
-
This will kill EVERY excel process running, even those that you did not start....
Private Sub KillExcel()
For Each p As Process In Process.GetProcesses
If p.ProcessName...
-
Well, from my perspective you have one of several options:
Database - wherever you are storing the data.
Specialized list collection in project settings.
xml file or flat file
I would say...
-
What tech is referring to is that you can declare the parameter another way:
.Parameters.Add(New SqlParameter("@RetMessage", SqlDbType.VarChar, 100, ParameterDirection.Output, False, 0, 0,...
-
Here is my go at it, I have used this type of loop before and it has worked very well for me (well enough that I include a more enhanced variation of it with my base dll in all projects):
...
-
tech's probably gonna shake his head at me, but I am going to expand a little on his post....it took me a while to get this concept from both sql and vb side.
In your Stored Procedure where you...
-
I tend to agree with jm, as he is the resident expert. However, if you do NOT want to go that route then instead of using Consts, use Read Only Properties. This would give you as the coder the...
-
I sent you a PM.
Thanks,
D
-
That is a rather vague statement. If you would, please post the actual code that you have right now and what you are expecting to be the output. That would give us a better idea of what you are...
-
Ayep, that is what it was. Even after all these years that kind of rookie mistake just messes up my day..... :blush:
Ahhh well thanks again guys!
D
-
This usually works: Textbox1.Text += "?"
D
-
Field type is Date/Time.
The procedure that generates the query string and calls the execute:
''' <summary>Removes specified customer from active status.</summary>
''' <param...
-
Hey guys and gals, it has been awhile. I have run into an issue using an OLEDB Parameter and am not sure how or why it is doing it. I have the following property setup in my program:
'''...
|
Click Here to Expand Forum to Full Width
|