want to update values in an xml file. When users select the xml file, the form binds controls to a dataset. After updating some/all values, the changes are saved. It works for every field except for a calculated value.
View 2 RepliesUsing Visual studio 2008, I have an application that its data can save to a binary file, using *.SDB extension, Moreover users can open this file from my application. I have 2 questions about this.
1-How can I assign an icon to this saved file with SDB extension when my application has been installed in other computer?
2-Similar to *.sln file (for Visual Studio project), How can I assign tow icon to single extension?
I've try to assign the new parameter to dataset, while i using the following code, i got the error like "Varchar is not a member of Devart.Data.Oracle.OracleType"
View 1 RepliesOnce I have filled a dataset is there a set of properties or in-line functions that will allow me to pull the data out of said dataset without having to populate a datagrid?
Code example:
Connection.Open()
accCommand.CommandText = "SELECT CustID FROM Rental WHERE DvdID = " & DvdID
accCommand.Connection = Connection
dvdDataAdapter.SelectCommand = accCommand
accCommand.ExecuteNonQuery()
dvdDataAdapter.Fill(dvdDataSet, "CustID")
Connection.Close()
I know the information returned from the query is a single value located at (0, 0) I just can't get to it so I can assign the value to the variable.
I have a control that has multiple tableadapters used to show various information.My delima is that I dont want to update all of them if the data for them was never modifed.Is it possible to check all bindingsources to see if they have any changes and force the ones that have modifed rows to update?
View 15 RepliesI have a datagridview with contacts on a form with clients. The underlying table for contacts has a field for Contactnumber. This is a identity column so its new number is generated by SQL Server.
I add a row and when I move to the next record on the form, the form �nd the information in the datagrid is saved to the database. So far, so good. The problem is: when I move back and try to delete that newly made row I get an error about concurrency.
It's logical actually, the record is saved, but the dataset of the datagrid doesn't yet know what the new contactnumber is. Apparently it's not information that it gets back automatically from SQL Server.
How can I make the dataset know the new identity of the row that is saved to the database? I use a simple da.Update(dsVerwijderingen, Tabelnaam) to save the changes to the database.
I have a multiline textbox that has wordwrap set to True I am assigning each line of the textbox to a string Lets say I typed this into the textbox without pressing enter and it just wordwrapped to the next line Visual Programming is fun it would assign "Visual Programming is fun" to the first string however, what i want it to do is assign "Visual Programming is" to the first string and "fun" to the second string.....now if i would have pressed enter after "is" then it would have done what I wanted it to do, but if i dont press enter and just let it word wrap it does not do what i want it to do...
View 5 Repliesis my code in VS 2008 (VB) to show Crystal Report. but crystal show saved data not my dataset:[code]
View 4 Replies[Code]...
txtlocated is the id of the HTML textbox. I want to assign the value of the textbox to the string loc. When i debug it the loc is shown as null the textbox value is not passed into the string.
How To Add Assigning Value to TextBox. In Local Report. using Visual Studio 2010 ( VB )
View 3 Repliesi have to do the same work in vb as i have done in c#:
[URL]
I'm facing a problem with my current member card reader development.
I'm reading the card number (just a serial number of 4 digits) with a card reader. this seems to work fine (even converting the text string to integers).
This number is then put in a query to find the exact record that corresponds with this number
Me.JSM_LedenTableAdapter.GetDataByKaartnummer(IntCardNr)
How do I make a connection between a button and textbox when using windows form applications. In other words, if a button is clicked on, how do I assign it to read that certain textbox where the information was entered?
View 4 RepliesWhen the form loads it reads from an embedded resource file that loads the data into variables. It then uses mid(variable,1,1) to load a single value into a textbox. It does this for a total of up to ten textboxes. Sometimes all the values show up sometimes some, sometimes none.
View 4 RepliesI have Microsoft Visual Studio 2010 (not sure on the differences of each version) Ive googled and looked all over. I dont like asking people to code everything out for me, but ive spent too many hours trying to figure out how to solve something that seems so simple.
[Code]...
I am trying to create a program that will send a URL saved in a textbox between the program which will be on different computers. So one computer will be running the program and the URL they have will be sent to the program on the other program.
View 2 Repliesjust want to know how to get the path of a text files then put it on a textbox when saved in vb.net
View 6 RepliesI have a WinForms app with a multi-line textbox. This displays and retains (after loading from the DB) line break characters fine. However if I assign the TextBox.Text value to a string variable and then re-assign the variable back to the TextBox.Text property, the line break characters are lost and replaced with a square character (can't past them here as they just paste as a line break!)
[Code]...
I have a textbox, a sql database, a binding source bound to the sql database. I can use auto-complete mode of the textbox with custom strings and it suggests in in a drop down form as the user types in a textbox. How can I use autocomplete mode with datasaved in different records of a field using the bindingsource?
View 5 RepliesI would like the autocomplete list of a textbox to be the words that the user has previously typed and saved. For example if they enter "dog", "cat" and "fish" I want the autocomplete suggests to show these three options. So far my Code only shows the last user input. I expect there is an easy solution as I am new to all this, but I can't seem to find it on my own.
[Code]...
I am creating a simple button based rpg and was wondering if someone could help me with 3 things how to hold information within the game until the player save's the game, Saving the game, and Loading the game.I want the saved games to be saved onto a encryted file like .db or .dat file..
View 3 RepliesI'm using the following query (which will only return one result) and I'm trying to get it into a combo box or text box. The reason for this is because I have a combobox on a form that is bound to the same table as the form, however, the rowsource for the combo box is from a different table (Containing two columns EmpID and Name), whenever the form loads it always loads the value that is stored which is an employee ID and i want it to show the name instead. I've posed all over and no one seems to know how to do this.
So I'm trying to write a query that, on load, will replace the code stored in the combo box with the actual name associated with it.
Private Sub ClosedReasonsLoad()
'Convert Closed Codes.
Dim sSQL As String = "SELECT Reason FROM [Close Reason] WHERE "
[Code].....
i have 3 textbox and 1 listbox bound to the same datatable. when i insert new row to the datatable, there are 2 rows affacted in datatable, one row in datatable is replaced by the newly added row, and this new row is also insert into the end of datatable, while this modified datatable is updated into the database, only the inserted row is updated, the other modified row did not affacted in database.
here is my code:
Private Sub Form1_Load(ByVal
sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim DA As MySqlDataAdapter
[code]....
I have a module where i have specified the connection string as below:
Public Function Connection() As String
Return "Data Source=192.168.0.1,1433;Network Library=DBMSSOCN;Initial Catalog=test;User ID=sa;Password=123456"
End Function
Then i have a form which has two textboxes. What i am trying to do is bind the two textboxes to a dataset in the following way:
Imports System.Data.SqlClient
Public Class Form1
Inherits System.Windows.Forms.Form
[Code]....
Im wondering how to use a dataset to populate a textbox. For example, textbox1.text needs to display information from a table with a few rows of data
View 14 RepliesI am trying to assign a dataset to the TAG property of a textbox control in my application. The code seems to do the assignment without any error but I cant see the property TAG name or the assigned value using quickwatch etc. etc. The TAG property name does show in the design window.
Is this property useable in my version (academic 2002 version 7.0) or does the TAG and any assigned value it holds not show in quickwatch. I can only find 1 reference which seems to suggest the TAG property is not supported in early versions, but would prefer a definitive answer.
I am trying to filter a dataset using input from a textbox. I would like this to happen on a button's click event. I am familiar with connecting to a database using an adapter but I have never tried to have VS make the connection for me and display results in a datagrid view. I have tried google'ing this numerous ways and tried numerous attempts to code this to no avail.
View 1 RepliesOk, as in my other post i asked this!!
If TextBox7.Text.Contains(ComboBox1.Text) Then
If ComboBox1.Text = "" Then
Else
[code].....
Im using vb.net 2010 express and I'm wanting to create a hyperlink in my dataset based on it's text. I have a search page that filters a binding source and brings up a form with the customers info. It's in detail, not dgv, and I have all my textboxes read only. I was thinking it would be easy by
If companytextbox.text = "msdn" then
system.diagnostics.process.start("www.msdn.com")
End If
How do you compare the contents of the textbox with result of the dataset?
View 4 Replies