|
Hello every one
Can some one plz help me with example of table locking. Wat i want to achieve is to lock the table for the time user one is doing read immediately followed by a update. If user 2 access the table he should be able to do so after the user1's operation is over
I am using datareader to read data.
Regards
Nishkarsh
|
|
|
|
|
Table locking is not what you are looking for. What you should use is a transaction.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Table locking is only for very specialized circumstances. Locking antire tables severely limits your app's scalability and increased administraive overhead. Think about it. If you app locks a table, then crashes, what do you do?? The lock doesn't clear itself...
|
|
|
|
|
Good Afternoon All
Am Overriding the Paint Method. i need to Change Colour based on the Value of a Certain Column. The Following Code Will Look for that Value in Every Column and Change the Colour in those Cells.
Dim o As Object<br />
o = Me.GetColumnValueAtRow(source, rowNum)<br />
If (Not (o) Is Nothing) Then<br />
Dim c As Char<br />
c = CType(o, String) '.Substring(0, 1)<br />
If (c = "True") Then<br />
' could be as simple as<br />
' backBrush = new SolidBrush(Color.Pink);<br />
' or something fnacier...<br />
backBrush = New LinearGradientBrush(bounds, Color.FromArgb(255, 200, 200), Color.FromArgb(128, 20, 20), LinearGradientMode.BackwardDiagonal)<br />
foreBrush = New SolidBrush(Color.White)<br />
End If<br />
End If
How can i change the Change the Entire row based on a Value in a Certain Column
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Since you are talking about columns and rows, are you using a DataGridView? If so, you want to look at handling the CellFormatting (http://msdn.microsoft.com/en-us/library/z1cc356h.aspx[^]) event. A DataGrid also has a similar event, try looking at this article[^] for more details.
Scott.
—In just two days, tomorrow will be yesterday.
—Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai
[ Forum Guidelines] [ Articles] [ Blog]
|
|
|
|
|
I would like to take a chance to thank you for your help,
Everything is working Fine
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Hi,
i have converted my application from VS 2003 to VS 2005 i am gettnig the error:
"PInvokeStackImbalance was detected
Message: A call to PInvoke function 'Senturion!SenturionFlash.KernelInterfaces::SetIssueEvent' has unbalanced the stack. This is likely because the managed PInvoke signature does not match the unmanaged target signature. Check that the calling convention and parameters of the PInvoke signature match the target unmanaged signature."
i am using Vb.Net windows application.
Mohammad Al Hoss
|
|
|
|
|
If it's a Win32 API you are calling, try looking up the function on http://pinvoke.net/[^] and make sure that you declared it correctly.
Scott.
—In just two days, tomorrow will be yesterday.
—Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai
[ Forum Guidelines] [ Articles] [ Blog]
|
|
|
|
|
You Declare'd the function incorrectly. Mostly this is because someone used the oold VB6 declare and tried to use it in VB.NET without knowing how the basic data types work. A Long value (32 bit signed integer) in VB6 is the same as an Integer in VB.NET. In VB.NET, a Long is a 64 bit signed integer. If the function you call pushes a 32 bit value on the stack and your code pops 64 bits off, you just imbalanced the call stack.
|
|
|
|
|
Hi,
your problem probably relates to the calling conventions (things such as CDeclSpec,
StdCall). Make sure your native code and the DllImportAttribute.CallingConvention
in your managed code are agreeing; I suggest to make them both explicit, i.e. not
to rely on default values here.
|
|
|
|
|
hi im making this program that can make a screenshot of the active window (alt+printscrren) and then see what color there is in a specifik X,Y cordinate. i made a program that can take the screenshot in vb.net but i only know how to take the cordinate color with C# so do any know how to eather make a screen shot of a active windoe with C# ore see a cordinate color with VB.Net??
|
|
|
|
|
Can't you translate the C# to Visual Basic? Just re-arrange some stuff, remove some semi-colons, and then cheat with this page[^].
|
|
|
|
|
If it's only a few pixels you want, you can call GetPixel on the Bitmap object holding the screen image.
|
|
|
|
|
Dear All,
I have an application which i want to integrate with other applications. My application will be running all the time (running on the tray icon) . I have implemented the keyboard hooking to catch a hot key F1 for exmple and call my application. What i need is to read a field value from the external applicaion and call my application passing that value as a parameter (Command()...)
Please give me key about where to look
Thanks in advance
Best Regards
3ala2
|
|
|
|
|
This is not easy. Unless the applications expose this information in an API (not many do), you're going to find this a huge pain. You have to get the window handle of the window that holds the control you want to get the value from. Then you have to go through the controls, an possibly container controls, to find the control you want, then send a WM_GETTEXT message to the control and get the value back. The problem is, there's no guarantee that the control in question will respond to the message!
|
|
|
|
|
I have a 32bit application built on vb.net2003 that uses the bundled crystal reports.
It installs and runs flawlessly on XP platforms.
when I install it on Vista Business (x64), the app runs fine, but any attempt to generate a report (that is, to instantiate a derived report class, as in, "dim rpt as new rptWhataver") results in
Cannot find KeycodeV2.dll, or invalid keycode.
keycodev2.dll is in fact present, and the app was built properly with the keycode property.
again, this app, and the reports work fine in about 1000 locations around the world on XP, win2k, and (gasp!) win98se. Anybody have a suggestion or work-around?
rani
|
|
|
|
|
|
Hello,
I'm using VB.NET 2008 (framework 3.5).
I would like to check permanently if a new entry (row) is added to a table in particular, but I have no idea about how to do this... (is there some equivalent of the FileWatcher for DB ?...)
Thanks in advance
Etienne
|
|
|
|
|
The service could periodically count (SELECT COUNT(*) FROM ...) the number of rows in the table and when the count increases you know a new row was inserted.
A better solution would probably be to use a FOR INSERT trigger on the table, as described by How to: Create and Run a CLR SQL Server Trigger[^].
|
|
|
|
|
ok, i'm going to try it (with the trigger).
thanks a lot ! 
etienne
|
|
|
|
|
is there any pivot table kind of control in asp.net / vb.net
|
|
|
|
|
is pivot table kind of control used in data reports
spriya
|
|
|
|
|
Native in the VS toolbox?? No.
You'll have to either write one yourself or use a third party graphing library, like ZedGraph.
|
|
|
|
|
hello, ive been working on a tabbed web browser for a little while now, and it's gotten to the point where i would like to add a favorites, and a history menu, i have tried and tried to implement a history menu and a favorites menu and have failed in trying to do so.
it would be great if you could help me out
|
|
|
|
|
All you have to do is add entries to a collection. They can be as simple as adding string objects to a List(Of String), or an XML document. Either way, you can easily serialize the contents to a file to save/retrieve the list.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
