Code:
dt.DefaultView.RowFilter = "[" + comboBox1.Text + "] LIKE '%" + textBox4.Text + "%'";
Mikkeee
Last Activity: May 8 '19, 03:05 PM
Joined: Feb 4 '13
Location: Charlotte, NC
-
The single quotes you have around your column name is the issue. Try this:
-
That's like asking 'what parts do i need to build a fast car'. You need to start with a database, grid, and some C# code but what you're asking is how to build the entire project. You need to start with a more specific question.Leave a comment:
-
Then a hashtable is the way to go.Leave a comment:
-
I would recommend using a hashtable with the key as the unique item name and the value as a counter. If the if the key isn't in the hashtable then add it and set the count to 1. If you do find the key then increment the value by 1.
EDIT:
I just realized that this is in a VB6 group. Use the same concept but instead use an array.Leave a comment:
-
You say you checked everything and it's OK yet you're not getting the response you need. This tells me that everything is not OK. I would need to see the output of your querystring in your first call and a subsequent call to be able to help.Leave a comment:
-
You're query string is only selecting the Channel field. Just change it to "select * from Test" if you want all the fields.Leave a comment:
-
Use this in your form load:
And this in your TextChanged event:Code:SQLiteConnection connect = new SQLiteConnection(connString); connect.Open(); SQLiteDataAdapter adap = new SQLiteDataAdapter("select Channel from Test", connect); DataSet ds = new DataSet(); adap.Fill(ds); dataGridView1.DataSource = ds.Tables[0];
...Code:DataTable dt = (DataTable)DataGridView1.DataSource;
Leave a comment:
-
How are you setting your DataSource? In your code above you set it to a datatable. I ran this same filter on my database without issue.Leave a comment:
-
I was a little quick on the trigger....
Code:DataTable dt = (DataTable)DataGridView1.DataSource; dt.DefaultView.RowFilter = "Channel like '%" + txtFilterChannel.Text + "%'";
Leave a comment:
-
I wouldn't open your db every time a keypress has been made due to the overhead involved. Instead I would either use a select statement on your data or set your View rowfilter. Your updated code unnecessarily creates a view, opens a connection, and set's the row filter but it's never assigned to your DataGridView. You should be fine with one line of code in there instead:
...Code:dataGridView1.RowFilter = "Channel like '%" + txtFilter.Text
Leave a comment:
-
RegEx is super powerful for stuff like this. Read a few tutorials and it will really get you out of a bind.
Code:Dim contents As String = System.IO.File.ReadAllText("C:\Users\user\Desktop\file.txt") Dim count As Integer = Regex.Matches(contents, TextBox1.Text).Count MessageBox.Show(count)Leave a comment:
-
Regular expressions are the way to go. Single line of code will get you what you need. Find the number of matches using RegEx.Matches(e xp,matchterm).C ount.Leave a comment:
-
No problem! I've been in your situation and received a lot of help so and I've come to the point where it's time for me to pay it back.Leave a comment:
-
I ran the following code against your CSV file and receive the following result:
#35 True Values
...Code:Private Sub Button2_Click(sender As System.Object, e As System.EventArgs) Handles Button2.Click Dim startCounting As Boolean = False Dim trueCount As Integer = 0 Dim csvFields() As String For Each line As String In System.IO.File.ReadAllLines("C:\Configuration.csv")Leave a comment:
-
Looks like the record which follows the section your looking for only has a single field. Change the following:
Code:If csvFields(0) = String.Empty Then to If csvFields(0) = String.Empty OrElse csvFields.Length < 23 Then
Leave a comment:
-
I looked at your file an you're getting the error because you're working with a screwed up CSV file. Whoever the developer is who wrote the code to output this should receive a very hard slap on their hand. Take a look at http://en.wikipedia.org/wiki/Comma-s...s_and_examples for best practices with CSV files. I work with banks and their back end systems and see this a lot. You basically have a CSV file with combined table outputs...Leave a comment:
-
And I just noticed that you have a redundant line of code. Your original post has:
but you're never using the SR object so just remove it.Code:Dim SR As New StreamReader("c:\Configuration.csv")Leave a comment:
-
Yes, instead of csvFields(1), change the (1) to the field number that corresponds to the field you're searching for. BTW... it's a 0 based array so if you're counting the column, subtract 1 from the actual column number you see in excel.Leave a comment:
-
Nope... that's your job ;-p I'm here to help you learn, not write code for you to complete your project. Just apply the same logic as above but look at the correct column number for that fieldname in the csvFields array.Leave a comment:
-
There must be something missing in your code. String.Format will not output the curly braces around the 0 '{0}' because this is a placeholder for the variables coming in. I created a similar csv file and ran it against the exact code I posted and see the correct results. Put a breakpoint on the line which assigns a value to your Label4 textbox and see what the variable trueCount is.Leave a comment:
No activity results to display
Leave a comment: