Here's the issue I'm having:
I have a filtered bindingsource bound to a datagrid. The datagrid fills and displays the data correctly based on the filter criteria.
The problem comes when I try to access the data directly from the program. It returns data, but only as if the filter wasn't there at all.
The count function returns the proper number of records.
[Code]....
I have a filtered bindingsource bound to a datagrid. The datagrid fills and displays the data correctly based on the filter criteria.
The problem comes when I try to access the data directly from the program. It returns data, but only as if the filter wasn't there at all. [code]...
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 RepliesOk simply my code doesnt want to output the correct number. I'm working on the project euler probems to expand my knowledge in VB.net and the current question I am working on is asking to work with triangle numbers. while researching I found that a triangle number can be calculated by using the formula:
[Code]....
I have a question similar to this one, but reading the (accepted) answer didn't give me much insight, so I'm hoping to state it more clearly and get a clearer response back.
I'm attempting to insert a data row into a table. I'm using TableAdapter's custom "insert nonQuery" that I wrote (it works, I tested) to accept some parameters. I'm fairly new to this business of communication with a database via .NET and what I'm doing is probably wrong by design. My questions are why is it wrong and what's the right way to do it? Both are equally important, IMO.[code]...
I'm using the TableAdapter to Insert rows into a database, when I use execute from the Query Builder, the line gets entered into the database, when I enter it via Form button, it doesn't get entered to the database using the same commands.
[code]...
I am pulling a date value from my database:
Dim qfresho = From p In dbConfig.Configs _
Where p.Description = "FROD" _
Select p.dateValue
Dim qfreshc = From p In dbConfig.Configs _
Where p.Description = "FRCD" _
Select p.dateValue
Then comparing these date values to the current date:
[Code] .....
But for some reason its always returning the Else condition - even though the values in the database should make the query true. I'm guessing for some reason its not pulling the results as a date?
I have a TableAdapter created where one column.identity is set to true with an autoincrement.My problem arise when trying to insert a row at run-time. The following is my code and the error message I am trying to over come.[code]"The column cannot be modified. [ Column name = RecordNumber ]" I am not trying to edit that column name. I set it to true identity so I don't have to keep track of record numbers that may be deleted later on. So basic question.How do I programatically add a row to table adapter that has one column.identity set to 'true'.
View 2 RepliesI have a strongly typed dataset that has rows with duplicate [sopnumbe] I am looping through them and displaying row data I want to only display the Distinct sopnumbe rows in my initial loop1.. but the sub loop uses the data out of all rows.. So I cant filter the actual dataset.
[Code]....
I have a table with several rows of data that I need to return to the controller. In my view, I initially load the table by selection of a time period and clicking a button. The table loads all my relevant records but one of my table cells contains a dropdown list. So I should be able make a selection in the dropdown click "update" and my controller saves the changes.
So everything works until I try and save. The model that is sent to the controller is completely null. The list property I have tied to the table cells returns to the controller null.
[Code]...
NOTE: This is written in VB.NET but C# help is welcome. I am familiar with both languages in MVC.
how to open an excel file and number the rows. The xls file is just a simple 2 column file with 5000 or so part numbers in column B. I need to open it, add numbering to the rows in column A ranging 0 thru 9, then start over at zero again.
i.e.
0
1
2
[Code]....
I have an XML file that is being updated via ASP.NET. The user should be able to add new nodes to the XML file AT ANY LOCATION in the node tree.
The XML file is read into a DataSet using DataSet.ReadXml(filename).
A new row is added to the appropriate DataTable, using InsertAt(row, index).
I have confirmed using a DataGrid, and using a loop (For Each dRow in Table, Response.Write..) that the new Row was inserted into the table at the correct spot (in my example code, the 3rd position).
However, The WriteXml() method is writing the node to the END of the XML tree! I can't get it to see the tree with the node in the correct location.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim sXML_Lesson As String = "test.xml"
[Code]......
I have an ASP.NET web application (VB.NET) using an Oracle database. On an insert, I need to get the identity of the inserted row back. I am trying to use RETURNING, but I keep getting a value of 1 returned.
Dim strInsert As String = "INSERT INTO L.TRANSACTIONS (LOCATION_KEY, TRANS_CREATOR, TRANS_EMAIL, TRANS_PHONE) VALUES (:location_key, :trans_creator, :trans_email, :trans_phone) RETURNING TRANS_ID INTO :ukey"
[Code].....
My brain may just be fried since it's the end of the semester, but my teacher kicked this back to fix and resubmit...she said that I am "returning the name of your function rather than your variable name".
Here is my code for all 3 forms.
code:
These are forms to calculate the cost of getting a cell phone package.
Is it correct to correct properties values on the fly? for example: (note the .ToLower)
Public Property X() As String
Get
Return _x.ToLower
End Get
[code]....
i'm working on a system that upgrades a basic version to a proversion but i have a payment gateway . it generates a code in an SQL DB.now i have a form in VB that has a textbox and a button how can i let VB connect to my SQL DB receive the code and then check if that code is correct and if its correct download silence the pro file. from an url.
View 7 Repliesi 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]...
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 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 have created a basic query generator which allows a user to select the Select, WHERE and criteria attributes using a number of checkboxes.However i have got stuck. In the results form i have the following code
Private Sub DisplayRecord()
RichTextBox1.Text = ds.Tables("newResults").Rows(intCurrentRecord).Item(0)
RichTextBox2.Text = ds.Tables("newResults").Rows(intCurrentRecord).Item(1)
RichTextBox3.Text = ds.Tables("newResults").Rows(intCurrentRecord).Item(2)
[code]....
The program keeps on crashing if the user does not select the corresponding amount of display records from above for the amount of attributes they want for the SELECT part of the query in the intreface in form 1.
How would i go about making something where the number of SELECT attributes selected which are listed in a string create the correct number of textbox fields in the results form (form2)
i 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 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!
[Code] It captures a frame of LiveVideo every some miliseconds and shows them simulating the filtered video, this is working fine but I don't know how to copy the filtered frame from VidProce to a new picturebox, I tried this but doesn't works X.Image = VidProce.Image. any idea or another way to filter the pictures?
View 7 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.
I have an application with a "filtered" DataView. The Dataview is bound to a form through a CurrencyManager. The problem is that when I add a new record using CurrMgr.AddNew(), and then use the CurrMgr.EndCurrentEdit() before saving the new record, the currency manager will point inmediatelly to the last record. How can I ensure the currency manager stays in the new record?.[code]
View 4 Replies
