I am very new to vb.net, just wonder can I use vb.net to do something like this : I have alphabet from [A][B]...to [z]. When A is clicked, product name that start with "A" and it's price will shown in a table below.
View 1 Repliesi have a form with a textbox, datagridview, tabcontrol. I use the tabcontrol to create an indexed view of the datagrid using the alphabet to filter the records to show the respected fields according what tab was selected. The textbox I have on the form is databinded to a field of a table in the database. The datagrid is also databinded to the same table in the database. The binding on the textbox breaks when I press on a tab to change the filter type. On the tabcontrol.selectedindex event I have this code to filter and fill the datagrid is: conn.Open()
[code]...
I have a textbox and I only want people to be able to type in the word "ALL" and the numbers 1-6.How do I go about that?I got the number part but do I have to make a separate line for each letter in the alphabet that isn't "A" or "L"?
Private Sub monthTextBox_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles monthTextBox.KeyPress
'If (e.KeyChar <= "1" OrElse e.KeyChar <= "6") Then _
'AndAlso e.KeyChar = "ALL" Then[code]....
I would like to know how to filter out system tables and only return user tables .when i run the code it displays lists of system tables with user tables list in combobox.I have just gotten into vb.net and have tried few ways to do this but dont understand well enough.
[Code]....
I want to detect F2 keypress as a shortcut to show something.. this is like F1 to show help in vb.net.
View 5 RepliesI've been encountering this problem. When I add a listbox at my game, all my keypress events and codes doesn't work. But when I remove it, it will work again. I don't know what's the problem. I need the listbox to add strings on it for my game.
View 2 RepliesI have created the following piece of code to try and see if the user pushes the 'f1' key, and if they do.
[Code]...
I am not sure if this code works yet because the keypressed event is not triggered when I push a key. Could someone tell me how I can change my code so that it will test what key is pressed, no matter what control on the form has focus?
i know this has to be simple but i can find anything anywhere tonight on how to check if while a textbox has focus if the ctrl+v or ctrl+c was pressed i simply need to use it like such:[code]
View 4 Repliesthis is my code in VB.NET 2008 and it works as the result, i can input starts from 1.00 until 99.99
but i need more than this i want the textbox automatic validate the input as i typed in the textbox
example: i typed "1000" then the textbox will write "1,000"
example: i typed "10000.99" then the textbox will write "10,000.99"
nb: it has to disabled from typing ","
[Code]...
I have a table (Projects) which is linked to projectVersions on projectID..projectVersions contains several columns on which I'd like to filter a returned project (and associated projectVersions) list. For example there is a "capacity" column and a "country" column. I am doing a filtered list of projects on one page and I'd like to include all projects where any one of the associated projectVersions has a capacity of 750ml and a country of "France" for example.It may be that a particular parameter is not set and so I pass a zero to indicate not to filter on that.I guess this needs some kind of subquery as when I try and do something like this: [code] it doesn't work as the "xxx" bit, being one-to-many, expects me to specify an item to get at the entities within and yet I want to query where ANY of the associated versions match one of the criteria.
View 1 RepliesI have several multi-line textboxes that I want to lose focus (i.e. when the user presses the right arrow key) but the control wil not relinquish the focus.Simply put, I first verify if the selection start is at the end of the text, if it is, and the user presses the arrow key, it should move to the next textbox. some debug.print code placed in strategic locations indicates that the target textbox gets focus and immediately loses it and the source textbox gains focus once again. Essentially not allowing the textbox to lose focus.
Select Case
Case Keys.Right
tbRight.Focus()
[code]....
After changing the source textbox multi-line property to false, it behaves as expected. Is this a "feature" .. surely I don't have to resort to "SendKeys"
I have a dataset filled with content from a XML file:[code]Now I want to have the most recent date of each asset written to a SQL database. At this moment i write al the records in the database, where I sort the dataset on Date, so the asset with the most current date is writeen to the database. Is it possible to do a 'filter' of the data first before writing to the database?I can use Max(date) is SQL to filter the correct records, but I want to do it right from the start.
View 6 RepliesI guess I just cant seem understand this correctly
Dim StatusClosed As String = Form11.Closed_Code.Text ' usually = S or ClosedSale or Closed Sale
Dim SubjId As String = Form10.add_Num_txt.Text ' usually = StreetName or Street Name or SN[code]....
If SubjId is StreetNumber or SN its ok , if its Street Number with the space I get error
If I place a ' around {3} in my afilter line then it works if the SubjId is Street Number but not StreetNumber or SN
When I use a command such as:
Me
.TableAdapter.Fill(Me.SomeDataSet.Table)
I am going out to the database, gathering the requested information and filling the dataset. Therefore, everytime I add a query to a table adapter, it is also going to the database to get the information. So, my question is, how do I fill a table in a data set with all the records in the database table and then, filter the information I've already collected in the dataset without going back out to the database again?
I have mp3 database (access). I want to filter table and show 100 most played songs. There is a field "PlayCount" which is increased every time the song is played. I know how to use TOP clause, but there is a problem when I want to sort results in descending order by "PlayCount" .here is the sql query:
SELECT TOP 100 * FROM Database ORDER BY PlayCount DESC this query returns 120 results. If I use "TOP 200" it will return 278 results. But everything works fine if I use ORDER BY Filename.
What code I need to search a whole table (not just one column). I can already search a column but how do I search the whole table for a string .
source1.DataSource = ds.Tables(listboxselect)
Grid.DataSource = source1
source1.Filter = "id = " & searchtxt.Text
How can I combine the filter conditions in a Table in ReportViewer? Here is a screenshot [URL]
I want to do like this;
if (Expr3.Value = 0) or (Expr3.Value = 3) or (Expr3.Value = 6) or (Expr3.Value = 4 and Vadeli.Value = True)
use dataset , bindingsource and table adabter to filter or serch on database and update the datagridview
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'Database3DataSet1.Table3' table. You can
[code].....
I am a newbee in vb.net 2008 i am making a simple inventory system.now my problem is i want to get the filter earliest date in my data table and put it to a textbox..
ex.
Product Name Expiration Date
Paracetamol 06/01/2011
amoxicillin 08/12/2011
Mefinamic 12/1/2011
I want to filter the earliest date "06/01/2011" and put it to textbox.
I am using open file dialog on my windows form. In the directory, there are all txt files but what I would like to do is to filter those txt files that does not contain XML in the filename. Is there a way to do it?
View 2 RepliesLet's say, I have something like a table in the WebBrowser component, it's not actually a table, because the data organized in flash, but, it's organized like a table, it has like rows and columns. You can see more in the attached file. Can I transform this text organized as table into DataGridView or some another tool that serves as table. like_a_table.JPG
View 3 RepliesI am getting the error "system.argumentException; Column ' test_id2' does not belong to table Table. At System.Data.GetDataColumn( string columnname0 at system.data.datarow.get_item(string columnName).
This error is occuring right after I set the parametervalues in the report object of the Crystal report.(Note this a visual basic.net 2005 windows form application.)
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim cryRpt As New ReportDocument
Dim sql As String
[code]....
The value for the first parameter @Parm_1d1 value to the crystal report version 11 is correct. However, when trying to access the second @Parm_1d2 parameter ,the values past to the crystal report is not correct.
I have a database with a table that is a child to many other tables. I am using this child table as a datasource for a datagridview. I am using comboboxes to display specific fields in any parent tables, instead of the user seeing the foreign key. Everything is fine. However, I would like to filter the BindingSource based on text matches between any of the fields in the child table and the corresponding fields of the parent tables.
[Code]...
I am trying to learn the new methods in .net, but, I cant see a way to step through the data like you can in an ado recordset. I want to pull data from a table once, then split the data with a filter, then step through the rows gathering the dtata till eof. Clear the filter and reset it for the next batch.
View 1 RepliesI wanted to basically rearrange the alphabet with a keyword infront as I am doing a simple substitutional cipher. I have kind of worked out the logic of doing that but I am a bit stuck on the coding side.
What I wanted was something like:Dim key = "keyword"
For i = 0 to 26
'insert keyword and put in A to Z after without duplicating characters
Next
'output: keywordabcfghijlmnpqstuvxz
Randomize()
Dim Alpha() As Char
Alpha = New Char() {"A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N",
[code].....
I m trying to filter a sql db with many filter criteria which inert the user in textboxes .. i ve tryed this query
[Code]...
I am trying to filter the results of a datagridviw using the bindingsource.filter method.
Dim filters(2) As String
...
If Me.txtPartIDFilter.Text = "" Then
[code]....
The issue is in the last line. ID_Part is an Int64 data type filters(0) is a string so the system returns a "Can't perform 'Like' operation on System.Int64 and System.String" error message.As you can see I tried converting the data type, but that failed since it is encased in String.Format()- it's going to be a string no matter what, I suppose.It's almost 1:00 a.m. so I'm not firing on all cylinders.
in vb6 we use this command to disable alphabet sensitive option compare text (for example:
option compare text
dim baby as string
baby=inputbox("")
[code]....
in vb.net how can i do this ( without using Lcase and Ucase)
What is the fastest way to enumerate the letters of the alphabet? Anything built into the framework?[code]...
View 3 Replies