Searching A Database And Returning Results In A VB Form
Mar 30, 2009
I have a problem which I have tried to solve in several ways, and by searching the Internet for various terms, searching through books and Visual Basic instructional videos, but none have yielded the correct results. My goal is as follows:
1. Create a Database listing job names, job numbers, and a link to the file about the job.
2. Create a form with 2 text boxes, a search button, a box to display results, and a preview panel.
The two above steps have been completed. The following is where I get stuck
3. I want to search for either the job name, and/or the job number, have VB search through the database and return the results in the results box.
4. On clicking on one of the results in the result box, the preview panel will show a preview of the file.
Notes:
i) The files being linked top are Microsoft Excel files.
ii) The box I have used for the results currently is a listbox, though I've no idea if this is the correct choice for what I want to do.
iii) The database I created is an *.xml database created in Visual Basic. I am a fair beginner to VB, learning as I go, but I'm stumped as to how to achieve this so any pointers on how to achieve points 3 or 4
View 2 Replies
ADVERTISEMENT
Nov 25, 2011
I have been taking a class in Visual Basic and am currently working on my final project which I am having some trouble with. I am using Visual Basic 2010 express The project is to create an application that will store data in a text file, specifically, Last Name, First Name, Customer Number, Address, City, State, ZIP Code, Telephone Number, Account Balance, and Date of Last Payment. I have gotten everything done except the ability to search the file by Last Name or Customer Number. I have no idea how to go about this? I was thinking of ways to use indexof or Readline to be able to search the data, but I'm not familiar enough with the code to come up with a good solution. Below is a picture of how my form looks..As you can see, I'm currently using 2 separate forms to get the data from the user. Here is the code for Form1 which is the "Customer Accounts" form in the picture.
Imports System.IO
Public Class Form1
Public customerFile As StreamWriter ' Object variable
Public customerFile1 As StreamReader ' Object variable
Public strFile As String
[Code]...
There isn't enough room to post the code for my secondary form, but you get the idea. I would like to be able to enter a search term in the textbox on the bottom right of the form, and either search the data as its displayed in the listbox, or search the actual file? I was thinking that the results would be displayed in a messagebox?
View 3 Replies
Apr 16, 2009
[Code]...
I need to happen is for whatever is typed in the txtStockBookID text box to be searched in the 'BookID' field in the database (dbStratagem) and for all relevant records to be produced in the datagrid (grdStockResult). The code used above has so far safely connected and displayed the entire table (dbStock) in the datagrid but I am not able to restrict the results to only criteria searched.
View 2 Replies
Jun 20, 2011
On a image file (PDF), the OCR has recognised the picture and text. However on Visual Basics, how do you search for a text on this image file? The primary goal is to allow a text search (i.e POxxxxx) on all the image files (PDFs). The returns of the search will be the assciated image files where the text (i.e POxxxxx) is found on.
View 1 Replies
Jul 13, 2011
I am building an application in VB.net and trying to get detail information from the database from de persons name that I write in a textbox, i've the following code (i get an eeror, can not find column "the name i give in the textbox").
in the load of the form :
mijnKlant.KlantVullen()
dgvKlanten.DataSource = mijnKlant.p_klant
With Me.dgvKlanten
[code]....
View 1 Replies
Mar 5, 2011
I have a query using LINQ-to-SQL. It queries an underlying database table Rooms. It uses Where conditions to narrow down the results, namely:
Gender.Current Occupancy < Max Occupancy Available Flag is Checked I know this should return results but it keeps returning an empty set.Code is below
[code]...
UPDATE: I've verified that the issue is with the statement where sh.is_available = 1, which doesn't make sense since this is a bit field.
View 3 Replies
Nov 17, 2010
We are noticing this occurs BOTH in javascript and in VB.net 2.0. So basically both in server side and client side code. Basically if you run this equation 975328 - 153279.43 you get the following answer 822048.57000000007. However, if you run 975328 - 153279.4, 975328 - 153279.433, or 975328 - 153279.5 everything is returned correctly. WHY the system calcuates the 975328 - 153279.43 with an answer with 11 decimal places? Not to mention adding the 7 in the 11th decimal place, thus making the equation answer incorrect.Of course I know I can trim, set the answer to appropiate decimal places, etc., etc.the above is proven by just entering the equation into the immidiate window, thus ellimnating varibables such as object types, etc., etc.
View 3 Replies
Jul 20, 2011
I'm doing some XLINQ in VB for work. I basically need to pull some values from a small chunk of XML as listed here:
<?xml version="1.0" encoding="utf-8"?>
<Fields>
<typeQtyRadioButtonList>1</typeQtyRadioButtonList>
<cmbQtyCheck>Reject</cmbQtyCheck>
[code]....
... Leaving out the implementation of the For Each loop....So I have stuck a break point on the for each and the collection has no elements in it.
View 1 Replies
Mar 3, 2010
So, I'm not really sure if I have this setup properly or not. This is my first attempt at utilizing LINQ and I am trying to return data directly from an XML file.Here is my XML structure:
<folder_list>
<folder lbl="_localhost" abs="C:\_localhostapache2triadhtdocs" unc="C:\_localhostapache2triadhtdocs" tag="default" />
<folder lbl="Programming" abs="D:\_prog" unc="D:\_prog" tag="default" />
<folder lbl="Anime" abs="D:Anime" unc="D:Anime" tag="default" />
[Code]...
View 9 Replies
Apr 27, 2011
I am developing a Point of Sale application and I have a form for the selling interface where i would like the user to enter an Item code (stock code) and based on the entry search for the record in the database. After Searching i would like the data of Item Code, Item Description and Unit price displayed on the form using textbox control.
(I am using Visual Studio 2010 - Express Edition)
I have tried using the following code but its not working
Private Sub txtItemCode_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtItemCode.TextChanged
Dim db As DataRow
[Code]....
View 7 Replies
Jul 12, 2011
My app is a Bible Reader. At load up I can choose Genesis Ch1 and its entirety pops into a rtb. I enter a word to search for like 'God' and hit the SEARCH button. The results I get are initially what I want. I get the verse 1:1 In the beginning God created the heaven and the earth. But then the app replaces the script with other words containing God, but all jumbled up. Here is the code I am using: Private Sub ToolStripButton2Search_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ToolStripButton2Search.Click Dim stSearch As String stSearch = Me.ToolStripButton2Search.Text For Each Line As String In File.ReadAllLines(Path.Combine(Application.StartupPath, "Bible VersionsKJV 1611King James Version of the Holy Bible.txt")) If Line.Contains(Me.ToolStripTextBox1.Text) Then Me.RichTextBoxViewer.Text = (Line) End If Next LineBryn Ryver
View 2 Replies
May 18, 2010
I have been having an issue with returning records from a SQLServer database where the date the record was created is between 2 user specified dates. When I populate the DataGridView with the results, they are incorrect and do not follow any recognisable pattern.
For example, if I specify the dates 05/05/2010 and 12/05/2010 I get the attached data in the DataGridView.
Code:
Private Sub btnGo_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGo.Click
'Clear the DataGridView
[Code].....
View 3 Replies
Mar 5, 2011
I am pulling a date value from my database:
Dim qfresho = From p In dbConfig.Configs _
Where p.Description = "FROD" _
Select p.dateValue
Dim qfreshc = From p In dbConfig.Configs _
Where p.Description = "FRCD" _
Select p.dateValue
Then comparing these date values to the current date:
[Code] .....
But for some reason its always returning the Else condition - even though the values in the database should make the query true. I'm guessing for some reason its not pulling the results as a date?
View 3 Replies
Apr 5, 2011
I have a GridView which is showing results and from which I am deleting a result using the auto-created delete link. My code behind to remove the row and associated info. is:
Private Sub GridView1_RowDeleting(sender As Object, e As System.Web.UI.WebControls.GridViewDeleteEventArgs) Handles GridView1.RowDeleting
' The deletion of the individual row is automatically handled by the GridView.
Dim dbDelete As New pbu_housingEntities
' Remove individual from the bed.
[Code] .....
It seems that it is not able to grab the row that is being deleted, so it is always giving me a "Object reference not set to an instance of an object" error.
View 1 Replies
May 7, 2012
like an Interop user control (VB.NET) to return and to accept multiple values from a get/set call. I assumed a user defined type (UDT), would be the correct way but I keep getting a "Variable uses an Automation type not supported in Visual Basic¯ from the VB6 compile. How is passing multiple values between an interop control and the VB6 application done?VB.NET (Interop) code, a control with a .NET ListView
Structure Employee
Dim Firstname As String
Dim Lastname As String
[code].....
View 2 Replies
Mar 11, 2010
Im currently working on an n-layer application that does alot of database work.90% of all database queries are updates, and inserts and I want to be able to view the results of my query in the presentation layer.I was thinking of creating a QueryResult class that has a few properties like QuerySuccessful (boolean), Message (string) - holds success or error message, and optional field to hold any additional data that may need to be passed back to the presentation layer.So I guess my question is, am I going about this the correct way by creating a QueryResult class, and passing that back up through the layers to my PL?
View 2 Replies
Nov 29, 2010
I have to write a program that allows a user to input DVD info such as DVD Name, Year produced, Running Time, and Rating. The user then clicks a menu item "New" to save that info to a file. Then the next time the user inputs new DVD info it has to append the new data to the same file. (I got this far and everything is working writing and appending data)Next the year has to be able to search by DVD Video name and it has to print the info in the text boxes on the form, if not found then a messagebox should say not found. When I use the sub procedure that I have created to search the record it always comes back as record not found although the record in in the file.
Option Strict On
Imports System.IO
Public Class Form1
'Class level variables
[code]....
View 1 Replies
Feb 24, 2012
how to find data using search command in my form application like searching a name in my database?
View 1 Replies
Feb 23, 2011
I have a Search web reference (from a Search Server 2010 express install) in a vb.net application that is utilizing the QueryService Class to search a production Sharepoint foundation 2010 site.At a previous point in time, we had created a proof of concept on an entirely test system that has since been turfed. From my recollection on this test system when documents were uploaded as a specific site content type (that inherits from document) and metadata was provided, we could search for specific metadata by making managed properties for each, and search results would be returned as documents (with the isdocument flag set to true). Viewing the document then became simple, as we could simply use the filename and path to display the stored file.Now we are developing a production system and we have encountered a new behavior, where these results now are returned as aspx results such as
[URL]
This of course makes it terribly difficult to locate and view the document, we can extract the Title which will then give us the name of the file with no extension, but that hardly helps, as the FileExtension data is aspx, not the documents file extension, so we don't have a full filename. We could display the page returned as a result, but would much prefer the document itself.
I've made a test document library, with just bare bones setup, (not using the site content type, or site columns) and uploaded some documents on the same site, and they are returned in the same fashion, so I don't believe the document library, or content type are the issue.
With a fairly limited understanding of both Sharepoint and Search Server, I don't know if this is a setup issue with the search service itself, with the site configuration, or with the querypacket I am sending. We also have a third party application (Knowledgelake) installed on the server that ties into sharepoint which could have changed configuration somewhere as well?
I don't think the query packet has changed since it was working in the proof of concept, other than the custom data column names. I will provide it here in case there is something glaringly obvious to an external reader.
<QueryPacket xmlns='urn:Microsoft.Search.Query.Document'>"
<Query>
<SupportedFormats>
<Format>urn:Microsoft.Search.Response</Format>
[code]....
View 1 Replies
Feb 24, 2011
I have a school project i am working on wich i am to build a program that randomly generates 500 alpha-numeric numbers (license plate numbers). the program needs to be able to search the 500 numbers and based on given criteria (a text box) that you put in return the matching results to another listbox. I got the 500 plate numbers to generate on form load but have been searching thru my textbook and cant seem to figure out how to take the imput from the text box and search the list box. Not asking for a ton of help but just a point in the right direction. i attached the assignment i was given from instructor.
[Code]...
View 5 Replies
Jan 19, 2011
im just starting to work with some database stuff, and ive got data binding done but im a little stuck with filtering. Ive got a test project, which has
-- listbox (bound to column 2/firstname)
-- Combo box (Has items added, with the same names as the items in colunm 3. so it has 'RPG' and 'Puzzle')
Now what im trying to do is when the item in the combobox is changed say to 'RPG' only items in the db which have 'RPG' in the surname column are displayed in the listbox. Been Google'ing and reading but all i can find is examples relating to a dataview and i cant get them to work/adapt to my situation.
View 2 Replies
May 1, 2009
is there anyway i can search for a particular row in all columns in a database and display them accordingly? like in a customer table, i have CustomerID, Name, Address is it possible to search for all the details of a customer?
View 4 Replies
May 1, 2009
is there anyway i can search for a particular row in all columns in a database and display them accordingly?
like in a customer table, i have CustomerID, Name, Address is it possible to search for all the details of a customer?
View 9 Replies
Oct 28, 2009
I am doing an assignment for class and it is searching an SQL Database file. On the GUI I have a text box and a button to search this database. It is presented on the form in DataGridView connecting to the file, and the file connection test succeeded, I am kinda so so on understanding what is going on with the connection between the file and VB 2008 but I am getting 4 errors: Warning1The designer cannot process the code at line 119: Me.PlayersBindingSource.DataSource = Me.BaseballDataSet
[code].....
View 1 Replies
Mar 11, 2010
Im trying to input a search box in my forms so that when I type in a customers name it will show there record. I've managed to do it in my transaction form, but not in any other standard forms. In my transaction form I've got this code:
Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtSearchSalesID.KeyPress
Dim dv As DataView = New DataView()
[code]......
View 1 Replies
Mar 4, 2010
I would like to return the data in a database query as an array, but the problem is, Im having trouble working out how to do it, here is how I would like the data to be returned:
array (
---> 1
---> ---> 1
---> ---> ---> fieldname
[code]....
I could create a multi dimentional array, but the results could range from 2 rows, to 2000 rows, I looked into redim, but you can only redim the last dimention, I would need to the first and second, but not the last.
View 2 Replies
May 25, 2010
In my codebehind I have this vb:
Dim reader as idatareader = includes.SelectDepartmentID(PageID)
While reader.Read
Did = reader("departmentid")
[Code].....
No Errors are being presented yet nothing is being returned by the reader. Is there an error in my code?
View 2 Replies
Apr 3, 2009
I am currently trying to develop a program, for personal use, that will monitor the lending of items of music equipments to friends and family etc. And, for my program, I have a requirement, which is the ability to search a relational database, for items loaned, through my program, based on criteria entered in a set of text boxes located upon the program's form. I have already set up the form, and have searched the Internet high and low, to no avail (probably didn't look hard enough).e,I would also like to make another request... if possible I would like to achieve this task with use of the 'LIKE' statement, so that I don't have to input the criteria in full, when I wish to search the database.
The database that I am using is a standard Microsoft Office Access database, saved in a '.mdf' format, and the database comprises of three tables; LoanTbl (which specifies the loan details), EquipTbl (which contains information about the equipment loaned) and a LinkTbl (which forms the relationship between these former two tables) - the reason for the LinkTbl, even though it may seem unnecessary, is because the data has undergone 'normalisation', so that it is stored in the most efficient way possible.
Also, whilst I am on the point of linking together my program and database, does anyone also possibly have any ideas as to ways in which to add data to this relational database; I do have coding for this, however, it only applies to a stand-alone table, whereas there are relationships between my tables.
View 11 Replies
Feb 8, 2012
I am in the process of creating a program that is linked to a database. I want to automatically generate a reference number that is not already present in this database, to do this i know i am going to need to search the database to check whether that number is already present or not. But I am unsure of the best way to go about this. I am using an access database and vb.net.
View 8 Replies
May 1, 2009
i am using visual basic 2008 with vb.net as language. i have created an application in which i am using oracle 9i sql database. the table is admissioninfo in which the columns are rollno,feespaid,dept,sem,sec. i want to know how i can search a record i.e, rollno from the database through my program and the program will show feespaid,dept,sem,sec in the textboxes.
View 1 Replies
