I'm using VB.NET with the MySQLConnector, I have an ID column with differents values, i.e:
101
102
201
202
203
302
304
305
306
I want to select all the values that start with "3" and then, select the MAX of them, in this case, "306"
I'm in a bit of a quandry. I am trying to build a simple search form where the user selects the column title and in puts the criteria then clicks the search button. This is the code I am using
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
details = ComboBox2.Text
'column name selected by user
specifics = TextBox1.Text
'criteria input by user
[Code]...
I'm writing an app for someone where I am pulling in work orders table information. The information includes: worknum, fname, lname, customername, description, etc. I do not plan to update the data in this table, only to read from it.I'd like to display a combo box for the work order numbers. The user would start typing the information for the work order in and it would autocomplete based on what's in the list. As work orders are displayed in the combo box, I want to update the data in text boxes representing the various fields.
I'm thinking rather than query the database several times, it would be a good idea to create a DataSet with information for the work orders table within the last x months then query the data from that dataset. I know there is a DataSet.Select method, but it looks like it returns the entire row. Is it possible to retrieve just a column of distinct values? For example, I'd like to do a select statement similar to this:
SELECT worknum FROM {WorkOrderDataSet} WHERE date >'{today-x}
The first part in curly brackets is meant to represent the work order dataset I create when first importing the data from Access. The second part in curly brackets will be replaced with variable data to represent a date to reference. I also don't think I'll need distinct because the workorder is unique (edit: is a primary key)Is it possible to retrieve just a column of distinct values from a DataSet with multiple columns? How do I do this?
I have three controls on my form; Textbox1, cboCity, lstCity When something (lets say "a") is entered in the TextBox1; I want to get each and every item in combobox cboCity that starts with "a" and add them to listbox lstCity.
View 5 Repliestable named mytablei have columns like this
[Code]...
i would like is to include amount1 and amount 2 values into sum only if amount1paidstatus="yes" for amount1 and amount2paidstatus="yes" for amount2, something like for selected day and selected customer.query "should" look something like this:select amount1(if amount1paidstatus=1)+amount2(if amount2paidstatus="yes")from my tablewhere (day=1) and (customer=1)
I'm having a problem with my Access database.I have to select the highest ActieAantal before the last action ( )because the last action is always the sum (Totaal).this is a part from my table
Persoonid..........ActieAantal..........acties..........Actieid....... ...datum..........aantal..........totaal
.......... 3 ................ 1 ................... aa ................. 99 ........ 31/12/1975
.......... 3 ................ 2 ................... bb 94 ............. 98 ....... 31/12/1975 ........ 94
.......... 3 ................ 3 ................... cc 10 ............... 5 ....... 17/03/1989 ....... 10
.......... 3 ................ 4 ................... dd 20 ............... 2 ....... 25/08/2003 ....... 20
.......... 3 ............. 999 ............. totaal = 124............. 9 . . . . . . . . . . . . . . . . . . . . . . . . . 124
The next person also has some acties with corresponding Actieid and a Total when I use this query I alway get the 999 values
SELECT Register.Persoonid, Max(Register.ActieAantal) AS MaxVanActieAantal
FROM Register
GROUP BY Register.Persoonid
ORDER BY Register.Persoonid, Max(Register.ActieAantal);
but when I try to exclude the 999 value I get nothing
SELECT Register.Persoonid, Max(Register.ActieAantal) AS MaxVanActieAantal
FROM Register
GROUP BY Register.Persoonid
HAVING (((Max(Register.ActieAantal))<>999))
ORDER BY Register.Persoonid, Max(Register.ActieAantal);
find the highest 'ActieAantal' after excluding the 999 values?
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 RepliesI am now trying to add a feature that was requested, mainly the ability to click a button or label, and have a messagebox pop up with the Vehicle with the HIGHEST total stats in the Vehicle list. What I need to know is:
1. If it's even possible to search for the highest total stat value in the Vehicle list?
2. If it IS possible, how difficult would it be?
[code] I've searched my a** off the past 2 days before coming here, hoping to be able to find an answer without bothering anyone here, but things just didn't go as planned...
In DataGridView I have three columns(year, month, day)
I wont first search dategridview by mounth, and the results search per day
I am doing a simple database project.I need to give the input in the database which is an access db from my input form and i have managed to do this part right.then i need to retrieve the details from the db using multiple search fields and show them in the datagrid view.I have 8 search fields(5 textboxes and 3 combo boxes). I also have included 4 other buttons which respectively clears the search boxes;clear the results of the gridview; show all results from the database;go to the input form and offcourse 1 search button.now all the buttons working fine except the search button. actually when i click on the search button if i include sql query for all the search fields only the first one works and also if i have clicked any other buttons before clicking the search button nothing happens, no result is shown and it happens the same if i search once and clicked any other buttons and come back to search, no result. I need to show the results in the gridview depending on the user input on those search criterias. user should be able to search in any combinations.I am using the below codings in my search form. the combo boxes are not bound.datagrid is bound to database though.
Public Class Paxsearchfrm
Private Sub Paxsearchfrm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'LAFDataSet.Table1' table. You can move, or remove it, as needed.
End Sub
[code]....
I've got a form that populates a DataGridView from an excel file. How would I filter that DataGridView so only the search criteria are visible. I need to search through 2 columns by all rows. I'm not very good with datasources I guess and can't figure out what all I need to accomplish this. DataSets, DataViews, DataTables.
View 17 RepliesCurrently I am searching through my list to find Customers that match on Address.
I need to match on both address and city. How do I rewrite my lambda Expression to match both criteria?
CustomerList.FindAll(Function(c) c.Address = addressToMatch)
[code]the main piece deals with the binding source filter. I've tried or/and. i tried to include that both codes in the string. i don't know what to do again i know you would recommend SQL but i don't know how to use that yet, so could you please recommend some bindingsourcefilter code to assist please. Its for a School project the search window looks like the attached picture
View 13 RepliesThis is the code I posted before. I have a thread open but it is confusing. I have a search of a datagridview. The search works. Now I would like to highlight the corresponding row of the search result. Scroll down to the highlighted row. If there are multiple results to the search critiria the next one should be highlighted.
Dim foundit As Integer = 0
Dim intResponse As DialogResult
With Me.DS.table
[CODE]...
I want to do a SQL SELECT COUNT in VB .NET to an Access DB. I can get the code to work using a text fields and text criteria but if I use a date field and Date criteria it returns 0 when there are some 47 records that it should count.
Dim Results As String
Dim InvDT As String = Date.Today
InvDT = "#" & InvDT & "#"
Dim strCnn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=S:MainData.mdb" connection string to your DB'
[Code] .....
I am building a real estate website. I have a table for properties (i.e. "houses"), a table for pictures, a table for features, etc. So each property's data comes from three, not only one table. I need to provide a function that retrieves requested property data depending on a search criteria, for example:
[Code]...
I need some guidance on the best way to proceed with searching a file content. I have a large file (see attachment) that is in text form, some of these files could be upto 50 times as big, therefore creating a huge file. These files contain information that is produced from another application and therefore I am unable to change the format of the file.
[Code]...
I'm realy new to this VB & Db programming#..I have two tables, one has the Vendor details, the other has all past and current PO details for each Vendor.[code]This needs to be done befere the 'For Each objDataRow In objDataTable.Rows. As the Dataset values will also populate another check Boxlist for 3rd Party.[code]
View 7 RepliesI am using select command for one of my button
Dim edit1 As OleDbCommand = New OleDbCommand("select * from [exporter] where exp_id='" & t1.Text & "'", con1)
now:-
t1 is a textbox
and in my table exp_id is "Number" now when i run this i get an error at the time executing reader (Data type mismatch in criteria expression.) but when i change exp_id properties to "Text" it run's properly
I have a datatable as shown in the figure. Let me explain my required based on this image. I have 7 rows of data. The rows 1 and 2 contains columns till UnitSqcNo same. I want only row 3 among the two. In general I want select all the rows with distinct model, unittype, unit and rest with greater CompId. ie the table should look like
View 1 RepliesI have a table which contains a list of products for a company. They input data about how much stock they have and also the level at which they want to be reminded that they need to order new stock.
[Code]...
I want to list all the true results in a form which the user is then able to navigate through. What would be the best way to go about doing this?
I have a datagridview with 2 columns, 1 is Batch_Number and another is Existing_Stock, there is about 6000 rows.My question is, I want to be able to write in a TextBox and hit a Search Button to search the Batch_Number column and filter out or highlight the row with the matching number to see the Existing_Stock
View 9 RepliesI have a Search function on my database.It countīs how may search result you get but now i want to load one column from each search result ( for each row in a DataTable ) into a "ToolStripDropDownButton.dropdownitems".[code]
View 1 RepliesI'm a bit of a noob at this and finding that all my research that's led me to wanting to do things right for data integrity are making it a bit more complicated on the front end.
Presently I have a Form in which I have two DataGridViews that I'm populating, each with it's respective stored procedure.
What the form is for is for linking rows from the one DataGridView (I'll call it DGV1) to a different one in the other DataGridView (DGV2).
Now to facilitate the ease of doing this for the user I want to both have the dgvs fully populated so that if the user wants they can just slide on through and manually select the rows in each they want and then there'll be a button to select which I'm planning to then use another stored procedure to then insert this connection between these two items into the database.
Another thing to facilitate this is a search bar. I want them to be able to type in something and have the datagridviews both navigate to where their selection is as well as selecting it so that it's then ready to be bound to the selection in the other.
What I'm wanting to know, and having a hard time figuring out, is how do you get such a search function to work on DataGridViews that I have bound to these read only stored procedures? How do I search and select within the DataGridView? And then how would I go about using the selection from two different datagridviews and putting those as parameters in the stored procedure that I wanted to use to then record the relationship in the database?
I want to take on a challenge.My ide is to me a program that search a folder for files with a specific file type ( like ".mp3")and then add information to a listview(Details). the information i want to add is:
[Code]...
I have a similar problem like here:
[Code]...
So in this case it must search in table FoaieParcursMasini find the second row and then stored the result of search in the listview.
I know how to do this in C#, but my dev team doesn't use C#...here is the answer in C#:How do I do this in VB?Essentially, if I knew how to write lambda expressions in VB, I would be set, but the materials I hav
View 2 RepliesUnable to select multiple column in datatable
Code:
Dim Activitydtb As DataTable = DirectCast(ViewState("TalentcharacterActivty"), DataTable)
grdviewactivity.DataSource = Activitydtb.Select("SELECT
[Code].....
Is there anyone here, can share some tutorial or ways to convert search result which is in xml format to html view which is more easier to view compare to xml view.
View 2 Repliesi am trying to make a search form with 1 label(surname) and textbox. i have 1 gridview on the form aswell. can you plz provide me any code so that when i type in textbox i should c the result in the gridview. wat i have done right now is. i have added data source and i than dragged the dataset.but when i load the form i already can see the data loaded on grid view .it than filters depending on the textbox. i want this gridview to be empty when it gets loaded.
View 4 Replies
