Can you set a condition inside the string.format parameter.So if i have
string.format("{0}" , if x = 7 then return "SEVEN" else return "ZERO")
Is there a way of doing this?
While searching on how to escape a single quote in String.Format, I found the answer at SO: Escaping single quote in String.Format(). It seems to be different for VB though. I tested it, and indeed C# needs
string s = DateTime.Now.ToString("MMM d \'yy 'at' H:mmm");
while VB needs
Dim s As String = Now.ToString("MMM d 'yy 'at' H:mmm")
Why does C# need a double backslash, and VB a single backslash? This might be a bit of a silly question to C# users, but while I can read C#, I'm not used to writing it.
I have some code in a VB module. When I run this with the SQL statement having hard coded values in the where statement it works. I am now trying to add Parameters to the module so that the Form can except an Input from a user, but I am getting the message: Input string was not in a correct format.
Here is the section of code:
objCon.Open()
objCmd.Connection = objCon
objCmd.CommandType = CommandType.Text
objCmd.CommandText = sSQL
[Code] .....
Like I said, if I substitute the Parameters for fixed values it all works.
I am populating a textbox with a single line of numbers that I would like to seperate out into strings.[code]...
View 3 Repliesa user copies multiple lines of text (say, from an email) into the clipboard. Based on my observations, when one tries to paste the text into a single-line textbox, only the first line is actually pasted in. (I am aware that the "obvious" solution would be to set the Multiline property to True, but there are reasons I am looking to avoid this and to put multi-line data into a single line.)
In the TextChanged event handler, I wrote code that parses the clipboard data to successfully convert it to a single-line, comma-delimited format.
Private Sub txtMassTrackingNo_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) _
Handles txtMassTrackingNo.TextChanged
[Code].....
var queryString = string.Format("filename={0}&filestream={1}&append={2)", fileName, Convert.ToBase64String(b, 0, bytesRead).ToString(), 1);
above line of code giving error 'Input string was not in a correct format.'
I have a function that is getting passed a String and a DataRow.The String is a custom formatter. The idea is to do this
String.Format(passed_in_String, DataRow("ColumnINeed"))
The reason this is being done is at this point we have no idea what the column contains.However, if the formatter is "{0:MM/dd/yyyy}" and the DataRow("ColumnINeed") is an integer containing 42, String.Format is returning: MM/dd/yyyy In this situation I need it to throw an exception instead of returning nonsense.Is there anyway to make String.Format throw an exception if the object does not match what the format string is expecting?
i have problem in displaying a single line in different line...
my code is
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Me.TextBox5.Text = Me.ListView1.Items.Count
[Code].....
Is it possible that when a new line (anywhere in a richtextbox) is added/deleted, then a line is also added/deleted in another richtextbox?
[Code]...
I want to modify a text file. It has a lot of lines of text in it. I want to add a line after a specific line (in the middle on other lines) and write strings there.
The code i have, writes to a specific line but it also overwrites the text on that line:
[Code].....
So I need a format string to pass to String.Format that would "move" the decimal point.I can't perform any math operations before doing the String.Format, so it has to work right off the bat.Basically I'm emulating a formatting string from a proprietary server. In it if I say:
"MR2"
for the value:
12345
The result is:
123.45
I'm close with this, but it's not spot on:
String.Format("{0:#0.##}", 12345)
an extra, but not necessary... there is also MR2Z, which moves the decimal 2 left, but if the value is 0 "" is returned.
however, i'm copying this directly from the book in its example format and still getting an error.
FormatException was unhandled
Input String was not in correct format
Public Class Form1
[Code].....
The code is as follows
dim st as string
st="select * from employees where empName='" & textName.Text &"'"
' The empName is Dani'e
'So the single quote with in the name Dani'e makes the vb.net code to halt.
If i have a line in a txt document "text.txt".Now what i want to do is open the file and read the contents.
When it find this "search.selectedEngine" term then it should delete that particular line and replace it with another string ("REPLACED STRING").
how to make a single column of a datagridview into currency format?
InventoryDataGridView.Columns(5).Name = "inventory_cost"
InventoryDataGridView.Columns(5).DataPropertyName = "inventory_cost"
InventoryDataGridView.Columns(5).Width = 70
InventoryDataGridView.Columns(5).HeaderText = "Cost"
InventoryDataGridView.Columns(5).???
i have a project and i want to insert multiple rows into a single column and then display them into a single text box...
this is what I'm going for:
DATABASE: column 1
| column 2 | column 3
| column 4 |
[Code]....
yes i know I've posted this in 3 different forums but no one seems to know either
I am filling datagridview with data from SQL server 2008 R2. one column is date which is stored in the data base as yyyy-mm-dd and when i retrieve it displays in the same format. I want to change the display to dd-MMM-yyyy.
Try
Connect_Design_Document_Record()
Dim cmdDrawing As New OleDbCommand("SELECT DRAWING_NO, DRAWING_DESCRIPTION, DRAWN_DATE, REVISION_NO" & _
[Code].....
Is a VisualBasic 4-byte single precision floating point variable the same format as Visual-C++ float?
I need to send floating point values from an embedded PowerPC written in gcc C++ to a VisualBasic GUI,and want to first test it by simulating the embedded using Visual-C++.software developer
I have an enum set with custom attributes. need to retrieve the attribute value in single statement ...
Public Enum Messages
''' <summary>
''' <value>(MessageText : Do you want to save ?)</value>
''' </summary>
<StringValue("Do you want to save ?")> Save
[Code] .....
Now I needed to retrieve the enum value like something below.
Messages.Save.GetType().GetCustomAttributes...... something is possible in single statement itself?
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 RepliesI am trying the following to select a long date, but becase the value is stored in SQL database as DateTime I am unable to return any results unless minutes and seconds match perfectly...I then tried to use 2 calendars and have the same issue with the DateTime format..
CODE:
Is there any way I can put Public Properties on a single line in VB.NET like I can in C#? I get a bunch of errors every time I try to move everything to one line.
C#:
public void Stub{ get { return _stub;} set { _stub = value; } }
VB.NET
Public Property Stub() As String
Get
Return _stub[code].....
How can you write a #If statement on a single line?
vb.net
#Const Debug = True #If Debug Then Console.WriteLine("Debug")'I also tried:#If Debug Then : Console.WriteLine("Debug") : #End If'
But that didn't work either?
I wrote very simple code to send emails. I wish that end users who do not have .NetFramework installed, could also install this application without installing Net Framework.
View 2 RepliesHow do I read a line from a database using WHERE? I've read this post but it doesn't really cover it and the forum search throws out the words, 'From' and 'Where' as being common. This is my bit of code but it just skips over it as if it doesn't exist so presumably there's an error, I dunno. I'm trying to read an entire line from the database where it equals the value of 'getweek' where 'getweek' is a variable.
[Code]....
I 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?
I'm new to vb.net and I have what probably is a simple question, but one that I am stuck on. I'm trying to add a single item to a ca combo box at run time. For example, a user selects a category from the first drop down box at run time, say "Admin", I want to add a single item to the combo box below it: Not applicable.
cboTest.Items.Clear()
cboTest.Items.Add("Not Applicable")
Why in the world did the VB team decide to change the format of a for statement for parallel processing to make it look more like a C# statement?Very confusing to VB programmers and it seems to be not needed. Why not just use the current for loop format prepended with the parallel?Certainly the compiler must be smart enough to be able to handle that?
View 2 RepliesI'm using Visual Basic 2008I've been trying to create a auto typer where I can put a whole page of words into a rich text box and the auto typer then pumps the words out one at a time.The code that I use is:
Timer1.Interval = TextBox1.Text
SendKeys.Send(RichTextBox1.Text)
SendKeys.Send("{Enter}")
That code would just type all of the words at once. Also, I'm putting the words in a rich text box. How could I save the rich text box so that each time I load up the application it still has all of the words in it?
Is there any box type in vb.net that is multi lined, however stays as a single line and when you click on it , it will open up into a multi lined box (because I want 10 of them in a small area , in single lines will be perfect but needs to have lots of information stored in each one) and then when the user clicks out of the box / into the next one, it returns to its single lined state?
View 8 Replies