|
so.. then what to do !!!!!!!!!!!
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
MAN MEN TAL3LE ENT EGLEB WEJHAK
WE EITHER FIND A WAY OR DIE TRIEN
Mohamad A. Flefel
mflefel@hotmail.com
+962 79 5963865
C#.net & VB.net Developer
|
|
|
|
|
BL MONASABEH, BDNA NETL3 EL YOUM,JASEM TAYYASAT MA3O
OK, E7KE M3NA BS TRAWE7
BTYE
Mohamad A. Flefel
mflefel@hotmail.com
+962 79 5963865
C#.net & VB.net Developer
|
|
|
|
|
how to Pass range of values from VB to crystal report
I have an order table in access.I want to print orders from 1 to 10 or like that.(values entered in two text boxes).I have created the crystal report,it is working smoothly when giving the range values.
But through Vb I wrote
orders.orderid>=value1 and orders.orderid<=value2
If I give value1=5 and value2=7 it is showing properly.I change the the value1 it is working.But if I change the value of value2 it is not refreshing.always the value of value2 remains the first value(the value given for the first time.)
|
|
|
|
|
Not sure I understand your question, but I suspect you may have problems with DataTypes. In what format is the Order No stored in your Database (Text or Number) I would use numbers so rather take the textbox value and convert it before writing to the database. Alternatively if you want to keep the order as text, pad the OrderNo with leading zeroes (in other words use 000001 instaed of 1)
|
|
|
|
|
I converted the text value to number.now its working.thank you so much.
|
|
|
|
|
i have no idea wat can i do to show the status of an action. Example like i have schedule a action to be done by 5pm today and in my DB i have a colunm call Status. wat can i do to allow my DB to update itself once the action is done?
|
|
|
|
|
You'll have to add code to the "action" to call some kind of status update routine to update the field in the database. It's not going to change on its own.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Sorry.. i dun really understood wat u meant. wat "action" u toking about. Do u have any example of my problem?
|
|
|
|
|
 You said "action" in your original post! What that "action" is, you have to code is so it updates the status you want.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
oh sorry. My action is to shutdown the computer and once tt is done i must be able to change the status to "DONE". I put those code inside the timer should i add the update code into the timer as well? And wat should the code be? Thanks...
|
|
|
|
|
I'm not writing you app for you. But, think about this. Youre code has to update the database with "Done" after tha action is complete, right? Your action is to shutdown the computer, so how are your code going to update the status if it's no longer running? You have to update that status BEFORE you do the action.
In your Timer code, you check the current time against the scheduled time of the job your supposed to run. Once the two match, you call another method to update the job status with something like "Executing". Then you call another method to launch your action. Once the action returns control to this method, it updates the database with "Done".
Now, in the case where you shutdown the machine, there will be no change of updating the database. So, when your app starts up the next time, it has to scan the database for any status of "Executing" and reset it to "Done".
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
HI
While debugging an app that imports data from Excel, the app bombed, and the Excel file got locked, and cannot be opened again. Is there a way to force the file to become unlocked again?
Cheers
Richard
|
|
|
|
|
Is this a bad question? Can I explain it in a different way?
Hope someone can help
Thanks
Richard
|
|
|
|
|
Hi,
I am getting "Stack Overflow at line 101" error when I try to view all the contents of a DataGrid by clicking view all, can anyone please provide some solution on this error.
|
|
|
|
|
Stop overflowing the stack !!!
Is any of your code recursive ?
|
|
|
|
|
No my code is not recursive.......
Actually when I populate Datagrid then i don't face any problem,
but when I tried to view all the contents of Datagrid then it shows this error, so I think it is somthing Datagrid related problem,
Please help me at earliest.
|
|
|
|
|
Well, given that lots of people use the datagrid, I assume it's a problem with the code that you're yet to post, crippling any attempts people may here make to help you.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Hi All,
We are porting the following VB 6 code in to VB.net
VB 6 Code:
NumChan = GetDppData(objDppApi, VarPtr(DataBuffer(0)))
Here GetDppData is the function declared as below
Public Declare Function GetDppData Lib "DppApi.dll" (ByVal objptr As Long, ByVal DataBuffer As Long) As Integer
Where DPPApi.dll is a registerable COM Dll.
VB.net code :
UseDll.DppApi.GetDppData(objptr, VarPtr(dp4DataBuffer(intMcaChannelCount)))
Where the above function is declared in a module with name UseDll as below
Public Declare Auto Function GetDppData Lib "DppApi.dll" Alias "GetDppData" (ByVal objptr As Integer, ByVal DataBuffer As Integer) As Integer
VarPtr function Definition in VB.Net is as below
Public Function VarPtr(ByVal o As Object) As Integer
Dim GC As System.Runtime.InteropServices.GCHandle = System.Runtime.InteropServices.GCHandle.Alloc(o, System.Runtime.InteropServices.GCHandleType.Pinned)
Dim ret As Integer = GC.AddrOfPinnedObject.ToInt32
GC.Free()
Return ret
End Function
Here the functionality that we are woking is :
We are passing the Address of array to the dll so that it can fill all the array elements using Base address of the array.
The VB 6 code is working fine.
In the case of VB.Net code array is not getting initialized.
Please Guide me How to proceed
Varma
|
|
|
|
|
Public Function VarPtr(ByVal o As Object) As Integer
Dim GC As System.Runtime.InteropServices.GCHandle = System.Runtime.InteropServices.GCHandle.Alloc(o, System.Runtime.InteropServices.GCHandleType.Pinned)
Dim ret As Integer = GC.AddrOfPinnedObject.ToInt32
GC.Free()
Return ret
End Function
The most obvious reason why this doesn't work is because you're pinning the object, getting the address of it, then releasing the pinned object so it can get moved, before you even return the address. That address is no longer valid once the pin is released by GC.Free.
You really shouldn't be passing the address of this array yourself. You should be relying on the Marshal abilities of the Framework to pass parameters back and forth for you and in the correct format.
Default Marshaling for Arrays[^]
Marshaling Arrays of Types[^]
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi Dave Kreskowiak,
Thanks for your Reply,
can I pass the Base address of the array before calling GC.free.
i.e. I will get the base address from the VarPtr and I will call GC.free in another function.
I will check this once i go to site.
Thanks for your Valuble information
Varma
|
|
|
|
|
No, you can't. That's what passing ByRef is for. You're stuck on VarPtr when it's such an outdated concept and is creating more work for you than you really need to be doing.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi,
check for
ADODC.Parameter class
hope this works...
Nitin...
|
|
|
|
|
i came across this error(No value given for one or more required parameters) in 2 of my buttons both got to do with DB. But i am unable to find a solution to that. Can anyone help me???
|
|
|
|
|
Sounds like you're calling a proc and failing to provide the parameters it needs, based on the limited info you posted.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
