I use a DataGridView to display filtered lists from a SQL data base.I've used this method on almost 100 Different objects.Today i'm getting a strange error from the DGV on only one of them, If you try to select an item in the list
[Code]...
here is what i'm stuck with i have datagridview and datasource is dataset. Everything is fine no problem.
It has 3 coloumns, ID, Name, City. ID is PK Now I have rowfilter on dataset like this
dataset.tables(0).defaultview.rowfilter = "Name Like '" + txtName.text + "%'" everything is fine till here. it show selected records. now, i have another text box on form which ask for id and search id in datagrid like this dim dr as datarow = dataset.tables(0).findbyid(cint(txtId.text)
in above case if id found then it will dr with row. which is fine. the question is how i can find if current row is in list or not because of filter on dataset.table
I have a datagridview in my application with numeric columns and date column. This datagridview is filtered by date. I want a label to show the sum of the filtered rows.
View 4 RepliesI have a datagridview bounded to a bindingsource (that is, in turn, bounded to a dataset that is the data origin of the project) and a bindingnavigator to a Access table, all of this done with the visual designer of Visual Basic .net 2005. I want to print in a crystal report the rows shown in the datagridview after filtered using the .filter property of the datagridview. But, to achieve this, I need to get the filtered rows in a dataset, and I haven´t got this in any way. If I pass to the crystal report the main dataset origin of the project, it will print all the rows, not only the filtered rows. I would have figured out that there would be a .getfilteredrows or something like that in the bindingsource object, but there isn´t. I managed to get this manually, through a loop, but I can´t believe it is the solution experts use.
View 7 Repliesi have one fill box and 2 radiobuttons in my form. I also have a database in which I have a table with names of workers, their smoking and marital status. My aim is to choose from radio button 1 if worker is smoking (yes or no) and radio button 2 if the worker is married (again yes or no). According to the selection, the list of workers matching with the selected criterias should be shown in the listbox1. Here is the code I wrote and I do not know how to complete or correct:
[Code]...
i databind combobox with datasource ,set display member=name and value member=id....insert into datagridview and then id value are stored in database that is ok.actualy i want to display name in datagridview, not id and insert id in database ,not display name
View 1 RepliesIm writing a simple VB program that connects to an oracle DB which retreives and inserts data to a table I created.[code].....
I want to be able to search through a table I have created to store all the information.Rather than just searching for one variable which would be easy to do, I want to give the user the option to filter out the search from the form.So say the user hits "Find", they would be given access to 10 comboboxes, they would select the information they want to search for (They do not have to select every box) and then click "Do Find".Then the form would display all the results of the query in the form.
Ok this is a hw assignment like always....just not sure on how to do the math on this form...the constants are declared for the registration fees and i did the same for the required days at each work shop i just need to find a way to multiply the days required at each workshop by the lodging fees. but i also need to display the lists of costs so its pretty complicated.
View 6 RepliesI have two lists of strings. One is a list of all students in a class and the other is a list of students in the class that completed an assignment. The two lists are part:whole. So we have two loops for copying elements and displaying them in a list box for only the students who did submit.
Dim f As Integer
f = 0
Dim h As Integer
h = 0
While (usersinclass.Count > f)
h = 0
While (usersidthatsubmittedassingments.Count > h)
[Code] .....
What I need is the remaining portion of the "usersinclass" list. (i.e. The students who did not submit). I tried an Else statement BUT with nested loops, every element is guaranteed not to match at least once, so I was getting elements that shouldn't be there. So, is there anyway to run the given lists against each other again to pull out the remaining students? (preferably with no repeats).
I am trying to write a program in VB2008 Express. I originally wrote it in excel, but I want to add some features and make it a standalone executable. the program is ideal for a spreadsheet application though.
essentially, there are two input tables. each containing about 6 columns and maybe 10 rows. I assume that could be handled by arrays. the output would be a continuously updated table of output based on calculations using the data from the two input tables. the output table would be about 4 columns by up to 1000+ rows, and would need to be recalculated and displayed each time any data in the input tables has changed.
first, are arrays sufficient to handle this? would databases be more appropriate?
second, what's the best way to display a long list of output, that has a user defined length and is continually updated. it would also be nice to have the ability to click on an individual cell (or value) in the output and have more code executed.
is there a way to incorporate a spreadsheet like tool for this as a backend? I want to make sure i'm using the most efficient approach before i invest too much time.
i know how to write a code to display data from the database into a datagridview, and i know how to use text boxs for uplying chnages on the database and directly display them in the datagridview, but what i want is to be able to aply changes without using textbox but directly the datagridview, so the user will be able to see that data on the datagriedview and insert his data in its field and update other and when he saves it will directly effect the database.
View 2 RepliesI am doing project now.i am a beginner for vb.net. I display data from ms access database to datagridview.Now i want add Button in Datagridview in one coloumn and when i click the button it will display the particular record and i want to display the diagram for that data. I am using filter.but it doesn't work.my code is
[Code]...
Does any one know how to search a Database with TextBoxes and button and display it on a DataGridView.I've already got the Data to show in the DataGrid, but with 6000 rows now I want to Filter or search the view.
View 8 RepliesSay I have three lists containing multiple objects. Lets also assume they each contain the same number of items. [code]...
Now say I have a dataGridView that I have defined as having three columns. Is there a way to assign the contents of each of the lists to each of the three columns (e.g. column 1 = myList1, column 2 = myList2, etc.) without iterating through each of the lists? I know I could define a dataTable, create the columns, and iterate through each of the lists...then associate the dataTable to the dataGridView's dataSource. However, I don't want to iterate through the lists since in my real application, these lists are large and the iteration would take too long. I'm just wondering how to assign these lists to a column in a dataTable in bulk.
I wish to read a web page that had various frames and div elements.To start with I would like to create a routine that justs lists all of those elements values and then display each element name and its value so I know what I have and how to reference it later on.I have been using the WebBrowser control and have managed to do a few basic things so far like go to a website and auto login.
View 2 RepliesI need to display an two-column editable grid not bound to a database. I took a look at ListView with Mode=Details, but it appears that only cells in the first column can be edited. I then took a look at DataGridView, and am having two issues:
1. When editing a cell, it adds a new row: [url] How can I prevent this?
2. I don't like the grey background and would like the grid to fill the whole space, right and below.
BTW, if you know of a good tutorial on using the DataGridView unbound, I'm interested. [Code]
I have a couple drop down lists connecting to an Access database. I can get the first drop down list to populate with the departments I have listed under "dept" in my access file. After someone selected a "dept" i want the second drop down list to populate with the names ("name"). Right now the second dropdown list is showing up but isn't poplulating. What am I doing wrong?!? I would like to include a third dropdown list for another selection with a button to then show things from the specific selections. Right now, I just need to figure out how to populate a list upon another lists' selections.
View 1 RepliesI have two lists. One list is a list of names, the other list is a list of how many times each name is found in the first list noted in the database
so...
Nick
John
Jim
Jack
is the firs tlist
10
13
13
2
is the second list. Nick had 10, john 13 and so on.I want to sort the second list from large to small, but have the index for the first list still linked to the correct amount of calls.i do it this way so I can
for x = 0 to num_of_names
string = lst_name(x) & "-" & lst_count(x)
next x
I've got 2 RTB one is for input of text and one is output.The output one needs to read the words from the input and display it alphabetically and with their line numbers.I have partly done it and it currently reads it but here is my problem When the words are outputted let say for example there are 2 words the same on the same line e.g the word 'you' appears twice on line one,at the moment its coming up like this
[Code]...
When .Clear() is invoked, is the memory freed up that was allocated when all of the items were added? I need to load several lists of codes from a database depending on the import selected by the user. Each list of codes will be a List(Of String). My idea is that I will load only small strings into a List(Of String) along with a List(Of <class>) for the data I will be validating and manipulating. When I am done, I want all of the data from the Lists to be purged from memory. Will .Clear() take care of that or does the memory still remain allocated and have to be dumped by the OS once memory gets full? (And, incidentally, what causes the OS to decide which memory blocks to dump? FIFO concept?)
There are so many lists, I'm not sure if I just want them sitting in memory or not. Granted, the lists will just consist of a single string value for each code pulled from the database. So there won't be a ton of data, so maybe I could just load all the validation lists at the beginning of runtime and only worry about purging the data List since it will contain between 35-50 "fields" per record and there will be a couple thousand records each import that is run. I don't want my program to actually cause a hit in performance in the long run. I ultimately don't see a problem because I won't be running millions or even hundreds of thousands of records at once, but I just want to be sure.
I have a datagrdview with a large number of columns, but I want to always display it showing the most right handside data columns, as if the horizontal scroll bar was set to the far right - how do I do this?VB2005 starter
View 3 RepliesUsing VB.NET 2008. Am using Datagridview in my application, Datagridview should display according to the windows screen size, Before I used vb6
code.
Private Sub Form_Resize()
On Error Resume Next
[CODE]............
Am new to vb.net, How to set a datagridview size according to windows screen size, In Datagridview property itself any option is available or i have to make a code as like vb. If i have to make a code, how to give form_resize in vb.net.
I know how to check whether an item exists in a list using (MyList.Contains), But I do not know how to check the whole list. For example (use one button and one richtextbox):
[Code]...
i have a dgv populated from a csv file and i am filtering the dgv further and exporting it to the excel. But my problem is it is exporting all the values from the original dgv not from the filtered dgv. I am using one dgv and 2 buttons in my form. When I click the button 1 my dgv gets filtered . when i click the button 2 it must export the filterd dgv to excel but it is not in a way as it is supposed to be instead it exports the unfilterd dgv (all the values from the dgv)
[Code]...
I am using axspreadsheet to view and edit excel files. In that I need to get the auto filtered (only visible) rows from axspreadsheet.
View 1 RepliesI start by looping through a string array, parsing out the strings I want and saving them to a temp table (I believe this part is working).Then, I take a DataView of the tale to get only the unique values from the rows.Then, things get messy, I need to get these unique values into my dataset. I been trying to do so using the DataView and also by passing the View to a new temp table then looping the values into the DataSet
View 1 RepliesCode:
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
If Me.ComboBox1.SelectedIndex >= 0 Then
' get new owner owner = Me.ComboBox1.SelectedItem
' apply filter to C1Schedule's data source (show only current owner's appointments)
[Code] ....
I have it filtering results based on which doctor I select. I also have a "SHOW ALL" item, how would I get it to actually show all the appointments regardless of doctor? Put it all in an if/then statement and check to see if the selected index of the drop down list is the SHOW ALL option? I'm not sure how to programmatically get it to show all though. It actually shows all the appointments (without filtering) as soon as it's opened, it only filters when I want I just need it to go back to unfiltered when I pick SELECT ALL.
I tried every combo I could think of to get it not to filter the results when I select SHOW ALL, but none have worked.
If Me.ComboBox1.SelectedIndex >= 0 Thenfilterelseme.ComboBox1.SelectedIndex = -1
If Me.ComboBox1.SelectedIndex >= 1 Thenfilterelseme.ComboBox1.SelectedIndex = -1
I don't know how to get it back to -1. The drop down list is populated with three doctors, and I added the string SHOW ALL, so as far as I know the index starts at 0 and would start with SHOW ALL. I tried an ElseIf me.combobox1.selectedindex = 0 then me.combobox1.selectedindex = -1 too and that doesn't work either.
I'm using a bindingsource to bind a dataset to a datagridview. Normally I would use a dataview to sort and filter the data, but since a bindingsource can also do this, I figured I would not need a dataview anymore. But I'm not sure how to get certain data from the filtered source. I know I can get it from the datagridview, but I'm not loading the entire dataset into the datagridview. I guess I could and then just make the columns I don't need be invisible. Or I could go ahead and use a dataview also, but that seems redundant. I was wondering if there is an equivalent to this code to get a specific item from a dataview, but pulling it from the bindingsource:
tbCode.Text = dv.Item(m_recno).Item("CodeNo")
As long as I'm not filtering the data, I can get it from the dataset, but when it's filtered, the indexes won't match.
[Code]...
I don't know how to get it back to -1. The drop down list is populated with three doctors, and I added the string SHOW ALL, so as far as I know the index starts at 0 and would start with SHOW ALL. I tried an ElseIf me.combobox1.selectedindex = 0 then me.combobox1.selectedindex = -1 too and that doesn't work either, so I'm obviously doing something wrong there.
A brief about the foundation of the program: I have created a VB2010 Windows Form application that connects to a Microsoft Access database. A datagridview is used to show all the data of the database. Then, a filter is used to filter the dataview (the BindingSource actually) and show the filtered db's data.
Let's say this is how I filter my BindingSource:
MyBindingSource.Filter = " price > '110' "
This would cause the dataGridView to filter the data (correctly), and let's say 10 rows are now displayed. What I am trying to do now is to get the sum of the values of one column of these new data. For example each of the 10 rows have a 'price' column which contains a double value. I would need the sum of these *filtered* values.
I found on the Internet that I may be able to transform the BindingSource into a DataTable and I could, but now I don't know how to access the values inside this!
