|
I just found out myself. I have to use the Split(string) operation but is there any way to split the string without having blanks to seperate it?
If anyone of you knows how to split "123-234" into 123 and 234 (meaning the two integers) then please let me know. At the moment I am able to split "123 - 234" into "123" "-" and "234" but well, if there are no blanks inbetween my programm will crash. And I really would like to avoid this 
Thanks.
Stephan.
|
|
|
|
|
Why use split? Just use SubString:
Dim a As Integer
Dim b As Integer
Dim s As String = "123 - 456"
Dim i As Integer = s.IndexOf("-")
If i < 0 Then
'must be in xxx form
a = Integer.Parse(s)
Else
'in xxx-yyyy form, so parse
a = Integer.Parse(s.Substring(0, i))
b = Integer.Parse(s.Substring(i + 1, s.Length - i - 1))
End If
This will work if spaces or no spaces. If you need the strings rather than the integers, just use stringa = s.Substring(0, i).Trim. The trim will remove leading or trailing spaces.
|
|
|
|
|
Scott Serl wrote:
a = Integer.Parse(s.Substring(0, i))
Well, seams as if VBA for Excel does not support "Integer.Parse"
Or does it? At the moment I am on Office 2000 but might soon be updating to Office 2003.
I had a look and the help says there is only a normal parse operation. The examples says parsing a telephonenumber and seperating it into two Cells (similar to my example). Maybe I could use this one ...
Or was your example supposed for .NET? Because actually I do not have this installed here and at the moment I do not have access to it. So I have to get along with what Office is offering 'til I will be able to use .NET
Stephan.
|
|
|
|
|
Sorry,
In Excel, it would be something like:
value = "123 - 456"
Pos = Instr(value,"-")
If Pos > 0 Then 'I think position starts at 1 in Excel
a = Val(Left(value, pos - 1))
b = Val(Right(value, Len(value) - Pos))
Else
a = val(value)
End If
I can't check at this computer because I don't have anything with old vb on it here.
|
|
|
|
|
now that i ponder on it a bit, when i use the split function in c# i simply do the following -
myString.split('-')[0] //gets xxx
myString.split('-')[1] //gets yyy
I wonder if you couldn't do the same for vb.net i.e.
myString.split('-')(0) //gets xxx
myString.split('-')(1) //gets yyy
|
|
|
|
|
You can but VB.net likes you to specify that the splitter character is of type char. Also the single quote is the comment character in VB.Net so you have to use double quotes.
myString.split("-"c)(0) 'gets xxx
myString.split("-"c)(1) 'gets yyy
If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
|
|
|
|
|
Sorry for writing this Question to this part, but i write it in SQL part, i got no answer
I have a table named "DebitsAndCredits" which has fallowing columns
AccountNumber char(12)
DebitCredit bit
Amount money
I have the same table in two databases which are MB0001 and MB0002
I would like to join them in a one result set.I write
SELECT DISTINCT (AccountNumber ) ,
(SELECT SUM(Amount ) FROM DebitsAndCredits m
WHERE m.DebitCredit =0 AND m.AccountNumber =f.AccountNumber ) as Credit,,
(SELECT SUM(Amount ) FROM DebitsAndCredits m
WHERE m.DebitCredit =1 AND m.AccountNumber =f.AccountNumber ) as Debit
FROM DebitsAndCredits Order BY AccountNumber
UNION
SELECT DISTINCT (AccountNumber ) ,
(SELECT SUM(Amount ) FROM DebitsAndCredits m
WHERE m.DebitCredit =0 AND m.AccountNumber =f.AccountNumber ) as Credit,
(SELECT SUM(Amount ) FROM DebitsAndCredits m
WHERE m.DebitCredit =1 AND m.AccountNumber =f.AccountNumber ) as Debit
FROM DebitsAndCredits Order BY AccountNumber
i dont know why it is not working in my way. I expect a table has three columns (AccountNumber,Credit,Debit ) as a result.
What is Wrong?What do u offer for me?
|
|
|
|
|
you must specify the database names in the query eg.
Select ..... from MB0001..DebitsAndCredits m1 ......
Union
Select ..... from MB0002..DebitsAndCredits m2 ......
If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
|
|
|
|
|
I have already done that. But i realized i forgot writing that when i asked
|
|
|
|
|
I have DOTNET project that connect to excel through RTD. After some time say 2 week the excel lose the connection to RTD component
I will be thankful if any body guide me how to solve this problem or how to fiend the reason of it
And thank of all any way
note:
the excel use interop dll to connect to the assembly dll
Aswanee
|
|
|
|
|
Well, there's nothing we can tell you since you haven't provided any useful information about the component RTD is connecting to. Is this a component that you wrote or a third party? What does this component do? We would also need to know about any error messages that are thrown.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I have an application written in VB6 that allow others to write plugins in the form of an ActiveX control. Now I want to allow dotnet usercontrols as plugins as well.
There are examples on the net of how to expose a windows forms usercontrol to COM as an ActiveX control. Although not actually supported by the framework, these seem to work if the usercontrol is loaded in a VB6 form. However, when the dotnet usercontrol is loaded inside a VB6 usercontrol, arrow keys stop working. Apparently they are interpreted as tabs (even if focus is in a textbox or listbox).
Now my question is, first, is there a way to solve this? Any pointers would be appreciated.
Second, since this is not really supported and I already have seen problems, I'm getting worried about more problems ahead. Is there anyone who has used dotnet usercontrols in VB6? Does it work well, or are there other problems that will appear later?
|
|
|
|
|
HI,
PLease let me know the provider or the connectionstring i should use to
read a .dbf file.
The oledb provider i am using works fine if there is no memo field in the
.dbf( i.e .fpt file)
But fails if .fpt is present
|
|
|
|
|
hi,
i need a shapes control to draw rect,square & circle.also,allowing the user to resize them.its urgent pls help.thanks in advance
parag
|
|
|
|
|
Take a look in the System.Drawing namespace which contains classes for drawing anything you like on a form or usercontrol.
If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
|
|
|
|
|
Good day to all,
I have a Access2000 database and would like to edit my entries from the internet. How could I go about setting the webpage and site up? How can I also provide security as I want to limit the access to my database to a number of users only. Thanks alot.
|
|
|
|
|
Well, first of all you need to write an ASP.NET site. I'd recommend using C#, because it sounds like you need a lot of help, and there are a lot more people answering C# questions, and C# samples, here on this site.
jamestong wrote:
How can I also provide security as I want to limit the access to my database to a number of users only
You can filter via IP, or set up a password system, whichever suits you better.
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
Hi Christian,
Thanks for the opinion, but my project is using Visual Basic and database is Access. My project dateline will be in a few wks time. Hence I dont think there will be time for me to merge from one programming platform to another.
I will stick to VB and Access. Any help from the rest?
Rgds,
James
|
|
|
|
|
Do you mean VB6, or VB.NET ? If VB6, you're screwed. If VB.NET, you can still use ASP.NET, but you'll find less help online, at least here.
Why do you have a project on for which you have 2 weeks, and not the faintest idea how to do it ?
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
hello...i've use the datagrid which is bounded with the textbox...however,when i tried to view what i've develop in the browser,the datagrid will not appear.
i've tried many things to make it appear but there is no avail.can somebody please show me how to fix it??? =(
besah
|
|
|
|
|
First, since you mentioned "browser", your question really belongs in the ASP.NET Forum, not VB.NET.
Second, fix what? Be sure to include a code snippet in your post so we can see what's going on and how your doing things.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
First time contributor
I have a copy application that copies a folder from one location to another.
If Directory.Exists(loc1orginal) Or Directory.Exists(loc1backup) _
Or Directory.Exists(loc2original) Or Directory.Exists(loc2backup) Then
Try
LogEvent("Copying " & loc1orginal & " to " & loc1backup & " ")
fso.CopyFolder(loc1orginal, loc1backup)
If chkLocation2.Checked = True Then
LogEvent("Copying " & loc2original & " to " & loc2backup & " ")
fso.CopyFolder(loc2original, loc2backup)
End If
Catch ex As Exception
LogEvent("Exception generatted: " & ex.Message)
berror = True
End Try
I would like to add a progress bar to the app for the user, simple! But how do I measure the values needed to feed the nim and max values to the progress bar comtrol? Will I need to compare size of the directories and match from there????
Please help
japel
|
|
|
|
|
If your going to use the File System Object CopyFolder method, you really can't add a meaningfull progress bar since CopyFolder will not fire any events you can subscribe to to update your progress bar. A couple of alternatives would be to fire off the Copy process you find in Explorer, which has its own progress bar, or write your own Copy function that can track the number of files/bytes it needs to copy and update a progress bar itself. Using the code you have now, you can't add a progress bar to it.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hello,
In VB6, MoveLast is an method of Adodb.Recordset. Can anybody tell me that what is the alternate function in VB.NET. Because in Vb.net, this function is not available.
Regards,
Eshban
EsHbAn BaHaDuR
|
|
|
|
|
Hi Eshban,
there is no corresponding/alternate method in vb.net.
i'd suggest you read up on ado.net (overview, samples) a little (or alot). ado.net is a subset of the .net bcl that can be used to work with data and data structures.
hope this helps.
-jim
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
