SELECT airplanes.ID_airplane
FROM (airplanes LEFT OUTER JOIN
airplanes_hangar ON airplanes.ID_airplane = airplanes_hangar.ID_airplane)
WHERE (airplanes_hangar.ID_airplane IS NULL)
This is the vb code.
Me.AirplanesTableAdapter.superawesome(Me.Hangar_DataSet.airplanes)
I want to pass the values returned to a combobox, or a string, doesn't matter i can take it from there.
Right now I have an array that is unparsed. One of its elements goes something like this:
"Blah, 555-5555"
So it's a name and a telephone number separated by a comma. The instructions I have tell me to use a query to put the information in the array into a data grid view in two columns, one for the name and one for the telephone number. I don't know how to isolate each inside a query.
I've been running into some errors with converting strings to dates in the following code. I have recently added the intcall.Value = DateTime.Parse(txtIntCallDate.Text) function which had gotten rid of the error message, however the records are not being updated, any of them on the form. Prior to this the strings were being updated just fine. As long as there is a date entered on the form there is no error, if it's left blank i get the "Problem converting string to datetime"
[Code]...
a user copies multiple lines of text (say, from an email) into the clipboard. Based on my observations, when one tries to paste the text into a single-line textbox, only the first line is actually pasted in. (I am aware that the "obvious" solution would be to set the Multiline property to True, but there are reasons I am looking to avoid this and to put multi-line data into a single line.)
In the TextChanged event handler, I wrote code that parses the clipboard data to successfully convert it to a single-line, comma-delimited format.
Private Sub txtMassTrackingNo_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) _
Handles txtMassTrackingNo.TextChanged
[Code].....
SQL String with multi line query
View 14 Repliesafter i get a successful ping response i need to send an HTTP request to the device examine the response and then display it. i'm trying to multi thread the 2nd bit with no joy so far.
Imports System.Net
Imports System.Net.NetworkInformation
Imports System.Threading
[code].....
im trying to write a query using multi 'where' conditions however am having so difficulty making it suitable for vb, sql = "SELECT * FROM Room WHERE [Room Size]= '" & Noofppl.Text & "'" AND [Number of PC's] = '" & noofpcs.Text&"'"
View 7 Replies[code]"An INSERT INTO query cannot contain a multi-valued field." i got this exception while trying to save record in access file.
View 4 RepliesI have an multi-database ODBC connection through a DSN. There is a primary database and two auxiliary catalogs. The Add Tables dialog in Microsoft Query only shows the tables in the primary database. If I pick one and continue on, the lists of columns in other parts of MS Query show all the columns in both the primary and auxiliary databases. If I pick a column, MS Query will look for that column in the primary database (great if it happens to be there, not so great if it doesn't). If I don't use any of the drop-down lists and just write a query in the freeform SQL editor, fully qualifying everything with the catalog names, the query runs fine.It looks as though MS Query is assuming only one database and one (default) catalog, and doesn't realize that it actually connected to several databases with separate catalogs.I get the same results with Office 2003 and Office 2007.Are multiple databases / multiple catalogs through a single DSN supported in Excel / Microsoft Query?
View 1 RepliesI'm working on an ASP.NET 4.0 site, which I inherited ownership of. It has a number of existing LINQ datasources pointing to individual tables. For example, to the Patient Encounter Summary table in SQL Server. The problem is in displaying the data there. It's a normalized database, so that table contains (for example) the provider ID, rather than the provider name.
It's simple enough to join the Patient Counter Summary to the Providers table (in SQL)... but how does one do that in ASP.NET? I'm not sure of the correct nomenclature, but the 'mid layer' is VB.
[Code]...
I am looking to remove an element from an ArrayList using a query, E.g. DELETE FROM arraylist WHERE (0) = "User1" (Where (0) is the index of the second dimension).
Code:
Dim Users As New ArrayList
Users.Add({"User0", "Details"})
Users.Add({"User1", "Details"})
Users.Remove("User1")
The reason I am looking for a query way to do this is because I will not know what the second dimension value will be.
Im trying to figure out how to query a dataset when I select multiple values in a list box? I have the list box linked to the dataset and am using a button to search the values selected in the list box. I don't know what to do!
View 7 RepliesI would like to be able to parse vb.net code files, so I can examine the collection of Subs, Functions (and their contents, including comments), private variables, etc. I can be open the actual source code files. So for example, if I have:
[Code]....
I'm creating a vb.net winforms application that will take in user given strings, parse them, and print out labels with variable information. The given string will be used in all the labels, but the variable part of the string will change with each label.
My question is: is it better to parse the strings one time, then store those values in arrays, or to parse the string each time a label is printed? Which will perform better? Which is better practice? What is the proper way to test something like this?
I'm adding multi-threading facilities for the first time. I have a function that is wrapped to be run in a separated thread. This function retrieves data (text) from a combobox and it works for sure without multi-threading.
When I call it as multi-threaded, I get the following error when I try to retrieve the data from the cmobobox: Cross-thread operation not valid: Control 'cmb1stBL' accessed from a thread other than the thread it was created on.
It looks like a restriction of thread-safety... I assume that the child thread cannot read from his parent, to make sure that he doesn't change his parent data. So how can I read the data from the combobox? Should I read the comoboxbox data before calling the child thread?
I have a need to build an app that will access about 10 websites and pass data to them, etc.I've read about something called multi-threading when searching Google. I've also seen people say that they use multiple browsers.Which route is better to use? I figure if you have to do some sort of multi-threading that you would access a single browser?
View 2 Repliesi have one project with multiples web services so i created various singleton class thinking in
performance. now i think create one singleton class and that have the instances of my webservices
[code...]
I have a need to build an app that will access about 10 websites and pass data to them, etc.I've read about something called multi-threading when searching Google. I've also seen people say that they use multiple browsers.Which route is better to use? I figure if you have to do some sort of multi-threading that you would access a single browser?Not sure which way I should approach this app.
View 2 RepliesHere is the code:
Function getData(ByVal id As String)
Dim reader As SqlClient.SqlDataReader
Dim statement As String
[code].....
When Creating a query using the sear Criteria Builder . I keep getting the error : "The schema returned by the new query differs from the base query" what does that mean and how do i avoid this problem in future
View 2 RepliesI am connecting to an Access database and using a parameter query with the LIKE operator to return all rows that match query. The string to search for is taken from a Textbox
sql =
"Select * FROM Allview WHERE Info Like" &
"*" &
CStr(TextBox1.Text) &
"*"
The query does not return any data in vb, but when run from access with same string, there is data returned.The connection to the database is done correctly, as I am able to return data with various other queries.
Partial code :
Dim
con As
New OleDb.OleDbConnection[code]....
I am trying to run a query an Access db from VB. The general query which I want to run is
SELECT * FROM Patient WHERE Patient.PatientID = ?
or SELECT * FROM Patient WHERE Patient.PatientLname = ?
I tried using an input box which captured the user input and pass that variable to the query, but that failed. Then I read about writing a function and using that, however, I keep getting an error which says Function not defined, but when stepping through the code, it seems to work. Here is my function: [Code]
The database:
"ID (Primary key)" | "Title"
0 | "title1"
[code].....
OK, before adding values to database, we should check if a row exists with this values :)TO do this, creating a Stored Procedure is a best way to deal with the database fastly.So... The problem now is, at the runtime, Miss OleDB throw this error:Microsoft Jet database engine cannot find the input table or query 'IF
i should say hi experts :D . Help me with this pretty code :)
The database:
"ID (Primary key)" | "Title"
0 | "title1"
[code].....
OK, before adding values to database, we should check if a row exists with this values :)TO do this, creating a Stored Procedure is a best way to deal with the database fastly.So... The problem now is, at the runtime, Miss OleDB throw this error:Microsoft Jet database engine cannot find the input table or query 'IF
I have to join two main tables, and I need to filter the results by elements in an ASP.NET web form. These filters are created on the fly so I have to use a lot of where extensions to filter the query. I want to execute the query with as optimized SQL as possible.
I am first doing a simple join between TW_Sites and TW_Investigators. Then there are two sub-tables that are involved. TW_InvestigatorToArea and TW_InvestigatorToDisease. While most of the where clauses are working fine, I have found a performance issue that won't be an issue right now, but will be an issue as the table gets bigger.
The arrays DiseaseCategories and DiseaseAreas would be the results of a CheckBoxList result.
Protected Sub LoadResults()
'Get Dictionary of Filters
Dim FilterDictionary As OrderedDictionary = Session.Item("InvestigatorFilterDictionary")
' Initialize LinqToSql
[code]....
I created a RDCL in the designer. I would like the User to Determine what is shown in the Report. How can I change the query at runtime? (ex. changing the customer Name)
This is the query that I have in the properties:
SELECT [Date], Address, Customer, Orders
FROM Report_qry
WHERE (Customer= 'JohnDoe')
how to take a query that returns a single row of data and load that data into textbox controls.I know about ExecuteScalar but it is only good for a single column of data from the query.
View 2 RepliesI've got confused at the moment.I've got one database to developed for MLM (Multi level marketing) company.so, there's one Members database.. each member have unique ID called membercode.. and all members can members under them.. can make 2 members down to 1 member.. all members are added in same table named "tbMembers" and for each member there's a "parentID" where I add member's membercode under whome that member is?.. right?
Now what's the matter is .. I want a SQL Query which can go under and under.. like 'John Doe' having two members under him named 'Suzan' and 'Ellie' and 'Suzan' is also having 2 members under her.. and same for Ellie. and for example.. 'John Doe' having about 300 members in his down line? All members are making transactions.. like they purchase product and Invoices are being generated (invoices tables have 'memberID'). Now the query is how to generate query which can calculate John Doe's Downline's TurnOver from invoices table's 'totalAmount' field's SUM?
I'm using Asp.net 2.0 (VB.net) and use SQL Server 2005 Express.
I have created a parameterized query in my tableadapter. Here is the SQL:
SELECT CalcinerID, Comments, CorrectiveActions, CrucibleOxideWt, CrucibleWeight, DCPressure, DCTemperature,
Date, DischargePressure, FeedPressure, FiredCrucibleOxideWt, GmSampleWt, LIMSNumber, LotNumber, MaterialType,
OperatorID, QualLabOperator, QualLabTimeStamp, RecordID, ToteBinNumber [code]....
When I use the Execute Query button in the Tableadapter Query Builder, the query works fine; I get all the rows I expect. However, when I run this in my code, the query behaves like an equality statement (i.e. Lotnumber = @Lotnumber) rather than a LIKE statement (Lotnumber LIKE '%' + @Lotnumber + '%').Here is the code that is not behaving correctly. Note that I have a textbox, LotSearchTextbox, where I enter the portion of the Lotnumber that I want to use as the filter. I also have a button, LotSearchButton:
Private Sub LotSearchButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LotSearchButton.Click
Try
Dim SomeNumber As Integer = Me.LotCalcinerO2TableAdapter.FillByLotNumber(Me.CalcinerDBDataSet.LotCalcinerO2,[code].....
why the query works in the Query Builder but not in the code?
I have a data table that looks like this:
USERNAME ICOUNT IAVERAGE DATE_LOGGED
LAGX01 1245 1245 05-07-2012
LAGX02 2211 1422 05-07-2012
LAGX03 1698 1112 05-07-2012
LAGX04 4598 1555 05-07-2012
LAGX05 2589 3245 05-07-2012
LAGX06 3321 1155 05-07-2012
LAGX07 3698 3458 05-07-2012
LAGX08 2589 4587 05-07-2012
LAGX09 1598 1142 05-07-2012
LAGX10 3156 1987 05-07-2012
LAGX11 5547 2011 05-07-2012
LAGX12 9456 3459 05-07-2012
Now, I want to execute a sql query that will display the top 5 based on average, so i did this:
SELECT DISTINCT USERNAME,IAVERAGE FROM myTable WHERE IAVERAGE > 0 AND DATE_LOGGED='05-07-2012' ORDER BY IAVERAGE LIMIT 0,5 and the result is:
USERNAME ICOUNT IAVERAGE DATE_LOGGED
LAGX03 1698 1112 05-07-2012
LAGX09 1598 1142 05-07-2012
LAGX06 3321 1155 05-07-2012
LAGX01 1245 1245 05-07-2012
LAGX02 2211 1422 05-07-2012
Now, I want to numberize my query result, so it will look like this:
RANK USERNAME ICOUNT IAVERAGE DATE_LOGGED
1 LAGX03 1698 1112 05-07-2012
2 LAGX09 1598 1142 05-07-2012
3 LAGX06 3321 1155 05-07-2012
4 LAGX01 1245 1245 05-07-2012
5 LAGX02 2211 1422 05-07-2012