User posts text into textbox/grid etc Button is pushed. The text is formatted as if it were in a spreadsheet. ie Only x words per row Each cell is of equal length and width.To put it another way; The first letter of the second word of the first row. should be directly above the first letter of the second word of the second row.
View 2 RepliesI'm writing a very basic program that pulls data from an excel spreadsheet into VB.
[Code]...
Okay, 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 was working on a project and could not get the text output to be formatted like a table in text-box or rich text-box in visual basic 2010. Here are the code i have tried.
For i = 0 To 17
If cartfull(i) Then
rtbReceipt.Text = rtbReceipt.Text & vbNewLine & amount_added(i)
[Code]......
I have a wizard I jinned up at work to import a CSV into our database. The intro "welcome screen" has a fair bit of text regarding the catalog format, but it looks so... bland.
My thoughts turned to making an html page, adding it to the project, and then in place of the text box of instructions have a web browser control to load that specific html doc in the project.
The html doc would have all sorts of pretty formatting and what not (bold, bullet points, colors, etc).
I've been trawling the web for ages trying to find some dll's/code to be able to extract text from a PDF file and keep the formatting as much as possible.I did find something last year, but it simply took all the text and created one big list of every section in no particular order, so I couldn't read the values I needed from it.
View 1 RepliesI'm using VB2008 Express and Flash CS4. I'm trying to create a CGI-formatted text file with VB2008 and use it in Flash. Below is an image of the form I'm creating. Beside each number is a textbox for input of the answer follwed by a double-numbered textbox. There's also three radio buttons on the top of the form, "Single", "Double" and "Triple". Single is multiplied by 1 for a number-inputted text box; Double is multiplied by two and Triple is multiplied by 3. Take a look at the form below and you'll see what I'm talking about.
View 1 RepliesI've put a page long document into a richtextbox, thinking I could get rid of the cursor (or caret -- whatever it is when you click on it) but no luck. (I guess there is an API for this -- and it may come to that).
View 1 RepliesI've decided to come back to working on an old program of mine, and it's been coming along nicely, but there's this one thing that I can't get working.I have formatting options (Bold, Underline, Italics, Strikethrough) available on my program, and they all work properly. I'm giving users the ability to export all of their text from a single page on the program to a .rtf file. However, the problem I'm experiencing is that each page has numerous RichTextBoxes on it, so I cannot simply use a RichTextBox1.SaveFile() command or something similar. I want to compile all of the text (including formatting) from all of the RichTextBoxes and put it on a single .rtf file. Currently, I'm getting the text from the RichTextBoxes using the RichTextBox1.Text command; unfortunately, that only gives me plain text without formatting. So, what I'm wondering is: how can I get the formatted text from a RichTextBox? Is there any command?
View 6 RepliesThe text I am trying to put my pattern into is:
<li class="hp">
<span>HP</span>
<strong>1850 (+300)</strong>
</li>
The (+300) can go away...i'd really only like to return just the 1850.
Visual Studio 2005 I have an application that prints formatted text to a printer. I'm using the sample code from MSDN to impliment PrintDocument.PrintPage. My function for formatting the pages uses exactly the same code.
The problem is that the actual printout is off by one line. The footer from the first page prints at the top of the next page. Subsequent pages scroll down by one line for each page printed. If I reduce my formatted text lines by one, the opposite happens... the header from the second page prints at the bottom of the first page.
I've fussed with margin settings and fonts and I just can't seem to make it print pages correctly. I'm hoping that someone out there has seen this and can offer advice.
[Code]...
I have a richtextbox with some colored and formatted text
I'm using regex to put some html codes around the keywords so I can dump the output into a wiki i have
For example:
Code:
What I'm struggling with a little though is how to do the comments.
lets say I have:
CODE:
my regex does:
Code:
I can assume that if I see a -- then the rest of the line is green..
I have
Code:
which puts the font tag at the start, but dont know how to get the end of that line..
The format I need is a group of numbers in a text file and it looks like this and it will always look like this:xxxx x xxxxxxxx xxxxxxxxx x xxxxxxxxxxx xxxx x
The problem is that it can be anywhere in a text file so I cannot search by a particular line.
How can I search for this type of string format in a text file?
I have read serveral tutorials online and seem to be missing something. I am trying to have the leading 0's show up in columns by setting the format to text.
''' <summary>
''' This is required for the grid view to export properly
''' </summary>[code]......
I need to export data to a text file either in VB or SQL and it has to be formmatted like this. The data is in a SQL Databse[code]...
View 7 Repliesi have a textbox in my app, and when you click the button it inputs the textbox.text into a website textarea this worked fine when i was testing it using the source code (html file on my computer) but what i did not realise was that the textarea was formatted with some java (added tools to the texarea) so now when i try it on the website it does not work as the textarea has the java running. (calls it from another url) code i was using
Me.WebBrowser1.Document.GetElementById("elm9").SetAttribute("value", Form1.TextBox10.Text)
IN THE HTML:
textarea
<td>
<textarea name="home" id="elm9" style="height:400; width:900">
I try to insert formatted text into Word bookmarks. The text comes from several rich text controls (we use TX Text Control) and is appended into a bookmark. The problem is that the tags are written as-is and are not interpreted.
oWord = New Word.Application
Dim strFileName As String = "\...Template.dot"
oDoc = oWord.Documents.Add(strFileName)
[Code].....
I tried with RTF or HTML format for my string but it is the same behavior.
Instead of the send message text box and message display text box, I have replaced it with RichTextBox for text formatting (bold/italics/underline/font/color). The problem I am facing is when I format the text and click on send, then the text displayed on the message display box (txtMessageHistory) is unformatted. [Code] Rest of the code of client is related to formatting of the rich text boxes that is not relevant to my problem. I just need to transfer the formatted text from client to server and then back to the client the same way and display the message with text formatting.
View 13 RepliesI am using vb.net 2005. In my form there is RichTextBox, when i write particular format with bold,diffrent font,color and save to sql server 2000 database with datatype 'Text' then formatted text not save in database.what is the way or source code to save formatted(rtf) text to databse, and how to display/retrive formatted(rtf) text back to RichtextBox.
View 1 RepliesI have a VB.Net program that reads in a flat file, and then parses line by line, formatting the data into different spreadsheets in an excel workbook (each line can be any 10+ different record types so I parse and put in appropriate excel sheet).
For smaller sized flat files (under 10mb), the parser works great. However, I am trying this on a file that is over 120mb (400k+ lines). While running, I will get an OleDBException saying that the spreadsheet is full. Now I am pretty confident that Excel can handle a much larger data set than a flat file. So I assume this exception is not giving me the true story as to what is really occuring.
I open a connection, and then parse each line in the file, inserting each row into the excel file. I assumed it would be bad performance wise to open/close the connection between each insert. Could this be causing the issue? Any ideas what I need to do to handle such a large file? There are cases where the flat file can be over 500mb.
To actually do the insert into excel, I am just doing the following (I construct an sql query based on the type of row and values parsed):
Dim conn As New OleDbConnection()
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ExportLocation.Text + "" + importFileName + "-PVF.xls;Extended Properties=""Excel 8.0;HDR=YES"""
[Code]....
Im trying to retrieve some rows from sql server having datetime column that matches the given value of the textbox in a form. The tables datetime column name is "DepDateDepositDate" and the textbox.text was formatted as longdate eg("Tuesday, April 06, 2010") I have this code below but it seems its not retrieving the data that i wanted.
Dim daBnkBok = New SqlDataAdapter("Select * From DepositRef Where Convert(varchar,DepDateDepositDate, 112) = '" & Convert.ToDateTime(clsGlobals.BankBook.bbDepDate.Text).Date & "' ", bbcons)
Can I get some assistance please on converting a basic text file into a excell spreedsheet (comma delimited).
I need to take this file that contains[code]...
I'm using the following code to populate a DataGridView with a worksheet. This is working fine, however, I'm unsure how I can get the Text from the page header. (not to be confused with the column header). Later in my code when I am exporting into an existing workbook with a new worksheet, I'm wanting to use the header text as the tab name. The header text being "September 2009" so that when I import/manipulate/export october, the new tab will be "October 2009" etc. [Code]
View 1 Replieswhen I try to publish my project, I have this error: Cannot continue. The application is improperly formatted.Contact the application vendor for assistance. [code]
View 1 RepliesI'm trying to get the first row in each worksheet to be shaded and have the font bold. Right now, I am able to get the first worksheet changes made, but none of the other worksheets within the same workbook are being changed. Here is what I have written so far for creating the spreadsheet and applying a format.Public Function WRITE_TO_EXCEL(ByVal dt As System.Data.DataTable, ByVal includeheader As Boolean, ByVal worksheet_index As Integer) As Integer
[code]...
I have a database full of dates that are in the format: MM/dd/yy. For example, today's date (November 4, 2011) is saved in the database as: 11/04/11. I'm having trouble with date ranges since my dates aren't formatted as yyyy/MM/dd (example: 2011/11/04). I don't have a way to change the way the database is populated, so I need to account for the date formatting differences within my MYSQL queries (via VB.NET). Here is my query (it doesn't work well because the dates are in the incorrect format):
SELECT CMP_DATE FROM my_data WHERE OBJ_DATE >= '1994/01/01' AND CMP_DATE <= '2011/11/04'
Is there anyway to reformat the dates within the query?
I am using tiny mce in a text box and trying to send emails.
<asp:TextBox ID="txtBody" runat="server" Rows="10" class="tinymce"
TextMode="MultiLine" Width="100%"></asp:TextBox>
but the email which is sent is not formatted..
<p><span style="background-color: #ff0000;">hello</span></p>
it shouldnt say all that? just hello with a red background?
Sub SendEmail(ByVal sEmailAddressFrom As String, ByVal sEmailAddressTo As String, ByVal sSubject As String, ByVal sBody As String)
Dim msg As New MailMessage
msg.To = sEmailAddressTo[code].......
my format statement from vb6 is not formating right in vb 2010. Here is what I have.
sw.WriteLine("202" & Trim(Str(1000 - index)) & "0" & Trim(Str(kdex)) & Chr(9) & Format(Plotrecinp(1, kdex),
Chr(9) & Format(Plotrecinp(index, kdex), "#.#####E+##"))
This is what it gives me: 20299901 14415.58E+14415.58E+ It should be more like this: 20299901 2.88462E-1 1.45098E+4 nevermind the difference in the number values. the formatting is what I want.
I have a Datetime Picker on a form.
When I use dtArrival.value for instance, it gives me the date in the format "24/04/2010 10:54 PM"
Is there a way that I can grab the value in the format "YY/MM/DD" e.g the value would return "10/04/24"?
Also whats the easiest way to calculate the number of days between two datetime pickers on the same form? I've tried to do it and it's just a mess.
In datagridview,i want to display the amount without decimals. so whatever values coming from backend,i'm directly assigning to cells value.then in cell formatting event, i'm formatting values without decimals,so here after formatting,the formatted Cell Value not reflecting in Original value. when i read the formatted value , its displaying only assigned value not formatted value..ex :
Public Class Form1
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
DataGridView1.Item(0, 0).Value = Val(12.123)[code].......