I want to generate a cd key with the format "####-####-####-####". I am generating the key using some algorithm like "PPKG6B8ZPG79U05R" but I need this as "PPKG-6B8Z-PG79-U05R". For this I am using CreateKey = String.Format("{0:" & sFormat & "}", strKey), but it gives the result as "PPKG6B8ZPG79U05R".
View 3 Replies
I'm trying to use a GUID to generate 6 random alphanumeric characters (just letters and number). Is there a way to change the format of a GUID before it is generated. Or must I generate the GUID in its standard format and then manipulate it.
View 5 RepliesI'm returning a database query into a List object and using that list object to fill the X and Y axes of my chart as seen below. (_runData is a "List(of DatabaseTableName)" style Object filled with the results of my query.
Primary_Chart.Series(0).Points.DataBindXY(_runData, "DateTime", _runData, "UPPER_PRESSURE")
My Datetime field is returning as a Serial Number (i.e. 40116.76111) so I want to format the X Axis to display the field more readably. Enter my problem code.
[code].....
Im looking for a class or code in VB.NET that can convert a black and white image in JPEG format to a grayscale TIFF format.
View 2 RepliesI'm creating a VB app that uses the Infragistics UltraGrid to display data from 2 JD Edwards files. Before the data is displayed, first I need to convert 2 date fields that are in JD Edwards Julian date format (i.e., 111158 for 6/07/11....the 158th day of this year) to mmddyy format.
MCTS: Web Apps, MCTS: Windows Apps, MCTS: SQL Server 2005, MCP: Windows XP Professional, A+, Network+, Linux+, Security+, Master CIW Designer, SCJP
I am using VS 2005 pro and VB.NET. How do you format the DataGridView.DefaultCellStyle.format property for zip codes and phone numbers. I have a zip code and phone number column(s) that I want to be formatted. I have tried a lot of different things:
Zip code: "99999-0000" or "Phone Number: "(999)000-0000" or "(000)000-0000" and the like So far nothing has worked. I can get my date columns formatted correctly, but not these. Can any one give me some examples that work?
I need to take a string formatted like '010711' (DDMMYY) and put it into format '01-Jul-11'. Ive thought about doing something like string.toArray and then having some conditionals that format from there but am looking for an easier way.
View 5 RepliesWhen retrieving rows from an SQL Server table I use the following code select mydate, Customer, Details from sales where mydatetime >= '" & format (somedate, "MMM d, yyyy h:mm:ss tt") & "'"This works fine unless the clients computers windows Region setting is 'English (New Zealand)'The default time format in windows Region and Language for New Zealand is [code]On computers with this region setting I get an SQL Error 'Conversion failed when converting date and/or time from character string'..If I manually select the other option for AM symbol, PM symbol in Region and Language i.e AM PM the all works fine again..What format string can I use so that above code always works, even if the Region time format is a.m. / p.m.
View 1 Repliesformat Gridview's unbound column in 12hr format? i tried the following code, it didnt work.
[Code]...
I have a DGV that is getting data from a sql db. The dates in this db are stored as doubles ie 40025.708681
How do I format this column as Date/Time?
I tried but this doesn't seem to work.
how to do this? DGV1.Columns("HostDate").DefaultCellStyle.Format = "d"
The bottom line on a dropped-down datetimepicker shows the date different then in the text-part.In my case, the text-part format was yyyy/mm/dd, but the bottom part of the dropped down part stated Today: dd/mm/yyyy, what is probably the format set in the regional settings.
View 5 Repliesi just started usign Vb two days ago, as it was required for work and i just wondered how to change the format of the total into a money format
View 3 RepliesHow to convert jpg format into binary format using VB code ?
View 3 RepliesI want to format the Timespan to have format like this 49 hr 34 mn 20 sec
I used the String format below :
String.Format("{0:00}:{1:00}:{2:00}", theTimeSpan.TotalHours, theTimeSpan.Minutes, theTimeSpan.Seconds)
It formats the Timespan to this format 49:34:20. How can I add hr mn sec to the String.Format above? or there's another easy way?
How would I format txtLabel.Text to a currency format?
The text would be 15000000
I would like the text to show $15,000,000
How to format drive in FAT 16 format using VB.NET without user interaction?
View 1 RepliesI am using the sqldataadapter for generating the output of query in the form of XML. I have following sample query
select FirstName,LastName from Users where userid='Amol'
After fetching the data using sqldataadapter, I got the result in following format
<Dataset1>
<Users>
<FirstName>Amol</FirstName>
[Code]....
I have a rather odd thing happening with an Excel WorkSheet that I am creating through .Net.I load up an existing workbook
Dim _xlApp As New Excel.Application
Dim _xlWorkbook As Excel.WokBook = _xlApp.Workbooks.Open(_templateFileName)
set it to be visible before populating it (for debugging purposes)
_xlApp.Visible = True
I then go on to populate the existing template.
Private Sub GenerateOceanFreightGrid()
Dim columnCount As Integer = 4 ' _standardColumnCount
Dim columnInsertPosition As Integer = 5
[code]....
When i set a breakpoint on the "Private Sub Gen.." line, and step through the code line by line, it inserts a new column for each variable declared, so in this case it will insert two columns before it even hits the "If MyBooleanValue()..." line (I can watch it actually happen due to the Excel app being visible). However, if i dont set a breakpoint and just let the code run straight through this doesnt happen.There is no multi threading happening or anything else that i suspect would have any impact on the code.
im making a program that will generate a number ever 1000mil seconds and when it hits 0 its makes a new time and starts again
i have 1000mil seconds set on a timer and i have this code
If Labelcount.Text >= 0 Then
Labelcount.Text = Random.Next(1, waitTextBox.Text)
[code].....
I am writing an application in which we have a Product Module, Now instead of defining individual products, we want to just state the Size Ranges in Width, height and different size scale available, and then automatically generate a list of products with all the Size combinations. I cant figure how to do this.Ill give an example.This is how we define a product
Product[code].....
If i had a fixed number of Size types i would just run For loops within for loops and inside the inner most for loop write an Add Item statement with Index of evry selected item, however since the Size types are dynamic, i need to write a recursive loop, and i just cant figure how to.
I'm wondering how I would go about generating a random number in VB.Net. As I am developing an ATM system for a bank, a randomly generated 4 digit PIN code would have to be assigned to each person.
View 2 Repliesi am working with Visual Basic 2008 and i wanted to know how u can create a random word?
View 8 RepliesI want to generate an xml file from the vb.net form application and i have the following vb code and the xml output file is shown below the code
Imports System.Xml Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code]...
My task is to develop a Control library (VB 2005) in which u enter a variable in textbox (>=1 , <=5). Lets say you enter "3" then u have too see in table all combinations of boolean numbers for 3bits (000, 001, 010 .....etc). If you enter "4" the table have to be different (0000,0001,....etc) with 16 combinations.
View 5 Repliesi am making a Reflector,I want Some help with generating Blocks of Code(Loops,Branching,using Blocks,Switch Case Blocks etc).Until now i am able to convert IL to expressions and identifying startoffset and endoffset of a Code Block for Generating Code Blocks..The Trouble i am facing is Identifying the Initializer, Incrementer and Condition in a For Next Loop. which are contained between the StartOffset and EndOffset as Expressions. [code]
View 1 RepliesI was wondering if there was a way to dispose a control that i generated at runtime in a diffrent block of code, The reason why i can't dispose of the control in the same block of code is that the controls settings depend on what the user imputs. For example if i generate the control on a timer tick the code would look like this,
[Code]...
I have a following controls in my vb.net form:
CODE:
This form will be storing a values to the SQL Database (SQL Server 2005). In the txtID textbox the auto id should be generated when ever user clicks on btnAddNew. The ID should be generated in for digit i.e. 0000, 0001,0002, .... and so on.
When the form is opened next time and when the user adds the new record, the ID should generate next value coz the ID will not be duplicated.
I have a following controls in my form:
txtID
txtName
[code].....
The way we create our DataSet right now is right click on project then choose dataset and create every table then each element that makes up the table. There are at least 10 tables with over 10 elements in each.
View 1 RepliesI am currently working on a project for a client to organize company forms easier
Here is what I need the program to do:
1.Have an input box where the name of an image can be posted. (This image will be copied over to the website, but not from this program, a standard FTP client will be used for that)
2. When the 'Generate' button is clicked, a .html page will be generated which is completely empty (Except for tags and such, which is required) and code to embed the name of the image (from step 1)
So this way the 2 files (HTML and Image) can be uploaded to the server, and made live relatively quickly. There is a flash application that auto-updates that displays the avaliable forms that has been made, but it is a pain to do it, and plus, it wastes time from the IT guy's jobs where as with this program, the receptionist could do it, as she handles the forms.
