I know how to use the dataformattext field with a boundfield but now i am taking two of my columns and dividing them for a percentage so i want {0:P1} also how can i stop divide by 0 errors
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("total2")/Eval("acdcalls")%>'
Visible='<%# Eval("total2")/Eval("acdcalls") %>'></asp:Label>
</ItemTemplate>
I am able to export a gridview to excel, my problem is that I cannot figure out how to remove the formatting from coming over from the girdview. Here is the code I am using to export the gridview: Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code]....
I have a Gridview that has a timestamp as one of the rows. When I read the data from the database the data is in the format( mm/dd/yyyy hh:mm:ss ). I've figured out how to format the way I want it which is just the ( mm/dd/yyyy ) and droping of the (hh:mm:ss) with the following code:
[Code]...
I'm using Visual Basic to assign a dynamic dataset to a gridview control. The VB calls a stored procedure on SQL Server which always returns the last 28 days of info and displays it in the gridview with the column headings as the date.
[Code]...
lets just say this is my 5th hour (and counting) learning programming, i googled since hour 1, i even read almost all i can read while im installing visual studio 2010 coz i really want to learn this programming language coz somebody said that this is an easy language to learn coz of GUI..on this onei got a program here with 10 textboxes and 3 buttons, and i want to save every text on that textboxes in a file (myfile.txt)..i did that by using this commands
Button 1
Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click
[code].....
I am writing a new app that has some special text formatting requirements, but I'm finding it difficult to get the text to line up properly. I am currently using the following code:
[Code]...
In this section, I am trying to manually add in tabs and line spaces so the string is formatted when displayed via the pre tag. But this does not work.[code].Is it possible to display HTML as text on your page in a formatted manner? For example, it should contain white spaces, tabs etc etc for readability purposes:From another question, I have learned how to display HTML as text as follows:[code]
View 4 Repliescode used to print a certain text from and RTF box with different formatting for different words. Also, can I print preview it and page setup it. I tried to use the print dialogs but could not do it.
View 3 RepliesI am currently trying to save a piece of data extracted from a piece of hardware in my office and save it as a text file. The problem now is, the text file saves the data like this:
[Code].....
How to copy the text in a RichTextBox along with its formatting to a wordpad or webbrowser?
View 1 RepliesI'm try to come up with a way for a user to enter a date and time into a textbox and for that value to be saved as a datetime variable back into a database. I'm wondering if anyone knows of a clever way to restrict what values a the user can enter so that the datetime datatype isn't corrupted. I've been playing around with the date time picker but I cannot seem to get that to work for me. I'd like the user to either pick the date and time from a picker and save that into a variable. Or I've seen applications where the textbox will automatically have a formatting type of template that makes it hard for the user to enter an invalid date and time.
View 2 RepliesI have some WORD files, which are formatted using bold, italic and colors etc. I want to copy entire content of word file into SQL Server table using Visual Basic.NET.I have a RichTextBox on my form and used datatype nvarchar(max) to store Unicode Hindi data. Everything is working fine... data insert and retrieve is OK, but formatting is GONE.
Below is the code to insert.
cmd.CommandText = "Update tbl_Camps SET CampName = '" & StrConv(Trim(txtCampName.Text), VbStrConv.ProperCase) & "', CampVenue = '" & StrConv(Trim(txtCampVenue.Text), VbStrConv.ProperCase) & "', CityID = '" & cboCity.SelectedValue & "', FromDate = '" & Format(dtpFromDate.Value.Date, "dd-MMM-yyyy") & "', ToDate = '" & Format(dtpToDate.Value.Date, "dd-MMM-yyyy") & "', LiveDVpkt = '" & txtDVpkt.Text & "', <strong>CampNotes = N'" & rtbCampNotes.Text & "'</strong> Where CampID = '" & frmMain.lblCampID.Text & "'"
I'm reading in values from an array of arbitrary size into a text box. Easy enough. However, in my application, certain values of the data are unusable and I'd like to give a visual warning to the user when this occurs. Whenever the data
is either negative or greater than 10, I'd like to display that value in red. How can I do this with a RTB?
ok so i got this program it populates a 20 bound two dimensional array with random number, the first column shows the numbers in random order, the second column in ascending order, the third column in descending order, it all seems to work fine except when i get a random number that is 7 digits or less, it throws my formatting off making some of the numbers appear crunched into the left column
here is a picture of the output:
here is my code for module 1:
Module Module1
Sub Main()
Dim arraySorter As New Sorter
[Code]....
Ok so I have a program that is setup to create a textdocument formatted like this: @FName@ !LName! $Age$ &Location&..on each line. But I need in the program to load the text into designated columns for the listview by placing the text in the columns using the symbols as start and finish points for the information to be loaded line by line. I'm just not entriely sure how to do that.[code]
View 2 RepliesHow to make the selected text in a RichTextBox Bold,italic,underline ,change its color to red, Font to "Lucida Sans Unicode" and Text size to 18pt.
View 1 RepliesI want to know in a program idea I am working on to use at my job I have several text boxes that are used to store decimal values to represent measurements (weights & lengths) and I was wondering is there a way that when program first run the text field is populated with a default value (eg. 0.00) or if the user deletes all text in the control and hits enter or tabs to another control it sets value to same default value
View 2 Repliesi want to format a selected text in a richtextbox such as bold and italic i use this code to do that
With Me.rtbdoc
If .SelectionFont IsNot Nothing Then
Dim currentFont As System.Drawing.Font = .SelectionFont
[code].....
I've made a user control (http:url.....)I'm trying to format the text based on the data type e.g.:
Date
Numeric - 2 Decimals
Numeric - 0 Decimals
String
Now, I've added a property so that the user can decide at design time, what format he wants for the textbox. I've also made the options an enum. And then the coding in a sub. But not sure what I have to do with the sub.When I put it in the TextChanged event, then I get the weirdest behaviour from it.LIke when I typed in 1234 on Numeric0Decimals, after I typed 4, the cursor jumped to the first position of the textbox...On type Date, I just type in 2009/08 and then again it just jumps to the front and set the text to 01/08/2009 .So obviously can't place the sub in the textchanged event...
Private msTextConversion As TextConversionOptions
Enum TextConversionOptions
DateType[code]....
I'll obviously still change my sub to make sure that the text entered is numeric,or string, or valid date etc. Just didn't get around that part yet.
Are there standard controls for formatting, which I can add to the form or the toolbar? I mean font selector, text size selector, bold button, and so on. OR do I have to create them myself. If they are standard,l how do I add them? I can't find any such thing in the toolbox.
View 3 RepliesSo i wrote a script which does a few things and richtextbox2 is updated as follows:
a = 27,130,000,000
b = 2,930,000,000
c = 4,290,000,000
Problem is, when i copy the contents of richtextbox2 to the clipboard using "clipboard.settext(richtextbox2.text)" and then open up note page, and paste the clipboard contents, it is wrapped wrongly and i get the following in note pad:"a = 27,130,000,000 b = 2,930,000,000 c = 4,290,000,000"
I am using "system.envoronment.newline" in my code to start a new line.
I am currently trying to save a piece of data extracted from a piece of hardware in my office and save it as a text file. The problem now is, the text file saves the data like this:
[code].....
There are 3 buttons and 5 textboxes in my program. ignore the "plot" button as that is a machine specific code, as well as any weird lines like
Dim mgr As Ivi.Visa.Interop.ResourceManager
as these were provided by my machine vendor. I only need help with the data formatting.I am trying to program the "Agilent 8757D Scalar Network Analyzer.
I was using VB6 and all my text formatting is stored in a database from the way VB6 stores it. How do I apply this formatting to a rich text box in VB 2010?
View 6 RepliesSo I'm using a plain TextBox to display output from an ongoing background process. I've created a 'report string' that displays in my textbox like it has 3 columns; there's a VariableName, a VariableValue, and a VariableEffect (showing how applying that variable to the process affected it).In my textbox, any VariableValue entry that has 17 or greater characters gets 1 tabstop between Value and Effect; any entry 16 or less gets 2 tabstops, and any value 7 or less gets 3 tabstops which very neatly lines up the 3 columns.
View 5 RepliesI am faced with a rather large text file (200-400 lines)The file displays a lot of data however the problem is that it is not lined up. The data at the moment resembles this
Column1 Column2 Column3 Column4
Bobby Fisher Virginia Rural
Willis Johnson Oklahoma City
[code].....
RTB.text (or .rtf) = "Some text" & "some bold text" & TextBoxA.text & BoldTextBoxB.text.
How to I make "some bold text" bold and the text in "BoldTextBoxB" bold when it goes into my RTB?
I need bold, italic, and underline, but would prefer a general solution.
I have a rich text box in my form, and formatting will be applied to the text.
I need it to save the text with its formatting as a string (to be entered into a database)
My problem is, my current code only takes the text unformatted, so when the form reloads, the text is plain
I need to put some date to a text file and I want to make it readable. The date would look something like this:
[Code]..
I just want everything to line up nicely. Would I need to make my own function to do this or is there a way with string.format or regex?
I'm trying to make a simple tool to format SQL code so that I can use it in VB.When I put in the following:
USE master
CREATE DATABASE netGuest
GO
I get...
"USE master" & vbCrLf & _"
CREATE DATABASE netGuest" & vbCrLf & _"
GO" & vbCrLf & _"
So it almost works. Really the only thing not working is that the lines are ending with the " rather than starting with them.Here's my code:
Protected Sub btnConvert_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnConvert.Click
If txtVB.Text IsNot Nothing Then : txtVB.Text = "" : End If
Dim input() As String = txtSQL.Text.Split(vbCrLf)
[code]....
I have a VB Application that is loading an Array with Numbers from the Sequel Server that have numbers 315054 no cents and leaving the .00 off even numbers. I need to write out the number to a textfile that has 14 zero's to the left removing the decimal point from the number.
The Number should format and be written out like this:
00000031505400 in the text file.
My coding does this as long as the even number has a decimal point .00 but if the number comes in as 315054 into my array my coding gives an Argument error with the coding below.
SCreditTextBox1 = Microsoft.VisualBasic.Right("00000000000000" & Microsoft.VisualBasic.Left(_sData(Irow, 7), _sData(Irow, 7, ".") - 1) & _
Microsoft.VisualBasic.Right(_sData(Irow, 7), 2), 14)
Is there a way to check for no decimal point and then place the number with no .00 as 00000031505400?
The accounting people are entering the numbers into the server this way incorrectly. The .00 is suppose to be entered with it, but not all even numbers are entered this way without .00, just a few, but I need to check the number to see if there are decimals and without decimals do something. Could my coding be re-written to account for not having the .00 and to format the number correctly to avoid the argument error?
I need for any number to format with:
$3,000.00 would appear in server as 3000 or 3000.00 and should write out like this below: I need to check for decimals and without decimals and writeout the format like this below:
00000000300000.