My project currently holds one dataset and several forms. In each form I have dropped an instance of that dataset and certain editors are bound to tables of that dataset instance. Now this means that when each form is loaded I also have to load the relevant data into the dataset instance of that form (basically i am loading the same data more than once).
[Code]...
I have two combobox, cmbCountry and cmbLocationI have dataset with 3 table, first table for Country value, second table with Location value and then I have table Apartments with IDCountry and IDLocation.I have 2 datarelation, ApartmentCountry, ApartmentLocationThen I bind the last table with cmbCountry and cmbLocation
View 2 RepliesLet's say we have a controltab with two tab. The first tab contains textboxs where entry values are entered On the second tab are textboxs that display the results. I have noticed that if I fill up the entry values and create the binding between each textbox and their property and then I destroy it (without clearing the textboxs), the textboxs of the second tab will not display any result. I have this exemple here BindingAddition.rar
[Code]...
I have a simple UI form with some controls (textboxes, checkboxes, datagridviews etc.)
The form communicates with an object that contains the values that should be displayed in the controls.
I have a Windows Forms which contains a whole bunch of different text items on TextBoxes, Labels, and ComboBoxes. I then catalog what is written in these Textboxes and selected in these ComboBoxes in XML files so that they can be reopened later. Because what goes into the Textboxes and ComboBoxes are physical quantities, they have units (for examples "Inches," or "Lbs," etc.) which are the text of the Labels themselves. Multiple quantities share similar units, so I don't allow the user to change each one individually, but instead change a unit globally (for example, all weights in "Kilogram" instead of "Lb").
The units themselves are Public Properties of a separate class which I named "MyDBClass". The properties raise events when they are Set, so that objects data-bound to them change as well.When I initialize the main Windows form, I instantiate a class of type "MyDBClass," set all the unit defaults ("LengthShort = mm," etc.), and create a databinding for the Labels to the "MyDBClass" properties (e.g. ctrl.DataBindings.Add("Text", MyDBClass, "LengthS") ). From then on, the only way the user can change the units is to use my MenuStrip and select "New" (which erases all text and sets the MyDBClass properties back to default), use the MenuStrip and select "Open" (which opens an XML file, reads the "Unit" elements in, and uses them to set the MYDBClass properties), or use the MenuStrip and select "Change Units" (which brings up a dialog with a handful of ComboBoxes containing possible units, and then sets the properties of the MyDBClass based on what the user selected in the dialog).
Having said ALL of that, I can finally get to the problem- one of my units ("SpringRate") does not change when the user selects "New" or "Change Units" from the MenuStrip. It will only change when the user opens an XML file. This makes no sense, as the act of opening an XML file calls the exact same code as selecting "New" from the MenuStrip (which is that is sets the properties of the MyDBClass). The label is also identical to its surrounding labels and the ComboBox which selects the unit is identical to its surrounding ComboBoxes (I tend to use Copy/Paste when working in Design mode). I even put Try->Catch blocks around the Property's Set code and the code inside the other Subs which calls it.
I seem to be having a problem binding the visibility property of a textbox to a database value using the advanced binding property.
I found this article (BUG: Inconsistent behavior when you bind the Visible property of a Windows Form control to a Boolean field) stating there is a bug in some older versions of the .net framework.
Does anyone know if this has been fixed in 4.0?
how to go about this? I have a form, frm1 w/a combobox, cboLocations, which is being populated using a sql string. There is also a frm2 w/a series of textboxes and other comboboxes. I want it so that once a selection is made from cboLocations, the textboxes and comboboxes on frm 2 are populated with the corresponding data. Here is what I have so far:
frm1:
Public Class frmLocations
Dim conn As New SqlConnection("Data Source=f03d3s-dev01; Initial Catalog=dos_track;User Id=vbuser; Password=tran3;")
Dim depot_refnbr As Integer
[Code]...
What's happening right now is that I make a selection from cboLocations on frm1 and click on the OK button, frm2 loads, but none of the textboxes are populating and one of the comboboxes, cboDepot, shows the different data when you click on the down arrow, but it's not displaying anything it its text field when frm2 loads.
In my application, I have created a dataset which is used as a lookup data and I have a couple of forms that use this dataset.
Generally, VS will generate a line of code that fills data into dataset using tableadapter when the form is loaded.
I have parent and child forms. In the parent form I've already filled the dataset and I don't want to fill the same dataset again and again every time I load a new child forms that use the same dataset. Are there any ways to do that? Or is it ok to fill the dataset for every form?
Can it cause any performance to my application?
I'm having a hard time to find out how to pass at run time a parameter which I defined in an adapter in a dataset. When I preview the data I can insert the value manually, but I was not able to find any code around how to pass it in the visual basic code.
View 2 RepliesI'm new to VB2008 and SQL Server. I have two forms (frmCustomer and frmDetail). The frmCustomer has a datagridview containing general data of customers, and a button to open frmDetail, which contains each customers detail information. All data modification is done on frmDetail (add, delete, and edit). Currently, both forms are binded to the dataset (same table). When the two forms are loaded, each form performs a FILL function that retrieves the data from SQL Server. In addition, all modifications done on frmDetail does not show up on frmCustomer until I perform the FILL function again on both forms. Seems like I'm maintaining 2 sets of data from the same table, and I think I'm doing more work than I have to. I'm sure there are ways to make this easier, such as bind both forms to a single dataset, so I don't have to do everything twice.
View 1 RepliesWhat I mean is that when I make queries on a Parent Form. Child forms can also retrieves the datatable /datarows from its parent form.
View 3 RepliesI have an application that uses bound controls on the form. I have a dataset associated with my form and have a custom query written for one of my tables that is supposed to get two fields in the database and order them by their ID in descending order. However, when I run the program, the bound controls do not contain the last record, but the first.
View 8 RepliesI have an XML file that has a basic hierarchical structure about horse racing. It has a summary of the tracks, some data about each track, then a list of all the races at each track racing that day. So lets say there are 10 tracks, and for each track there are 8 races. This is a snapshot of the data....
HTML
-<Meetings xmlns="" Jurisdiction="VIC">
-<Summary MID="MR_20110801">
<VenueName>ECHUCA (VIC)</VenueName>
<Type>R</Type>
<Events>10</Events>
<Track>DEAD </Track>
[Code] ......
I have written the code to pull down the data into a data store, but I dont know the BEST way to put the data into a set of tables. My first thought was to traverse the nodes and add rows into tables but I figure there must be a native VB process that reads the xml and puts it into the the appropriate table. How to code up the process for getting the data into a set of tables that match the xml. So lets say I have a Summary table, I would like all the data about each track to go into that table. Then I would have a Races table and have the data for each race go into that. What I have done already is import the xml into Access to create the tables (which was a breeze!) and then link that data source to my project. So I have the tables already built.
I have a form that when a user clicks on a button that it opens a new window with a dataset. Is it possible to be able to edit that dataset and have messagebox.shows along with that for approval?
View 2 RepliesOk, as in my other post i asked this!!
If TextBox7.Text.Contains(ComboBox1.Text) Then
If ComboBox1.Text = "" Then
Else
[code].....
so what I want to do should be pretty simple. I've been following the examples found here Using the BackgroundWorker Component - VBForums . I've been successful, but I'm not smart enough to put it in my project.
What I'd like to happen is this
1. I hit a button to load data from a dataset....
2. have a progress bar show until this action is complete.
The main problem is that I can't figure out how to tie the "progress bar" to the action of "pulling the dataset"
I'm sure this is a crazy question for you all, but hey...
Would I put all of the coding in the button_Click sub?
I have added a SQL Server datasource through the wizard. I created my forms which were bound to the dataset. Is it possible to change the datasource and dataset names while updating the dataset the binding controls of the form?
For instance, Server 1 has DB1 and Server 2 has DB2 (DB1 & DB2 store the same information/tables). Is it possible to keep the forms and only update the binding information if I want the forms to use DB2?
I have a dataset that I search using the
dataset.tables("table").Select("WHERE clause")
method to query. I then use a datarepeater to display the results. Is there a way to programatically tell if no results are returned? I'm aware of the Dataset.tables.Rows.count, but can this be done after the select method?
[Code]...
My background is mostly Access VBA and I am having to learn VB.NET. I am trying to recreate an Access 2007 application I wrote into VB.Net. We are looking at using a hosted SQL Server so we do not have to worry about remote offices or replication. I am using VS 2008 and SS2008.My issue is that I need to create a login form in VB that with look at SQL Server DB and return a dataset record matching the username and password. There are many tutorials on here but do not match what I am looking for.I have a stored procedure with 2 parameters (@prmUser and @prmPassword) named spLogin.I need to call the sp and pass the parameters to SQL Server DB and return the complete row of data that is matched from the button_click event on my form.
In Access, I would have a form that would have the returned data and I would reference that information throughout the application by using the 'forms!frmName!txtValue' to populate forms, reports, and fields that would capture the user that created the record. What is the best practice for this?Next when the login credentials are correct then I need another form to open, which is my MDI form, if not correct then msgbox to try again.
[URL] some properties aren't showing in my vb just like the one needed in the video..my computed column is made only by
-project
-add new item
-dataset
then i just changed the expression property
This is my first post here so forgive me if I am not following any correct protocols. I am attempting to generate a DataSet and bind it to a datarepeater object. I had been doing this at Design Time and was getting an error message when filling the dataset when the form loaded. So I am basically createing the dataset in my code now when the form loads and binding it to the datarepeater. However, when I attempt to bind the dataset I get a NullReferenceException - even through I know that there are 60 rows of data in the dataset table.
[Code]...
As you can see i have several debug messages in there. I get the error on the last line when setting the datarepeater data source. I try and get data for a specified lot - if it doesn't return any values I create some values in the datatable and add them to the DB. On first load when there is no data this works perfectly. If I then close the form and reload it, it will display fine. However, if I change any of the data (database is updated) and then go back in again, I get the error above.
I have a problem with a combobox. I have a form (with information about clients) with textboxes binded to a dataview. One of the columns in the dataview contains a number that tells me what kind of client it is. I don't my users want that my users have to fill in a number in a textbox, but I want them to choose a item from a combobox. De selected value should be the value that is actually saved in the database.
This is my
Dim cmd As New SqlCommand
Dim dr As SqlDataReader
VerbindingMaken()
cmd.Connection = cnnVraagbaak
cmd.CommandType = CommandType.StoredProcedure
[Code] .....
De Datasource is the information in my combobox. With Databindings I'm trying to bind it to my dataset (or view, that doesn't work either) with clients. Every time I get a NullReferenceExeption. The moment I remove the line cbo.DataSource = dsRelatie.Tables("Relatiesoort"), I don't get an error, but it doesn't work either.
That dataset is filled (I've checked) and also the derived view. The column Relatiesoort exists. What do I have to do to make it possible for my users to choose an item from a combobox and save the selected value to the underlying dataset?
Am new to VB, can anyone tell me very simple how to share the MAIN Bindingsource with an detail form where i want to edit 1 record from the main datasource?
andreg
I have a list of strings. How do I bind it to a listbox so that the listbox updates as the data of the list changes? I'm using vb.net.I've tried this so far. I've manage to display the data, but not change it:
Public Class Form1
Private mycountries As New List(Of String)
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code]....
I've also tried this:
ListBox1.DataBindings.Add("items", mycountries, "Item")
But items is readonly, so it doesn't work.Also, if I want to bind the enabled property of a button to a boolean, how can I do that?I've tried this but I don't know what to add for the last parameter.
Dim b As Boolean = True
Button3.DataBindings.Add("Enabled", b, "")
Is it possible to have an internal XML dataset within a VB 08 program I ask because we at present have the program load an external XML on startup, but i would prefer this to be internal withing the program to stop other editing the XML file.
View 6 RepliesI have an ASP.NET page with a Wizard control containing several steps and about 80 form fields. The data is collected and inserted to a database from the code behind page. I need to set this form up so you can not only insert, but edit a record as well. So I want to databind the fields. I'd rather not use a FormView because then I would have to revise my existing code, since you can't access controls inside a FormView directly. Is there a way to databind the fields without using a FormView?
View 1 RepliesI have a button that i basically want to either show or hide it based on if a certain string has a value or not. I create the buttons in code so i was trying to used databindings with a converter but i can't seem to get the converter on the binding after the value changes. I'm not sure if I'm going after this correctly or not... Here is what i have for creating the button and the binding and the converter. "sFileLocation" is a string inside my class "QuestionsFile". This works for initialization but its just when the value of the string changes, this binding doesn't see the change and doesn't run the converter and all that for me...
Dim btn2 As New Button
Dim b2 As New Binding("sFileLocation")
b2.Mode = BindingMode.TwoWay
[code]....
The thing I don't understand too is that the binding works fine if i just binding the property to the Button.Content. So the property is updating correctly when it gets changed, and the buttons content changes accordingly.
I'm trying to do something with databinding between 2 controls...Here is a sample code (that doesnt work - and that is my wonder):
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Me.TextboxPlus2.DataBindings.Add("Text", Me.TextboxPlus1, "Text")
[code]...
Is there a way to fill a checked list box with data from a sql table and then use the checked items as parameters or a stored procedure?
View 5 RepliesI have an ASP.NET page with a Wizard control containing several steps and about 80 form fields. The data is collected and inserted to a database from the code behind page. I need to set this form up so you can not only insert, but edit a record as well. So I want to databind the fields. I'd rather not use a FormView because then I would have to revise my existing code, since you can't access controls inside a FormView directly. Is there a way to databind the fields without using a FormView? I'm new at this by the way so sorry if the answer should be obvi
View 3 Replies
