|
Hi all
I am kind of stuck with a strange issue.Can anyone help me.
Mine is a VB 6.0 to VB.net 2005 migration.Crystal reports 7.0 is being used in VB 6.0.I am now using .net crystal engine.I have written .net code that manipulates .rpt(this rpt is the same old 7.0 one) file at runtime and generates report.The code is working fine and report is getting generated.
I now compared the report generated from VB 6.0 and .net.Here are the differences.
1.For money field from SQL database a '$'sign is attached to each value.
2.In VB 6.0 a decimal value 2.9 becomes 3.0,but in .net it is displayed as 2.9 itself.
To correct the same i went to .net 2005 crystal report editor-Design-Default Settings and changed the field format options of currecy and number(removing $ sign and decimal roundoff setting).
But whatever i do, in final report the value doesnt get reflected.Then i wrote a runtime code to change the format.But again no use.
But to surprise when i went to control panel and removed $ sign from system regional settings,the $ value was removed from currency.What about decimal roundoff then.
What am i missing.Why is the setting that i do in crystal reports .net editor not getting reflected.Please help.
|
|
|
|
|
I have got a website with a search control on it that is not being picked up. Am I missing a reference to this control or is there something else I am missing? Thanks in advance
Stephen
Stephen Lintott Bsc IT (RAU)
|
|
|
|
|
What do you mean by "picked up"??
Perhaps you should be asking this in the ASP.NET Forum instead...
|
|
|
|
|
Hello,
I have the following problem. I have a VB .net 2008 application that is getting data from a SQL 2005 server that is on a Small Business Server 2003 R2 premium Server.
The application is working fine but sometimes the Green Circle of Vista is coming up and the system is locked for sometimes 10 minutes. After the green Vista circle is gone the programm is still working without any problem.
There is vista Business with SP1 installed.
I think that the application wants to get data from the server and on some moments there is the green waiting circle from vista.
Does anyone has a idea what can be wrong.
I am using a 100 mbit network to access the server. Other Pc on that moment that uses the network for other applications such as word,... has no problem accessing the server.
Could it be a Vista problem ?
The problem is that the application is used for a Point of sale solution , so when there is a customer waiting and suddenly the green circle is there for 10 minutes nothing can be sold on that moment wich is not a good situation.
Thanks for the advice.
best regards
Didier
|
|
|
|
|
DCAUB wrote: but sometimes the Green Circle of Vista is coming up
What circle?? Where does this circle appear?? Is it in your application??
|
|
|
|
|
This may or may not be a problem in the application. If this happens, use system tools (task manager, event log, performance monitor etc) to observe what's going on in the system. For example:
- most virus scanners halt the system when new virus information is applied or the software is being upgraded.
- virus filters for emails can do the same
- Windows update can freeze the system momentarily
- network card problems can freeze the app if the connection is lost and the re-estableshed and so on
First, have a look to the event log (both system and application), if you see anything suspicious.
The need to optimize rises from a bad design.
My articles[ ^]
|
|
|
|
|
Hello,
Thanks for answering my question.
On this PC , the connection to internet is not set and it is only used for Point of Sale. So there is no virusscanner installed on this machine.
Windows update is also not set to automatic.
There are some days that the problem is not there so i dont think that it is the programm after waiting for a while sometimes 10 or 15 min the green circle is gone and everything is working fine again.So i think the programm is ok.
Maybe the network that the connection to the SQL Server is lost ....
Thanks
Didier
|
|
|
|
|
Hi All,
I am using Vb.Net 3.5
I want to Hide the windows taskbar when I am starting my windows application, and show the task bar again when I am exit from my application.
Please, tell me how can I do that from Vb.net.
Arindam Banerjee
Sr. Software Developer
Rance Computer Pvt Ltd.
Kolkata (India)
|
|
|
|
|
You can set your window position so it obscures the taskbar. You can't stop the user from using the task bar, nor should you want to.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
I am just want to use Auto Hide Taskbar feature of the taskbar.
Rather, my form Size is sufficiant to show the full screen mode.
If my taskbar is hide then my application shows full screen but If my taskbar is shows then my application is not in fool screen mode.
Arindam Banerjee
Sr. Software Developer
Rance Computer Pvt Ltd.
Kolkata (India)
|
|
|
|
|
So basically, would you and make the form size = screen.workingarea?
This will work:
With Me
.TopMost = True
.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None
.WindowState = FormWindowState.Maximized
End With
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
I already do this job.
By this, The taskbar is not disabled.
Arindam Banerjee
Sr. Software Developer
Rance Computer Pvt Ltd.
Kolkata (India)
|
|
|
|
|
You cannot, and should not, disable the TaskBar.
|
|
|
|
|
If u want disable the task manager or hide u can use registry and u can make disable and enable.
|
|
|
|
|
Its not Task Manager, I wanted to hide the Task Bar
And How using registry.
Arindam Banerjee
Sr. Software Developer
Rance Computer Pvt Ltd.
Kolkata (India)
|
|
|
|
|
The only way to hide the Task Bar is to kill the Explorer process, but that's not acceptable to the user either.
|
|
|
|
|
simple test on google gives me over 100000 hits.
Public Const SWP_HIDEWINDOW As Integer = &H80
Public Const SWP_SHOWWINDOW As Integer = &H40
Private Declare Function FindWindow Lib "user32.dll" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Integer
Declare Function SetWindowPos Lib "user32" (ByVal hwnd As Integer, ByVal hWndInsertAfter As Integer, ByVal x As Integer, ByVal y As Integer, ByVal cx As Integer, ByVal cy As Integer, ByVal wFlags As Integer) As Integer
Private Sub bHide_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles bHide.Click
Dim hSystray As Integer = FindWindow("Shell_traywnd", "")
SetWindowPos(hSystray, 0, 0, 0, 0, 0, SWP_HIDEWINDOW)
End Sub
Private Sub bShow_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles bShow.Click
Dim hSystray As Integer = FindWindow("Shell_traywnd", "")
SetWindowPos(hSystray, 0, 0, 0, 0, 0, SWP_SHOWWINDOW)
End Sub
|
|
|
|
|
That doesn't disable the TaskBar, it just hides the window temporarily. It's still not a good idea to do.
|
|
|
|
|
I guess I don't truly understand the purpose of the request.
1. If pdnet has the app in Kiosk mode, why are you worrying about the taskbar - you can't see it anyways?
2. Don't know about you, but I'd be pissed if I ran an app and it started changing my theme/settings in Windows without me allowing it to do so.
All around bad idea to it.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
Sometimes project specifications is to run it full screen so that the taskbar isnt visible. From what I gathered in his post, he doesn't want to disable it, just wants the same functionality as 'Autohide the taskbar' option.
I'm kind of curious as to this myself.
|
|
|
|
|
EliottA wrote: Sometimes project specifications is to run it full screen so that the taskbar isnt visible.
The code I posted earlier in this thread accomplishes that. The form covers the task bar, just like VS if you run it in full screen mode without changing the settings or killing the task bar itself.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
I've got a legacy DB from which I need to extract a file. But when I do so, the file ends up approximately double the original size (and obviously also unopenable).
Does anybody know a way around this?
Thanks! 
|
|
|
|
|
If you're able to connect to the DB at all, then there's no reason why the file should not come out OK. Hard to say more without seeing code, and knowing what sort of DB you're talking about. I'd assume the issue is in your code tho, b/c if you get a database connection at all, then it should return the right data to you.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi. Thanks for the reply.
It's a SQL Server database. And yes, I am able to connect to it without any problems.
Here's the code I'm using to retrieve the file(s). This code works successfully with files that were saved by my .Net application.
<pre>Private Sub File_Read(ByVal FileName as String, ByVal strConn As String)
Try
Dim ConnRead As New SqlClient.SqlConnection
ConnRead.ConnectionString = strConn
ConnRead.Open()
Dim AdptRead As New SqlClient.SqlDataAdapter(" SELECT FData " & _
" FROM Misc " & _
" WHERE FName = 'filename.exe' ", ConnRead)
Dim CmdBldRead As SqlClient.SqlCommandBuilder = New SqlClient.SqlCommandBuilder(AdptRead)
Dim dsRead As New DataSet
AdptRead.Fill(dsRead)
Dim myRow As DataRow
myRow = dsRead.Tables(0).Rows(0)
Dim byteRead() As Byte = myRow("FData")
Dim sFilePath As String = Application.StartupPath & "\" & FileName
Dim fStream As IO.FileStream
fStream = New IO.FileStream(sFilePath, IO.FileMode.Create)
fStream.Write(byteRead, 0, byteRead.Length)
fStream.Flush()
fStream.Close()
fStream.Dispose()
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub</pre>
The file I'm retrieving is 48kb big, but when I retrieve it, it's size is 96kb.
Thank you for your help. Please let me know if you require any more info.
|
|
|
|
|
What is the data type for FData in the database?
If it's varchar, you most likely use different collation now than what was used with VB6.
The need to optimize rises from a bad design.
My articles[ ^]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
