|
Hi,
I am writing an SQL Server database application and I have noticed that under Management there are some database locks from my application. I don't think this is a good thing and want to make sure I am releasing the connection properly.
How can I do this?
At the moment I am doing this.
connection.Close();
connection.Dispose();
connection = null;
Is this enough?
Thanks
Stephen
|
|
|
|
|
It's enough to use Connection.Close() method.
About the locks, what kind of queries do you use?
|
|
|
|
|
Hi,
The queries are all SELECT, INSERT, DELETE and UPDATE queries.
Thanks
Stephen
|
|
|
|
|
Do you use any Transactions?
If so, you may want to add WITH (NOLOCK) to your select's used within the transaction
|
|
|
|
|
Anybody got any ideas on how to parse a resume form a word documnet. Basically the asp.net form would required users to upload word document, the webserver would then use ms word to open and save as text or xml. I would like to figure out a way to parse out name, address, phone etc...
I've tried saving it as a ms xml but have not had any success figuring out what's my next step. even if somebody had an example in javascript , c# or vb.net
thanks
|
|
|
|
|
Letting upload user their resume and then parse them would be difficult as each user might have different format of resume. The best way is to have all fields input by user rather than upload resume. User could easily copy and paste resume content in your input fields like name, address, phone or work history.
Sanjay Sansanwal
www.sansanwal.com
|
|
|
|
|
I've seen it done on multiple websites so i know it's doable, i just don't know how.
|
|
|
|
|
I have a mesh that I generated from the Mesh.TextFromFont method. I would like to center its axes so that when I rotate the mesh along the Y axis, it rotates around the center of the object instead of the beginning of the 3d text mesh.
How can I center the axes of a mesh object in such a case in Direct3D?
John 3:16: "For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not perish, but have everlasting life."
|
|
|
|
|
What I would do is create an invisible parent object, add the text mesh to the parent, so that any transformations done on the parent will get done to the child. Offset the child's position in the parent appropriately, then rotate the parent.
Tech, life, family, faith: Give me a visit.
I'm currently blogging about: The Secular Left, the Religious Right, and Prejudice
Judah Himango
|
|
|
|
|
So there is no way to actually change a meshes axes in Direct3D?
John 3:16: "For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not perish, but have everlasting life."
|
|
|
|
|
|
Hi Folks!
Does any one has implemented D* searc Algorithm...
If ( yes )
send me the code
else
Some tutorial link..
Regards,Jinbaba
Bye
|
|
|
|
|
How about A*?
/\ |_ E X E GG
|
|
|
|
|
I was testing the LinearGradientBrush functionality and came across a behavior that is totally unexpected and I hope someone can help me out.
I am overriding the OnPaint() method of my form and all I am trying to do is draw a linear gradient from blue to yellow inside a rectangle, here is the code:
protected override void OnPaint(PaintEventArgs e)<br />
{<br />
base.OnPaint (e);<br />
Rectangle rc = new Rectangle(10,10,80,15 + this.mHeightOffset);<br />
Point p1 = new Point(rc.X, rc.Y);<br />
Point p2 = new Point(rc.X, rc.Y + rc.Height);<br />
LinearGradientBrush br = new LinearGradientBrush(p1, p2, Color.Blue, Color.Yellow);<br />
e.Graphics.FillRectangle(br, rc);<br />
}
The problem is that the gradient shows the first row of pixels as yellow instead of blue. That's why I added the variable mHeightOffset and verified that the linear gradient doesn't behave as expected for all heights of the rectangle.
Does anyone have any ideas why this would happen?
|
|
|
|
|
Well...
Ive tested the code snippet and it looks like it should: A clear gradient from blue to yellow.
|
|
|
|
|
Robert,
Thanks for testing it, that's weird that it works fine on your computer and not on mine. Maybe it has to do with the display resolutions. That's why I had a variable called "mHeightOffset" which I kept changing and noticed that increasing the height just by 1 pixel got rid of the yellow line; however, if I kept increasing then the line came back. I guess this behavior is expected if the rectangle to be filled is larger than the distance between the points specified in LinearGradientBrush; however, I am using the exact same distance.
Please let me know if the code still works fine as you change mHeightOffset. To do it you can add a NumericUpDown control and call Invalidate() every time the value is changed.
Thanks,
Rudy.
|
|
|
|
|
Im astonished. You are totally right. I work frequently with the LinearGradientBrush but that never happened to me...
You only workaroundf for this is probably changing the first point of the brush by one pixel:
Point p1 = new Point(rc.X, rc.Y-1);
|
|
|
|
|
Thank you Robert, I figured out the problem right before reading your message because I wasn't connected to the internet. Wish I had seen it earlier.
It's weird and illogical but works.
Thanks,
Rudy.
|
|
|
|
|
I suspect you're getting an off by one error, because if the top left corner is 0,0, say, and your rectangle is 20 pixels high, then your bottom corner will be 0, 20. However, a 20 pixel high rectangle would end at 0, 19. Try Height - 1.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Thanks Christian, I tried something similar and the problem gets fixed for one height and not for all heights. What I did was place a couple of controls on my form, one to adjust the drawing height and another to adjust the height of my LinearGradientBrush. Usually setting the height of the LinearGradientBrush smaller shows the error mentioned; however, setting it larger by one pixel fixes the problem for some heights but not for all so the fix is not consistent.
I gave up on this problem and placed a border around my drawing to hide the incorrect row of pixels.
Thanks,
Rudy.
|
|
|
|
|
I figured out how to get it working, although it's not logical. The solution is to set the starting position of the LinearGradientBrush 1 pixel before the rectangle to be drawn.
Originally in my code I had:
<br />
Rectangle rc = new Rectangle(10,10,80,15 + this.mHeightOffset);<br />
Point p1 = new Point(rc.X, rc.Y);<br />
Point p2 = new Point(rc.X, rc.Y + rc.Height);
so I changed Point p1 = new Point(rc.X, rc.Y)
to: Point p1 = new Point(rc.X, rc.Y - 1)
Everything else stayed the same and I removed variable mHeightOffset
|
|
|
|
|
Hi i urgently need help in designing a tab control, i want the tab pages to list vertically on the side. I need urgent help...
N.M
|
|
|
|
|
You can set the TabControl property Alignment to left. However, there is a bug in this mode if you are using XP Visual Styles because in this mode the text won't show and all you can do is create a new tab, override the OnDrawItem of the tab and draw the text yourself.
|
|
|
|
|
Hi,
I'm working on a Office plugin which is supposed to work in Outlook (as well as other Office programs). I need to listen to certain events from Outlook, particularly the ItemAdd event on a folder I create, and the NewInspector event as well. The only problem is that my event handlers stop working at some point in time, sometimes it seems to happen when I cut a mail item from the folder, but sometimes for no particular reason at all. Has anyone experienced anything similar? I'm writing my plugin in C# by the way (hence I'm posting in this forum ).
Best regards,
Daníel
Wenn ist das Nunstück git und Slotermeyer? Ja! Beierhund das oder die Flipperwaldt gersput!
|
|
|
|
|
How do you subscribe to the events? Like this?
outlookObject.SomeEvent += new SomeEventHandler(MyEvent);
Maybe SomeEventHandler gets GC'ed (outlookObject is a COM object and maybe the interop layer decides it's not got nothing to do with SomeEventHandler instance) ?
Did you try instantiating SomeEventHandler as a class level member variable? Something like
class MyClass
{
private SomeEventHandler eventHandler;
public MyClass()
{
eventHandler = new SomeEventHandler(MyEvent);
outlookObject.SomeEvent += eventHandler;
}
}
I'm only guessing though, based on the fact that you said it works fine initially and then stops working after some time.
Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro
|
|
|
|