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 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 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'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 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 RepliesWhile I understand there are properties of MailItem that would allow one to programmatically create a formatted email, I would prefer the ability to copy the body of an email that is already formatted to my liking (bolding, italicizing, embedded pictures/tables, set margins, etc.) copy and paste it to a newly composed email such that this formatting is preserved.
View 4 RepliesHow to show pop up menu from database in gridview on each gridview row items ?Example of this is : http:[url].....Move your cursor to Departure time and arrival time...a want this type of popup in gridview items....which fetch entries from database..
View 2 RepliesIn my application,i have a gridview in which columns are created at runtime.Actually these columns are created when i am entering data in a database table.[code]where Column1,Column2,column3 may vary during runtime.i need to enter values to these columns during runtime.But i cant bind these columns because these are created during runtime.The first column "Description" will not change.It will remain constant.For each description, there will be values for each column.At last these data will be saved to the database.How to add columns in the gridview during runtime?
View 2 RepliesI have a modal popup that contains a gridview. On the click of a button inside of a grid i reload the gridview with the data that depends on the id of the row clicked in the gridview. I would have like to reload the gridview onclientclick but I couldn't find a way to do that. Is it possible to reload a gridview client-side without the user even knowing the page partially loaded?
View 2 RepliesI am using VB.net.
I need to fill a gridview(1) with data that cames from another gridview(2), ie:
(2) - All articles in the database.
(1) - Selected articles from (2)
What is the best way to do that?
I have the following code, which generates insert queries
For Each f As String In Directory.GetFiles(d)
objSQLStringBuilder.Append("insert into table1 (full_path, file_name) values ('" & f.Replace("'", "''") & "', '" & f.Remove(0, Len(d) + 1).Replace("'", "''") & "');")
Next
However, the paths which it finds are formatted as follows
c:program filesmicrosoft officewinword.exe
I need to format the paths as follows
file:///c:/program%20files/microosoft%20office/winword.exe
How can I modify the above code to do this?
I have a Dynamic Fields comming from database. These fields populated on RichTextBox after changing the color.Means Different Fields in Different Color.
View 1 RepliesHow does the VB.NET compiler in this case determine which function is being called?
To me, it seems like it should raise an error because it CAN'T tell (or at least that's what it seems to me.)
Public Class Form1
[code]...
I just had a quick question about formating in currency in Visual Basic 2010 express. I already understand how to get it to work during runtime using the FormatCurrency feature, but I am wondering if there is a method to do it so that the user's input becomes currency instantly? (basically, is there a way to make the textbox always display as currency, rather than as a weird decimal?)
View 7 RepliesI am using a RichEdit control for the user to type in the content of the e-mail.
View 6 RepliesI am creating an XML table, and the table needs to have a title and then column and row headings. How can i write this in vb.net, the code in vb6 is below, is there something like XMLfile.Content = Blank? XMLfile is a class, cmbEngineOption is a check box on the interface. i'm not sure what tabstyle or frame are, but title is suppose to be refering to the title of the XML table.
[Code]...
I'm taking values from Numeric Ups and Downs for Hours, Minutes and Seconds. The problem is that, for example, if the time for example is 9.15 am it will show as 9:15:0 What I want to do is format them so if any of the values(Hours, Minutes or seconds) is less than 10, it will add a 0 before the number so as the number shows as 09:15:00. What I tried is this but it does not work: [Code]
View 3 RepliesTotal Physical Memory: 2144903168
Available Physical Memory: 934649856
Total Virtual Memory: 2147352576
[code].....
At the moment i am doing my IT PROJECt for college and i need my project not only to work but look good.
CVBox.AppendText(TextBox1.Text & vbNewLine & data & vbNewLine & ComboBox1.Text & vbNewLine &
nationality & vbNewLine & vbNewLine & TextBox5.Text & vbNewLine & "Tel. " &
[code].....
i am trying to format the result of a calculation to time.In VB6 I would use: answer = format(answer,"00.00")But in VB2008 this does not work,What I am trying to ahieve is always to display "00.00"
View 10 RepliesI am using a GridView and I need to show the currency in Arabic culture so I used this code which is working very well,
DataFormatString="{0:c}" The results will be like this : د.ك. 55.000 Now what I want is to change it like this : 55.000 K.D ???
How do I format my vb.net mvc date to a shortdate in my view
<td>
<%: Html.DisplayFor(Function(modelItem) currentItem.DateCreated)%>
</td>
I'm doing some math with the Timespans in .Net, and occasionally the sum results in a negative Timespan. When I display the result I am having trouble formatting it to include the negative indicator.
Dim ts as New Timespan(-10,0,0)
ts.ToString()
This will display "-10:00:00", which is good but I don't want to show the seconds so tried this.
ts.ToString("hh:mm")
This returns "10:00" and has dropped the "-" from the front which is the crux of the issue. My current solution is this:
If(ts < TimeSpan.Zero, "-", "") & ts.ToString("hh:mm")
but I was hoping to accomplish the same by using only the format string.
i want to write data in csv file using vb.net. so before writing the data i want to format the cell to text.how to do this.
View 2 RepliesI wrote a small program in VB.NET to export data from DataGrid to Excel and it works perfectly. My manager now wants me to display the data in a presentable format. How should I go about it. I recorded a macro but was unable to apply that in vb.net.
View 1 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 RepliesPrivate Sub Item_TypeComboBox_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Item_TypeComboBox.SelectedIndexChanged
'auto increment for each type of items
[code].....
I'm looking for the format specifier for String.Format() (or if there is a NumberFormatInfo class that will do it) to format a integer as octal in .NET, as {0:x} formats it as hex, e.g: String.Format("{0:x}", 15) // returns "f"
View 1 RepliesCan someone give me some code to set the cell of an excel spreadsheet to a number format that use a max of 2 decimal places. Or would it work better it I change the data I am putting into the cell to a proper format? Here is a sample of data that is going in. Right now its going in as a string... col("ADJ").ToString() where col is a DataTable oject.
View 2 Replies I currently have this to produce and emailI want to add color to 1 line and then set it back to back once it has complete
the line
oMail.IsBodyHtml = True
oMail.Priority = MailPriority.High
[code].....
