Jon Parker's Q&A profile

• Windows Forms DataGridView events firing oddly

  First: It took a bit, but I've come to enjoy the DataGridView! My current issue is that the events seem to 'keep firing' after expected. I have a form with a TreeView and a DataGridView. The TreeView is being used as a menu and when a node is clicked, I manipulate my DataSet and DataGridView data binding within the TV_AfterSelect event. I'm finding that the DataGridView's _RowsAdded and _RowsRemoved events are firing long after expected. I've put breakpoints on the TV_AfterSelect:End Sub, DGV_RowsAdded and DGV_RowsRemoved. I'm amazed to see that after the End Sub that the DGV events continue to fire. Once I get to the End Sub breakpoint, ...Show All

• SQL Server New to SSIS

  Hi All, I am attempting to create an Intergration Services package. I need to insert data into several from one table. Is it possible to accomplish this in one task Are there any examples anywhere Thanks for your help, Roy Have a look at the multicast transform. This allows you to create n copies of the same upstream data to do with as you please. Allan Wiki.sqlis.com "RoyAF@discussions.microsoft.com" wrote in message news:670237cd-3394-484e-bf5d-59d53e77176b@discussions.microsoft.com: > Darren, > Thanks for the reply. > Just so I am clear on something; I cannot split different colum ...Show All

• Visual C# does a static timer works like any other static variable?

  Hi everybody I have a class Graph that has a static timer timSecs and a function start that enables the timer Graph.timSecs.Enabled = true; Graph.timSecs.Start( ); In the main application I have two objects of the Graph class. But it seems like the event timer just triggers for one of the objects. Any suggestions Thanx How about using a timer class Instead of having your class start the timer, it would be better to have the timer class call your classes... Something like this - I didn't test this, I know it works with one event handler, it should work with two. If it doesn't w ...Show All

• SQL Server Understanding ADO

  Hello, I want to use OLE DB in my projects. Since I start my work with ADO, I have some troubles and questions.At first, I have MDAC 2.8 SP1 and SQL Native Client from MS SQL Server 2005. Here's list of them: What difference between "SQL Native Client" and "Microsoft OLE DB Provider for SQL Server" I have troubles with understanding API cursors: all my sql-statements always returns Forward-Only Cursor Type. Here's little test about it written in VisualBasic: Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim Commd As New ADODB.Command Dim Co ...Show All

• Visual Basic How to maintain security on server with socket applications

  Hello everybody I donot know weather its a right place to this question or not but if this is not a right forum for this question then please let me know My concern is that lets say i have a server that is running a VB.Net application and this application has sockets that listens 24 hours for the connection made from remote sites using TCP/IP. My server is connected on internet Can somebody tells me how I protect my application form being accessed via anyother computer on the internet because of its sockets thats always listen on a certain port. Secondly opening ports like i have mentioned above could be threats for both my Operating S ...Show All

• Visual Basic Newbie Question

  I apologize in advance if this is the wrong place to post this question.  I am using VB.Net 2005  (expess) and am relatively new to Visual basic and SQL 2005 (express)  Anyway, I was going through a tutorial set (creating an RSS Reader), and after completing basic code / form creation, it made me wonder if there was a way to have the treeview facilitate the Channel/Folder/Item fields that I created in the Database.  If there is, how would I go about accomplishing this (or at least help with directing me where to get the instruction from). Thanks in Advance, John Petty I assume the structure you are going for ...Show All

• Visual C++ My Visual Studio does not load stdafx.h & stdafx.cpp in my project file

  Whenever I create project file it won't work because stdafx.h and stdafx.cpp files are not preloaded into the project file, how do I fix this problem You can set the use of precompiled headers in your project properties.  You can make it automatic, not happen at all, or happen only on files which have the #incude set ( so only some files use precompiled headers ). ...Show All

• .NET Development What is remoting?

  Please suggest a book or some example   Vikram wrote: Hi, While I agree with Hussein and Nicholas, I would still recommend you read the blog of Matt Tavis where he has some recommendations regarding the usage of .NET Remoting. http://blogs.msdn.com/mattavis/default.aspx Regards, Vikram http://dotnetupdate.blogspot.com/    It should also be noted that remoting is not going to be enhanced beyond 2.0, and that EnterpriseServices has been noted as being the easiest in terms of upgrading to Indigo.  For all intents and purposes, Remoting is now a dead end.         & ...Show All

• Windows Forms Create setup which contains database file

  Hi, I'm creating a setup using visual studio 2005, the application contains a database file which is 575 Mb .When is create a setup it show error Error 1 Could not find file 'K:\Current_Working\...\..\ZZZ.mdf' 'Not enough storage is available to complete this operation.' How do i continue.. . Thanks I'm getting the exact same error with an MDB file of just under 490MB. Anybody gonna take a stab at this ...Show All

• Windows Forms Transparent Usercontrols

  Currently transparent background color is not supported in usercontrols with overlapping controls as it was supported within VB6 with the backstyle proeprty. In the transfer of our software from VB6 to VB.Net this lack of functionality is killing our application. Please help. The SetStyle  etc. is working indeed. No problem. However I want to find o ...Show All

• SQL Server Restricting sql user connection..

  Hi, I have a question to restricting sql user connection after certain amount of time. (SQL 2000) In otherwords I can kill the connections made from the application aftercertain amount of time. (say 50 seconds.) I saw some options from SQL Query Analyzer Tools->Options -> Connections 1. Login Timeout 2. Network Package size 3. Query Timeout 4. Lock Timeout I guess by setting any of those will meet my requirement. If any one used these for this kind of requirement please post here. OR Can I use 'remote query timeout Option' from sp_configure. Thanks in advance mka Connections 'should' properly be controlled by the appli ...Show All

• SQL Server Conversation ID cannot be associated with an active conversation

  Hi: My service broker was working perfectly fine earlier. As I was testing...I recreated the whole service broker once again. Now I am able to get the message at the server end from intiator. When trying to send message from my server to the intiator it gives this error in sql profiler. broker:message undeliverable: This message could not be delivered because the Conversation ID cannot be associated with an active conversation. The message origin is: 'Transport'. broker:message undeliverable This message could not be delivered because the 'receive sequenced message' action cannot be performed in the 'ERROR' state. How do I pro ...Show All

• Windows Forms Question using IN clause and parameters in oledb command

  Hi all, II was wondering if anyone knew if I can do something like the following... cmd.commandtext = 'SELECT id FROM tbl WHERE id IN (@listOfIntegers)' cmd.parameters.add('@listOfIntegers', oledbtype.integer).value = "12, 14, 16" I can't seem to get it working (if it can work ). Firstly, the the numbers are integers but it is being submitted as a string so i realize&nbs ...Show All

• SQL Server [SSIS] Migrating Tables and searching for Surrogate Keys

  In an old accounting deduction table, I have a field with deduction types (annuity, Bond, dues, flex, garnishment, standard, etc). This table has about 20,000 records. I've created a DeductionType table and placed all the types (about 20 of them) and some other deduction information on it. While importing data from the old database, how would I look up the Surrogate Key on DeductionType for every column and place it into the new table Are there events you can override or would this be another flow control inbetween the old and new table Would I have to create a temp table (I hope not) If anyone knows or knows of online documenta ...Show All

• Windows Forms Is creating form objects and disposing them better or using Activator.CreateInstance()?

  I'm building an MDI application, and when user clicks various menus I want to load the child forms only if it is not loaded previously. I came up with two versions of methods to create the child form when menu is clicked. In the first version the calling method creates a Form instance, and in second version it sends Form's type. Both version work, but can experts explain which is better private void ShowChild( Form formToShow) { foreach ( Form form in MdiChildren) { if (form.GetType() == formToShow.GetType()) { form.Activate(); form.WindowState = FormWindowState .Normal; fo ...Show All