DB/Reporting :: How To Include DB Info In RichTextBox
Jul 27, 2009
I have connected my database to visual basic.I have a form1 which allows me to scroll through all the data in my database (i.e. the name, account no, address etc)My form2 contains a calculation involving payments which involve the previous account.My form3 needs to contain this calculation PLUS the database information in a RichTextBox. My question is how do I include my DB info in a RichTextBox? (i.e how do I pass the information from form1 onto form3)
View 4 Replies
ADVERTISEMENT
Apr 24, 2011
For a class project I am thinking of doing a Spelling Bee game. I would like to have a button that will place the word in a sentence, and a button that will give the definition. Are there .txt dictionaries out there with this information? I've checked a few places like WordNet but I didn't see a dictionary that also includes sentence info. My other concern is using custom classes. I don't have a lot of experience creating classes, and I really want to become more familiar with them, so it is important that I integrate them into this project. What would be a logical way using classes in this project? Maybe a 'word' class?
View 1 Replies
Jun 30, 2009
I'm Making my own email reminder. When a button is clicked it will send info from three textboxes and one richtextbox.But when i get the email, the text arent with spaces between what is typed in the diffirent textboxes.
So etc. "NiceCoolGoBad"
"Nice" is textbox1.
"Cool" is textbox2.
"Go" is textbox3.
"Bad" is richtextbox1.
How can i make my own text between them?
[Code]...
View 3 Replies
May 13, 2011
im using as usual vb express 2010 right now on winxp, but planning to make the programs fully suported on vista & win7.
First heres my structure on public class:
Structure cartas
Dim numero As Integer
[Code].....
and the richtextbox4.text has paragraphcs or vbnewlines however u wanna call them.
Saving it on a txt file looks like this:
7:John:Marcelo:this is first paragrah[]this is second paragraph[]and this is third
note i use [] to simulate the squareish paragraph thingie that is used in a textfile. since if i try to copy it here, it will automatically convert itself into an actual paragraph.
Anyways when i try to load the file using readline i only get the first paragraph displayed and all the rest of this specific text unexistent.
View 10 Replies
Jun 30, 2009
When you click a button, i want the program to send info's from 3 textboxes and one richtextbox. Public Sub Email(ByVal Subject1 As String, ByVal Body1 As String, ByVal ToAdd As String, ByVal Acc As String, ByVal Pass As String)'(Subject,Body, Email to be sent to,Email account, Password)Dim smtpServer As New SmtpClient Dim mail As New MailMessage
[Code]...
View 1 Replies
Nov 17, 2009
What I am trying to do is get specific info from a database and what I am getting is the first entry.
I have made a database connection, made the top bar not visible and I have inserted a text box and multiple labels. My MDB database has 3 columns (street, city, postcode) and multiple rows.
What I want is when a user enters a postcode in the text field the other labels get the info related to it. I.E. when a user enters "FY1 3DL" the labels update to "King street" and "Blackpool". With the code below I get the first row from the database.
Code:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Me.StreetsTableAdapter.Fill(Me.WcipcodeDataSet.Streets)
End Sub
View 1 Replies
Nov 30, 2009
I'm working on a simple "sports management" game just to test out whether I could make an actual one some time in the future, but for the life of me I haven't been able to figure out how to save the contents of the datagridview. I want it to be saved in a format that doesn't require the user to have Access or any other program, so that the only thing users need are the .exe and the database file. Another question about the datagridview: How do I access the content on specific rows and columns of the datagridview? If I want TextBox1.Text to be whatever is written on Row 4, Column 2, how do I access that information?
View 1 Replies
Jun 4, 2008
I need to convert a large VB6 app to vb.net which does a lot of database work and produces a Crystal Report. The initial form is simple a login form which validates the user. I am trying to use a datareader to retrieve the user's login info but it won't compile on the statement where I'm trying to get the Connection String from the app.config file. It complains that the ConfigurationManager is not declared on the dim statement. Where and how do I declare the ConfigurationManager? I thought it was just pointing to the app.config file but apparently that is not correct. [Code]
View 3 Replies
Feb 17, 2009
I'm writing a program in VB.Net and loading the info into a SQL database. Debugging it works fine on my machine that I am programming it on, it connects to the database and runs through all the info perfectly. However trying to get it to run on another machine it will not connect to the database. I realize the reason for this is the connection string, it's looking specifically at the file directory for the database. How do I change this so that it will function on any machine. The program is only intended to run on one machine at a time and not over the internet.
View 2 Replies
Feb 2, 2011
I need to write some code to tell the user when daylight savings starts and ends in another timezone, this is what I came up with but it keeps selecting the last Else line. The other lines are working fine, the problem is only with the lines, daylight savings today and not tomorrow. There is probably a much neater way of doing this but I thought this would work.
Private Sub Auto_Time_Change()
Dim sydneyTime As TimeZoneInfo = (TimeZoneInfo.FindSystemTimeZoneById("AUS Eastern Standard Time"))
If TSSlblTimeZone.Text = "Normal Time" Then
If CurDate.AddDays(1).Day = "1" Then
[Code] .....
View 4 Replies
Aug 11, 2009
i have a rich textbox with some data that need to be stored in a datagrid it refreshes every 30 seconds and its a player list. the problem is i know how to show 1 player in the datagrid but the next one i dont...
i dont know how to stop my CharArray when it finds an enter and from the enter that it put those value's in a new chararray...
my code :
Code:
' my timer
If Now >= ReqTime Then
DataGridView1.Rows.Clear()
[Code]....
View 6 Replies
Jun 15, 2010
I want to include an average in a column where the average ignores zero values in a report cell where the column may have
17
19
0
[code].....
I want 16, not 11 so (17 + 19 + 12 + 13 + 19) / 5 not (17 + 19 + 0 + 0 + 12 + 13 + 19) / 7 Something like this if it would work.
=SUM(Fields!fieldname.Value) / Count(iif(Fields!count_cycle_per_hour.Value >= 0,Fields!fieldname.Value,0))
Essentially just average everything in the column NOT a zero?
View 4 Replies
Jan 22, 2011
What SQL Server data type should be used to store RichTextBox text? The reason I ask is because the BOL indicates not to use text or ntext anymore because these data types will be excluded from future versions of SQL Server.
View 4 Replies
Mar 12, 2010
I am very new to programming so let me apologize for that upfront.I am using Visual Studio 2008 and have created a windows application form. I have the form connected to an MS Access database named vendors.accdb. I have added a DataGridView to my form named VendorsDataGridView. I have also added a RichTextBox to my form named RichTextBox1.[code]I have my form setup to run queries that compare like items from different vendors and display them in the VendorsDataGridView.what I need the form to do is when I doubleclick on a particular row (in the VendorsDataGridView) I need it to copy to the RichTextBox1 and go down to the next line so I can add more rows from different queries.I need to understand what goes between the Private Sub and End Sub of this:[code]I could use a textbox instead of a richtextbox if need be.I have searched high and low for the answer to this. I have tried a variety of things but none have worked. I have been reading different books to try and understand Visual Basic code better but I am too new to programming to get the doubleclick event to work.
View 1 Replies
May 20, 2011
I have very complicated, unnecessary code because I wrote it myself and this is a new concept to me. The code is intended to find a string in the main window's RichTextBox (the string is obviously supplied by the user). The code works fine, but due to its convoluted nature, I don't know how to implement a "Match case" function.
The form has these controls (at least the ones you use when searching for text):
Textbox: "txtFind" - User enters a search term here
Checkbox: "chkMatchCase" - Allows a user to choose whether or not to match the case of the search term
Button: "btnFind" - The Find Next button
And this is my code
Dim index As Integer = 0
Private Sub OK_Button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnFind.Click
Dim strSearchTerm As String
[Code].....
Anyway, if there's a better way to implement this, please let me know. And I did extensive searching, but found no good solution. I ended up combining a bunch of little parts of other tutorials into this. If there's no better solution, I'd just like to know how to implement a "Match case" function.
View 1 Replies
Jul 31, 2010
I am working on a media player, and I would like to setup a local playlist feature. I am using a single ListBox and its "Display-" and "Value-Member" properties. The display is the song's Artist and Name, and the value is the song's file path (i.e 'C:UsersUSERMusicetc.').To write the file path to the .txt file, I believe I can use the following code:[code]
View 18 Replies
Jul 23, 2009
how to create Quick info and/or parameter info for own code?
View 6 Replies
Jun 22, 2011
I am making a program, obviously, and I require some assistance. I found an explanation on how to read information from a Text file and have modified it for my needs. Here is my (modded) version:
Public Function GetInfo(ByVal playlistname As String) As String
On Error Resume Next
Dim PlaylistInfo As String
[code].....
View 6 Replies
Jan 7, 2010
I'm making a database app. I've finish the search, add new, and add function. What I'm trying to do is to expand the functionality of the add new item function.
View 2 Replies
Nov 17, 2011
I am trying to do is fill out a form with certain info, put the info into an array, and write it to a listbox using loops, arrays, and maybe a function if I need one. This is for VB2010 and here is what I have so far... I think there are ways to make it shorter but I cannot figure it out.... maybe just brain dead from all the coffee I have been drinking!
[code]...
View 1 Replies
Sep 6, 2011
under my project I have the following
However when I use this code.
lblABOUT3.Text = "Version : "
lblABOUT3.Text += My.Application.Info.Version.Major.ToString()
lblABOUT3.Text += "." & My.Application.Info.Version.Minor.ToString
[Code]....
View 8 Replies
Mar 17, 2009
how to correlate info from a textbox based on a listbox item selection. For example the user will select an item from the listbox, enter say the length of a song in the textbox say 2:00 for song #1, select say song #2, enter the song time for that song say 3:00, click on song #1 again and have the same textbox display the length of that song and be able to do that until there are no more songs on the list.
View 5 Replies
Aug 26, 2010
I have a richtextbox with a large file inside....I want to be able to search for "Fornication" within the text (KJV Bible) and have every instance of that word to pop up into another richtextbox along with the scripture it is in.
View 1 Replies
Jun 28, 2011
I'm currently having a problem dragging and dropping my label1.text to a richtextboxt which isn't created on design time...well im currently found a solution but i think it is only for a temporary solution because i use a drag and drop i drag it to a textbox then it willl transfer the data to the richtextbox....through the use of the textbox... here is the code ive come through..[code]...
View 2 Replies
Sep 17, 2011
Can I get info from stored cookie on the local machine. I have a Webbrowser control in a winform, and I would like to output data from a cookie to a label or so.
View 4 Replies
Jul 25, 2011
I am creating a text editor like notepad. Well its an advance type because it is a tabbed notepad type. It saves html files.
I only created tabcontrol on the design time named TabControl1. the tabpages and the richtextbox are created on the form load and when adding tabs. [code]...
View 7 Replies
Jul 26, 2011
I have 2 forms. The 1 is named frmMain. inside of it is a Richtextbox named RTB.
The other form is named frmInsert. Inside of it is a Richtextbox named rtbtext.[code]..
View 5 Replies
Jan 9, 2009
I want to do something like this:
Code:
'create a dataset and a table
Dim ds As New DataSet
[code].....
View 5 Replies
May 14, 2009
i have a c# script the validates emailadresses. I want to access the script in my vb project. I imported the .cs file but i have no clue to access it.
So far i added:imports microsoft.csharp
There seems no way to reach it, system does not seems to know it is there..
View 21 Replies
Feb 1, 2009
Is it possible to include an SWf in an EXE? (So that there is no separate file?)
View 8 Replies
