Shared Dropdown Datasource Updating?
Aug 15, 2011
I have a goal to have dropdowns populate using a string array as the datasource. Re-binding works well in the dropdown event, but if I make a change to a currently selected line item it won't change until I make the box dropdown again. Is there a way to keep this updated without re-binding the data?
Also, this is one of several dropdowns on an MDI child form. I'd like to make sure they're all synced. For instance if one has "Bob" selected and I change Bob's name to "Chris" I need all the "Bob" dropdowns to change to "Chris". Is there a way to do that without having to cycle through all the windows and call a rebind function?
Finally, I want to know if there's a better way to do it than the way I'm doing it. Since all these children have to be synced, the MDI parent holds the String array as a public property and the children each leech off of it.
View 1 Replies
ADVERTISEMENT
Jan 22, 2010
I have a dropdown where the items initially are filtered (using a SQL Datasource) based on the selection of another dropdown; however, I have included a checkbox where if checked, the dropdown needs to populate with all data from another datasource How do I programatically remove a datasource that is bound to a control and then define another?
I have the following code, but it errors:
If cbOverrideArea.Checked Then
Me.ddArea.Items.Clear()
[code].....
View 3 Replies
Jun 14, 2009
I gather MATTER NUMBER and PATENT NUMBERS in a listbox on a dialog form - that I pass to the main form after the dialog closes.I then ask for CASES on subsequent dialog forms and want to have drop downs for MATTER NUMBER and PATENT NUMBERS that "have the suggestions" of what was entered in those list boxes earlier.So - I've been using DATASOURCE for binding to datatables and thought to myself - heh - I can probably set the DATASOURCE of the DROPDOWNS - and it works!
Public AddMatterNumber As ListBox
Public AddPatentApp As ListBox
MatterNumber.DataS
[code].....
View 2 Replies
Mar 27, 2008
I'm trying to make my datagrids datasource change when you select a particular item from a drop down menu but all I get is blank cells! any ideas? I don't think it is changing the colums property automatically either.
If chooseType.Text = "Add / Edit Players" Then
updateDB.DataSource = PlayersBindingSource
[code].....
View 1 Replies
Sep 23, 2011
I have this controls
ComboBox: list of myobject
TextBox: view a description
DataSource: list(of MyObject)
MyObject:
property id as int
property combodesctription as string
property description as string
What I want: I set the datasource of combobox with list of MyObject when I select a value on combobox, I would like see description in TextBox is it possible bound text property of TextBox to same datasource of combobox or it is possible change description of TextBox only with changedEvent of ComboBox?
View 2 Replies
Oct 22, 2009
Visual Studio 2008 Express Edition.I have a have a DataSet, created from (part of a) Access database. I have tow tables in it (say A and B). When I change something in table A, I need to get data from table B to complete table A.My approach was to use the RowChanged event inside a (Partial) Class of table A. For that to work however table B needs to be shared. (I don't like to refer to an instance.) I got it to work by changing the DataSets designer code, but don't want to do it all over again when the code is regenerated for some reason. So: would there be any way to have these tables shared by default?
View 3 Replies
Aug 15, 2011
I have inherited a database that is moving to the web. Problem is that some of the string fields have html characters....
One example is....
"" without the quotes, IT WON'T SHOW UP IN HERE EITHER, trying something else. At any rate it has < and the > signs with text in the middle.
How can I escape any possible combination of html references.
SelectCommand="usp_getSingleStringData" SelectCommandType="StoredProcedure"
<SelectParameters>
<asp:SessionParameter Name="shrtText" SessionField="shrtText" Type="String" />
[Code]....
View 2 Replies
Mar 9, 2011
I've got a VB2008 application that can potentially generate a table with up to 540 columns. The table is then used as the DataSource for a DataGridView. With column counts in the hundreds the processing time can by over a minute. With all this in single threaded Form code the UI locks up until the DataGridView is loaded. I've taken time stamps of the process to find out where the majority of time is spent.
[Code]...
View 1 Replies
Apr 19, 2010
I'm learning some more VB in my spare time, and I'm making a simple customer database that uses SQLCE. I've got the datasource set up and all that, but for some reason when I hit accept on the form, nothing happens?
[Code]...
View 3 Replies
Jan 4, 2012
I have a wingrid that is bound to a datatable. I create a new asynchronous thread and from that thread make a remote server call passing the datatable. When the server call is completed the wingrid automatically refreshes to show any changes. However, since this is not being done on the main UI thread of the program, we will often get an error where the control goes whilte and a big red X appears in it.
Is there a flag to set the wingrid to not automatically upate when the datasource changes? I would like to turn it off before the remote server call and turn it on again after I am back on the main thread.
View 2 Replies
May 10, 2010
I have setup a datagridview with one column as a combobox and bound to a dataset.
However, during runtime I want to refresh that column to show the changes. How do I do that?
View 3 Replies
Oct 13, 2011
I'm writing an app that pulls information from a DataSet as a one-way thing (e.g. the datasource populates a listbox, but for selection purposes only -- the user cannot change the list values). My problem is, when I select something from the listbox, all of the other listboxes change too, as if the control is telling the others "Update your contents to display what is in row 5"
[Code]...
I then use the IDE to bind lstOne and lstTwo (both listboxes) to datInfo, and use the DisplayMember to bind lstOne to colOne and lstTwo to colTwo.When I run and click on a value in one listbox, the other one follows suit. For example if I click on "One Three" in lstOne, lstTwo displays "Two Three". I expect to click on "One Three" then be able to independently set lstTwo to "Two One"
This seems counter-intuitive, so is there a way to do what I'm after from the IDE, or will I have to do it all from code?
View 3 Replies
Sep 28, 2009
I would like to know the best, or standard, way to accomplish real-time client updates in a small multi-user application using an access data table as a data source.Specifically, this application will be used by 3-4 people. It uses a datatable which is filled on form load and bound to a datagrid at design time. The datatable is stored on a shared drive. The data table on the shared drive is updated in two ways:
1) Users can update the datagrid which then updates the datatable on the shared drive via the data adapter's Update method.
2) A server application does some work on some text files, periodically updating the data table.
I need the clients to reflect the changes to the data table on the shared drive as closely to real-time as possible. I know that the data table stored in memory on the client is disconnected from the data table on the shared drive, so I must query again to get the updates.
1) Is there an alternvative model I can use which is connected, and which will automatically reflect the updates in the data table on the shared drive?
2) If not, what is the best way to check for changes in the data table (so I can know when to call the data adapter fill method)? I am planning to poll the drive for a change to the .mdb file, raise an event and then fill the data adapter when the event is triggered. I am using this method successfully now to check for changes to a text file in another application, and I know how to implement it?
View 1 Replies
Sep 28, 2009
I would like to know the best, or standard, way to accomplish real-time client updates in a small multi-user application using an access data table as a data source.
Specifically, this application will be used by 3-4 people. It uses a datatable which is filled on form load and bound to a datagrid at design time. The datatable is stored on a shared drive. The data table on the shared drive is updated in two ways:
1) Users can update the datagrid which then updates the datatable on the shared drive via the data adapter's Update method.
2) A server application does some work on some text files, periodically updating the data table.
I need the clients to reflect the changes to the data table on the shared drive as closely to real-time as possible. I know that the data table stored in memory on the client is disconnected from the data table on the shared drive, so I must query again to get the updates.
I have two questions:
1) Is there an alternvative model I can use which is connected, and which will automatically reflect the updates in the data table on the shared drive?
2) If not, what is the best way to check for changes in the data table (so I can know when to call the data adapter fill method)? I am planning to poll the drive for a change to the .mdb file, raise an event and then fill the data adapter when the event is triggered. I am using this method successfully now to check for changes to a text file in another application, and I know how to implement it
View 5 Replies
Sep 3, 2009
I have a list of servers in the first dropdown. I want to get list of all databases in the second dropdown depending on the server selected in the first dropdown.
For this I need to query each server while selecting the server.
View 1 Replies
Jan 30, 2011
I use vb.net and windows form and sqlserver
I added Data Source(Microsoft SQL Server (SqlClient)) to my project. and now I need to change it to ODBC Data Source .
View 1 Replies
Aug 25, 2011
I have a class like this:
[Code]...
It works, when I make getBar methods public, but I don't want to expose these unneccessarily. Why I can't call private shared methods from a public one in the same class is over my head. I'm using .net framework 4.0 in a web application.
View 1 Replies
Mar 30, 2012
I've taken over the maintenance of the website (ASP.NET VB) and on one particular page I noticed the below code
Inherits System.Web.UI.Page
Public Shared UserNumber As String
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
[Code]....
My question is whether the variable UserNumber can be accessed or changed by any other user than the current one?
View 2 Replies
Aug 12, 2009
Given in the following language specification, for me at least, calling Db.Foobar() [In the following code] does not indeed call off to the Shared Constructors of the base classes. I am curious as to a) is this my own fault for doing something wrong or b) is this an error in the language specification[code]...
View 2 Replies
Jan 14, 2011
I seem to be drawing a blank. I'd like to create a "shared" variable that is shared with all instances of a class but not classes that inherit from it. For example.Class A: Shared list As New List(Of String): list.Add("A")
Class B Inherits A: list.Add("B")Class C Inherits B: list.Add("C")The end result I'd like is that any instance of A has just A in the list. Any instance of B has A and B in the list. Any instance of C has A, B, and C in the list. I can accomplish it by creating Instance variables, but I have to construct the list for each instance of a class. I'd like to construct it once for a specific point in the Hierarchy and then share it accross other instances of that class.
View 12 Replies
Jun 4, 2010
I am trying to add shared members in derived classes and use that values in base classes...
I have base
class DBLayer
public shared function GetDetail(byval UIN as integer)
dim StrSql = string.format("select * from {0} where uin = {1}", tablename, uin)
end function
end class
[Code]..
currently there is error using the tablename variable of derived class in base class but i want to use it i dun know other techniques if other solutions are better then u can post it or u can say how can i make it work? confused...
View 2 Replies
Jan 25, 2012
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.
View 1 Replies
Dec 16, 2009
is there a difference between shared events and non-shared events?
Private Shared Event EVENT_something_changed()
Private Sub SUB_handles_something_changed() Handles Me.EVENT_something_changed
End Sub
no errors with this code, but how is Me possible since the Event is shared. it seems like there's no errors between switching shared with un-shared and switching Me with Myclass, all 4 combinations seem to work, isn't that weird
View 18 Replies
Nov 26, 2011
I want to fill a dropdown in the pageload by using a BLL and DAL class. This is the code
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
dropBrand.DataSource = BLLManufacturer.selectManufacturers()
[Code]....
The first dropdown fills up with brands as it is supposed to do, but the second does not. The second dropdown needs to show car models by the chosen brand in the first dropdown. However the dropBrand.SelectedValue always returns 0 whatever brand I select. Without the convert toint16 it doesnt work either nor with convert toint32 or toint64.
View 1 Replies
Dec 28, 2009
I am limited for space on my form. Is there a way that I can have a textbox act like a dropdown? So the form will show as one line. If the user starts typing multiple lines then it opens the drop down so they can see what they have typed. Will it have all of the same goods as a textbox, like copy and past? When they are not typing then it will be closed and only showing the first line.
View 3 Replies
Oct 14, 2009
I have been to internet hail and back trying to figure out what Im doing wrong with my combobox cells and columns.When I add items to the cell using .item.add("something"), othing shows in the cell. I can add 5 items and nothing shows up. No dropdown and nothing in the cell. In debug, I can stop and look at the cells value and see that n-items where indeed added but yet, they dont show up on the screen in the DGV.I have a DGV and I have tried this 2 ways.. creating the columns in the form designer and by adding the columns in code.Heres a snippit of the datagridviewcomboboxcolumn (thats a lot of typing) anyway.. this is the def for it and the surrounding columns:
Dim conx_text_col As New DataGridViewTextBoxColumn
conx_text_col.DefaultCellStyle.BackColor = Color.Teal
conx_text_col.DefaultCellStyle.ForeColor = Color.White
[code].....
View 8 Replies
Jan 4, 2011
I have created a sub that I am using over and over again. However, I am not able to get the values from the database. Screen shots and code attached. I need a second pair of eyes, can't seem to figure out what is wrong.
Form Load
vb
'Populate the drop down lists
PopulateDropDownListFromDB(cboReferrerType, "ReferrerType", "ReferrerName")
[Code]....
View 3 Replies
May 11, 2011
I have a large VB/SQL application that I have created a problem in. I have a table of procedures that have an active flag on them. This flag can be toggled through a user screen. Other screens access this same table to populate dropdowns. The values are stored in the table as the ID field (PK). The problem I have is that I am selecting the dropdown values based on the Active flag. If I select a record that has a procedure stored in it that has been made inactive, I get the old Object Not Set to an Instance.... error.
What I want to be able to do is check for the value in the record when populating the dropdown and allow the record to be displayed by bypassing the SQL error and just showing the dropdown value as blank while not altering the record itself. I hope I'm making sense. Code is below.but I'm back in app programming after being a SysAdmin for 20 years and I'm still rusty.[code...]
View 1 Replies
May 19, 2010
Create a membership database that has fields for title, first name, surname, address, subs renewal date and membership type (active, social, honorary or life). Make an interface that allows a user to display, sort and create records. Consider the use of drop down boxes to aid error free input.
When i add a new datasource i get to "Select database objects" page and then i get an error message. "Could not load "Microsoft.etc"", im using an access database with pre-created fields.
View 1 Replies
Jun 4, 2011
I cannot add data source in my window applciation;...There is no menu for me to add a new datasource.
View 8 Replies