I have one Field in MYSQL DB. Name is ' Field1 '. I can store the Richtextbox text(it contains Bold, Italic, Etc). using the code ' Richtextbox1.rtf 'But when i am trying to display using 'Richtextbox1.rtf=dt.rows(0).item(0).tostring ',It shows 'File Format is not Valid '.
View 2 Replies
I have determined thanks to the last q & a that there is something wrong with my "save to db" code as well as my "retrieve to picture" code. Even If I manually save the pic in the db it stil wont retreive. This is code i patched together from 3 or 4 examples around the net.
Dim filename As String = txtName.Text + ".jpg"
Dim FileSize As UInt32
Dim ImageStream As System.IO.MemoryStream[code]......
What kind of file format can I use to save the DataGridView's contens? Can it be the .xls format? This means I want to open the contents in Excel later. But I don't want to launch the Excel itself when I save the contents? Because Excel may not exist n the clients' machines. This means I just want to "save" not "export".
View 6 RepliesI'm making a program that has a "Print" button. I want it to open a PrintDialog, let the user select the printer they want to use, and print the contents in the RichTextBox/TextBox.
I was thinking about this:[code..]
I'm am having a heck of a time finding a code snippet that works for this. I have got to the point where it appears the picture is stored as a blob (perhaps incorrectly) by using this [code]...
View 3 RepliesI'm trying to do something quite simple. I need to take a pipe-delimited text file and store the contents of the file in an array.
View 2 RepliesI am working on my real time project where the configuration details will be given on runtime. Based on the configuration details, the next form will be loaded and the data will be exported to the database and spreadsheets from the pop3 server. I have done the extraction work from pop3 server. Now i want to store the configuration details that are provided in the controls present in the form. I am new to visual basic 2005 and it has the .Net 2.0 Framework. I do want to create the text file as notepad and and i want to save it runtime with the details. I am in hope that you people will me.
View 2 RepliesI have developed a vb.net dll (.net 3.5) which does the following :
- I have data of several stock market companies.
- They are stored in several folders under a main folder.
- These files are random access files.
- There can be around 4000 files in total for example.
I wrote a program which reads a current csv file and stores contents in array. Then I store name and path of companies in folders (which I was talking about). Then I match one company from csv (stored in array) to companies in user's folder (again reading from array). If found I insert data in the file (random access file). This whole process takes for eg. 2 min my system. A similar program was written years ago by someone in powerbasic which takes slight less time if run one but if run for multiple csv files it takes only a few seconds doing the same thing for other files. When I do the same thing (by writing code to .net dll) and making a dummy app to run it, no matter how many times I run it takes same time. And is way slower than the earlier one (PB) one I was talking about. But if I paste the same code in my win (.net) app and not use .net dll then it runs a bit faster.
I need to show status so if I pass my form's label reference to .net dll and it updates it does that slow down process a lot. As I mentioned I am trying to process the files and it takes longer in .net. What should I do to get best performance? Unfortunately due to unexplainable reasons I cannot change the format or use a db. The files which I am reading/writing (random access files) are use by other products so I have to stick to that format. What I am doing is storing the location of those files in array so that I don't have to search folder again. that is not taking time. But opening reading and writing files is time consuming if I am doing it for few thousand of them. A similar program in powerbasic (developed years ago) runs fast. Running code thru .net dll is slower than running it thru program. Why?
I'd like to use a dictionary to store the contents of an ini file. Now I know you can simply say
myArray.add("key1","value1")
myArray.add("key2","value2")
etc...
But Id like to store more information with a specific key, not just a single value, so id like to associate other values with key1 eg firstname,surname,address.
So by knowing the value of 'key1' I could retrieve the firstname, surname or address associated with it.
I know in PERL, hash arrays work in this manner
eg
$hash{'key1}{'firstname'} = 'john';
$hash{'key1}{'surname'} = 'smith';
etc....
I have a RichTextBox that contains a Customer History.
I need to be able to print the contents, allow users to select the printer they want to use, and print the contents without running off the printed page.
I'm using vb 2008 with Vista.
I am unable to read from the text file in VB. I want to read the contents for text file and store them in array. See my code below and the text file. How should I read this text file.
'Purpose : This program will read student name & final marks for a set of students from the text file and then calculate & display class average, class standard deviation, number of students above class average, name of student with highest mark, number of students with A's(90-100), B's (80 < 90), C's (65 < 80), D's (50 - < 65) and F's (<50).Calculate for standard deviation of a set of numbers:Step1. :Find the average Step2. : Square the difference between each number and the average
[Code]...
how to display richtextbox contents in Datagridview. Wat i am doing is on button_click1 i am loading text files to richtextbox and on button_click2 i am saving it in a Drive and loading from there to Datagridview is there a alternate way to directly load from richtextbox to Datagridview
View 3 RepliesI was wondering how I could go about returning the dimensions of the rectangle of the content inside a richtextbox? For example, suppose I have a richtextbox on a form with the text "Measure this text and graphic as a rectangle" entered into it and a small graphic object that I load into the richtextbox. How would I return the Rectangle of the text and graphic within the richtextbox?
View 2 RepliesI want to print the contents of my RichTextBox1.Text how can I do this?
View 1 RepliesI have searched google and youtube for a tut on this but cant seem to find any :/I have a script that adds contents of textbox1 ans textbox2 to a online mysql database like username and and password.All this works perfect What i now need is to display the contents of the given database in a listbox or something.How would i go about this or is there any good tuts on this, all i seem to find is tuts using ms database not mysql
View 6 RepliesI am using the following code for a checkbox, if checked it should print the text defined, unchceked, it clears the items in the ricktextbox. My problem is it prints fine (lets say it prints two lines) as defined, when I uncheck, it clears the text in rich text box, but when I check again, the text appears in the richtext box, but displayed from 4th line. I need to restart from the beginning/ or at least from the next available line. I cant use clear() since it erase all the contents as i have another 3 checkbox items placed.
If CheckBox1.Checked Then
richtextbox.SelectionColor() = Color.Blue
richtextbox.AppendText("Urgent:")
richtextbox.AppendText(CheckBox1.Text.ToString + vbNewLine)
Else
richtextbox.Refresh()
End If
I have 42 RichTextBoxes (RTBs) and I would like to add my ContextMenuStrip to each of them (which I have already done), but the problem I am having is when the application is running and the ContextMenuItem "Copy" for example is clicked, I can only make it copy the context of one of the RTBs, when I would like it to copy the contents of any individual one. So as I mentioned, I have 42 RTBs, but I am having trouble getting the contents of the focused RTB. The below code is just copying the 1 RTB and when I Copy on another RTB, it copies the contents of RTB1.
I originally started out with like so, but is just for the one RTB and when I add more than one in the code below it's even more of a disaster..
Private Sub Copy_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Copy.Click
RichTextBox1.Copy()
End Sub
I tried using this, but I was not sure how to add the copy function into it:
Private Sub Copy_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Copy.Click
Try
For Each itm As Control In EnumerateAllControls(Me)
For Each c As Control In itm.Controls
If TypeOf c Is RichTextBox Then
[Code] .....
How to Copy ContextMenuItem to focus on the user focused RTB.
I have a richtextbox contains Texts and Table. Now I want to send this richtextbox contents as email body message including table lines,
is it possible?
Dim Mm As System.Net.Mail.MailMessage
FrmMail = "onel@dreamincode.net"
ToMail = "mahey@dreamincode.net"
[code]....
How can I store an image in a MySQL database using VB.NET? Could you show some examples that use the INSERT command?
View 4 RepliesHow to store Mp3 Files in Database and display it into a listbox? So that I can load the files and display it into a listbox if I start my MP3 Player.
View 3 RepliesHere is my problem: I need to store HTML in a MySQL database. Afterwards, I need to be able to retrieve the HTML and have it be valid HTML that a browser can render.
How can I store HTML in a MySQL database using .Net? How do I retrieve it afterwards? As this is the design phase, I can create the database any way that is needed.
I'm having a problem with Dim query As New MySqlCommand("Select count(*)....") I would like to take the variable query and do an If query <> 1 Then statement on it. Is this possible or is there a completely other way to go about this comparing the contents of a MySQL select statement. I'm rather new to Visual Basic.
View 1 RepliesI am doing database coding for the first time. I wanted to get connected to MYSQL database with "Root" as username, "Password" as password , "DBNAME" as database name, "Local Host" as host and Append the contents of a textbox control to MYSQL column. So can anybody please post code bit in VB.Net for doing this task.
View 17 RepliesHow can I store and retrieve an image to a MySQL database using VB.NET 2005?
View 3 RepliesHow to store string data to mysql table.[code]...
View 1 Repliescode on storing path image and retrieve path into image using mysql database and vb.net/vs 2008. I only know how to make a browse button and get the image into hard disk and display it in picturebox. I'm done with the the problem is how to store the path and retrieve the path into image.
View 1 RepliesI am new in VB.NET. Can any tell me how a richtextbox query MySQL table. i.e select * from table test where name= 'Bowser' then the richtextbox will display the results.
View 3 RepliesWhat i need it to display all records in that database into a richtextbox or something.This is because i need to regarly check the database records and it would save a lot of time rather than manually logining into the cpanel and checking.I was looking at datagrid but that only does:Microsoft Access Database File (OLE DB)Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider for Microsoft SQL Server Compact 3.5)
View 2 Repliesis there a way that i would automatically paste the clipboard contents to my richtextbox after the shell command?
my code goes this way..
shell("ocr")
richtextbox.focus
richtextbox.paste
my code won't paste the clipboard details after it has finished the shell process.
I have successfully create a user name = 'root' and host = '127 .0.0.1 ', use the mysql command (client mode) as follow: sql = String.Format("CREATE USER '{0}'@'{1}' IDENTIFIED BY '{2}'; GRANT ALL PRIVILEGES ON *.* TO '{0}'@'{1}' IDENTIFIED BY '{2}' WITH GRANT OPTION;", userName, serverHost, userPassword) When the script above I change it to store procedure (server mode) as below, I found the error as follows: (Error 1064 - You have an error in your SQL syntax; check the manual That corresponds to Yout MySQL server version for the right syntax to use near 'pass' at line 1)
[Code]....
