|
If the lineitemnotes column will be exactly 'Refunded' or 'Added During Recieving' then try this:
If Trim(row("wtnumber")).ToString() & Trim(row("wtcustomername")).ToString() = "" Then
If Trim(row("lineitemnotes")).ToLower() = "refunded" Then
customername = "Refunded"
status = "1"
ElseIf Trim(row("lineitemnotes")).ToLower() = "Added During Receiving" Then
customername = "Stock"
status = "3"
End If
End If
What exactly are you doing with the variables after you set them each time? If you're trying to iterate through a table and set the fields of the rows (customername, status) then you should be putting this code inside a For Each loop and either submitting each row individually or updating at the end via a dataset. This code should work though as far as checking the row's column for a certain value.
Nate Lindley
|
|
|
|
|
The variables are being inserted into a MySQL database. I am using a For Each Loop. Here is the code:
For Each row In dtTable.Rows
If row("WTNumber").ToString() = "" Then
SoNum = vbEmpty
Else
SoNum = row("WTNumber").ToString()
End If
If Trim(row("wtnumber").ToString()) & Trim(row("wtcustomername").ToString()) = "" Then
If Trim(row("lineitemnotes").ToString.Contains("Refunded")) Then
customername = "Refunded"
status = 1
ElseIf Trim(row("lineitemnotes").ToString.Contains("Added During Receiving")) Then
customername = "Stock"
status = 3
Else
customername = "Stock"
status = 3
End If
End If
Next row
|
|
|
|
|
No, the lineitemnotes column will not be exactly 'Refunded' or 'Added During Recieving', it comtains othe data too.
|
|
|
|
|
I was wondering if you can add a custom class to the My.Settings object. I mean I know you can because I did, but the problem I'm having is the class won't persist ie. the data isn't saved. The only requirment (I thought) was that the object needed to be serializable, which mine is. So am I doing something wrong, or is this just not an option. I looked for a while but just couldn't find an answer or an example. Also as a general rule, if there even is one, what kind of data should I save using the my.settings object? Should I just stick with basics like form location and color settings or is it appropriate to store whatever you want as long as you wish to store it in an xml format?
Here is a very simple class I made for testing.
<Serializable()> _
Public Class TestClass
Public Name As String
Public Sub New(ByVal name As String)
Me.Name = name
End Sub
End ClassThis is the code I used to extend My.Settings object.
Namespace My
Partial Friend NotInheritable Class MySettings
Inherits Global.System.Configuration.ApplicationSettingsBase
<Global.System.Configuration.UserScopedSettingAttribute(), _
Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
Global.System.Configuration.DefaultSettingValueAttribute(Nothing)> _
Public Property MyTestClass() As TestClass
Get
Return CType(Me("MyTestClass"), TestClass)
End Get
Set(ByVal value As TestClass)
Me("MyTestClass") = value
End Set
End Property
End Class
End Namespace
|
|
|
|
|
wrote: to anyone who has encounter appforge
If you're asking about something obscure, all the more reason to put it in your subject line, so the subset of CPians who can help, will see it. imagine how useful it would be if all the subject lines were variations on 'help help help'
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Is there a way to put a random letter in a set of labels in vb.net 2005, for example, when i load a program, a different set of letters will show up, only single letters, but different each time???
I want the letters to be from a-z, and be different each time for 10 different labels.
I know you can do random numbers, i wasnt sure about letters, and how they would be stipulated.
Cheers
|
|
|
|
|
just like you doo with numbers... i supose that you need that for joke or some fun...
Private Sub Timer Tick
dim i as integer=random number
GetLatter(i)
End Sub
private sub GetLatter(Byval xInput as integer)
if xInput=0 Then
label1.text="A"
elseif xInput=1 Then
label1.text="B"
End if
End Sub
Hope you understand... :->
|
|
|
|
|
I dont get it!
So your declaring i as an integer, but what is that used for?
Also dont get the get latter bit, how do i loop this through all the letters of the alphabet?
Cheers for the quick response btw, im a bit of a noobie, go easy on me!
|
|
|
|
|
' Create an ArrayList and fill it with ASCII values
Dim salt As New ArrayList
For num As Integer = 65 To 90
salt.Add(num)
Next
Dim rand As New Random()
Dim iPos As Integer = 0
Dim cTemp As Char
While salt.Count > 0
' Get a random position within the ArrayList
' use the Random.Next(min, max)
iPos = CInt(rand.Next(0, salt.Count - 1))
' Retrieve the letter within the ArrayList
' using ArrayList.Item(iPos)
cTemp = Convert.ToChar(CInt(salt.Item(iPos)))
' TODO: cTemp holds your random letter
MsgBox(cTemp.ToString)
' Remove the letter within the ArrayList
' using ArrayList.RemoveAt(iPos)
salt.RemoveAt(iPos)
' Using the above statment will
' decrease the ArrayList.Count
End While
This might be a little easier to under stand. Good luck.
I'm listening but I only speak GEEK.
|
|
|
|
|
now im even more confused!
|
|
|
|
|
Create a random generator:
Dim rnd as New Random()
Get a random character:
Dim c as Char = Convert.ToChar(rnd.Next(65, 91))
Put it in a label:
OneOfMyLabels.Text = c.ToString()
Repeat the last two steps for each label.
---
single minded; short sighted; long gone;
|
|
|
|
|
Yours a star, but:
Do you mean like this:
Dim Chara As Char = Convert.ToChar(rnd.Next(98, 123))
Private Sub frmTestAllRows_Load(ByVal sender As System.Object...
lblLetter1.Text = Chara.ToString()
lblLetter2.Text = Chara.ToString()
lblLetter3.Text = Chara.ToString()
lblLetter4.Text = Chara.ToString()
Cos that makes all the labels the same value!
Also, is there any way to do this for 20labels, without having to write out the statement for linking to the rand for each one
-- modified at 15:20 Tuesday 6th February, 2007
|
|
|
|
|
It's obvious from your answers on this thread that you're pretty new to VB. If you're writing something for some fun, finish this project by all means, but then buy a good book on VB ( the language, not the forms designer ) and work through it.
harveyhanson wrote: lblLetter1.Text = Chara.ToString()
lblLetter2.Text = Chara.ToString()
lblLetter3.Text = Chara.ToString()
lblLetter4.Text = Chara.ToString()
Will obviously make them all the same value.
harveyhanson wrote: Convert.ToChar(rnd.Next(98, 123))
will generate a new random char every time you call it.
You can write code to iterate over the Controls collection and find textboxes and set them. I suspect this is beyond you, and I am not a VB.NET user, so I can't write an example that I can guarentee will work. The other alternative is to write this code for every label on your form, yes.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
harveyhanson wrote: Do you mean like this
No.
I wrote:
Repeat the last two steps for each label.
---
single minded; short sighted; long gone;
|
|
|
|
|
Just create a function that returns a random letter. You should do this.
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
label1.text = RandomLetter()
label2.text = RandomLetter()
'...
End Sub
Dim rnd As New Random
Private Function RandomLetter() As String
Return Chr(rnd.Next(97, 123)).ToString
End Function
Or if you want to dynamically find each label and assign it a random letter use this:
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
RandomizeLabels(Me, "Label*")
End Sub
'---Assigns a random letter to each label who's name matches the given pattern---
Dim rnd As New Random
Private Sub RandomizeLabels(ByVal container As Control, ByVal pattern As String)
For Each ctrl As Control In container.Controls
Dim lbl As Label = TryCast(ctrl, Label)
If lbl IsNot Nothing AndAlso lbl.Name Like pattern Then
lbl.Text = Chr(rnd.Next(97, 123)).ToString
End If
Next
End Sub
The above code assumes the labels are on your form and not in another container like a panel. If they are then instead of passing 'me' you should pass the container control like 'panel1'. Also the pattern can be anything. Just give your labels a consistent name such as lblRandom1, lblRandom2...and use a pattern of "lblRandom*".
-- modified at 17:52 Sunday 18th February, 2007
|
|
|
|
|
Ok, ive sorted this:
Dim c1 As Char = Convert.ToChar(rnd.Next(97, 122)) : lblLetter1.Text = c1.ToString()
Dim c2 As Char = Convert.ToChar(rnd.Next(97, 122)) : lblLetter2.Text = c2.ToString()
Dim c3 As Char = Convert.ToChar(rnd.Next(97, 122)) : lblLetter3.Text = c3.ToString()
Dim c4 As Char = Convert.ToChar(rnd.Next(97, 122)) : lblLetter4.Text = c4.ToString()
Dim c5 As Char = Convert.ToChar(rnd.Next(97, 122)) : lblLetter5.Text = c5.ToString()
Dim c6 As Char = Convert.ToChar(rnd.Next(97, 122)) : lblLetter6.Text = c6.ToString()
Dim c7 As Char = Convert.ToChar(rnd.Next(97, 122)) : lblLetter7.Text = c7.ToString()
Dim c8 As Char = Convert.ToChar(rnd.Next(97, 122)) : lblLetter8.Text = c8.ToString()
Dim c9 As Char = Convert.ToChar(rnd.Next(97, 122)) : lblLetter9.Text = c9.ToString()
Dim c10 As Char = Convert.ToChar(rnd.Next(97, 122)) : lblLetter10.Text = c10.ToString()
Is there anyway to put this in a loop so it doesnt take up so many lines of code, i know im just being pedantic, just thought i would check!
|
|
|
|
|
|
Gotcha! Cheers.
Just final question, can you explain exactly what this line does, is it that if lblLetter is not empy and also has a name similar to lblLetter then...???:
If lblLetter IsNot Nothing AndAlso lblLetter.Name Like pattern Then
|
|
|
|
|
Actually it wasn't necessary to change the variable 'lbl' to lblLetter. What the function does is loops through every control on your form or whatever parent control you passed in. Every control weather it's a button, or textbox, or label inherits from the control class. TryCast attempts to convert the control to a label. If this succeeds then lbl will contain a reference to a label that's on your form. However, if the control is a button or some other control that isn't a label the cast will fail and nothing will be returned. So we need to check to make sure 'lbl' isn't nothing. The function accepts a pattern so you can limit which labels get random letters, otherwise all labels on the form would get a random letter which may not be desirable. So the second part of the if statement checks to see that the name of the label matches a given patter. In your case you've named your labels that get random letters as lblLetter1, lblLetter2 and so on. So you would pass in the pattern lblLetter*. Simply put with that pattern any label with a name that begins with lblLetter will get a random letter. Hope that clears that line up.
|
|
|
|
|
Hi there,
I was wondering if it is possible to alter the display memory and display other things , like i capture the desktop, enlarge it *4 and then display it as the normal desktop woud be displayed
on the screen , no forms no programs just the dektop (the program running behind the scenes capturing the real desktop on a time based event) and the mouse
So i can capture the screen and i'm able to show it in a picturebox , so it like i have the desktop and a form with a part of it.
my question was if it was possible and how
Kind regards
|
|
|
|
|
An article was recently submitted that does this, it's claim to fame is that it doens't use p/invoke. Generally, you'd pinvoke some Windows APIs to capture the screen. Search the articles on the site, there's at least one or two that do this.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
I need some advice:
I have a listview which has check boxes and controls the checked items in a different listview. For example, if ProductA is checked in ListViewA then ListViewB will automatically check the items which relate to ProductA. My question is:
How can I find the appropriate items in ListViewB and set their state to checked?
My second question is:
Is it possible to disable some of the checkboxes in the listview control and leave the other ones enabled so users can check and uncheck them?
Thanks b4 hand,
Yoshimitsu
|
|
|
|
|
Well, how are you getting these items in the first place. From a database? The items in ListViewB would need some sort of way to distinguish them. This way you could filter the names on whatever the item happens to be. For instance Male and Female names might be in ListViewA. When you select Male you need to look at the items in ListViewB and determine if it's a male name. How you do this would be dependent on your situation. So maybe you could describe where this data is coming from and how it's set up.
I don't think it's possible to disable some checkboxes but not all. However, if this is what you want you might be able to fake it. Although, it sounds like only displaying the appropiate items is a more user friendly approach. To prevent an item from changing you could use this code.
Private Sub ListView1_ItemCheck(ByVal sender As Object, ByVal e As System.Windows.Forms.ItemCheckEventArgs) Handles ListView1.ItemCheck
e.NewValue = e.CurrentValue
End Sub
This will prevent all items from changing so in order to use this you'll need to keep track of which items should be allowed to change and prevent just the ones that aren't in that list to change.
|
|
|
|
|
Thanks TwoFaced,
Here is what's happening:
The user enters a name through a textbox for example Breakfast and then selects a bunch of food items from a listview with checkboxes. Then the user can press save and make another record, for example, for lunch and so on. Each customer can have many meals, and each meal has many items. when the user clicks save I push the record into an arraylist and when the user presses finish I send the records from the arraylist to the database and the form closes.
In the parent form there is listview so when user clicks on Breakfast then I have to get all the selected items and find those items in ListViewB and check them accordingly.
I managed to do it by looping through the Arraylist, and comparing each items string to each item's string in ListViewB, if match then I check them.
However, I don't think this a good approach, right?
I hope this makes things clear.
Yoshimitsu
|
|
|
|
|
I think things are a little clearer. I've now got a general picture of your scenerio. For all I know there is a brilliant solution to your overall problem, but I don't have one. However, I'll give you what I've got. You can add items to the listview with a key and then access that item using that key. Now from what I understand you've got food items in listviewB. So the name of the item would be the key. The user selects say 'Breakfast' from ListViewA. You then get the food items the user wants for breakfast and store that in an arraylist. You could then access each item in ListViewB directly by using the items name because you used the name as the key. Hopefully some code will make this clearer. Here is a little example which shows what I'm talking about.
'---Add items with keys---
With ListView1.Items
.Add("Steak", "Steak", "")
.Add("Apple", "Apple", "")
.Add("Rice", "Rice", "")
End With
'---Uncheck previous items---
For i As Integer = ListView1.CheckedItems.Count - 1 To 0 Step -1
ListView1.CheckedItems(i).Checked = False
Next
Dim itemsToSelect As String() = {"Steak", "Rice"}
For Each item As String In itemsToSelect
ListView1.Items(item).Checked = True
Next
One thing I don't understand is why does ListViewB have check boxes and why are you checking the items instead of filling ListViewB with just the items the user had selected for 'Breakfast'? It seems to me this would be a nicer approach but maybe there is more to this that I don't understand yet. Either way the code I posted should give you an idea of how to more directly access each item instead of looping through all the items in the list.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
