Searching For Value In Separate Table - Result Yes/No
Jun 4, 2009
I am currently updating an application I wrote to view Car Insurance Policies, using a backed SQL database and a front end vb.net GUI. I now need to make a change.
I haev added a new table which has all Active Policies, and i have the old table with every policy there has been active or not. We do an import from a separate company, and there is no Active/Not Active field.
I need a query/code that will populate an "Active/NotActive" field in the old table. For example:
CODE:
View 3 Replies
ADVERTISEMENT
Apr 30, 2010
I'll get straight to my problem - I'm currently coding in Visual Studio.I have a table (countries) with the columns ID | Name. The table is filled with around 28 records.I also have a form with 4 combo boxes (set up as 1,2,3 & 4) that I want the user to select. These combo boxes will display the names from the table countries. I then want to use the selected names in the combo boxes to Insert into their corresponding ID into another table. For example England would have the ID 1, USA the ID 2 etc.So, is it possible to have separate combo boxes that will give separate ID values but using the same table? At the moment I can't seem to find a solution.Eventually the form will have more than 4 combo boxes so I don't want to use separate bindingsources for each combo box.
View 5 Replies
Apr 7, 2011
i need to separate at command result -like IMSI No. mobile type ...etc - from the following OK after the result i need the result alone to put it in a database i need it as a string to deal with like a number maybe to dial phone or retreive the msisdn
View 4 Replies
Apr 13, 2011
I hav copied my whole cde in form 1 to give a better insight of my question.what I want is to search for a string example title of a song then display my result to a richtextbox but the result should include the title the location and number.[code]
View 2 Replies
Jul 8, 2011
I have a problem with search form. I use date-time picker for user to pickup their prefer date. And when I tried to set any date, it produces no result. Bellow is my code:
Try
myDataSet.Clear()
myCommand = New SqlCommand("SELECT * FROM tblVisitor WHERE EnterDate LIKE @EnterDate",
[code].....
View 1 Replies
Aug 24, 2009
I am pulling the computer model from the bios, the passing the result into some SQL to find it in a table (as the bios name, and the names in the database are different).If it exist, it writes the value from the database to a combo box (cbModelBios)I am trying to debug the case where the computer model does not exist in the table.I figured I would just try to see if the SQL statement returned null, but I am still getting an error [code]
View 2 Replies
Nov 12, 2009
I have an application where I need to be able to search for the workers related to a company from a contacts list. I am able to do this by entering the company number but I am unsure how I can set the query to allow to search for the information in the other table.
[Code]...
SELECT RecordNo, CompanyID, AccntRep, CustNumber, Person, SubjectID, StatusID FROM dbo.Contact
WHERE CompanyID = @companyNo I think that I need to create a join in the SQL statement to the company table but am unsure how to go about this and I would be grateful if someone would give me a point in the right direction so that i can search for the company name instead of the companyID.
View 2 Replies
Jun 4, 2009
Create a combo box that contains the values:
- Year 7
- Year 8
- Year 9
- Year 10
Thats easy enough, but i need to then need to do the following:When a option is selected, i want to display a seperate table for that year.For example, if i select "Year 7" a table specificly for "Year 7" is displayed.(Using visual studio)
View 11 Replies
Nov 10, 2009
I made some progress and I am succesfully reading in reading in two columns of data to my DataGridView but now I am stuck. I have to search the first column for a particular number the read in that row and put the data in a variable to use, how do I search through this data?
Here is what I have so far:
vb
Private Sub RetrieveContacts()
Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=" & Application.StartupPath & "myTest.mdb")
Dim adapter As New OleDbDataAdapter("SELECT [PN], [SIZE] FROM MYTABLE", conn)
Dim dt As New DataTable("MYTABLE")
adapter.Fill(dt)
dgContacts.DataSource = dt
End Sub
View 7 Replies
Nov 3, 2009
I am having to create a data adapter to pull data into a dataset, then loop through that dataset in order to add information into a new column from a separate data source. My first data source is access. My second data source is oracle. Here is the code I have to do this, which works well when I show it in a grid.
Dim da As New OleDbDataAdapter("SELECT tblSummary.WorkOrderNumber, tblLabor.Crew, tblLabor.NumberOfMechanics, tblLabor.NumberOfHoursPerMechanic, tblTasks.TaskNumber, tblTasks.TaskDescription FROM (tblLabor tblLabor INNER JOIN tblTasks tblTasks ON tblLabor.TaskID=tblTasks.TaskID) INNER JOIN tblSummary tblSummary ON tblTasks.JobPlanNumber=tblSummary.JobPlanNumber WHERE
[code]....
how I can search through this data table. For instance, I want to see only rows that are in this data table that have "Replace" somewhere in the "Description" field, which is the field I added from my second data source. How do I do this? Is there an easier way to do all this instead of filling my dataset from the first source and then adding columns from the second source by looping?
View 4 Replies
Jul 8, 2010
I have a form that reads the data from the database table ( so you can see I have figured out how to attach to a databse table)On the form I can scroll through the data with use of the binding navigator that VB automaticly installed on the form, but I need to search the table for specific data in one field.I am guessing that one way is to use a query, but I can't figure out how to use one.I realize that this may be real simple, but because I am just learning VB, I don't know where to start.
View 4 Replies
Jan 13, 2011
I'm trying to write code that allows a search for a particular record in a data table. The table, imported from an access database has 4 columns, the first being names of cities. I need to search for a particular city and have it display the city name and the other three columns of data for that row in particular text boxes. Here is my code...it is the last sub routine that is the problem...I'm tying myself in noob-ish knots trying to figure out nested loops etc to search... (I've commented some of it out whilst I tried to figure it out but I'm running out of time and patience and my knowledge of VB is limited!!)
[Code]...
View 3 Replies
Mar 10, 2010
I'm just starting out at vb.net but have done programming before. i am trying to use a treeview to display information in a seperate table on the same form dependant on which nod of the tree is clicked. Secondly is it possible to import the information from an excel spreadsheet or does the information have to come from an access table.
[Code]...
View 2 Replies
Jan 9, 2011
I got a problem I need to search by First Name OR Surname. So the user can enter one or the other or BOTH.
So here's what I got I set two primary keys to try and find the row but I'm gettin all sorts of problems, for example when I set FirstName & Surname as primary key which you need to do to use the find method i get an error as it expects two values..
Dim da As New SqlDataAdapter
Dim con As New SqlConnection("Data Source=UserSQLEXPRESS;Initial Catalog=StudentTeacherDB;Integrated Security=True")
[Code]....
View 2 Replies
Aug 15, 2011
I have produced some VBA in Access that creates a spreadsheet.I have also created an SQL query that retrieves records from an Access table.I have 48 tables (each table for a specific institution centre).I have created another bit of VBA code that creates a spreadsheet and loads the records from the query in to the spreadsheet.Each centre has a unique Sequence Number (Indent Number)At the moment though, all I can do is import one table (records for one institution) in to a spreadsheet. I want to end up with calling the function and having an output of 48 spreadsheets being saved to my desktop, each spreadsheet containing records of a different center.I have thought about putting a loop in, but not sure how I would quite go about it.
Here is my code to create the spreadsheet:
Public Sub ExcelExport(lngIndentNumber As Long, strFolder As String, strCrit As String, strReport As String)
', ctlLabel As Label,
DoCmd.SetWarnings False
[code]....
View 2 Replies
Aug 16, 2010
I want to execute an SQL statement and put the result in to a data table.
Sub getvehicletypes()
Dim dt As New DataTable
Dim intLine As Integer = 0
[Code].....
Once Ive got it in a dataset I need to work out how to search the dataset for a code and return the corresponding description and vice versa
View 10 Replies
Aug 9, 2011
THis code extract a value from a table to a var...
Dim var_IES_fornecedores as double = 0
For Each dRow In ds.Tables("Tabelavalor").Rows
If dRow("numeroconta").Equals("221") Then
[CODE]...
This is the problem...the numbers after the period should be just 2 and not a lot of numbers...everythin wrong with the code?
View 2 Replies
Aug 3, 2010
I need to pupulate a Grid, but i like to do like Microsoft SQL Server Management Studio, when you make a Select to a table with bounch of rows, it start show the result but in the botton still retriving data.So you can start looking the data, not like you get the data and after you get the last row you can asing to the Grid.
View 6 Replies
Oct 16, 2009
I want to be able to get the one record I return from a table and put the results into text box's directly rather than put the result into a combo box and then transfer the text across.
Private Sub GetStationStats()
conn.ConnectionString = myConnString
Dim myCommandStationStats As New MySqlCommand
Dim myAdapterStationStats As New MySqlDataAdapter
Dim myDataStationStats As New DataTable
Dim SQLStationStats As String
[Code] .....
The fields Signon and SignOff, plus many others which I didn't include in this sub. Above code does work, its how to get it into a text box.....
View 2 Replies
Feb 2, 2012
What type of collection should I use to store data from a table (in a book) that has multi-dimensional Keys to get a single value result?
What is the best way to store and retrieve these values in a program?
View 9 Replies
Nov 4, 2011
In my VB.net code i have:
cmd.CommandText = "SELECT * FROM [strfg].[dbo].[Myfunc] (@MyParam)"
Dim myparam As New SqlParameter("@MyParam", a)
cmd.Parameters.Add(myparam)
The function (runnig on SQL server) returns a table with four columns, one row.How do I call this function from Visual Basic? cmd.ExecuteScalar() is obviously not correct. In c++ I use a recordset. What is the equivalent in vb? Does anyone have a short example?
View 2 Replies
Feb 23, 2012
I created a telephone number form where the user enters the telephone number in a text box as (nnn) nnn-nnnn. The first 3 digits in parenthesis are the ISD code, the next three are the area code and the last four are the local number. I need to separate out these three fields of the phone number and display in three separate text boxes labeled appropriately. Now, suppose the user enters the phone number in a text box as a continuous string of 10 digits, where the first three represent the ISD code, the next three represent the area code and the last four represent the local number. I'm lost as how to change this string into the form (nnn) nnn-nnnn. This is what I have
[code]...
View 3 Replies
Sep 17, 2010
I have a TabControl object on my form with many tabs created in code (TabPages) and my problem is that the same objects that are in the initial TabPage needs to be in the other TabPages created in code, I have this done in code when the user clicks the 'New Tab' menu option, however the same code is used for any new tabs created. The problem created here is that I have an event against one of the objects that appear in the other TabPages, but because the same code is used to create any new tab pages, the event will only work on the newest tab page, if that makes sense? By the way these objects that appear on the other TabPages are properties at the top so events can be handled against them in the respective subroutine.
[Code]...
View 5 Replies
Dec 10, 2010
I am currently having a headache on how to solve this problem that i am facing. here is the situation: I have a combobox and a list box on the main form. The combobox will get the data from the ms access database. In the database, i have the details of a person's IC, Name and DOB say for eg on one entry I have D215311523C,SHAWN,13/04/1987 So now, my combobox on form load will show the list of dates in the database to allow the user to search base on the date itself by clicking on the selected date. So when the user clicks on the particular date say 13/04/1987, people in the database whose birthday is 13/04/1987 will be shown on the listbox.Meaning to say if i have 3 entries whose dates are the same 13/04/1987, 3 entries will appear. If there is only two entry, then two results will be shown. But now, when i do a single click on the date, one result will be shown. That is correct. But the problem is when i click on the same date again, three of the same results will be shown on the list box. that is it will display : 13/04/1987 13/04/1987 13/04/1987 which is not the case. Then it will show more duplicates of the same results if i click more times on the same date which should not be the case.
Dim n As Integer
Dim numbers() As Integer
Dim StartFrom As Integer
Dim EndAt As Integer
[code].....
View 3 Replies
Sep 25, 2010
I am using a datagrid in my where i am having four columns. In first column the parameter values are entered and in the second column measured value is entered and in third column the nominal value is entered.Inthe fourth column the result is displayed by subtracting the measured value and nominal values. I am doing this calculation in Datagrid cell validated event. What i want is,there will be many rows in the grid,when typing the value in the third column the corresponding result will be displayedin the rowof theresult column,save button will be displayed while the form loads,when the calculate part is completed that is there should not any cell of the resut column empty then i should enable the save butto.
View 2 Replies
Oct 14, 2009
I am encountering the following issue So i have a device that sends stuff at the serial port, i then parse it and put it into an array of bytes like that:
Dim HCI_Command_Rcvd_Byte() As Byte All good till here What i wanna do is make an array and put this result every time the serial port gives me a new result, for example:
[Code]...
Basically what i wanna do is let the port parse the messages, fill in the array with the result at an empty spot in this array and then i will have a separate thread that will look in into this array in each non empty space and after it looks into the non empty space it will use or discard the info and also mark this space as empty (after it checked)
View 7 Replies
Oct 27, 2011
I have a few forms that have a lot of really intensive updating along with a great deal of user interface (text boxes, button clicking etc) Is it possible to open a separate form as a separate UI thread from the start up form that called it to "show" or open or whatever the new method might be?
View 6 Replies
Apr 16, 2010
I just read about DataSet in VB.NET, it uses disconnected concept. My question is: if my apps has "List All" button that query data from 1 table in the database, and that table has "very very very" many rows, so my DataSet will be filled with those data and eat up memory. Can I limit the data that being put to the DataSet from that query? But I want to be able to retrieve the next data from the same query if the user want to see it?
For example:
I have 1000 rows in my database, and i query all of them. But I just want 200 rows being inserted to my DataSet, but if the user want to see rows number 201 and so on, I want to be able to retrieve the next 200 rows, and so on. So it just like cutting those data into a group of 200 rows. Can I do this with the concept of "disconnected" of the DataSet?
View 5 Replies
Jun 21, 2011
I have set up a method in vb.net and in xcode for encrypting a string using as far as i can tell the same parameters for an AES encryption.I've looked all over the place but cannot find information on whether they use the same encryption algorithm and settings.
this is the vb.net code:
Dim encryptAES As New AesCryptoServiceProvider()
Dim encoding As New UTF8Encoding()
Dim encryptor As ICryptoTransform
encryptAES.Key = encoding.GetBytes("12345678901234567890123456789032")
encryptAES.IV = encoding.GetBytes("1234567890123416")
encryptAES.Mode = CipherMode.CBC
[Code]...
View 1 Replies
Aug 30, 2009
I want to add a new table in my accdb and copy the content tfrom an existing table into the new one.
Is there an easy way to do this?
View 8 Replies
