I want to store rich text from vb.net to mssql database. My question is what will be data type in mssql to store rtf information.Also is there any free control availble to show basic buttons to conntrol formatting for rich text box like colors , fonts, etc. as i found standard rtf control in vb.net just show the text box and no way to format the text in rich text box.
View 2 RepliesI have a rich text box and i want to enter 10 values and I want to use this button I have to store it. How can I do this? Or can anyone link me to the Microsoft site with information about this? (this is visual basic in Visual studio 2008)
View 3 Repliesis there a way to store blobs / rich text memos as rtf programmatically on server hard disc instead of the database ?
Update (1)
i want to write in a memo field and store it using identifiers like sessions and time stamps for example writing a memo with the session "subject" and session "dateANDtime" to be stored as "mysubject-12/12/2010-11:56pm.rtf"
how to retrieve the file. can i build hyperlink programmatically?
I 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
When I insert rtf data from rich text box in sql table containing 3 char(255) type columns + char(6000) columns it returns access violation error.
View 12 RepliesI want to show rich text box data in a datagridview.
The data is stored in a access DB and when I show this data in a datagridview there is a HTML text shown.
I have a number of text boxs that gather data and put it in a combined string in a rich text box that displays all of the collected data. Some of the text boxes require data pasted from other sources however when that data is then copied from the rich text box to the clipboard through a routine, it loses its formatting. home to maintain the original formating?
[Code]...
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 am using visual basic 2010 and i am making a program that stores text data in text files and when i go to debug the program it doesnt let me.
View 7 RepliesI have a question (suppose to be simple). The question related to reading text file which is in the below format.
[Code]....
What I want here is to store the first data column in the file to be stored in AreasString and 2nd column in Level, 3rd in Importance and so on untill the end of the data. In addition, How can I check the type of data? For example, if I want to say: If 10.25 is double then msgbox ("it is double") else msgbox ("it is integer")
How to store text data to mysql table. My string data is : dim strPath as string strpath="D:My projectFirstMonoHighr.rst" I can do it. but stored string data is with this"". D:My project FirstMono Highr.rst How to solve this problem..?
View 2 RepliesI'm trying to build something called a structure which will store data it retrieves from a text file. I have the structure set up like this:
Structure Employee
Dim FirstName As String
Dim LastName As String
Dim ID As String
Dim Hours As Integer
Dim Wage As Decimal
Dim EarnedPay As Decimal
End Structure
[Code] .....
How to set these operations up?
I'm creating a Client Server application which involves theServer running some scripts in clients and getting back results in an automated way. In Server, other than Main thread, i have 2 worker threads, a) one monitoring response from clients and b) the other scheduling next available job to respective client which executes that job. The issue here is ,I want these worker threads to write the status of their work in the UI(which comes under Main Thread). Also i need to write things in worker thread in a Data table and Rich Text Box in Main thread. But, I can't do so, since it has been blocked to access one thread's function or property directly from others. Is there any work around to do this?
View 8 RepliesI'm watching tutorials about creating Web Site and about controls.I think I added SQL Database to the project (it's not empty) properly. Suppose it has two columns: FirstName, LastName.I have TextBox1, TextBox2 and Button1 on the web site form.I enter any integer number (5, 10, 15 or whatever) into TextBox1. I want to press Button1 and get a value of 5th person (10th, 15th or whatever) from SQL Database into TextBox2.Who can help me with that? Should I read about ADO.NET and use something from there?Later I want to use VB for work with that strings.
View 2 RepliesHow to Find data using a combobox? I make a code to search or find it's work but cannot find the data..this is my code:
[code]...
but when i try using a textbox it's works.
currently developing the backup and restore procedure of my database....and im using the SQL UTILITY[URL]..but...i was thinking if is it possible to obtain the Data Source or the Server name automatically...when the form load.
View 1 Repliesfrom picture at above, i just generate all file to get filename , title and MD5 hash.. but, how can i save all data from picture (datagridview) into MSSQL server?
View 5 RepliesDim Dr2 As New OleDb.OleDbCommand
Dr2.CommandType = CommandType.Text
Dr2.CommandText = "SELECT... FROM... WHERE..."
Dim Dr1 As OleDb.OleDbDataReader
Dr1 = Dr2.ExecuteReader
The above code was originally written in VS2003 to retrieve and display data from Access 03 database, and runs without error. In VS2010, this code is throwing a "Command Text was not set for the Command Object" error and points to the last line as the source of the error.
How fast did the VB.net inserts a data in a Mssql database??
View 1 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 problem with transfering data from MSSQL Server 2005 to Access.
I need to make a VBScript that can take out all data from one table in mssql and update one table in Access. The tables exist in both databases and looks the same, but there can be more data in the table from MSSQL Server so i need to update the table in Access with this data.
E.g. I have a table called: SMP_Alert in both database's. So i want to do something like this (dunno if that is possiable):
Set objConMSSQL = CreateObject("ADODB.Connection")
conMSSQL = "Provider=SQLNCLI;Server=127.0.0.1SMP;Database=SMP;Uid=SA; Pwd=smp;"
objConMSSQL.Open(conMSSQL)
[Code].....
Or do i need to create a recordset of the table (SMP_Alert) from MSSQL, and loop through it to transfer the data into the table in the Access database?
I have 200,000 rows data need to be inserted into MSSQL 2005 express. I have 4G memory. From the beginning, there is 2.0G used. Then, I use microsoft text driver to load text file into datagridview. Memory rise to about 2.8 GB.I start write data row by row from datagrid view. Memory usage keep rising , then OutOfMemory exception is catched.I try to use GC.Collect and for System.Data.Odbc.OdbcConnection , I also try .Dispose(). But it is no use.How can I keeing the memory within about 3.0GB for this usage ? I monitor .vhost.exe. It rise to more than 1G.
View 2 RepliesUsing Table control: how to display data from connected MSSQL?
View 2 Repliesi know that integer is a variable to store whole numbers and that a string is a varialbe used to store any text, but what variable type would you use to store a number that has decimals?
View 7 RepliesI'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 RepliesI'm new to Visual Basic, VS2005.I've added a Table to the WebForm. At Default.aspx this code was added automatically:
[Code]...
I 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 Replieseveryone! 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 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 Replies