I'm connecting to an acess DB, adding data works fine, but if I want to change data in an existing record it does not work nor trows up exceptions. What am I missing? I think the db is the one causing the trouble but I can not see how?
View 4 RepliesI had built an application such like items management, I used two table in two different database in two different engine server, the stack is, when I want to make event for add new data, how I can make the event for the combobox ID for switching it's datasource from before.. for the knowledge, the first table is Xtable, database is Xdatabase and the machine is Xmachine; and for the second one is : table is Ytable, database is Ydatabase and the server machine is Ymachine...
View 1 RepliesI cannot figure out how to change the data in a listbox. I'm being driven completely mad by vb.net, finding it very very complicated.
Ok I have two list boxes on a form that contain correlated data i.e. the first item in the first list box corresponds to the first item in the second list box.
Under the two list boxes I have two text boxes for data entry.
For Example :
LstTagDatabaseLoop LstTagDatabaseSource
TxtTagDatabaseLoop TxtTagDatabaseSource
I want to Add Update and Remove items from the list. If the user selects an item, I want the selected item in the other list to change to correspond. I also want the two text boxes to be udpated with the currently selected item.
[Code].....
however this invoked the selectedindexChanged sub umpteen dozen times and while in the end it did actually update the data, its obviously not the right way.
I found ListViews which perhaps is more appropriate but I couldn't get my head around it at all so returned to trying to use these listboxes. Is there a different object I should be using.
I'm finding vb.net to be too complicated for a hack programmer like myself...
So, I've got a text boxes which loads up a content from a XML file, usually a numbers I want a button, so when I will change the numbers on the text box, the data in file will change as well, in other words a save button That's how the data is being taken from a file
[code]...
Those EditPaths, Playa2 etc are making up a path to a file
How do you change a data type, for example an integer to a currency type, I'm an old vb6 user and I cannot figure it out because there is no such animal.I want to do a program for my album collection and I cannot format values ...
View 1 RepliesI wrote some code that displays 2 columns of the table "gebruiker" in a sql 2000 database called "TST".But if I change something in the Datagridview it isnt passed trough to the database.What do I have to add in my code so that it does?[code]
View 1 RepliesI have data like this in text file
202103
20204
20210
202110
I want to change the above data to be like this
(2 2.50 03.0)
(2 2.00 04.0)
[Code]...
in creating an application that will change a couple of lines of data in a file im using vb 2008,
View 2 RepliesI converted a program from vb6 to vb.net, I used a propertybag to clone my recordsets and after I would filter them to navigate threw my data and then show the result in a gridview, but I have a problem in vb.net with my filter.In vb6 the program would go through my data, but in .net it stays on the same data and it goes into an infinite loop.My problem is to arrange my filter so that it can [code].....
View 3 RepliesDoes anyone know how to cancel a row change in a data grid? What I want is to allow the user to modify a row in a grid. When they try to leave a row after changing it, then prompt them to save the changes before moving to the new row. So far, the rowleave event is working to prompt them to save or not. But I'd like to give them the option to cancel...which should leave them on the original row. The rowleave event, nor any other similar event, appears to have the abiity to cancel the move.
I thought about remembering the row number and just putting it back on that row...but it seems like there probably should be a better way to cancel the row change.
I'm have a list box where I want my data bound to a data binding source. Easy enough, just set it in properties. But I want to be able to change the values to a different binding source when I click a radio button. In other words, for each radio button I want a different set of data in my list box.[code]
View 2 RepliesI have two DB tables Table1 and Table2I am displaying the data of Table1 using a gridview. I want to show the data of table2 in another gridview when a user clicks on a row on gridview1 i.e I want to change the data in gridview2 when the user clicks on a row on gridview1 . Both the tables are related using PersonID.
View 2 RepliesI have a two forms with about 25 bound controls on each in the same solution. All of the data for both forms is in the same SQL table. I need to filter the data and only get the data appropriate to the called form. I consulted an University VB professor and he would only say "it won't be easy".
I tried removing all of the bindings and rebinding them to the new datasource but there were still some remnants (probably from the navigator) that proved illusive.
Is the only solution to recreate the VB forms and bind them to the new datasource?
(using Visual Studio 2008 Professional)
Private Sub HazMatlLabelsBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles HazMatlLabelsBindingNavigatorSaveItem.Click
[Code]...
I have a form with label1.text that always runs.
label1.text = "operator1"
i have read in a text file and saved data from it as a string.
i want to continually read this file and when the string data changes i want label1.text = "operator2"
i cannot figure out how to change the label1.text when the data changes.
I have a label that displays information from my database and I need to format it. It displays a number format like so: (53389) and I just need it to display (53,389)it uses the SQL to COUNT or SUM the data from the datasource. is there a way to have it format like I want when it is displayed, or do I need to change the data format in the database?
here is my code:
Try
Me.MAINTableAdapter.Fill(Me.MainDataSet.MAIN)
Me.MAINTableAdapter1.FillByExceeds(Me.BurnListingDataSet.MAIN)
[code]....
I have two comboboxes. The data sorce of combobox1 is a list of string that is fixed.Combobox2's data sorce will be a list of string that depends on the selection of combobox1. This is very similar to a common case as follows: first enter your contry, then depending on your enter, the second combobox will show you the list of universities in the country.
'Change selection of first combobox
Private Sub cbxClient_SelectedIndexChanged(sender As Object, e As EventArgs) Handles cbxClient.SelectedIndexChanged
[code]....
I have below codes on how to notify forms of data change.
If I were to convert it to exe, how do i then notify the multiple instances of this application of a data change?
Public Class Form1
' use the WithEvents keyword in that the events of frm2 can be handled using the Handles keyword
[Code]....
I have a ReportViewer showing a report that is bound to a dataset. The dataset gets its data from a Access database backend. I have a separate form that allows the user to add/update/delete data. My problem is when the user makes changes to the data using the data entry form, the report does not reflect those changes. I have to close the entire program and reopen it before the changes take effect on my report.[code]...
View 4 RepliesHow to change the frame rate in Visual Basic 2008 Media Player? I have error: System.NullReferenceException was unhandled Message: Object reference not set to an instance of an object. IS there any way to fix this? Here's My Code
[Code]...
i am trying to make a search criteria based on last name.i have dragged and dropped customer dataset as details view on my form and booking as gridview(customer id is foreign key in bookings table so now when i scroll through customer i could see the relaive booking history in grid view.). now i have many customer so i have to scroll down to look for a particular customer.i want to create a textbox where i can enter customer's last name and it should change the data of details view from current customer to the customer which is searched and also should change the related data in gridview aswell which is customer booking data.really need help plz..provide code if u can..here is wat i have done but no luck.
Dim ds As DataSet
'** means:
'check for correct name of the table in dataset, you can still use index like [0] if this is 1st or only table in dataset
[code]....
I want to change the data on a HKEY_LOCAL_MACHINE key i´ve been trying to get the code right but it wont work[code]...
View 2 Replieschanging data in a certain tag within an XML via vb.net.
The files will be all in subforms and look like:
<?xml version="1.0" encoding="iso-8859-1"?>
<Documents xmlns:xsi="http:www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="myxsd.xsd">
[Code].....
I need to create an app in which different users will change data from a DataGridView. I was thinking to use SqlDependencies to automatically update changes.
I have tried the example from link bellow but it seems that something is not working properly.
[URL]
I want to mention that I am making this app in VB.NET
I want to create a textbox which contents are validated every time the text in it changes. And an image is displayed beside the textbox if it is correct and another image shows up if its not correct. Pretty much like ajax.
Heres the method which I called from the class.
Public Sub read1()
cmd.CommandText = "SELECT * FROM testdb WHERE Name='" & name & "'"
Try
[Code]....
Problem is, the method seems to be only called once. And the first image that was displayed stays the same even after inputting a data which does not exist in the database. I'm connecting this program to a mysql database using odbc.
If I wanted to change the value of a column for every row in a datagridview, what is the best way to do it? I have encountered an issue when the datagridview is bound to a filtered DataView and need to know what I am doing wrong. The code I would normally use is
Code: For Each r As DataGridViewRow In DataGridView1.Rows
'don't touch the blank line, it is pointless and will error out
If r.IsNewRow = False Then
'set the current line with the current ID.
[Code]...
I have the following code to try and change a field in a Microsoft SQL database. I don't get any Exceptions when processing the code but I use the Microsoft SQL Management Studio to view the data before and after but the data does not change.
myDataAdapter.SelectCommand = New SqlCommand
myDataAdapter.SelectCommand.Connection = New SqlConnection(myConnectString)
myDataAdapter.SelectCommand.CommandText = mySqlString
[code]....
OK So basically as the title says, in my browser i have tabs, now when a new tab is open and the user will go to a new page, if they click to the next tab the url box & document title remain the same (until they click a link or something) are there any methods of detecting when the person clicks to another tab so that i can code it to change the textbox and form text?
View 4 Repliesi m developing a window application using vb.net & ms sql server 2008. The date is by default mm/dd/yyyy. But i wanna change this to dd/mm/yyyy. How is it possible and where do i hv to make changes?
View 3 Repliesi have a code which has the connection string as driver. dim s as string = "Driver={SQL Server}; Server=xxxSQLEXPRESS; Database=dbRegister; Trusted_Connection=yes" i need to change that to - "data source=1.2.3.4;user id=xx;password=xxxxx;initial catalog=xxxxx;Connect Timeout=30" when i just change the text it gives this error - "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" how do i declare the datasource?
View 2 Repliesis there a chance that I change the header name of the exported data from gridview. Below is my code and its working fine. my only problem is I can't change the header name
My code
Dim strFilename As String = Now.Date.Month.ToString + Now.Date.Day.ToString + Now.Hour.ToString + Now.Minute.ToString + Now.Second.ToString
Response.AddHeader("content-disposition", "attachment;filename=" & strFilename & ".xls")
[Code]....