|
Use the Array.Copy or Array.CopyTo method to copy the data from one array into another array.
Use the Encoding.GetBytes method to encode a string into a byte array. Example:
byte[] group = Encoding.UTF8.GetBytes(groupNumber.ToString());
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Array.CopyTo is exactly what I was looking for. 
|
|
|
|
|
I'm running a VB6 application that queries an SQL Server 2000 database. I'm facing a weired behavior: sometimes the application get toooo slow while executing a specific query, while the same query executes very fast from SQL Query analyzer. I'm not able to catch when it's becoming too slow.
this application has tooo many users connected in the same time but not all are executing the same command at the same time. the table subject of query has many indexes. the log file of the database is small. this is weired since no one can tell when it executes normally from the application and when it becomes too slow
is there any clue where and what to look for in order to solve this?
thanks  
|
|
|
|
|
i would imagine that one of the tables is getting locked (see http://www.mssqlcity.com/Articles/General/sql2000_locking.htm for locking info) If you are entering data then the SQL Server will lock the row or maybe the table to stop other people changing it will your are to keep integerity.
You can get around it for your query by using the nolock feature
SELECT * FROM TableA WITH (nolock) INNER JOIN TableB WITH (nolock) etc.
Otherwise can you provide more info on what the app does etc
Regards
AKimba 
|
|
|
|
|
I think that akimba is right that a dead lock\delay lock might be occurring. I don't think changing the nolock locking hint will work though since that is the default hint for select statements.
Generally to avoid deadlocks, the tables should be used in the same order when doing updates/deletes/inserts. It's a major pain to come up with this list and stick to it, but by referencing the tables in the same order deadlocks shouldn't occur. Another option possibility might be that you have stored procedures that are using a looping structure to perform table modifications which would also cause blocking to occur).
IE, this could be happening especially if there is a large amount of users doing updates, etc.
Stored Procedure 1:
--update table 1
--update table 2
Stored procedure 2:
--update table 2
--update table 1
Might have to narrow down the places where the locking is occuring and modify just those (bandaid approach) vs. changing everywhere the updates are being used.
--Edit:
Starting recording performance data on the server(s) where the delays are occurring. Should narrow down the table(s) that are problematic. Also may need to review indexes.
Just throwing out ideas.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
|
|
|
|
|
Hello,
is anybody can give me merge modules for crytal reports in VB.net 2005.
|
|
|
|
|
Nope. If you're entitled to have them with your licensed copy if Visual Studio, then you have them on the installation CD/DVD's. If not, you don't have them and noone here is going to risk their money and license giving you stuff you're not supposed to have.
|
|
|
|
|
Hi,
I am having awful trouble trying to use the IMAPI2. All I am trying to do is do display the media in a drive per drive letter and also trying to read an ISO. If anyone can help it would be great.
Thanks
|
|
|
|
|
Hi all,
I an using crystal reports to show the reports.I want to use the pull method in crystal reportie connecting the query and connection string in run time..
how can i paass the database connection string to report??
Dim frpt As New rptformula
Dim rpt As New rptstudent
rpt.SetDatabaseLogon("sa", "nimda")---(here iam passing the login and pwd to login into the tables connected to reports but I want togive the connection string in runtime in pull method)
CrystalReportViewer1.ReportSource = rpt
,i saw database properrty in crytal reports how to use that property
|
|
|
|
|
IIRC you need to give each table in the report the credentials.
For each Table in Report.Datatables
Table.creds = ???
next
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hello all,
I want to add a row in datagridview at zeroth index.
its not difficult.... i know
but this new row should have all cells as checkbox. and datagridview is databound.
so, my grid will have checkbox row at first line and rest of the line as textboxcells...
is there any way to do it?
Thanx !
|
|
|
|
|
Hello,
this does not seem be possible. Conversion of boolean values to different datatypes may throw some
errors while inserting values.
Regards,
Allen
Allen Smith
ComponentOne LLC
www.componentone.com
|
|
|
|
|
Need urgent help, Please reply ASAP.
We are working on a VB 6.0 to VB.Net migration project which is using lots of different third party controls for e.g. “Crescent enhanced edit controls” which is provided by the vendor Crescent Quickpack.
In a VB 6.0 code file we have a third party control as “CSTextLibCtl.sitxEdit” which exposes following properties.
Begin CSTextLibCtl.sitxEdit csParticulars
Height = 375
Left = 2280
TabIndex = 4
Top = 240
Width = 1455
_Version = 262145
_ExtentX = 2566
_ExtentY = 661
_StockProps = 125
ForeColor = -2147483640
BackColor = -2147483643
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.24
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Modified = -1 'True
HideSelection = -1 'True
RawData = ""
Text = ""
StartText.x = 2
StartText.y = 6
FirstVisPos = 0
HiAnchor = 0
HiNew = 0
CaretHeight = 13
CurNumDataChars = 0
MaxDataChars = 0
FirstDataPos = 0
CurPos = 0
MaxLen = 0
DataReadOnly = 0 'False
Mask = ""
CharacterTable = ""
End
However when we migrate the form containing this control to VB.Net using migration tool “ArtinSoft” it migrates the code as shown below.
Public WithEvents csParticulars As AxCSTextLib.AxsitxEdit
.
.
Me.csParticulars = New AxCSTextLib.AxsitxEdit
.
.
.
CType(Me.csParticulars,
.
.
System.ComponentModel.ISupportInitialize).BeginInit()
'
'csParticulars
'
Me.csParticulars.Location = New System.Drawing.Point(152, 16)
Me.csParticulars.Name = "csParticulars"
Me.csParticulars.OcxState = CType(resources.GetObject("csParticulars.OcxState"), System.Windows.Forms.AxHost.State)
Me.csParticulars.Size = New System.Drawing.Size(97, 25)
Me.csParticulars.TabIndex = 4
Me.Controls.Add(Me.csParticulars)
.
.
.
CType(Me.csParticulars, System.ComponentModel.ISupportInitialize).EndInit()
(the above code is present in designer form)
As can be seen from the above code snippet out of approximately 30 properties only 4 properties are mapped in VB.Net and rest all are embedded in “OcxState” object.
We wanted to have a one is to one mapping of Third party control properties to VB.Net Custom control (which we have developed) properties. However since no properties are visible in the migrated code we are not able to do the mapping. We even tried to decode the “OcxState” object that is present in the “Resx” file in the Base64 format. However that also didn’t work. Now we are stuck up at this point where untill we have this mapping we wont be able to replace the Third party controls with the VB.Net Custom controls.
We would appriciate any inputs on how to capture third party control properties and their values in the migrated code so that we can establish the required mapping.
|
|
|
|
|
akanchu wrote: Need urgent help, Please reply ASAP.
No. Demanding urgent help around here is rather rude and impolite 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
See if I have this correct.
1. You have a 3rd party VB control
2. You have a self-written VB.Net custom control
3. You are using a 3rd party tool to convert your VB6 to VB.NEt
akanchu wrote: However since no properties are visible in the migrated code we are not able to do the mapping.
Why not? You have the properties (you listed them) and you claim you wrote the custom control. Or is it that you are suprised the convertor doesn't map the VB6 control to your custom control?
Well, I would have been more suprised if it did.
And you expect someone who doesn't have your source code to tell you what to do URGENTLY.
Well, its your code....
Bob
Ashfield Consultants Ltd
|
|
|
|
|
There is nothing that's going to automatically figure out that your custom control is supposed to replace another control and automatically remap the properties. I would have been blown out of the water had this really worked! You'd just going to have to rewrite the code by hand. A conversion tools is not ment to convert code for you guaranteed 100% accurate, even without the goofy replacement of an existing control with another. Coverting code is not a "one-click on a tool" process. Covnerting code, evenusing a tool to do most of it is still a full-blown developement project.
|
|
|
|
|
I'm writing an asp.net web application. I want to filter automated requests that are made from some software.
How can i find out automated requests. I mean how can i differentiate automated request and user made request.
fine
|
|
|
|
|
Perhaps you would get more answers on ASP.NET [^]-forum
The need to optimize rises from a bad design
|
|
|
|
|
Hi, i had developed a application for automatic navigation in URL and save information to disk. I'm using webbrowser control.
All is correct, but, i have a problem!!!
When the application is navigate, 'alert' window is open and the application stop.
How i close 'alert' window in code ???
I supossed the solution is complicate but I'm sure this is possible.
Thanks
|
|
|
|
|
Hello gurus 
the funny little problem now comes from a timer component. The main code starts the timer (interval 1) and - right afterwards - a BackgroundWorker component. I intend to count the seconds which the BW needs for his task.
Realizing that the time-label in my form wasn't updated (through 'lblTimer.refresh' in the Timer_Tick event), I stepped through the code and had to see that the Timer_Tick event just isn't called at all   and even a stopmark I placed within the event was ignored. Searching for possible reasons didn't bring me much further yet.
My question: Is there anything (apart from stopping the timer) that makes VB ignore the Timer_Tick event completely? Or are there any imaginable reasons for that behavior?
Thank you for inspiration,
Michael
|
|
|
|
|
Most likely the timer isn't enabled or Timer_Tick event isn't wired.
Also reconsider if you really need interval of 1 millisecond.
The need to optimize rises from a bad design
|
|
|
|
|
Hi Mika,
as the timer is surely enabled I have to ask you what 'it isn't wired' would mean? I thought as soon as the timer is started the tick-event would start until the timer is stopped?
You're surely right regarding the interval which I had set to 100 before. When I'm back to a reliable tick-event I guess I can switch that back since it's only needed for the form's update. I hope with your help I'll have a timer-tick again soon ...
I found a weird effect, too: running the app from debug-mode, the tick-event seems to run sometimes and therefore update my timer-label - I just can't tell the exact conditions. It feels a bit like the Backgroundworker eventually blocks the timer...(is there no 'DoEvents' or similar command to put there anymore?) like under 'race conditions'.
I thought I'd probably post a part of the code:
Private Sub Main()
UpdateDriveInformation()
ProgressIndicator.Style = ProgressBarStyle.Marquee
startTime = Now
Timer.Enabled = True
If PROC_MAKELIST Then
ThreadID.Text = TXT_MAKELIST
BackgroundWorker2.RunWorkerAsync()
Else
ThreadID.Text = TXT_DELREPORTS
GroupBox1.Text = TXT_MAKELIST
BackgroundWorker3.RunWorkerAsync()
End If
End Sub
Private Sub Timer_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer.Tick
Dim mDbl As Double = Now.ToOADate - startTime.ToOADate
Dim mDat As DateTime = DateTime.FromOADate(mDbl)
Try
Dim mDat2 As Date = Date.FromOADate(mDbl)
lblTimer.Text = mDat2.ToString("mm:ss")
Catch ex As Exception
lblTimer.Text = "Timer Error!"
Err.Clear()
Finally
lblTimer.Refresh()
End Try
End SubMaybe you see something wrong here?
Thanks for now
modified on Sunday, September 28, 2008 11:35 AM
|
|
|
|
|
By wiring I mean that you have an eventhandler attached to the objects event. From your code I suppose that Timer refers to the object drawn to the window.
At a glance I don't see anything special in your code but all necessary operations are not included. I take it that the rest is defined in Designer.vb (for example interval and so on).
One possible problem you may encounter is that Tick isn't necessarily raised while debugging. This could be one reason why it sometimes is run and sometimes not.
The need to optimize rises from a bad design
|
|
|
|
|
Thanks for checking.
You're right, I did the form in the designer and it refers to lblTimer - which is nothing than kind of a stopwatch - drawn to the window. After building an exe and starting it several times, I have to say that it's exactly the same effect: Sometimes it starts counting (one or two seconds was the maximum), sometimes the label just stays at 0.
Would it be possible that the Backgroundworker blocks the timer... something like 'race conditions'?
modified on Sunday, September 28, 2008 1:00 PM
|
|
|
|
|
For a race condition you should use a common resource in both threads. And even if that's true, it should appear when you use the resource, not on timer tick.
However, it's possible that you are blocking the whole UI thread (I take it that the timer is in main UI thread) and in that case the tick won't occur. If that's true your UI should also be non-responding.
There's also the possibility that the timer's enabled property goes to false. Try using debugger and add a conditional breakpoint to timers enabled property and define the debugger to stop every time the value changes. This helps you to eliminate that possibility.
The need to optimize rises from a bad design
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
