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]...
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 am trying to make sense of an msdn article: [URL]..as i need to print the contents of a Richtextbox - including text formating. Now i know im not the first to wail about how painful printing is in .net, but im now stuck.
The article isnt too easy to follow, that or im need my caffeine drip changing.
So far as i have understood it, i have added a class to my project, called Richtextboxex.vb
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 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>
How to print the contents present in the gridview using Vb.net
View 1 RepliesI' working on an Office Supplies website for a college course I'm doing. I have most of the website created, I'm just working on the shopping cart element of it now.When the user goes to check out, I have a Gridview displaying the items the user wishes to buy as follows, it contains 3 columns, REF NBR, Product Name and Quantity, when the user clicks on the 'BUY NOW' button I want to take all the reference numbers from the Gridview and search teh database and deduct the Quantity from the number of items in stock.
View 2 RepliesI have a gridvidew (GV2). I want the user to be able to export the contents of this gridview to an excel spreadsheet for offline processing.Here is my subroutine:
Protected Sub ExcelButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles ExcelButton.Click
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
Me.EnableViewState = False
[code]....
On clicking the ExcelButton I get the error message:
Control 'GV2' of type 'GridView' must be placed inside a form tag with runat=server.
The control GV2 is in fact inside:
<form id="form1" runat="server"></form>
I have some VB .NET software that interfaces to a load of old (but sound) COM objects. The VB provides a GUI for the COM objects, part of which consists of setting various options on the COM objects - several of which relate to string formatting.I have a simple pair of VB .NET functions that convert basic %f, %d, %g formats to/from .NET equivalents using a large select case covering specific common strings, but they don't cover all formats.[code]Before I start diving in and making it more versatile with some parsing, does anyone know of a class (eg VB or C# .NET) that provides a decent ready-made implementation? Or perhaps some regexp wizadry could be used?
View 2 Repliesif this is not the right area to be posting this. I couldn't find an area dedicated to discussion about IDE features.Somehow one of my .vb files is not showing the nice formatting that is default in VS2008, such as the text colors, etc. how I can get this back? I don't know what to search for, as I don't know what its actually called. On the left you see what I want, and on the right you see what I have right now.
View 4 RepliesI have a program that is calculating the cost of a certain number of plane tickets, the validation and basic calculations are fine the only problem i've got this: There is a discount text box field called "txtDiscount" where IF a user enters a number it will discount this as a percentage off the total cost of all the tickets, but I cannot get it to work [Code]
View 2 Replieshave a really annoying VB 2008 problem and I'm hoping someone knows how to solve this. I implement the following code:
Code:
DispArrDate = MonthArr & "/" & DayArr & "/" & YearArr
DisplayArrDate.Text = DispArrDate.ToLongDateString
So basically, I'm getting date information from the user and trying to convert it into a date format, and show it to the user in a text box which is obviously named "DisplayArrDate", and "DispArrDate" is a date variable and "MonthArr" & "DayArr" & "YearArr" are strings which are always numbers because they are selected from a drop down combo box.
Now, the code works perfectly on my computer and some others, but for some unknown reason, on some computers, even if they have the same local date settings, it gives me the error: "Conversion from string "4/13/2009" to type 'Date' is not valid.", that's just one example, where "13" is obviously the day. I use the month/day/year format because, in the toturial I'm reading, it tells me, that no matter my local date settings, when using VB 2008, the month/day/year format should always be used and it will display a date in the local format automatically. It seems that on some computers, this isn't the case, and the month/day format is creating errors.
formating a date here
Dim dt As DateTime
dt = dsTitles.Tables(0).Rows(0).Item("servicedate")
lbldate.Text = Format(dt, "dd/mm/yy HH:MM")
The original date is - 19/08/2008 00:00:00
the date that variable dt gets is - #8/19/2008#
the final result is - 19/00/08 00:08
Good day to all of you again, I've been looking into this problem for several hours now and I can't find what is wrong with my piece of code
[Code]...
I have this string "0.9874" and I would like to use vb code to change it to "0.9.8.74" so that it looks like a proper version number.How do I do this? String.Format("{???}",MyString) or perhaps:
View 8 RepliesA TimeSpan by default shows hours, minutes & seconds when converted to a string. How do I show only hours & minutes? I tried ts.ToString("hh:mm") but that doesn't work.
View 7 RepliesI want to make an application that allows you to format a drive.My application consists of a combo box (so user can select drive) and a format button to format the selected drive.
I would like to know is this possible and if so how?
I need to make sure that a certain textbox only allows dates to be entered under a certain format EG: DD/MM/YYYY
View 8 RepliesI'm a bit rusty when it comes to formatting the old xml's lol i can write them fine, i have this so far:[code]
View 3 RepliesExample:
Format(781234.57,) 781235
Format(781234.57) 781234.6
Format(781234.576) 781234.58
[code]......
I have two labels, one that will show the total gallons used in a journey and one that will show the total litres, both of these labels refer to their own Integer variables. How do I get the results to be shown only to 2 decimal places? This code below seems to work with Gallons but not with Litres?
[Code]...
i have an array of booleans whose current boolean values I want to preserve but add additional length to the array? How can I achieve that? My code looks like this:
Dim Array() As Boolean
Dim ArrayInterimShort() As Boolean
ReDim Array(119)
[code]....
PROJECT TYPE: Windows Forms Application
LANGUAGE: Visual Basic
.NET VERSION: 3.5
[code]....
I am attempting to display time in a label on my MainForm. The label should display a stopwatch control's elapsed time in hh:mm:ss format. My code is displaying "00:00:00". I have defined the hh, mm and ss as variables but I can't seem to figure out how to use them effectively.
vb
Public Sub RefreshTimeElapsed()
' Refreshes time elapsed display.
Dim hh As String = Me.MyStopWatch.Elapsed.TotalHours.ToString
[code]....
i am trying to display a line of smiley faces ☻ and change the colour of each face, i cant use a find method as there are 10 of these smilies so i thought about using a loop and selecting only the last one entered and changing its colour. here is a simplified version of my
VB.Net
For a = 0 to 9
RichTextBox1.Text += "☻" ' add the smiley
[code]....
This when i ran it changes the first nine to the first colour in the array and correctly does the colour of the last smiley? could i for instance format the character first then add it formatted?
So 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 have a text box that displays a phone number. The data is coming from a database.Right now it just displays as "xxxxxxxxx". I'd like to display it as "xxx-xxx-xxxx" or even "(xxx) xxx-xxxx"Here's the code that I'm currently using to display the phone number - PhoneTextBox.DataBindings.Add("text", aBindingSource, "Phone")What can I add to this line to get some formatting?
View 2 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].....
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 am trying to create a code where I placed sets of numbers in an array.I'll use a masktextbox to have the user enter the numbers to match what's in the array. If the user enters the number, ex: social, and the data is correct (matches the numbers in the array), something happens if the number entered in the masktextbox does not match any of the number sets in an array then another thing happens.The masktextbox so far only validates format and gets number only, however, I want the number entered to match whats in the array.
View 1 RepliesI have a DGV and a TextBox into my form. The TextBox displays the "DGV.rows.count" for example as "3" but i want to show me "00003". How can i format this textbox to display data like "000XX"?
View 3 RepliesWorking on a class project where one heading in a lisbox has to be indented while the subsequent information has to be right-justified. Not sure how this is done.Have tried writing code like:
'To list cost of parts in listbox
''Formatted so value is in U.S. currency
lstTotal.Items.Add("Parts" & ControlChars.Tab & ControlChars.Tab & ControlChars.Tab & parts.ToString("C"))
But using ControlChars.Tab over and over again doesn't seem very efficient. The spacing in the listbox looks uneven and the code looks more cumbersome--less easy to read.