|
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.
|
|
|
|
|
This is one of my button can u take a look and is there a problem here???
Dim sqlStr As String = ("Select * from EventTable")
Dim StrActionName As String = ""
Dim dTable As DataTable
Dim db As New DBController
dTable = New DataTable()
db.Connect("PCMgr.mdb")
db.retrieveDTable(sqlStr, dTable)
Dim TReader As DataTableReader
TReader = New DataTableReader(dTable)
While TReader.Read
StrActionName = dTable.Rows(0)("ActionName")
If StrActionName = TxtActionName.Text Then
db.Connect("PCMgr.mdb")
db.InsertRecord("Delete from EventTable where ActionName = " + TxtActionName.Text)
db.Close()
End If
End While
End Sub
|
|
|
|
|
Well, for a strt, your string in
Subjugate wrote: db.InsertRecord("Delete from EventTable where ActionName = " + TxtActionName.Text)
is not in quotes. For second, I have no idea what DBController does, but InsertRecord doesn't seem like the method to call with a line of SQL for deleting records. Either way, I would never write an app like this, it is nasty. I'd use stored procs, and a clear data layer.
|
|
|
|
|
Sorry i dun quite understand u... For do u mean by not in quotes?
|
|
|
|
|
Do you know what quotes are ? Passing a string variable using SQL requires the string to be in quotes 'like this'
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
