I'm trying to add a name of a product to a Textbox...the name of the product is stored in a database. Now there is a Combobox with number in them....1 2 3 ect. Now if you select one of the numbers it must display that product name?
conn.Open
Textbox1.Clear()
myDataSet.Clear
[Code].....
I want to retrieve a data from my mysql database into my textbox, my problem is how can i show the previous and next data in a column? because it only shows the last data entry.
this what i have done so far
Sub filltextbox()
strsql = "select * from tbl_studinfo"
mysqlcmd.CommandText = strsql
[Code].....
I have a single form in Visual Studio 2010...in that form...
TextBox = txtSearch
Button = cmdSearch
DataGridView = GridView1
GridView1 is bound to a View, tblAccounts.
tblAccounts includes multiple columns, including a text field for 'AccountName'...this name can be in one of two columns.I'm trying have a user enter any part of an AccountName in txtSearch, click cmdSearch, and return all matches in tblAccounts to GridView1.
[code]....I have a dialog that comes up and asks for a reason for declining the business.I don't want the code to move on after not enabling the "me" until the reason has been entered and saved into the database. Also, at that point where it says "I WANT...." I want to copy the textbox fields into a new database and then delete this entry from the database, how can I do that. I am using VS 2008 and SQL.
View 2 RepliesHow do you get a textbox being using for password entry to display the black circle that you often see in web forms, on the iphone etc etc?
I can change the PasswordChar property to an asterisk no problem and even copying and pasting symbols inserted into Word seemed to work - just couldn't find a symbol that looked like a bullet point!
Can this actually be achieved for a standalone exe, or is it something unique to web forms? Surely copying and pasting symbols from Word isn't actually the answer?
I have setup a page in Excel with several textboxes for data entry. I would like to be able to tab from textbox to textbox so I can enter this data as quickly as possible.
View 3 RepliesI'm creating a project for my brother's thesis for his VB subject.Now, the thing is, I'm trying to display row data from database to the (already binded) textboxes in form1. As you may know, this procedure requires that the program:
1. Declares an sqldatareader, sqlcommand, and an sqlconnection.
2. open the sqlconnection.
3. ....and use the sqldatareader to fetch the data from the source file.
The database file is made using sql server compact 3.5 and is located on same pc as where I'm making the program.The problem is, I'm getting stumped in trying to connect to the sql server. I'm getting a 26 error "error locating server/instance specified". installing sql server 2008 management studio to allow remote connections (which was already allowed in the 1st place), enabling TCP/named pipes protocol in the config manager, and enabling sql server browser service. I dont have spi firewall on since my isp has its own firewall on and xp fwall is off too. What I'm not sure about is my connection string as it might have been impeding me to connnect to server. How do I form out the correct connect string?
I'm working with a windows application,i have my database,and what i want is to display a record of my database in a textbox,i mean to bind textbox from database.here is my code for tha function of binding:
Private Function bindStudenti()
txt1.DataSource = objBLStudenti.fngetStudent()
txt1.DataBind()
End Function
it says that "datasource is not member of system.windows.forms.textbox
i try to search and get student name from phone number...but how to display student name to textbox...the database i use is sqlCE 3.5
Private Sub search_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles search.Click
Dim connect As SqlCeConnection = New SqlCeConnection("Data Source=Program Filesstudentinformation.sdf")
Dim search As String
search = "select name form student where number =" & TextBox2.Text & ""
Dim command As SqlCeCommand = New SqlCeCommand(search, connect)
[code].....
i want to get some values from my database and display them in a textbox.how can i do that?
View 1 RepliesI want to display a data from database into textbox in vb.net by giving a name. In my database the values are:
Subject: [URL]
Predicate
Title
Object: [URL]
I want to display a object in textbox by giving a predicate value as title
Dim con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\documents and settings\admin\my documents\visual studio 2010\Projects\WindowsApplication1\WindowsApplication1\db1.mdb")
Dim cmd As New OleDbCommand
Dim dr As OleDbDataReader
Dim da As New OleDbDataAdapter
[Code] .....
I have a search textbox in my form. I also have, textboxes for computer name, mouse serial number, monitor serial number and phone number. While in my database, they are all reside in one table named tblComputerAsset. I am using Access for my Database.
[Code]...
I have two textboxes and 1 button ...
i m doing when i enter travel id in textbox1 and click on button1 then in textbox2 i retrieve the travel agency name according to the travel id i entered in textbox1,
I want when no record is found according to the travel id i entered in textbox1 then in textbox2 it shows the message no record found ...
this is coding i use to retrieve record in textbox2 by enter travel id in textbox1 : have a look ...
re-edit this code according to my query above :
Protected Sub Button4_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button4.Click
Dim SQLData As New System.Data.SqlClient.SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;User
[Code]....
i'm doing a searching form, here is my code
Dim con As New OleDbConnection
Dim cmd As New OleDbCommand
Dim rd As OleDbDataReader
[Code]....
then after that i'm double click the 1 of the row in listview and 1 form popup with all data in database.
Suppose der is one database name Customer which have columns like Cust_ID,Cust_Name,Cust_Mob,Cust_Address And on Form der are one list box which contains all Cust_Id from database and 4 textbox so when user click on the listbox having id as 1 it should display name, mob and address of cust_id 1 in 4 textbox respectively?
View 18 RepliesI am at a stand still on this one. I know how to connect and add to the database, I just don't know how to retrieve the information so that a user can see it! If anyone could help me with code or another example.
View 4 RepliesI am trying to retrieve information from one row that has four columns(name,company,address,phone) so that once it is displayed in 4 different textboxes, I can transfer to a word document.
View 2 RepliesI'm not sure how to do it, I keep on getting the wrong output.My required solution is to click a name from the combo box and display bits of information.How would I loop it so if one entry is smaller than the previous, it doesn't affect it?
Dim filename As String = "subject.txt" 'Declare where the text file is'
Dim objRead As New System.IO.StreamReader(filename) 'Make objRead read the text file'
Dim array() As String = System.IO.File.ReadAllLines(filename) 'Make array a string'
[code]....
Now I know this is definitely wrong, but this is only part of the program.
Well I'm not sure how to do it, I keep on getting the wrong output.My required solution is to click a name from the combo box and display bits of information.How would I loop it so if one entry is smaller than the previous, it doesn't affect it?
Dim filename As String = "subject.txt" 'Declare where the text file is'
Dim objRead As New System.IO.StreamReader(filename) 'Make objRead read the text file'
Dim array() As String = System.IO.File.ReadAllLines(filename) 'Make array a string'
[code]....
How do you carry out a query from a criteria e.g name entered by the user from a textbox. and then display the query results in a list box..
View 2 RepliesI need to display all the data in that table but it only shows me the last entry.
db.OpenConnection()
strSQL = "SELECT * FROM BaselineTeam WHERE Process = '" & txtProcess.Text & "' " & _
"AND SubProcess = '" & txtSubProcess.Text & "'"[code]......
Just lately I've been 'playing' with entering data into a ListView and I have come up with the following code which seems to be OK. Can anyone see if there is any fault with it?
Code:
I whant to entry data in a database (fild) by pressing a button. The problem is that the button is in form 1 and the database is in form 2.
In the Button1_Click i have the cod for Form 2 to show.
I have three text boxes in a winform (.net 1.1).
I am expecting the user to type in a positive number or just to leave it as zero (default).
Is there a way that I can check that the user has typed in a number rathet than letters.
As I am coding it in VB.NET, I would prefer it if any answers where in VB style rather than C# or C++.
Back on my form with a ton of financial data entry textboxes but I want to have the data formatted at runtime, as I enter the data.I have a format declared as Public Const cFmtCurrency = "##,###,###" ' don't need decimal for the local China currency What would be the least compicated way to have these textboxes (19 of them) format the Long Integer values as I enter the data. I think a Lost Focus event would be silly; there must be a better, more efficient way.Also want to use this format when I retreive records from the db (don't see a reason to mask data in db)
View 7 RepliesI've got a program and what I need is for a Timer (running in a different thread) to constantly be checking a TextBox for an entry that is similar to:Quote"(PlayerName)" has joined the server.Where (PlayerName) would be replaced with the players name in the TextBox. What I would need the TextBox to do after it has found this entry is to add (PlayerName) to a listbox. If someone can help me out this far then I can use the same code to get it to remove the player when they leave.Below is a picture of what it should look like inside the program.
View 3 RepliesOkay, that snippet made the file I was trying to open in the %USERNAME%AppDataLocal folder worked perfectly, again, many thanks - But now I'm 3/4 of the way through my program, and I've hit a wall - I have the exact same program I made in VB6, and it works to perfection, but I am TRYING to switch over to .NET, and am finding a lot of difficulties in getting certain things to work - My biggest headache right now [ Which is basically the finishing of my program ] is a bit hard to explain, so this may be a rather long post: One of my programs that I use to keep track of my Music hard drive outputs to an XML file, in which there is one line I would like to be able to 'Replace' through the program I am making now to a different user-defined string, and close [ Applying string change/save ] the XML file. I have my Main Form, a TextBox1 [ I can't get the XML to open in a ListBox like I wanted ], TextBox2, a 'Locate String' Button, a 'Modify' Button, and an Exit Button. I open the XML file with this in my Form1_Load event into my TextBox1:[code]
The <DateValue> is the line I want to be able to modify [ Which the entire string looks like this: <DateValue>2010-04-10T10:00:03.5009756-04:00 </DateValue>, and I want to be able to change the date and time to whatever the user specifies ], which once the XML is loaded into TextBox1, when the 'Modify' Button is clicked, that string is then loaded into TextBox2... This is where I am lost - How can I apply the modified string to the TextBox1.Text [ Entire XML file ], and save it upon program end, without the rest of the XML lines being disturbed? I realized I needed another Button - The 'Modify' Button now loads the selected string into TextBox2, and I have a 3rd Button to 'Apply Modification', which I want to update the <DateValue> string in the TextBox1 [ Full XML file ] from the modified string in TextBox2, then save on exit - Hope this helped clarify things.So here's the routine:
1. Form loads, opening the XML file, and loading it into TextBox1.
2. User clicks 'Modify' Button to load searched string into TextBox2.
3. User modifies TextBox2 entry.
4. User clicks 'Apply Modification' Button, which changes the searched string in TextBox1 to the modified user-defined string.
5. User clicks 'Exit', which saves the XML changes from TextBox1 [ Without messing up the XML file format ], and the program ends.
Here is something that I had in a VB6 program that worked great and was very fast. I'm trying to get it to work in VS 2005 but i am having no luck. I can'r get an answer from searching this forum or from MSDN. Here was the VB 6 Private Declare Function sendMessageByString& Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, ByVal lParam As String)
[Code]...
I am looking to programme a button to check if an entry from a textbox exists within a table.
This will done via a button.
how I would code the button to make it query the table?
My project requires users to be 18+. I have supplied a textbox for birthdate entry, but I don't know if that's the best way. Also, I don't know how to format it so that it only accepts date entry.
Next is the calculation part... yikes.
today - bithday = age
Code:
Private Sub Birthday_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Birthday.TextChanged
End Sub