|
i have a string abcd 36.2 How to get the value 36.2 only , with abcd can be changed?
|
|
|
|
|
Hi
one option is that you can loop through the entire string and check for numerics
ie.
Dim x As String = "abcd 36.2"
Dim value As String = ""
For lp As Integer = 0 To x.Length - 1
If IsNumeric(x.Chars(lp)) Or x.Chars(lp) = "." Then
value &= x.Chars(lp)
End If
Application.DoEvents()
Next
MsgBox(value)
hope this helps
Anoop
|
|
|
|
|
That's the hard, slow, and non-globalized way to do it...
|
|
|
|
|
thanks
i have run time error 424 Object required .How do i solve it ?
Thanks\
|
|
|
|
|
There's always a space separating the text and the number? You could split it up on the space;
Dim MyString() As String = "Test 123".Split(' ');
You can get the integer-part like this;
Dim MyNum As Integer = Int32.Parse(MyString(1))
I are troll 
|
|
|
|
|
Is the format always going to be 'AAAA ##.##'? Meaning is the value always going to be 4 letters followed by a space?
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
No, lenghth of the string in front are variable . My purpose to get the number inside?
|
|
|
|
|
Hi,
split the problem in a couple of smaller ones. There are at least two parts:
1. locate the "word" that contains the number
2. translate that word to a numeric value
1. depends on what you do know about the pattern in the string.
e.g. if the number is always at the end, find the last space, get the substring behind it.
if there is exactly one word plus a space in front, find that first space and look for a possible space after the number too.
2. is easy with int.Parse or int.TryParse
If you were really lazy (I wouldn't dare to assume that), split the entire string in words based on a space, then foreach "word" do a TryParse until one succeeds.
And now you are on your own I guess.
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
|
|
|
|
|
Hi dec82;
you could use a regular expression to pull the numeric data out.
' Test data
Dim testData As String = "abcd 36.2"
' String to hold the wanted info
Dim numericValue As String = String.Empty
' A regular Expression to pull out the needed info
Dim m As Match = Regex.Match(testData, "^.*?(\d+(?:\.\d+)?)")
' Test to see if the string had a numeric value on the end of it
If m.Success Then
' Pull out the information
numericValue = m.Groups(1).Value
End If
MessageBox.Show("Numeric Value = " & numericValue)
Fernando
|
|
|
|
|
Hi I'm working on a project that involves printing a datagridview and I don't know how to write a complete code for, it looks too complicated please somebody help it's urgent.
|
|
|
|
|
|
I have a Interbase database file and want to use in VB but I don't know to make connection to Database
have somebody to know make connection
|
|
|
|
|
The Wikipedia page says that it supports standard interfaces, so access it like you would any other database
|
|
|
|
|
Use an OleDb connection, and set the connectionString[^] accordingly.
Good luck
I are troll
|
|
|
|
|
what is "sibprovider" give me this error "The "sibprovider" provider is not registered on the local machine
|
|
|
|
|
It's the driver[^] that you use to talk to the database. There's also one available for ODBC, from EasySoft[^].
Enjoy
I are troll
|
|
|
|
|
I have developed an application using Visual Basic .NET 2008 which uses a MySQL Database. The connection string i use is something like
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
so actually the server is localhost, database name is customers(or watever!), and uid=root and pwd is ***** :P
so everything works fine...now this program is something which i need to run on other computers as well....so do i have to install mySQL server to each and every computer that i need to run this software? cant i get a single database like MS SQL Server ?? .mdf or .sdf??? Plz help me! and if possible please tell me or post a website which can help me deploy the database to another computer to use.
This is a project which i need to submit to my university so plz tell me what files i need to burn on to the CD that im submitting and any special instructions that i should include in the CD to run the project
Thanx loadz in advance
|
|
|
|
|
swaroop09 wrote: so do i have to install mySQL server to each and every computer that i need to run this software?
Yes, you do.
swaroop09 wrote: cant i get a single database like MS SQL Server ?? .mdf or .sdf???
There's no such thing. Even for SQL Server files, you have to install at least the SQL Server Express Edition. You can't just throw an .MDF file on a machine and expect the app to use it.
How do you deploy an app using MySQL?? A little research[^] would be in order.
|
|
|
|
|
Hi All
Im trying desparately to search a sql table image field passing in a parameter which is a byte array. I am having no luck whatsoever. I get this error when i run my code below :The data types image and image are incompatible in the equal to operator.
<br />
Public Sub SearchByteArray(ByVal ByteArr() As Byte)<br />
Dim strSQL As String<br />
Dim oConn As SqlConnection<br />
Dim oCmd As SqlCommand<br />
Dim oBLOBParam As SqlParameter<br />
Dim str As String = ""<br />
' Try<br />
' Create and open connection object<br />
oConn = New SqlConnection("data source=XXX;initial catalog=CustomApps;user id=sa;pwd=xxx;")<br />
oConn.Open()<br />
' Insert statement<br />
' Notice that @BLOBValue is a placeholder for the actual data<br />
strSQL = "SELECT BlobField from MyImageTable where BlobField = (@BLOBValue)"<br />
' Create a command object<br />
oCmd = oConn.CreateCommand()<br />
' Set SQL statement<br />
oCmd.CommandText = strSQL<br />
' Create a command parameter<br />
oBLOBParam = New SqlParameter("@BLOBValue", SqlDbType.Image, ByteArr.Length, ParameterDirection.Input)<br />
' Finally, set the actual data<br />
oBLOBParam.Value = ByteArr<br />
' Add this parameter to the command<br />
oCmd.Parameters.Add(oBLOBParam)<br />
' Execute SQL statement<br />
MessageBox.Show(oCmd.ExecuteNonQuery())<br />
' Close the connection<br />
oConn.Close()<br />
<br />
End Sub<br />
Can anyone help or assist please ?
|
|
|
|
|
Hi,
I am not an SQL or database expert but I would be very surprised if SQL could do record selection based on BLOB content.
I do have one suggestion: you could add an 'imageHash' field to your table, then with an app, calculate and store the image hash value one. Any algorithm would be fine. Later on, when you want to search for an image, calculate its hash value, then search for the hash value.
NB: there is a slim chance a hash search may result in more than one match, so you would still need code to compare the bytes if you want to be absolutely sure you got the right image.
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
|
|
|
|
|
Mates,
hello, i need help. how to run or call rdlc report in vb.net.
why is it that i dont have Me.ReportViewer in code. I added already the reference Microsoft.ReportViewer.WinForms but still. I google already. but their examples has Reportviewer. Is there any something i missed.
Thanks for in advance.
C# コードMicrosoft End User
2000-2008
「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」
|
|
|
|
|
You won't find a ReportViewer object in your project unless you drag an instance of it from the ToolBox onto your form. Once you do this, it's default name will be ReportViewer1, not ReportViewer.
|
|
|
|
|
why i have the following msg ??
Namespace or type specified in the Imports 'System.Managment' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases. C:\Documents and Settings\XeleX\Local Settings\Application Data\Temporary Projects\WindowsApplication1\Class1.vb
|
|
|
|
|
Don't cross post on multiple forums. It makes collaborating on an answer very difficult.
One of two things happened. You either didn't set a reference to the System.Management.dll file, or you tried to use a namespace as a class or object.
For the reference, right-click "My Project" in the Solution Explorer, then click on the References tab. Click on the Add button, then in the dialog that pops up, click on the .NET tab. In the list, look for System.Management and double-click it.
If you tried to use System.Management as a class, you need to rewrite your code a bit and use the correct class in that namespace. You can't just specify "System.Management" as expect it to work.
|
|
|
|
|
thanks a lot dave
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
