I am using a Dim All_PriceLists As System.Collections.ObjectModel.ObservableCollection(Of BSPLib.PriceLists.PriceListPrime) where PriceListPrime implements Inotify for all properties in it.
I bound the All_PriceList to a datagrid as DataGrid1.ItemsSource = All_PriceLists but when I do All_PriceLists=Getall() where Getall reads and gets the data from the DB, the datagrid is not updating.[code
I am creating some user controls in vb using winforms. I ran across the observable collection and INotifyChanged events and was wondering if this type of action was available in winforms As I understand it, the observable collection is a WPFapplication, but it would be nice to use this type of functionality in a winform as well.
View 6 RepliesI'm still teaching myself how to bind and use observable collection. One problem that I'm a little confused on is binding multiple classes/observable collection to one page. In other words, if I have a PersonName class and a AnimalName class, I have to create two separate observalbe collections for each? How would I set the datacontext when a page only allows one?
[code]...
Now If I add another class, how would I combine the two on the binding part and collection part.
I've been working on this problem for a while and I'm clearly missing something...I create, populate and bind an observable collection like so:
Dim _ObservableWEI As New ObservableWEI
...
_ObservableWEI.Add(New WEI() With {.WEInum = 1, .WEIvalue = 1})[code].....
The problem is the filter effects the contents of both listboxes. I guess I need a specific instance of the collection to apply the filter too or something
I will be doing an MVVM Project soon and I'm working a couple tutorial/examples out. How do I take the following code and connect it to a database. If I were to have a datagrid, how can I change information in the datagrid and have it automatically update? I'll be using MS SQL.
[Code]...
I have my datgrid's itemsource binded to a observablecollection. Every 5 secs my client app resceives a list from the server which i use to update the observable collection. The problem is that when it updates the grid seems to reset (if details is open when i update the details collapses, if i have an item selected it will un-select)
Here is the code that i am using to update my observable collection:
Private Sub creategriddata()
Dim svc As New ServiceReference1.Clientthing then re-adding
How to sort items in ListView by column bound to an Observable Collection ?I've looked all over the place and I can't find anything easy enough or simple on this.
View 2 RepliesI have a WPF ObservableCollection which is bound to a ListBox and I have a Sort() method which when called will convert the ObservableCollection to a List(Of T), and undertakes a sort based on a date/time column within the collection.
The data is sorted, even when new items are added to the ObservableCollection, however the date/time isn't being correctly sorted. The data is sorting based on the date however it is very much random when it comes to the time portion. The following is an example of the outcomes I am experiencing:
[Code]...
Is there anything that I am doing incorrectly in this method that would cause the time portion not be included in the sort? Is there a better way of doing a sort?
I have a webpage with a form that is used to edit some object. This object contains a Collection of other objects defined like this: Public Overridable Property Employees As List(Of Employee)
On a form I can delete an employee, add a new one or modify existing one. When I click save new values are sent to the server. On a server I check if the user exists. If exists then I modify its values, if it does not exist then I add it. All employees that exist on the server and were not sent are marked as deleted (State changed to EntityState.Deleted). I try to use the following code (dbCollection = database entities, newCollection = collection sent from the form):
[Code]...
This code does not work, because changing to EntityState.Deleted removes the object from collection, and for each loop breaks, since the collection is modified...I know that I can overcome this problem by using a for loop or adding objects to delete to some other list first, but I hope maybe there is a pattern that would make my code nicer.
I'm trying to update a value in.... errr, one of the variables in my structure (don't ask me to use the correct terminology because I don't know it). I'm doing this during a Select/Case ..
[Code]...
This is just an example, I've stripped out most of the real code. Anyway, the point here is that when I set Client.SendPhase to 999.... then next time I come back to this loop it's still set at 0. Why doesn't it retain the value I've given it?
I have a datagridview that I am binding to a collection. What I need to do is process each object in the collection (send quotes to our customers), and then display the items status in the grid. Then once the collection is completely processed clear the grid of items for the next round. I am binding to the collection with .DataSource = collection.
My Question:What would be the best way to update the grid as the collection is processed one object at a time.Initially I had thought about storing each item in a database table and then bind the grid to the table. Then as I processed each record, update the record and rebind the grid. The problem I had with that method was that I would be constantly writing and deleting data from the same table. That seemed unnecessary vs just using a collection and updating the collection.
I am creating a POS system, but there are a couple of things that I cannot get my sales form to do. It contains a datagrid view of the table containing columns code, description, Qty, total. After the code has been entered, I want it to load the description automatically. After the Quantity has been entered, I want it to give the total amount for that Item + the total amount for this order.
[Code]...
I am a newbee to the programming. So please guide me if i am wrong. up to binding of the datasource my programe working perfect but during save button it gives error.(Value can not be null. Parameter name : daatTable)
[Code]...
I'm having a database, using GridView I retrieve the data into my WEB application.Then I set the rows to editable (not sure if it is fully completed) and when I edit some cells I want to update the GridView AND the database behind.When I click on 'edit' then the button is changed to update. I get some unhandled exception. I don't expect anything else since I didn't put any code in the update methods like RowCommand, RowUpdating, RowUpdated, RowDataBound.
View 4 RepliesI have a datagrid that I use to display data from a SQL 2000 table. I am trying to write back any changes the user makes to the datagrid data back to the original table but don't know the proper method to do this.
Here is the code that populates the datagrid:
Dim TheDatabase As System.Data.SqlClient.SqlConnection
Dim ConnectionString As String
Dim cmd3 As New SqlCommand
Dim Adp3 As New SqlDataAdapter
[Code]...
I could use some suggestions on how to code the write back command that will allow the user to change the data in the datagrid and have those changes be written back to my tAdjustment table.
I have a form with tabcontrols and datagrids in my accessfile I have 35 tables.I have set the datagrid to edit by enter and I use this code to update the tables:
View 7 RepliesI am currently stuck on a project where I am populating a datagrid from a series of labels and textboxes. I have that part down. Now for the part where I actually add it do the database, I am having a problem. It is actually adding everything to the database just like I want it but when it finishes adding the data from the datagridview, I am getting an error saying there are no values.
I have included the code I have been working with.
Private Sub btnsubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsubmit.Click
Dim I As Integer
For I = 0 To DataGridView1.Rows.Count - 1
[Code]....
I have a working data grid on my form which pulls the courses the logged in user has signed up for from my database.
[Code]...
However, i can't figure out how to do this:When a new course is added to the database, i need the data grid to 'refresh' or 'update', which will mean that the new course will show up in the grid automatically.
Currently, users have to restart the application in order for the new course to appear in the data grid.
I have a list of Active Directory entries (computer names) as a Collection data type. How can I add the computer entries and the pertinent columns to the DataGrid control on my WinForm? I have borrowed this code from some web site to add the list of computer to the pcList which is a Collection type.
pcList.Add(dirSearchResults.GetDirectoryEntry().Name.ToString())
I have a datagrid which is getting populated by two tables. I want to know how do i perform an update on these tables once the user tries to save any edited data. I am doing the following which i found in one of the articles online: [Code]
If objDataset.HasChanges()
Then Dim data_adapter As OleDbDataAdapter Dim command_builder As OleDbCommandBuilder fillSql = "Select [Price Info].[Product Quick Find ID] As
[Code].....
Not able to update the table in access using the below function
Private Sub btnUpdate_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnUpdate.Click
Dim cn As New OleDbConnection(Con)
Dim objUpdateCommand As New OleDbCommand
Dim objDataAdapter As New OleDbDataAdapter
[code].....
Im trying to update a datagrid and a text box value in access database. both shld be saved in the same row simultaneously, unfortunately its not happening. they were gettign saved in a different rows.
conn.Open()
sqlQRY = "Insert Into tblPlot(SurveyNo)"
sqlQRY = sqlQRY & "Values"
[Code].....
I have a bound datagridview when a editing a datagridviewtextboxcolumn and the end edit is called I use the tableadaptermanger.updateall(dataset) to update the db. All well and dandy but having a problem with a comboboxcolumn. The db is only updated after I have selected a new value from the comboboxcolumn and click on another cell in the grid. If I dont click on another cell the db is not updated. I have tried this code but no good:
[Code].....
How do I fire an event when changes are made in a datagrid embedded in my form? My datagrid houses line items for different forms (Sales Orders, Purchases Orders, etc.), and when a value is changed (i.e. quantity or price), I want it to re-calculate the datagrid automatically (extended amount) and also re-calculate totals in the form itself without having to hit the Save Button. Right now I have a sub-routine that fires when the button is chosen, but how do I fire this event automatically on datagrid changes?
View 7 RepliesI am trying to update a table based on row selected in a grid (C1TrueDBGrid1.Columns(1).Value), but I am getting the following error:
Update unable to find TableMapping['Table'] or Data Table 'Table'
Code:
Dim ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/DataDirectory/AOPT2002org.mdb;Persist Security Info=True;Jet OLEDB:Database Password=testaopupdate" Dim objConnection As New
[Code]....
"I've wrote a code that accesses data from MS SQL server in DATAGRIDVIEW in VB.NET.the problem is whenever i save the changes back to the database, changes are not reflected back
[Code]...
I'm trying to create a datagrid with auto generating columns. Let's say my Collection is a property named Articles of my viewmodel of type ObservableCollection<ArticleWrapper>.
I bind now the ItemsSource to this collection:
<wpf:DataGrid ItemsSource={Binding Articles} />
The class ArticleWrapper is like this:
[c#]
public class ArticleWrapper
{
public ArticleConfigurationSet ArticleConfigurationSet { get; set; }
public string Description { get; set; }
[Code]....
But now my problem: I want to bind the displayed data to my ArticleConfigurationSet property. But I cannot change my ItemsSource Binding, because the SelectedItem property of the datagrid must be of ArticleWrapper (for command handling).
The datagrid should also look like this:
While working with an excel file (.xlsx), the data I get from it is an IEnumerable(of Dictionary). When I bind this to my datagrid, I get the problem that I only see 2 columnsI've been tracing this problem and discovered that in the first row in the excel, there are only 2 values (cell C and D). I think the binding to datagrid looks at this first row to create its headers. This results in my datagrid only showing columns C and D.
View 1 RepliesThis VB.NET rookie is asking for the support of those with expertise. BACKGROUND: Form1 has a Datagrid, Dataset1 create by drag DB into datagrid. Form2 presents the record selected from the datagrid. Within the LOAD_FORM I search the DB with the Key and place data in Dataset2 (DS created manually)
CHALELNGE Record updated in Form2 is saved in DB fine and when Form2 is closed, record updated does not appear in Form1. I�ve tried the following but no sucess In form1 event Ive got the code to load data into the DS Me.TUSERSTableAdapter.Fill(Me.PTDataSet.TUSERS) FINALLY: What should I do to see the datagrid updated?
i have a datagridview that is pulling information from a access database. The tables being queried is called "History" I can pull data and update data with no problem, however if i edit the date field i get the following error "Syntax error in UPDATE statement" my code is below.pulling from access
[Code]...
