I am trying to get the last entry from my database based off the date entered. The sql is not working exactly as I want it. Here is my sql SELECT TOP 1 * FROM BILLS_HITS ORDER BY DATETIMEADD DESC.Can anyone see anything wrong with it? The sql returns a record with the date - "6/6/2012 7:10:11 AM" and not one that is for 6/10/2012.
View 1 Repliesthe disply color buttons click even procedure shold display the color of the item whose item number is entered. all item numbers contail eactly five characters(12b12). my problem is i can not get it to disply a color in the lblcolor control. it displays the item number.
[Code]...
the project here is to take the three amounts from three text boxes entered by the user and return a string in a label telling the user if the triangle is either a right triangle, equilateral triangle, or neither after clicking a button. The code I have must use a new Class named Triangle. No matter what is entered in the text boxes, the label always returns "You created a right triangle!"
[Code]...
I hope this question is sufficiently clear I'm trying to port an application that I wrote in Access VBA to VB 2010 express and SQL Server. In Access, when the user enters an item in a combobox that is not in the item list an event is fired ("not in list") from which I can set up records in related tables. How can I do the same in VB? I can't see any equivalent to the "not in list" event.
To be more explicit with an example. An address consists of Street, e.g. "23 Acacia Drive", Town, e.g."Wilton" and County, e.g. "Oxfordshire". When entering a new address, the form first requires a street entry in a text box. Next, a Town entry in a combo box which is populated with towns already in the address table. If an existing Town is selected the (previously disabled) County field is automatically filled from that town's County as read from the database. If a new Town is entered the County field is enabled and the user either selects an existing County or adds a new one which is added to the database using similar logic on the not in list event.
[Code]...
Here is my code as I have it
Code:
Public Class Form1
Dim OpePro(7) As String
[code].....
How do I return the Name of each item in my Imagelist?for example i need something like below
for i = 0 to ImageList1.items.count
MsgBox(ImageList.items(i).Name
Next
I wish to get the Text of item where I know its index! most of the codes I have founds Return the index number not the text it self!
View 5 RepliesI want to return a value of a ListBox item, NOT the index number.
My attempt: Dim pInt1 As Integer = ListBox2.Items.Item(0)
i want this code to return the ListBox item's integer value, and not the index number itself how can i return a ListBox item's value?
Given a simple DTO (AccountExpiry) with properties of 'AccountNo' and 'ExpiryDate' and a List of same created thus:
New AccountExpiry(123, New Date(2012, 4, 1))
New AccountExpiry(123, New Date(2012, 4, 2))
New AccountExpiry(123, New Date(2012, 4, 3))
New AccountExpiry(124, New Date(2012, 4, 2))
New AccountExpiry(124, New Date(2012, 4, 3))
New AccountExpiry(124, New Date(2012, 4, 4))
How do I use LINQ to retrieve the most recent entry per account. I have a feeling this will involve GroupBy and FirstOrDefault. It seems like...
From Item In Source Group By Item.AccountNo Into Group
Should return all of the data grouped appropriately, but It is unclear how I might apply .FirstOrDefault to each group.
In my code I have to create a listbox and a form as its container. After adding a few items through code I am not able to make code return a Selected Item when I select the item manually; it always returns the las item added. However ther is no such problem with returning the Selected Index.
View 8 Repliesi want to search item A (from a list of X items) in list B but i want to get the item not found example Search ITEM A in LIST B if not found then return a print....if found continue with ITEM B..and so on.
View 11 RepliesI am doing this within a thread:For Each item As ListViewItem In lvUsers.Items and I am getting: Cross-thread operation not valid: Control 'lvUsers' accessed from a thread other than the thread it was created on.I have been able to adjust a control in a way using something like:
Public Delegate Sub ListAddNameInvoker(ByVal text As String)
Public Sub ListAddName(ByVal text As String)
If lvUsers.InvokeRequired Then
[code]....
But how do I get data from a control and pass it to another thread?
If cmOptions.Visible Then
Return
End If
I have a refreshing process that updates a listview every ten seconds. If the context menu is open for a selected item it should return and not refresh?
Regarding my college project. i'm working on a sales system . i have a form which consist of all the following information( item code , item name , item price , quantity of item ) which is display using a data grid . data input by user using text box and all this information will be stored in a database(sales database) i'm using ms access 2007. the grand total will be displayed in a text box . and amount paid will be input in a text box too , my major problem now is how to i create a reciept that will have all this information of the purcase. i have a reciept button . what the next step ? i dont have any idea how to get the reciept done.
Imports System.Data.OleDb
Public Class Form5
Dim con As New OleDbConnection
[CODE].......................
I am creating a Calender application using the monthly calender control.I am trying to implement a search for the calendar so a date can be entered into a text box which intern moves the calender to show the date entered. I have been try to figure this out with no luck, is it even possible to do?
View 2 RepliesI have a list box on the form which functions as a copy/paste. When you copy something, it is automatically added to the list box as a "clipboard helper". Here is the problem,however: if the text is more than 1 line, the list box does not show all the text.It ends up looking messy.So getting back to my question, is it possible to make the list box item height for an item depending on the amount of lines that item contains?This is a one line sentence in the list box and should take up one line.This is a multi line sentence in the list box and should take up two lines for item height.
View 11 RepliesIn my application I have a listbox and SelectionMode should be MultiSimple because users need to see which items they selected. In another tab we have another listbox this one should show all the selection users had done in first tab. Private Sub
[Code]....
I use this code to return records in a DataGridView:
[Code]....
I'm working up a system where I plan on using RealProxy objects to enable intercepting method calls against a set of objects, handling the call, and then returning appropriate results. This works just find for simple return types like strings or ints, but I can't seem to return objects from the RealProxy.Invoke method. Everything works. I get no errors, but the returned value is always NOTHING, instead of an object.
I've worked up the smallest sample code I could, and have included it below. Essentially, just call RPtest and single step through. The code creates a simple object, RPTestA, with a string field and an object valued field It then retrieves the string
[Code]...
Is it possible to compare 2 dataitems and then display the result depending on the 2 values using if eval at run time?I have a ListView with databound controls. 1 is RedemptionChoice and the 2 is CashBack.When 1 reads "0" and 2 reads > 0.00 the output should read AUTO I have read many comments online and most point to create a new function within code behind but have found it impossible to implement on my own.I tried this as a test on the actual page:
<%# If(Eval("CashBackRedemptionChoice").Equals("0") & Eval("[CashBack]").Equals("0.00"), "Auto Cashback"))%>
2 needs to be greater than 0.00 for AUTO to be displayed. Hence I know this would not work. Just trying to give an example of what I would like.
I'm making a Visual Basic GUI application to display whether a number of my ports are open for people to know whether things like my website and my Minecraft server are open.My problem is I have absolutely no idea how to do this in Visual Basic.Basically, I'm asking for something which sends a signal to an IP with a specific port, if it is open then return true, if it's closed, return false. Similar to: http:[url]....
View 1 RepliesI'm having some difficulty with a sorted & grouped listbox in WPF vb.net 3.5 that has an items source bound to an ObservableCollection.
What I want to be able to do is to retrieve a piece of data from the ObservableCollection items source depending on what item in the listbox the user has selected.I've almost got it working but because the listbox is sorted it does not match the index of the items source.
[code]...
As I previously mentioned, because the lstBox is sorted and also grouped the index's don't match up.Does anyone know how I can get the correct information I want from the List Source depending on the selected item in the list box?
I have used the command:
For Each Proc as process in process.getprocesses
Combobox1.Items.Add(Proc.MainWindowTitle)
to populate a combo box with the list of current process windows, however for every process that doesnt have a main window title there is a blank space, is there a way that I could tell it to not insert the item if it's mainwindowtitle field is blank?
How someone would select an item from a list box and click a button and have that item go into another listbox with it's price? I seem to be stuck on this part.
Here's my code:
I want to select the first option from the first listbox and I want to put it into another listbox along with the price of that item on the same line in the listbox. I can't seem to figure out how to that.
Public Class Form1
Const dcmPRICE_STRESS As Decimal = CDec(595.0)
Const dcmPRICE_TIME_MANAGMENT As Decimal = 695
[CODE]...
i want to make program like this:
if DataGridView1.item(SID).value = DataGridView2.item(SID).value then
color=green
else
color=red
i want all item list in DataGridView2.item(SID).value will be checked.
this is my
Private Sub PSCDataGridView_CellFormatting(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellFormattingEventArgs) Handles PSCDataGridView.CellFormatting
Dim myBL As String
[code]....
I've been trying to feed a multi line textbox into a string array then check item by item if a string contains part of it.
[Code]...
So i've to write this program whose purpose it this:
Purpose: The user enters the item name and amount of the item purchased. The program calculates the tax for the item and the final total, and then displays these values. Tax on all items will be 7.75%.
And so far i've this code but it's not working:
' Program: Cash Register
' Author: Nidhi Shah
' Date: February 2, 2010
' Purpose: The Cash Register Window application will
' computer the tax and the final cost of a
' purchased item.
Option Strict On
Public Class frmCashRegister
' Tax per item - used in multiple procedures
Const _cdecTaxPerItem As Decimal = 0.0775D
[CODE]...
Just started on vb.net
I have a combo box with "yes" and "no" with i select Yes i want the label2 to change the text to "yes" likewise with "no"
I've tried to code it in a logical way as possible but it just doesn't works except for the "wtf" so i think that overall my code is correct but the way i want to retrieve the selected item from combo box is wrong.
Public Class Form1
Dim aa As String
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
[Code].....
Ok, so I have a listview on one form, and when a button is pressed it opens up a new form with the contents of the selected listview item and it's subitems in a series of textboxes. The user can then change the data in the textboxes and either press save to make the changes or cancel to close the window. What command would I use to change the selected listview item and subitems to whatever is in the boxes?
this is the code that populates the boxes:
Private Sub Form_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim appeditcontents As String = main.passlist.SelectedItems(0).ToString
[Code]....
i have a combobox containing countries name and their codes like INDIA:CNT001 then i have a textbox that store the code of country i.e CNT001(fetching from database) Now i want to match that code with the combobox code so that the combobox is set to that item when i click a button. i m using vb.net and sql server as database.
View 5 Replies