|
I'm not sure how to do it with your approach but i did it by returning a table with a SQL UDF.
I don't think this approach is too friendly on the overhead, wont advise doing it with large amounts of data.
CREATE FUNCTION udfReturnMyData(<br />
@MyArg1 varchar(30),<br />
@MyArg2 int)<br />
<br />
RETURNS @v TABLE (Column1 int, Column2 int, Column3 Varchar(10))<br />
AS<br />
BEGIN<br />
<br />
insert into @v (column1, column2, column3)<br />
(SELECT Column1, Column2, Column3 From MyTable Where MyCondition = True)<br />
<br />
return<br />
END
I call this function from VB by doing a simple SELECT * FROM udfReturnMyData(MyArg1, MyArg2)
Hope it helps.
you can't forget something you never knew...
|
|
|
|
|
hi friends
plz tell me how to print a .TXT and excel file from VB.if we have a excel file on Hard Disk , how to print that excel file
plz give small code snippet
thanks in advance bye
take care
Rahul here
|
|
|
|
|
Use the Printer object to draw what you want on the printer.
For the excel file, the only way I can tell you is to add an Excel OLE to your form and open a file in that, then print the whole form using PrintForm. Ofcourse this only prints the visible parts of the sheet on the form....
|
|
|
|
|
Does anyone know if it is possible to search directories from the last folder created to the first in a given directory? I am using:
myFolder = Dir(MyPath, FileAttribute.Directory)
and this always starts the search in alphabetical order but I really need to search the last folder created so as not to go through every folder as the files being looked for are most likely in the most recent folders (there are many folders so it's a bit slow this way).
I am using vb.net, is there a better way for folder searches?
Hope this makes sense!
Cowtech
-- modified at 1:41 Thursday 20th April, 2006
|
|
|
|
|
This is one of another ways. you can get subfolders of your main folder
You need a list box here,
For Each foundDirectory As String In My.Computer.FileSystem.GetDirectories("E:\", FileIO.SearchOption.SearchTopLevelOnly, "*")<br />
ListBox1.Items.Add(foundDirectory)<br />
Next
You can get directory’s creation date and time to an array like this
Imports System.IO<br />
.<br />
.<br />
.<br />
<br />
Dim folderCreatedDates(ListBox1.Items.Count) As Date<br />
<br />
For i = 0 To (ListBox1.Items.Count - 1)<br />
folderCreatedDates(i) = Directory.GetCreationTime(ListBox1.Items(i))<br />
Next i
And use for loop statements and Array.Sort(FolderCreatedDates) to sort them according to created date
Regards,
Chatura Dilan
|
|
|
|
|
Thanks Chatura
I thought of doing exactely what you have explained here although I wouldn't
be using a listbox. Thought there might have been a simple way for the dir function to start the search in reverse order, not to be I think.
Thankyou for your input.
Cowtech
|
|
|
|
|
hello
i have declared a varible in public section of class like this:
" Partial Class addnewsite
Inherits System.Web.UI.Page
Public cat_id As Integer"
i have assign a value in add_click module.
and i want to use this variable value in another sub_click module.
when i access the variable then it take 0 instead of that variable value.
i'm firing the add event first and after it sub event.
what is the reason..plz give me some solution
|
|
|
|
|
Can't tell you much without seeing the relevant parts of the code. You description doesn't shed any light on what your code looks like, what it's doing, are what the problem might be.
Copy and Paste your code into a post, DO NOT retype it!
Dave Kreskowiak
Microsoft MVP - Visual Basic
-- modified at 9:56 Thursday 20th April, 2006
|
|
|
|
|
If what you are trying to modify is the integer cat_id, you must pass it by reference to any code that is expected to modify it. value types are passed by value by default, and so can't be modified, only read.
If this doesn't help, then do as the previous answer said, and post the relevant parts of your code. Declarations aren't enough.
We need to graduate from the ridiculous notion that greed is some kind of elixir for capitalism - it's the downfall of capitalism. Self-interest, maybe, but self-interest run amok does not serve anyone. The core value of conscious capitalism is enlightened self-interest.
Patricia Aburdene
Bulls make money, bears make money, pigs get slaughtered.
Jim Cramer
|
|
|
|
|
Hi there,
Does anyone can let me know how to create the asp component in visual basic .net ? If possible guide me step by step
i have try to create a class... but it unable to register.
noobie here.
Thanks in advance
Budi
|
|
|
|
|
Could anyone tell me whre i could see a list of visual basic string and math functions.
|
|
|
|
|
In the Object Browser. Press 'F2' in you code file. Select Math/String
|
|
|
|
|
can i make VB.net DLL,so i can import it and use it within programs that support dll ?
|
|
|
|
|
You can make a COM dll, or a .NET dll, depending on who you want to open it.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
So when i make .NET dll with vb.net can i use it within my program(that support dll) as vc++ dll ?
|
|
|
|
|
I have created a Windows application and used the setup wizard for deployment purposes. It runs perfectly well on my machine but after I install the application on another machine and try to start it I get an error that says;
"Application has generated an exception that could not be handled.
Process ID 0x450 (1104), Thread ID 0x3a8(936)."
What have I messed up.
Shawn the desparate programmer
|
|
|
|
|
Is the .net framework installed on the host machine?
|
|
|
|
|
Yes it is. This is MS access database project with crystal reports. I think it may be a CR problem as this problem did not occur until I integrated the CR into the project.
|
|
|
|
|
You've probably already looked into these but . . . what the heck!
Something missing perhaps?
Is the expected version of the Framework installed?
Do you use Crystal Reports or some other third party software?
Config file?
If you haven't already, you might want to use the build option that pulls all of the accessed assenblies into the local Bin folder. And no, I can't remember what or where to specify it off the top of my head. Sorry.
Good luck!
Will
|
|
|
|
|
Apart from the framework being installed, ensure that your assembly has sufficient rights to execute on that machine (go to Control Panels -> Admin Tools -> .NET Framework Configuration utility).
Errors like this occur because you have (probably) created the assembly on a machine under a userid which had local admin rights so you never saw any problem in development. Installing it onto another machine and running under a user without local admins rights highlights that there is something in your assembly which relies on more than normal rights to execute.
This is a very good reason never to develop a program under a local admin id because inevitably you'll find out there is a problem only after deployment.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once 
|
|
|
|
|
Whats wrong with this code
<br />
TextBox1.Clear()<br />
TextBox3.Clear()<br />
Dim datipass As New StreamReader("c:\0206USAGE.txt")<br />
Dim totalChargeByName As New SortedList<br />
Dim fields As String()<br />
<br />
Do Until datipass.Peek() = -1<br />
fields = datipass.ReadLine().Split(ControlChars.Tab) 'Or Convert.ToChar(Keys.Tab)<br />
If totalChargeByName(fields(2)) Is Nothing Then<br />
'Start tallting for the new name.<br />
totalChargeByName.Add(fields(2), CDec(fields(9)))<br />
'TextBox1.AppendText(fields(2).ToString & " " & fields(9).ToString & vbNewLine)<br />
Else<br />
'Add the new charge for the existing name.<br />
totalChargeByName(fields(2)) = CInt(totalChargeByName(fields(2))) + CDec(fields(9))<br />
End If<br />
Loop<br />
<br />
Dim x As String<br />
Dim y As Decimal<br />
Dim total As Decimal<br />
Dim i As Integer<br />
For i = 0 To totalChargeByName.Count - 1<br />
x = totalChargeByName.GetKey(i)<br />
y = totalChargeByName.GetByIndex(i)<br />
total = y + total<br />
TextBox3.AppendText(x & y.ToString("C").PadLeft(20) & vbNewLine)<br />
Next i<br />
TextBox1.Text = total.ToString("c")<br />
datipass.Close()<br />
This is the text im trying to sum up
<br />
056:13459131 6802941 bkeveney editorial.usatoday.com "US,Beverly Hills,CA" 2/6/2006 20:43 2/6/2006 20:43 11887 0.9 0.50 DIAL usage<br />
053:113898037 6802941 rbarbrow editorial.usatoday.com "US,Beverly Hills,CA" 2/7/2006 17:31 2/7/2006 17:31 470 0.9 0.50 DIAL usage<br />
054:113461388 6802941 bkeveney editorial.usatoday.com "US,Beverly Hills,CA" 2/7/2006 23:34 2/7/2006 23:34 20253 0.9 0.50 DIAL usage<br />
051:117142732 6802941 rbarbrow editorial.usatoday.com "US,Beverly Hills,CA" 2/12/2006 0:30 2/12/2006 0:30 13480 0.9 0.50 DIAL usage<br />
055:13716868 6802941 bkeveney editorial.usatoday.com "US,Beverly Hills,CA" 2/12/2006 4:30 2/12/2006 4:30 13498 0.9 0.50 DIAL usage<br />
052:113234620 6802941 rbarbrow editorial.usatoday.com "US,Beverly Hills,CA" 2/12/2006 9:47 2/12/2006 9:47 18520 0.9 0.50 DIAL usage<br />
051:117156396 6802941 bkeveney editorial.usatoday.com "US,Beverly Hills,CA" 2/12/2006 12:28 2/12/2006 12:28 3567 0.9 0.50 DIAL usage<br />
051:117172183 6802941 rbarbrow editorial.usatoday.com "US,Beverly Hills,CA" 2/12/2006 21:17 2/12/2006 21:17 5035 0.9 0.50 DIAL usage<br />
Baiscly its not adding up right (this is just example text to show the point that it wont add like numbers or something ive tried walking threw it and i just dont see where tis screwing up
-- modified at 22:15 Wednesday 19th April, 2006
|
|
|
|
|
What is the result that you get, and how does that differ from what you expect?
---
b { font-weight: normal; }
|
|
|
|
|
bkeveney = 2.00 ( ie .50 + .50 +.50 +.50)
rbarbrow = 2.00( same)
what im getting is
bkeveney = .50
rbarbrow = .50
now if it was more than just .50s
lets say 2.34 it would add that correctly and give me 2.84
|
|
|
|
|
You are converting the sum to int before adding every value. Int(0.5) + 0.5 = 0.5
You don't have to convert the sum at all, you already know that it's a number.
---
b { font-weight: normal; }
|
|
|
|
|
Why should converting it keep it from adding like numbers
for example if i change the values to .51 and .52 i will get 1.03
if i try to add .50 and .50 i get .50
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
