I am saving the text in a Rich Text Box(vb.net) into the DB. It saves fine..(Datatype--long text). The text has modified appropriately in the DB. But, when I try to retrieve it, it says, invalid format or cannot convert to integer (If Date of Birth is in the Text) or some vague errors...Please help THE ERROR : The file format is invalidHERE IS THE ACTUAL TEXT in the RTB --Notice the Bold and the UnderlineVITAL SIGNS:
View 5 RepliesOn the main form of my application, I have a Rich Text Box which is where the user will be entering information. The text is black. then, i have a button which calls the dialogue "Notes" A dialogue appears, with a rich text box. the user should then be able to enter text into the box, click "OK", and the text entered into the Notes dialogue be inserted to the rich text box on the main form -- with the font colour "Red". The rest of the text in the main rich text box on the main form should remain black.
View 2 RepliesI have a question, i need to store the value of richtextbox to MySQL and retrive the value from MYSQL to richtextbox. can you give me a code in vb.net? and will the formating be affected like the font and alignment?
View 6 Replieshow to handle Rich Text Format in VB.net 2005
View 2 RepliesI am trying to copy the contents of a word document which is basically in a letter format.I am trying to copy it onto a rich text box editor...but when i copy it..i am losing all the formatting of the word document.This is the code i was using
Dim aDoc As Word.Document = WordApp.Documents.Open(outfile, missing, [readOnly], missing, missing, missing, missing, missing, missing, missing, missing, isVisible)
aDoc.ActiveWindow.Selection.WholeStory()[code]......
How do I reference the Header and Footer in a RichTextBox? And if I can't how do I access it in a file in RTF?
View 1 RepliesI am unable to load rich text files into my rich text box. It worked fine yesterday, would there have been anything I could have changed by accident?
With OpenFileDialog
.Filter = "Text format (*.txt)|*.txt|Rich Text Format (*.rtf)|*.rtf|All files (*.*)|*.*"
[Code]...
but I am getting the error File format is not valid when i attempt to open any Rich Text file
I have a rich text box which I use in order the user is able to add pictures, coloured writing, different font etc... however I need to load specific text in the rich text box when the user load the Form.how I can add (I guess) the HTML to load this every time the user load the form.
P.S the text will change depending on who loads the form so I can not do a simple
RichTextBox1.LoadFile("C:Documents and SettingsDesktopSigniture.rtf")
I'm Making a Simple syntax highlighter and I'm Doing the highlighting in the text Changed event of a RTB and for obvious reasons I can't re highlight the whole document each time someone presses a key so i highlight one line each time the text changes. But this creates a Problem. If someone pastes code into the RichTextBox It only highlights the last Line. So is there a way to get if the user typed the text in with his keyboard or pasted it from the clipboard in the text Changed event?
View 6 RepliesMySQL databases exists for saving values as strings (text only). Is there any way that i could store files with the same speed as a mysql command ? I know that it depends on the file size but lets say that the file is "Avatar.jpg" 50KB... I ve tried FTP but this is not what im looking for. e.g. You want your users been able to upload a file like the [Add This Attachment] button does in dreamincode.net and you dont have any background on PHP/HTML/Javascript/ASP.NET just VB.NET and the basics of MySQL plus you dont want to use it for a website. How do you accomplish this? Something silly that ive tried was opening an image as text then update the mysql server with that text but it didnt work backwards after i wrote the text on the file and oppened it ...it said that the image was corrupted.
View 7 RepliesI have a question, how would i have a button, then when you click it, it puts the text at the text cursor in the RTF?
View 5 Repliesi'm having a problem converting a date to the right format. Below is the code I am using:
Dim getDate As DateTime
getDate = DateTime.Now
With cmdParent.Parameters
.Add("@date_created", OdbcType.DateTime).Value = getDate
.Add("@last_updated", OdbcType.DateTime).Value = getDate
[Code]...
This causes the following error: ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-5.5.8-enterprise-commercial-advanced]Incorrect datetime value: '' for column 'date_created' at row 1
This is being inserted in a MySQL db. The date_created column is of type datetime.
What I have is a vb app that has a datagridview bound to a MySQL database. One of the columns is a time that is updated at a set interval using the MySQL NOW() function. The format that the now function uses is MM/DD/YYYY HH:MM followed by the ante/post meridiem. What I am hoping to do is for each row in the datagridview, parse out just the time (H:MM). Then compare this time to the current time. If a minute has elapsed between the time that is parsed and the current time then throw up some kind of alert (e.g message box). I know I can loop throw the rows by using the following:
For Each DataRow As DataRow In DataSet.Tables(0).Rows
Dim time As DataColumn = DataSet.Tables(0).Columns("lastUpdateTimeStamp")
'If lastUpdateTimeStamp is greater than 60 seconds then
MsgBox("Some alert here");
Next
However I am not quite sure on how I can parse the MySQL NOW() format.
i've been attempting to update a DateTime Field in a MySQL Table i've created via vb.net. I've made many attempts however i'm still getting the error that i have an error in my SQL Syntax. The format that the DateTime in Vb.net is 6/21/2011 12:46:25 PM. I need to convert that to the MySQL DateTime Format which is 2011-06-21 12:46:25 and also is running on a 24 hour clock. I've searched many forums and haven't found a conclusive solution yet. Below is the code i have so far, with attempting any DateTime Conversion.
Imports MySql.Data.MySqlClient
Public Class FinalFailedPinNumberAttempt
Dim connectionstring As String = "Server=localhost;user id=root;Password=;database=mylaundrycompany"
Dim SQLConnection As MySqlConnection = New MySqlConnection
[code]....
everyone! I've been at this for a while, and I'm not sure how this issue can be resolved:I'm working on a project in VB.Net, and I have a form with a rich text box. I have a groupbox with 4 radio buttons inside that are intended to change the font color of the text. Coincidentally, I have to repeat this same functionality for a 2nd set of radio buttons that would change the text font family.
At any rate what I've only been able to do is the following to successfully change the font color of whatever text I highlight in the rich text box:
Private Sub rbtnBlack_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles rbtnBlack.CheckedChanged
rtbxTextEditor.SelectionColor = Color.Black
End Sub
Private Sub rbtnRed_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles rbtnRed.CheckedChanged
[Code]...
Is there a way that I could write a sub (I'm assuming I would use a sub, since I don't think I need to return anything, thus eliminating the use of a function) that would handle the action of changing the selected text color in the rich text box without having to use a separate sub for each radio button? Mind you, per my teacher's specs, she doesn't use a button handler for any of this.
is it possible to make first 60 characters in a rich text box a different color than the remaining text?
View 25 Repliesi want to insert a string as date format in mysql table using vb.net.my code is given below.but i always get an error .the string is stored in an array.
mycode
------
Dim sdfsa As String = Convert.ToDateTime(newarray(i + 17)).ToShortDateString().ToString("yyyy-MM-dd")
Dim newdate As Date = DateTime.ParseExact(sdfsa, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture)
datarw("date_of_birth") = newdate
I will show 3 columns of text in rich text box. i want show the column border with color.i can separate the texts with tabs or spaces but showing data in columns and cells will improve the visual of my program .
View 1 RepliesOkay, so what I want to do is directly output formatted RTF text to a Rich Text Box control in VB.NET. I don't want to find the text, select it and color it as it is not practical for what I'm doing. I've tried outputting RTF code but that isn't working either. Can I actually do this or will I have to write a dll?
View 1 RepliesI am working on an applictation to scan windows files to check for missing files, i have a couple questions on how to do this.I would like to use the %systemroot%system32 that way that it doesn't matter what drive letter it is, i'm not sure how to do this because when i tried it, it told me the file i was looking for didn't exist (in this case C:windowssystem32 undll32.exe) which does exist. Is there some way to use the %systemroot%?
Also, i am trying to print the resaults to a rich text box such as if rundll32.exe is missing put in the box "rundll32.exe is missing". How do I allow it to write it in the box, I tried the print command, but it didn't work.
I've been wanting to create a look like the attached jpeg Ive been looking around for a few hours for a solution to make text boxes transparent or have a background image. I've found a few projects on this form and elsewhere which include transparent text boxes, but every time I try to use it the way I need to--with the text box over a picture box--there are always various rendering errors. Most of the time, the text box is transparent if its just placed on the form (not over any other controls). But when I place them over other controls (like picture boxes), the 'transparent background' always take on the color of the form background.
This is one that I was trying to use. I found a few others around, but they all had the same render errors more or less.[URL]...I figured transparency or background images would have been supported natively. Anyone have any ideas? Maybe I missed something in my searches. I didn't really see anything which adds background images in text boxes (rich or otherwise). At this point, I'd just like anything that works, so it doesn't really need to have transparency--just a simple background image would be great.
I'm returning a database query into a List object and using that list object to fill the X and Y axes of my chart as seen below. (_runData is a "List(of DatabaseTableName)" style Object filled with the results of my query.
Primary_Chart.Series(0).Points.DataBindXY(_runData, "DateTime", _runData, "UPPER_PRESSURE")
My Datetime field is returning as a Serial Number (i.e. 40116.76111) so I want to format the X Axis to display the field more readably. Enter my problem code.
[code].....
anyone knows the query of selecting from monthname and year(September 2011) from mysql database DATE format(yyyy-MM-dd)
View 1 RepliesHow can I change certain text's color (like Visual Studio does with "Public Class" or "Public Sub") is inside of a Rich Text Box?
View 14 RepliesHow can I fully justify text in rich text box?
View 1 RepliesI want to transfer data from one rich text box to another but when i use RichTextbox2.text = RichTextbox1.text it transfer just text not images.if there is any way to do so?
View 4 RepliesI have ~ 1 page how to that is currently in a text file which I want to add to a richtext box.I am just wondering if there is some way I can just copy/paste it so it keeps its formatting etc.
View 1 Replieshave more than one text color in the Rich Text Box, because when I highlight one word and use the color changer, it changes ALL of the words in the text box, and I want to know how to be able to have a specific word, or words, be a different color.
View 13 RepliesI want to protect specific text in rich text box , I tried with
RichTextBox1.Select(1, 100)
RichTextBox1.SelectionProtected = True
above code is working fine but when i retreive data from database in .rtf format & I try to protect some text then its not working in first time it works second time
what I am trying to do is create an effect in a richtextbox so when the user types any text surrounded by Brackets { } is coloured a different colour to the rest of the text say blue for example. How would I go about doing this?
View 3 Replies