Save SQL Results Into A List?
Jan 25, 2011In my database one user can have multiple order. i want to get all orders for a user and save it in a list.[code]...
View 1 Replies
ADVERTISEMENT
Loop To Ping A List Of Ip's Return The Results And Save Them To An Access Db
Aug 6, 2009Sorry for new thread--i have this code, basically a loop to ping a list of ip's return the results and save them to an access db:
[Code]...
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code]...
Generate A List Of Random Integer With A Click Of The Button And Put The Results In A List Box Using .Net?
Nov 18, 2009If I can generate a list of random integer with a click of the button and put the results in a list box using VB.Net but how do I randomly change several integer number generated by button 1 by clicking button 2? How I retain the results of button1 and change the results when clicking button2?I try before but the two button function code cannot relate to one another.
View 1 RepliesSave Results Of Stored Procedure Into Table?
Mar 12, 2009I have a stored procedure, and I want to save the results of the stored procedure into a table. Is there a way I can do this with a simple query without creating the table beforehand.
View 8 RepliesWhen Save results In A SQL Server Table / They Are Incorrect
Mar 10, 2009When subtracting two doubles the result appears to be correct but when I save said results in a SQL Server table they are incorrect. I know their are problems with decimal values in the binary world but isn't there a work around for this?For example 421.2 - 418.9 = 2.3, but the result stored in the SQL Server table is 2.29!In the VB code I used Math.Round to round to two digits and the values appear correct during debugging but, as I've said, in the end they are off by .01. [code] decimal(10,2)BTW, I've tried numerous methods of getting the correct value but have not met with any success. I've used Math.Round on Val1 and Val2 separately, after the subtraction, and on the ResultVal. I've also converted the ResultVal to a string using Format(ResultVal, "#####.00") and then back to a number but still the value that ends up in the SQL Server table is wrong.
View 5 RepliesGet Results To Post To One Row In A List Box?
Nov 20, 2009i am trying to get my results to post to one row in a list box for each one but instead it just keep adding up with a million rows and adding each result properly,
Dim A08count As String
Dim A01count As String
Dim totalA08 As Integer
[Code].....
Place Results Into A List View?
May 22, 2009I can't remember how I make an Access query, so could someone give me some help?
Also, how do I place the results into a List View?
Populating A List Box With Query Results?
Dec 9, 2009I am working on making a Windows based application within Visual Basic 2008 Express that could potentially be used for a music school as a project. This application is connected and bound to a Microsoft Access database. Within this application I have a form for adding a new appointment reservation. This form has a combo box that the user can select the lesson type (eg. "I want a piano lesson"). Upon being changed, a list box would be populated with the names of all instructors that have that selection as either their primary or secondary talent.So, my database is bound, the query is written (correctly...i hope), and I don't know how to 1) select the table column that I want displayed in the list box and 2) actually display the query results within the list box. Is this making sense? Probably not, bu
Private Sub cmbLessonType_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmbLessonType.TextChanged
'populate the lboInstructor box
[code]....
[2008] Number Results In A List Box?
Feb 26, 2009I want to list the results in my list box in a numbering format, something like this:
1: Result #1
2: Result #2
3: Result #3
How do you create this type of format in a list box.
Adding Items To List Results In Duplicates?
Jul 29, 2009I have this code to return a list of fund sources for our organization.
Dim FundSourceList As New List(Of FundSource)
Dim fs As New FundSource
If results.Count > 0 Then[code].....
The problem is that when I loop through the resulting FundSourceList all it shows is the last value. For example, if I have three fund sources (state, federal, athletic), then when I use this code to loop through all I get listed is athletic, athletic, athletic.
For Each FundSource In FundSources
Debug.Print(FundSource.FundDescription)
Next
So I change the code to this. I moved the creation of the fs variable inside the loop.
Dim results = From result In dsResult.Tables(0) Select result
Dim FundSourceList As New List(Of FundSource)
If results.Count > 0 Then[code]....
This works fine but now I'm creating a new class over and over again. It seems a little inefficient to me. Can I not create the class outside the loop and use it over and over again?
Linq Return Results Contaiined In A List?
Mar 23, 2011How can i select using linq from a datatable where the the only results I want back (ID's) are contained in a list of integers?
View 7 RepliesList Results From Command Line In Listbox
Mar 29, 2011I am trying to develop an application and am still learning VB. I have a commandline that will list some applications that I need to make selectable to run certain processes based on what is selected. I have already found the MSDN stuff on using the RedirectStandardOutput class to add to streamwriter. What I need to do is read each line and add to a listbox so that the user can select each application. How to read each line of the stream and add to a listbox.
Here is that code.
' Define the namespaces used by this sample.
Imports System
Imports System.Text
Imports System.IO
Imports System.Diagnostics
[Code] .....
Query SQL Server Table Results Into A List?
Apr 13, 2012I am trying to create a CLR SQL Stored procedure that uses a query and adds the results to a list in VB.NET. Through debugging I determined that my add statement for the reader into the List is somehow converting my data types and throwing an error when I attempt to execute the compiled Stored Procedure.The columns I am querying are Integers
Code:
Imports System
Imports System.Data
[code].....
Search Dataset And Populate List Box With Results?
Jul 28, 2011I do however have a slight background with VBA particularly with MS Access, so I am not completely lost.I am recreating my Access database application in VB.net.I created a new project and added an Access database through the wizard, which automatically created a dataset for the database. On one of my forms I have, esentially, a search form. What I want to happen is have a text box, and as I start typing display a search result from my customers table in the list box under it. So for example, I type "A" and all customer names that start with "A" are displayed in the list box.I continue typing with a "p" (full string is now "Ap"), then all customer names that start with "Ap" are displayed and so on...
I did search on my own first before posting this and found a few tips but cant really get it to work the way I want. This is what I have... I know I would put this code in the keypress event of my test box, but just until I get it working I attached it to a button to search. (I basically got this online and not even sure its the correct usage.
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
'Create a dataview[code].....
The item in red is where i get an error. it sucessfully builds and i open the find form enter a last name that I know is in the customers table, but I get the error "Cannot find Column ["whatever name i typed inthe text box"].So first of all is this the correct way of going about what I want to achieve?If so how can I get it to work?BTW the next step for the user would be to double click the customer in the list box they are searching for to open the customer Details form for that customer, so I would need an ID or Index attached to that item to be able to open that record in another form.
Using Word Interop SaveAs To Save A Text File Results In Errors
Nov 15, 2010My application crashes when trying to save a word document as text. The error at SaveAs is "Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))" I am opening and manipulating a Word 2003 Document (using Word 2007) and then trying to save it as a text file.
[Code]...
Getting Multiple Selections From List Box To Display In The Results Label?
Nov 5, 2009My name is Tim I'm having a problem getting my multiple selections from my list box to display in the results label and there is no examples in the text any how I'm thinking I need to use a loop to get it done. is this evern in the ball park?
Option Explicit On
Option Strict On
Option Infer Off
Public Class MainForm
[code].....
List To IList Polymorphism Attempt Results In InvalidCastException?
Jan 29, 2010In a program I am writing (in VB.NET, 2008), I have 2 classes, "Receipt" and "Group", each with similar properties, both implementing a custom interface entitled "IIDUser". In my program, I have a number of lists of "Receipt" and "Group", declared like:Friend receipts as List(Of Receipt)
I have written a few functions that apply equally to managing both lists of receipts and groups, declared like this one:Friend Function getNextAvailableUserLabel(ByRef theList As IList(Of IIDUser), ByVal startLabel As Short) As Short
Then called like this:getNextAvailableUserLabel(receipts, s)
I did all this in an attempt for interface-based polymorphism, as I thought writing 2 identical functions (except for that one would be for lists of receipts while the other for lists of groups) would be bad practice (and waste time). However, I get an "InvalidCastException" during runtime. It is explained, "Unable to cast object of type 'System.Collections.Generic.List`1[Receipt_Sorter_v2.Receipt]' to
[Code]...
Simple List Of Favorite Sites (save To List)?
Mar 15, 2011I'm trying to get this code to save the list when a new website is added, how do I get a list of collections to save a link that I designate into the list?
Private Sub ToolStripButton8_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ToolStripButton8.Click
ToolStripComboBox2.Items.Add(WebBrowser1.Url)
[code].....
VB 2010 - Assignment - Text File - List All Of The Data From Results.txt In The Listbox
May 4, 2012I'm studying VB 2010 at uni and struggling with this assignment, I'm stressing now with one week to go before its time to hand it in and still not knowing how to do it (even though i've read the whole textbook!)
I have copied the instructions and the files I have been given.
1 List all of the data from Teams.txt in a Listbox. Include suitable headings.
2 List all of the data from Results.txt in the Listbox (use the same Listbox as in 1 above). Include suitable headings. Note that you cannot assume that the file contains only results for the first 3 weeks of the season. Your program should be able to process a results file with more or fewer results.
3 List all of the data from Results.txt in the Listbox. However, in this case the actual team names should be output (your program will need to get this data from Teams.txt. The data should be formatted so that it is aligned correctly. Include suitable headings.
Save CountToNumber In List And Display List To Row?
Feb 1, 2010Say I have a list and it looks like this:
1
2
3
[code].....
Vb Wpf Database Applicationwin - Name Entered By The User From A Textbox And Display Query Results In A List Box
Apr 10, 2009How do you carry out a query from a criteria e.g name entered by the user from a textbox. and then display the query results in a list box..
View 2 RepliesShow The Final Results Instead Of The Results Real-time
Sep 28, 2010I have a form that allows users to select file and then it reads the contents, parses the data and then executes a sql insert statement to add it to a database. What I am having issues with is showing real-time results. Currently, I have the import operation take place on the import form within the OnLoad event. The problem with this is it only shows the final results instead of the results real-time. Is there anyway to do this without creating a seperate thread and delegates?
View 1 RepliesSearch A Listbox And Save All The Results In Another Listbox?
Jan 27, 2012for now, i am using this code but it doesnt give me what i want.. for example i want to list all the items with the string "1"
Dim x, count As Integer
x = ListBox1.Items.Count
count = 0
[Code]....
Add And Save Items To A List?
Feb 10, 2011How can I add and save items to a List of Items in a listbox to an existing Text File in the bin folder? I'm already using IOStreamReader to pull information from the file, but I want the user to be able to add additional items (Name and Last name). Also, I'm having some issues organizing the list in the list box.How can I organize it pro pertly (2 columns)
View 1 RepliesList View Save/Contains?
Sep 30, 2010Okay i need some total help on this list view What it has Columns
What i Need help with
1------Save(From a Textbox1,Textbox2, Droplist.seleteditem.text
2------Contains(If Textbox1.text has a item from Column 2 then it replace Textbox1.text with Column 3)
here is an example with Contains
[Code]...
Save List Of OvalShapes?
Oct 7, 2010I have created a list of my OvalShape on my form and would like to save this information so When I open the Form up I can us an OpenDialog and select what Project to continue editing.Here is my code to create the List:
Friend NoteDotList As New List(Of OvalShape)
Sub build_NoteDotLest()
NoteDotList.Clear()
[code].....
How To Save Array List To My Settings
Oct 5, 2009I have some code in a module:
Public esUsefullitems as new arraylist
That declares my list and I am using a simple structure to store data in but what I was wondering how can I save the arraylist to my.settings without getting a nasty object reference is not set to an instance of an object error, I know this involves using the 'new' method but I have tried many different ways of doing it but I still get that error, how do I do it?
Listbox Don't Save Whole List In Tray?
Jun 10, 2012i'm trying to make a clipboard saver, which i code in a tray application. The problem is when i'm going to tray, the list only saves the last copied item. How do i get this list to save when in tray?
My code is:
Option Explicit On
Public Class PopupForm
Private Sub PopupForm_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load[code].....
Save The List To A Text File?
Feb 17, 2009I almost have this one complete but after trying a few things (which includes some one giving me their source so i can see how they did it, but it didn't work) I still have no joy.When the duplicate free list is in Listbox2 i want to save the list to a txt file but i want the user to be able to choose where they want to save it kind of like this
Private Sub Button4_Click_2(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
[Code]...
Save A Huge List Of Inventory Items?
Aug 31, 2009I am programing a basic P.O.S. (Point of Sale) system, ad am looking for the best way to save Inventory objects. The object contains a few Singles and Strings (Such as barcode, name, price...ect). Assuming the user could possibly input thousands of such items, what is the best way to store and handle these?
My first, and simplest thought, is to add each inventory Item to an ArrayList, then once the user saves, or closes, the ArrayList prints each object to a text file, then when the program opens it reads the text file to re-populate the Array list. However, this seems very un-efficient (I assume). Would it be better to use an excell file or a Database (I know almost nothing about databases, but I can learn), or something completely different?