I'm going to crazy: I tried this code it works well with me
Code:" Delete From TBinMaterial where inMaterial = '" & TextBox1.Text & "'"I tried this code too. It works well with me Code:"INSERT INTO TBinMaterial(inMaterial)" & "values ('" & ListBox1.Text & "') "But this code it doesn't work Code:" Delete From TBinMaterial where inMaterial = '" & ListBox1.Text & "'"and this code too doesn't work Code: " Delete From TBinMaterial where inMaterial = Last(inMaterial )
I have a list box that allows multiple values to be selected.Here is my query for my gridview
[Code]...
then before the query is run i use to subtract the final , so i dont get an error and i have to use textbox1.text in my query and not the parameter. that is slower and sql injection,
i'm doing a desktop application using VS2005 with MSSQL 2005. i have a problem with the where clause in the update statement while selecting the listbox item. this is the code for the listbox in load page:
[Code]....
and this is my update query in the delete button event handler: mySQL = "update Appointment set recordStatus = 'deleted'" how do i put in the where clause in when i have 4 columns in the listbox? so can i do this with listbox or have to do with datagridview?
To do is stop the last line, begvalue = begvalue - depreciation, from showing up in the listbox. I tried an if statement but that doesn't work
Depreciation to a Salvage Value of 0. For tax purposes an item may be depreciated over a period of several years, n. With the straight-line method of depreciation, each year the item depreciates by 1/nth of its original value. With the double-declining-balance method of depreciation, each year the item depreciates by 2/nths of its value at the beginning of that year. (In the last year, it is depreciated by its value at the beginning of the year.) Write a program that performs the following tasks:
Requests a description of the item, the year of purchase, the cost of the item, the number of years to be depreciated (estimated life), and the method of depreciation. The method of depreciation should be chosen by clicking one of two buttons. Displays a depreciation schedule for the item similar to the schedule shown in Figure 6.23. Figure 6.23. Depreciation schedule for Programming Project 7. [URL]
This is the code I have so far:
Dim yearpurchased, cost, life, depreciation, begvalue, total As Double
Dim item As String
[CODE].........................
I need to get the last two numbers on the bottom right of the table.
I was convinced that If <expression> Then <statement [:statement]> Else [statements] in concrete form of If a = b Then SayHello() Else SayBye() End has sense. I read article on msdn on If-then-else, but I forgot why I was reading, so I concluded, that snippet above means this
If a = b Then HelloIsSaid : IsNotEnded Else ByeIsSaid : IsEnded But I have tested it now, and I see, that Else without statement is nothing more than decoration. It would be pretty good if it had function I described. Do you think its good request? Or do you know any circumstance where this Else has some function?
I want to put it (the select count statement) in this LINQ statement so I can get the sales count in my linq statement: Dim TheLeads = (From L In DB.Leads Where L.IsDeleted = False Select L).ToList() Is this possible to do in LINQ?
If I set a ListBox.Height = ListBox.PreferredHeight when the control is hidden and IntegralHeight = True, then set it visible:
a) Actual Height reduces by typically 3-5 pixels after redraw (but not 1 pixel per item).
b) PreferredHeight does not not appear to give the correct integral of item heights.
Is there a way to make ListBox calculate the correct integral Height before the ListBox is made visible, so it can be correctly pre-positioned from bottom edge?
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
add an if statement and an exit statement to my do loop that exits when my future value (FV) is greater than 1000, then to change the exit statement to a continue statement so my loop will continue even though my fv is greater then 1000, point is to get this to run even though my if statement doesnt do anything. problem something wrong in my code and an exception error (xception of type 'System.OverflowException' occurred in mscorlib.dll)
so can someone show me where or why I have an error is, what am I overthinking now! I could use a hint, OMG i could use a tutor for that matter
I'm writing something that will examine a function and rewrite that function in another language so basically if inside my function F1, i have this line of code var x=a.b(1) how do i break up the function body into symbols or "tokens"?I've searched around and thought that stuff in System.Reflection.MethodInfo.GetMethodBody would do the trick however that class doesn't seem to be able to have the capabilities to do what i want..dit 2:basically what I'm trying to do is to write a program in c#/vb and when i hit F5 a serializer function will (use reflection and) take the entire program (all the classes in that program) and serialize it into a single javascript file. of course javascript doesn't have the .net library so basically the C#/VB program will limit its use of classes to the .js library (which is a library written in c#/vb emulating the framework of javascript objects)
how to use them then before, but am still a little confused with a few aspects. Here goes:
1.) Lets say you have a method that checks for a certain condition(s) and if it fails Throws an exception. Does it have to be in a try/catch block? Meaning can the "Throw" statement exist in a block with no try/catch statement?
2.) Now lets say we have a method that has a try catch block and in it there is a throw statement. When the throw statement is executed does it first try to find an appropriate catch block in the same method or does it immediately go back to the calling method without looking at the catch statements in the current method where the exception was thrown?
3.) I created a custom exception class that inherits from ApplicationException. Next I created a method which has a catch block that catches this type of exception and does some action. Is the System(i.e CLR) smart enough to throw an exception of this type, or does it only throw exceptions from SystemException?
4.) I know that some people are more liberal in their use of exceptions and others use it more sparingly when truly strange stuff happen like the DB going down. I am writing code where I am getting some info back from the database, converting it and then storing it. Sometimes there might be data that comes back from the database and other times the field is empty and the Null value comes back. Therefore in the instances where Null comes back from the database I should not convert the value to anything, since I will get an error. What should I do in this situation? Should I let the CLR throw the exception when it goes to convert the Null value or should I check for the Null value and if it exists not convert?
5.) In general when I throw exceptions, is it sensible to only throw exceptions of the type Application Exception or are there instances where the programmer throws exceptions of the type SystemException?
I'm building a listview search feature in my app. (See the code below). It works really well, except if you search "T" then the code removes all items, if you search "t" then it removes every item except for those starting with "t". Is there any way to make a 'like' statement, or use some kind of wildcard to make the statement not case sensitive?
For Each itm As ListViewItem In ListView2.Items If itm.Text Like TextBox1.Text & "*" Or itm.SubItems.Item(1).Text Like TextBox1.Text & "*" Then Else
I have a line of code that is working in one statement but not the second statement. I'm not sure what I'm doing wrong, I am learning slowly but surely, and it is by no small margin because of the ave found here =) The error is occuring in the intResult = intSelection x intCount line of the SECOND Do While Loop.
The blue squiggle line is under "intCount" just FYI Dim intSelection As Integer Dim intCount As Integer = 0
I am using VB.NET (version 2008). I have two types of items populating in a listbox (checked listbox). For example: lets say one is type "A" and other is "Type B". Their names maybe same so if the user sees those items in listbox then he won;t be able to determine their type until he click on them and checks out its properties. I wanted that I add each item to listbox and colour them so that blue for example means type "A" is there and red means the other. So this way I will be able to know at a glance that how many item of what type is present. I guess it may not be possible to do that in a standard checkedlistbox. I am also using component factory's krypton controls which enhance the gui of an application. But I dunno if I can progress using that.
I have the following vb code which works as expected when it's in a code-behind page. I tried to move it to a shared or component page since I will need to use it in multiple pages:
Imports Microsoft.VisualBasic
Public Class DetTime 'Determine eastern time
[CODE]...
However the "if" statement shows an error " statement cannot appear outside of a method body" and the Microsoft solution is to "move statement into a procedure or subroutine"
The scrollbar that comes with the ListBox is too small for touch screens, so I use my own scrollbar instead. But when you do this on various forms you end up repeating a lot of code. So my solution was to create a custom scollbar that has a property I can set to the control I want it to be a scrollbar for. In vb6, I can use the withevents keyword to get access to the control's events so that all the scrollbar related code can be in the custom scrollbar object I created, except...I had to create a refresh method for the consuming code to use to let the scrollbar know when the number of items changes. The scrollbar doesn't need to be told how many items there are because it has access to the control, but for a listbox there is no event to tie into when an item is added/removed so not 100% of the scrollbar related code could be encapsulated.
Is it possible to select an item in one listbox and then display the data of another listbox with the same indexed position? I am planning a project and this is something I would like to attempt but I haven't figured out how to do it.[code..]
I tried doing the above code but instead of displaying the listbox text the message box just returned false.
I am using Visual Basic 2008 Express Edition and I am trying to set a listbox so it starts to scroll when it hits the middle point of what is viewable on my list. I also want to set it so the list is always visible so you when you reach the bottom of the list you can scroll down to the bottom but if you scroll back up once it reaches that middle point it will start to scroll up again.
problem that i am facing is i want to add array of object as a single item in listbox. in vb6 i was using this Label1.Caption = Label1.Caption & Mid$ (strInput, intI, 1) & " " List1.AddItem (Label1.Caption) i was using label. caption to store object but not work in vs2008 because label.text only take text and left other values
what it does iswhen a user checks an item in the checked list box it transfer it to a listboxso i have a checked list box and a listboxi am planning to put another listboxwhat i would like to be able to do is thatwhen the user checks an item on the checked list box it will transfer the item into the listbox [like the one on my previous thread]and be able to show an messagebox with a textbox [ i read its called an input box ] or another form with a textbox and/or combo box will pop up
I am starting to learn reading and writing to textfiles. One quick problem. My code here
'Read is the variable that will read the kp.txt file" Dim read As IO.StreamReader read = IO.File.OpenText("C:2/kp.txt"[code].....
however when it is read into the listbox those 3 words appear on one line in listbox How can i make it so that each line of the textfile is placed in each line on the listbox?
I am having problems with copying from one listbox to another and keeping the paths of the files in the listbox's. At the moment i have two listbox's, listbox1 shows the list of files without the directory paths showing. Listbox2 is used to add items from listbox1 which work ok but what i need is to be able to preserve the directory paths to each file. how to do this and have searched high and low for a solution without any luck.
I have worked out one way of doing it but i think there is a better way of doing it as the reverse does not seem to work. So basicly i want listbox1 to list the files without the paths and pass it on to listbox2 so that the files can be copied to temp directory as they are being add to listbox2.
Below is my
[CODE]...................
Routine to add items from listbox1 to listbox2: I have created another listbox3 (which is in bold), which is hidded under listbox1 and holds all the paths to the files and is use to copy the files from there original directory to a new directory.
[CODE]...................
Routine to add items back to listbox1 and remove them from listbox2. I have created another listbox4 which is hidden under listbox2 which i was trying add the paths from listbox3.
I have a question here.. pls kindly advise.I need to design a simple form that allow user to choose the value from Listbox A to Listbox B. For example, in Listbox A, have value A, value B and value C, then user can choose (or highlight value B and value C) and copy into the listbox B.
May i know how can i do this in vb.net? Any reference link?
