I have a form with a number of controls based on those controls and a database i filter what data i want to be in AllowableHeightsCombobox. I am using an Arraylist to hold the data. The problem i am encountering is that after filling allowableHeightsCombobox once, it will not update or change the values in it. this is the only place where i change the AllowableHeightscombox's datasource.
[Code]...
When I update but do not really made any changes to the value and press the update button, the data becomes null. And it will seem that I deleted the value.I've taught of a solution, that is to add both combobox1.selectedtext and combobox1.selecteditem to the function. But it doesn't work.
combobox1.selecteditem is working when you try to alter the values when you update. But will save a null value when you don't alter the values using the combobox combobox1.selectedtext will save the data into the database even without altering.But will not save the data if you try to alter it.-And I incorporated both of them, but still only one is performing, and I think it is the one that I added first:
Dim shikai As New Updater
Try
shikai.id = TextBox1.Text
shikai.fname = TextBox2.Text
shikai.mi = TextBox3.Text
[code]....
My class Looks like this:
Public Class CoursesLib
Public CoursesOfferedMAIN As New Dictionary(Of String, Category)
Public Class Category
Private _CategoryName As String
[code]....
on a windows form i have a combobox called currency, it is populated by a table-adapter called exchan-gerate which is turn populated by a dataset called mydataset. on form load, i issue update commands to the back-end database that holds the table which populates the dataset - they work. if i look at the update to the combobox, they are not reflected until i exit and restart the app - then they're fine. further down the form load i've tried:
Me.exchangerate.Update(Me.DataSet.Currency)
Me.CurrencyComboBox.Refresh()
am i missing something silly to have the values in the combobox change and refresh at the time of the update to the database? as i said, an exit and restart of the app displays the accurate data.
i am still beginner in coding, i am using vb.net 2005 and access. in my form i am having a radio buttons called DEPARTMENT: english
[Code]...
I am new to vb.net and I am using visual studio 2010. I have two comboboxes on a form, each combobox is set to DropDownList so that a list of items can show in the combobox, but no text is allowed to be entered.
For combobox A, if user chooses item 1, the list of combobox B should be updated accordingly. I think this is quite common on a lot of applications. But I do not know to implement it. I even do not know the keyword to search for the relevant property or event handler.
I have filled a DVG with information and added another column to index(8) pragmatically Now i want to create a combobox with values depending on values in other cells on the same row so each row will have a combo box with different selections. below i have placed the code and hoped someone would have some input on how to approach this. i have tried datagridviewcolumn but that fills every row with the same information regaurdless of a if statement
[Code]...
I am trying to update a value of a node in an XML file. I can navigate the file, but when I use the SetValue function, it doesn't seem to update the value in the file. Is there some save or commit function I need to perform?
Here is the code:
Dim doc As XmlDocument = New XmlDocument()
Dim navigator As XPath.XPathNavigator
Dim nsMgr As XmlNamespaceManager
Dim Done As Boolean = False
[code]....
I have two combobox in a form: Cb1 and Cb2
When I load the form, Cb1 and Cb2 are connected to a bindingsource.
When I change Cb1, the code (below) changes Cb2 to show only the items according to Cb1
This is working fine.
The problem is when I change Cb1 , change Cb2 and click the save button..... Cb2 seems to be 'lost'...
I'm using VS2008.
CODE:
I have a DGV I am working on, and I have many columns.
For example I have Columns colcase(Combobox), colreportTime(Time)
the combox shows 4 cases {A,B,C,D}
what I need to do is if the user select "C"
the the colreporttime will show the time of this change unless the old value is C
My.Settings.Current_DB is bound to 'cbdatabase' which is a combobox which is filled by this method:
me.cbdatabase.datasource = (From foulder in New IO.DirectoryInfo("" & Application.StartUpPath & "Database").GetDirectories Select (folder.Name)).ToArray I am using the My.Settings.Current_DB to keep track of the current database being used by the client. So that throughout the program and when the program starts up it knows what the current database is.
The databases and the folders have the same name, in order to keep track of. My problem is when the combobox is filled when the program starts, it is overwriting the current info with the first item of the info loaded into the combo box.
[Code]...
Instead of maintaining the Current_DB as "Default", it updates it with the first item into the Combobox and that is "Alabama". How do I fix this so that it maintains the correct Current_DB and not update when the Combobox is filled.
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].....
I am using Visual Basic express edition 2008.I am trying to know if a value in a single dimensional array is repeated in the array. If yes, then multiply one of them by 100. For example:
MyArray (14) = 12, 15, 18, 15, 18, 11, 15, 18, 16, 14, 18, 8, 12, 17, 10
In the above example:
MyArray (1) = MyArray (3) = MyArray (6) = 15
MyArray (2) = MyArray (4) = MyArray (7) = MyArray (10) = 18
MyArray (0) = MyArray (12) = 12
[Code]...
The program i am writing has 5 features, all of which i want to run in their own threads. On the main for I have a listView which contains all the accounts (user password etc). The thread is defined as:
Public fbaThread As New Thread(New ThreadStart(AddressOf fba_Start))
In cmdAdderStart i begin the new thread by:
fbaRun = True
fbaThread.Start()
[Code]....
I have managed to write the UpdateDebug() to update my txtDebug on the main form. But now I am having trouble being able to pull the values from lvAccounts.items().subitems I can accomplish this with global variables but i'm sure this is not the best way to do this.
I have two comboBoxes, one is CountryCombo and second is StateCombo.What I want is the that when i the clicks country combo and select a one country then the States of that the country should get populated in the State Combo.I have tried things many many many but nothing working. Below is my code of how my CountryCombo is getting filled.
query="select CountryName from CountryMaster"
if dr.hasRows()
{[code]......
I have a ProbationComboBox with the SelectedValue bound to a RegistrationBindingSource, and the DisplayMember bound to a ProbationBindingSource. [code]
View 2 RepliesI 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?
if textbox1.text =S1, S2 then on button click event the S1 and S2 column value of Table in MSSql2005 database will be updated with the value "b" where date=1/3/2012
But the update is not working...
My MSSQL2005 Database structure :
id date S1 S2 S3
1 1/3/2012 b b NULL
I have a table with several columns that allow NULLs. How would I go about writing a SQL Query that will allow me to skip that column in an update if the value is "empty". Should I use a boolean flag letting the query know to update that value? I do something similar in a SELECT like this SELECT * FROM table WHERE (@boolFlag = 1 OR col1 = @col1Val)But trying to do that for an update has proven to be an exercise in futility. Ideally I'd be able to say skip this value if true, otherwise update over my 20ish columns. Right now I can't pass in DBNull.Value, so instead I'm being forced to insert "" which is converted into whitespace (for instance, my nvarchar(50) has 50 spaces).I'm using a SQL Server DB/Table and a DataSet in VB.NET, constructing my queries in VS2k8 if that matters.
View 1 RepliesNot 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].....
In a WinForms app (VS2008 / .Net Framework 3.5) I bind data from SQL Server to controls. If there's a null value e.g. an employee has no middle name (allowed by business rules), when I browse that record at runtime an exception is thrown. So I code: If Not (row("middle_name") Is DbNull.Value then txtMiddleName.DataBindings.Add(New Binding("Text", row, "middle_name)). Say someone adds a middle name to this record, because the control had no databindings the dataset.HasChanges property is false and update stored proc doesn't run. I guess I could handle this like this: If txtMiddleName.Databindings.Count = 0 AndAlso txtMiddleName.Text <> "" Then row("middle_name") = txtMiddleName.Text. I guess I would have to do something similar to handle a value changing from not null to null.
View 8 RepliesThere are 2 subs. First one populates a DataGridView with data from a SQL table:
Dim SQLCom As SqlCommand
Dim myDA As New SqlDataAdapter
Dim myDS As DataSet = New DataSet()
[Code].....
I am trying to use several Class arrays to hold values that I will cycle through at a later point to perform some calculations. I need to change the array sizes to fit the data as it is entered. I am using one procedure to set the first element of each array and then a separate procedure to pass the additional values as they are entered.
Until my last attempt at changing my code, my StartBalance sub seemed to work, I could step through and see the values assigned to the class arrays in the code block. However, when it moved on to the Transaction sub, it did not recognize that the first set of values were set, the array shows zero values for index 1.
I have gone through several changes trying different ideas from reading blogs and articles, but I guess I am not understanding how these work. I even used the class arrays directly instead of the Property procedures to see if I would get a different result, but I do not.
I believe I must be approaching this incorrectly and though I can find dozens of examples of setting class variables and even a couple on using arrays as class variable, I can not find any that show how to then pass values to those arrays.
Public Class Statement
Private _tranDate(1) As Date
Private _amount(1) As Double
[Code]....
I am trying to update a link table with values from multiple datagrids, the field types in the link table are numbers and the value selected from the datagrids are also numbers. I am getting the following error:
The OleDbParameterCollection only accepts non-null OleDbParameter type objects, not String objects.
In line : cmdCompany.Parameters.Add("@COMPANY_ID")
Dim ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|aop29.mdb"
Dim cmdCompany As OleDbCommand
Dim cmdReceiver As OleDbCommand
Dim CompanySQL As String
[Code] .....
I have the following code:
[Code]...
The problem I'm facing is that the update happens correctly only for the first of many values. All the other values are calculated and consequently, updated incorrectly in my table. I am almost certain that the looping is what is causing the problem but have been unable to find a way around it.
Here is my
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=BHgardeners11.mdb;")
cn.Open()
Try
str = "UPDATE Products SET ProductCode = ?, ProductManufacturerCode = ?, ProductsTitle = ?,
[Code] .....
If there is only one item in the database, then this code works. If there is more than one record then the error is produced that it is trying to produce duplicate values. This is down to the Primary key in my database which is the only thing that cannot have duplicate values. However, when I remove the primary key it has the predictable problem that it goes crazy and does weird things.
I'm using ASP.NET 2.0 and VB.NET. I have a login page. If I am an existing user, when I log in, my user details are popped in the respective textBoxes. Now I wish to change one of these fields. I edited one and then clicked on the Edit button to update the record. It's not updated but instead it brings the existing value from the text box.
[code]...
(The following code cant work , it just wont update.. my bar default max is 80 and its still shooting over 80, its not dividing)
Sub displayprogress(ByVal amount As Integer, ByVal progress As ProgressBar)
progress.Value = 0
For i As Integer = 1 To amount
[code]....
i did try replace the question with SQLLquestion(0) but the result given was 0 and not the question from database i tried calling function sqlquestion() from one of the form but it just cant work i think tis wrong...
I'm writing a time entry program to record when an employee checks in and when they check out.I'm struggling on the part where I need to calculate a time span (time out / time in). I am selecting the In Time, Out Time, and Total columns.I want it to take the Out Time subtract it from the In Time and place that value in the Total column.I have so far and have tried several variations of different updates but have had no luck.[code]I keep getting a syntax error in the UPDATE statment.I'm not very fluent with OleDB yet and I'm not sure if I'm doing the update correctly.I have no problem with OleDB and single UPDATES or single field updates but when I am updating multiple rows with different values.
View 16 RepliesI am using a number of tables on my application and two of which have a foreign key constraint I have set between them. When I change the account number on the main table via a combo box all of the relevant information for that table on the form is updated accordingly. However, the child table which has a foreign key reference to the Account Number of the main table is not updated when the acocunt number is changed. I have set the update to cascade in the references but still am having issues.
View 5 Replies