MarcStevenson's Q&A profile

• SQL Server Loop through each record and then each field within each record

  I need to essentially do 2 loops.  One loops through each record and then inside each record row, I want to perform an insert on each column. Something like this maybe using a cursor or something else: For each record in my table (I'll just use the cursor)      For each column in current record for cursor               perform some sql based on the current column value      Next Next So below, all I need to do is figure out how to loop through each column for the current record in the cursor AS DECLARE Create_Final_Table CURSOR FOR SELECT     FieldName, AcctNumb ...Show All

• Visual C# connecting to sybase server on network from a .net application

  there is a sybase server installed in a one of the machines in our network, say machine A. and in my machine i hv installed sybase network client. how can i set connection string in my application to use the server on Machine A at present my connection string is : AsaConnection connEQ = new AsaConnection("Data Source=eq2gents;UID=DBA;PWD=SQL" ); pls help me. sajitha The connectionstring format: Data Source='SERVER';Port=5000;Database='DatabaseName';UID='Username';PWD='Password';   Now, just use the values you need, you should replace SERVER for the server name you want. ...Show All

• .NET Development Possible bug? FileIOPermission failed

  I think the following code should throw an SecurityException if I run the code from a network path. But it does not. try {     FileIOPermission perm = new FileIOPermission(PermissionState.Unrestricted);     perm.Demand(); } catch (SecurityException ex) {     MessageBox.Show("Sorry, you can only run this application from your local disk.", "Security Error", MessageBoxButtons.OK, MessageBoxIcon.Error);     return ; }   And another problem I found is that I do not need to call Demand() to let SecurityException be thrown. Look at the following code: FileIOPermission p ...Show All

• Visual Basic I have problem with win2000 and vb2005 in clickOnce

  Hello all, When I install my clickonce application, in win2000 OS there is a problem comes up when first form shown there error mesage is System.NullReferenceException: Object reference not set to an instance of an object. at System.Windows.Forms.Control.WaitForWaitHandle(WaitHandle waitHandle ) at System.Windows.Forms.Control.MarshaledInvoke (Control caller, Delegate method, Object[] args , Boolean synchronous) at System.Windows.Forms.Control.Invoke (Delegate method, Object[] args ) at System.Windows.Forms.Control.Invoke (Delegate method) at Microsoft.VisualBasic.ApplicationServices.W ...Show All

• Software Development for Windows Vista ASP.Net, SQL Persistence Issues.

  Hi, I have several questions / issues so I'll attempt to put them in order. First off I'm using Feb CTP and SQL 2005, VS 2005 I have a need to create several (very) long running workflows, so I set out creating my host. Initially I used a console app for testing etc... and the test workflows that I created persisted, dehydrated and rehydrated fine. BUT, the workflows need to accessed from inside a web app. So I started using the WorkflowWebRequestContext to get to my instance of the runtime. The config used for the runtime is as follows: <WorkflowRuntime Name="WorkflowServiceContainer"> <Services> <add t ...Show All

• Visual FoxPro Number of variables

  When I create a 200 x 200 array dimension MyArray(200,200) no problem, but when I try to create a 400 x 600 array, I get a "Too many variables" message. How could I make my application work Thank you for your help. Michel Cariotis I have never gotten this error nor can I replicate it, but ….. Prior to ver 9.0 Arrays where limited to 64,000 elements, yours has a whopping 240,000 !! So I assume you are using 9.0. Have you tried changing the MVCOUNT value in your .fpw File (I have no idea if this settings effects arrays or if the limit has been raised above 64,00 ...Show All

• Visual Studio 2008 (Pre-release) VS2005 Release 2005 after migrating from Beta 2 to ReleaseVS 2005 I am getting VSS related Issue

  Earlier I have VS 2005 Beta 2.0 its working fine with VSS, but after installing VS2005 Release and migrating my code from beta 2.0 to Release I am start getting VSS related issue. While check out its gives me this error message : "unexpected error encountered. It is recommended that you restart the application as soon as possible." Ritesh - could you please be more specific and tell us what file and line number are mentioned on the error message that you are getting is there something specific that you did to migrate your code to release of VS2005 please let me know. -Grigori ...Show All

• Software Development for Windows Vista cpu constantly running at 100%!!! and Vista running EXTREMELY slow please help

  i have no idea what to do,  when i go to task manager and click performance it says my cpu is running at 100%, and its doing that 100% of the time, im afraid it may overheat. I am running a Sony Vaio laptop, 3.2 Gz, 1Gig RAM, 64MB video card. vista is also running slow, very very slow... it lags and it doesnt alow me to move large files. (says that i do not have permission) HELP! Sorry for bumping, but I have the same problems and my mi laptop's battery runs out too fast because of this, too. Thanks. ...Show All

• SQL Server How to get the Task name inside your custom task

  I have a custom task, and during the Execute method I'd like to get hold of the task's name. It appears that this is held on the TaskHost, but I cannot see how to obtain that from within the task itself. Anyone got any ideas Thanks Darren Jamie. I think SourceName is only added to the Variables list if your package has Event Handlers. Allan ...Show All

• .NET Development .NET Runtime 2.0 Error Reporting

  Hi, My application is running on 65 PC. After a few hours, this applications crash on 2-3 PC. I get no exception in my log files. I set the Application.ThreadException and AppDomain.CurrentDomain.UnhandledException exception event handlers. The last one is triggered with 'System.NullReferenceException: Object reference not set to an instance of an object.' but there is no stack trace available. I got no dump file, no popup window. I only get the following entry in the event log : Event Type: Error Event Source: .NET Runtime 2.0 Error Reporting Event Category: None Event ID: 1000 Date: 13/05/2006 Time: 21:53:39 User: N/A Computer ...Show All

• .NET Development Dictionary, StringDictionary, Hastable, ... and NameValueCollection - When to use which

  There are many options like Dictionary, StringDictionary, Hastable, NameValueCollections and ... The purpose of some are clear like SortedList, rest can be used interchangeably. Hybrid is also kind of clear along with ListDictionary and so is Hashtable. Is there any documentation, which can suggests which collection/dictionary should be used in which scenario Improving .NET Application Performance and Scalability - Chapter 5 — Improving Managed Code Performance. Also search for "Collections and Data Structures" in MSDN. ...Show All

• SQL Server Howto reinstall with local encrypted data, no domain?

  This is a question more about EFS, I think, than SQL itself, so apologies for that. My SQL data is stored encrypted (EFS) on an external drive; I have a laptop (not on a domain => no active directory) with XP; I wish to reformat & reinstall the O/s on the laptop, but leave the external drive as is. How can I ensure those external databases will be accessible afterwards   I have exported the SQLServer certificates, but can't find any way of making another user (myself as admin, as a test case) able to make use of those certificates.  I understand - perhaps incorrectly - that because I am not on a domain I have no data recover ...Show All

• Visual C# input text into another form

  Im not sure how to I can get my program to put text into another unrelated program. For example if I press a button, how can I get IE to open and for the website address be automatically placed into the address bar (The website will be specified in a textbox in my program) All I have is this so far when the user clicks the button, beyond that I have no idea since Im a beginner: using System.Diagnostics; { Process process = new Process(); process.StartInfo.FileName ="iexplore.exe"; process.Start(); } For internet explorer: System.Diagnostics.Process proc = new System.Diagn ...Show All

• Visual Studio Tools for Office Determining current node based on selection

  Hi I have wired up an event handler for the SelectionChanged event.  Within this handler, I want to determine what my current node name is.  Any idead on how to do this I also recall you can use Selection.XMLParentNode to get to the currently selected object. Though you might want to test and verify this statement. ...Show All

• .NET Development .NET Framework 2.0 question

  I appologize in advance if some of my  questions to the forum is a little out of place. I am not a programmer or developer, just a gamer, system builder, and network administrator of a home network. After installing .NET Framework 2.0, Direct X9.0c's Diagnostic shows that one of the two system.dll files is missing. The one that is listed belongs to 1.1, so logic dictates that it is the one for 2.0 that is missing. However it is in the .NET 2.0 folder! Some other symptoms are that logging into .NET sites must be done manually (being signed in with MSN Messenger does no good), and Auto-Scroll function for IntelliPoint 5.2 does no ...Show All