Jonathan Freidin's Q&A profile

• .NET Development How do i remove an empty element name?

  My XML file contains empty element names. this is due to the fact that my data in my dataset contains null values. the following code should provide a better insight: < GH1_TEAMNAME > Incident Management Team (IMT) </ GH1_TEAMNAME > < DE_Team_Leader > hjjj </ DE_Team_Leader > < DE_Full_Name > ioll </ DE_Full_Name > < DE_TELE_WORK > hgtr </ DE_TELE_WORK > < DE_T ...Show All

• SQL Server HOWTO: Script object as execute?

  (Didn't know in wich group this question belongs....) Hi group, In QA there is an option called 'Script object as....' Were developing a lot of sp's. When I use this option the 'skeleton' of a sp is created. Eg Create proc uspMySP @Message varchar(10) AS SELECT @Message The mention option would generate the following: DECLARE @RC int DECLARE @Message varchar(10) -- Set parameter values EXEC @RC = [EMGLSP3].[EM3_OWN].[uspMySP] @Message The qu ...Show All

• Smart Device Development Rotating app in vb.net

  Hello, Is there a sample out there in vb.net to rotate the screen for wm 5.0 I cannot seem to find anything. Any help we be appreciated. Thanks. John throwing this in a class using System; using System.Text; using System.Runtime.InteropServices; namespace DeKangoeroe { [Flags] public enum DMD { DMDO_0 =0, DMDO_90 =1, DMDO_180 =2, DMDO_270 =4, } ...Show All

• Windows Forms Hide a tab Page in vs 2005 is this possible?

  In vs 2003 you had to remove a page and then readd it. In my eyes I could not see the reason of MS not providing a visible property I see that in vs2005 is still the same thing They say is by design mmm... What is it the proper way to handle the visibility of a tab page in vs2005 thanks for your help Hi, Use the Insert function rather than the Add in the TabPages Collection. So that you could specify the inde ...Show All

• SQL Server SQLAgent2005 not starting

  I installed SQL 2005 successfully but sqlagent is not starting, giving the following error: SQLServerAgent could not be started (reason: Error creating a new session). And in the agent log I see the following error. Message [298] SQLServer Error: 208, Invalid object name 'msdb.dbo.syssessions'. [SQLSTATE 42S02] Can anybody give any ideas how to solve this Thanks... If you fisrt stop the SQL Server (MSSQL ...Show All

• SQL Server SQL Server 2005 - Auto-indent???

  Hi, I recently installed Sql Server 2005 SP1 and plan to use it going forward as my primary database engine. I'm creating my first SQL Server 2005 database - everything so far is going well and I really do like the improvements over 2000 as far as the tabbed interface goes... First problem though ... I've just began to create a stored procedure, and am noticing that in the SQL Server 2005 T-SQL Query text editor, it does not auto-indent th ...Show All

• Windows Forms Bindingsource - Is there event any equivalent to positionchangING.

  Hello, I have few textboxes binded to a bindingsource. I want do some validation and take some action based on that, when user is trying naviagte through the rows. If the validation fails I want to stop position being changed. There is no positionchanging event on bindingsource object. There is only positionchanged event and that fires after the position is changed. Is there a event / method / technique to handle stop posstio ...Show All

• Visual Studio Can't connect via HTTPS from VS 2005b2 to VSS 2005b2 on SBS 2003 (error 0x80072F0D)

  Hi, We've be wrestling with getting VSS up and running, and finally it is working over http.  Now, requiring SSL by going to Server -> Configure on VSS Admin gives us an error: "Failed to enforce SSL requirement on IIS.  VSS Web Service is disabled on this machine.  Configure IIS to allow SSL connections and enable the VSS Web Service from SourceSafe Admin." The service gets set up fine, virtual directories and all - but no ...Show All

• Visual Studio VS 2005 Beta 2 with .new Framework 2 (release) and VS 2005 SDK (October)

  I had VS 2005 Beta 2 installed and working with .net Framework 2 Beta 2. This morning I decided to try out the DSL tools. This required replacing the .net Framework 2 Beta 2 with the released version. Then installing VS 2005 SDK. Eventually I got everything installed. But now VS 2005 won't load. I get the splash screen with the note about the VSIP Licence Required (I read the threads indicating that this didn't mean anything). So will the DSL ...Show All

• Architecture designing an online & offline application... what methodology to use?

  Hello, I am at a stage where I want to develop and application that will work the same whether if you are online or offline. I can always write an application that hooks up to a server while online (connected to a network) and queries a db for the interactions bewteen the user and the app. Then when offline have another app that looks at the local database... but i don't want to write two apps... I want to build an app like outlook ...Show All

• SQL Server Complex Join

  Hello, I am blocked with a Join Request I have 3 tables : TaUtilisateurs store the users TaClients store the customers TaJoinClients_Utilisateurs store right of user on customers : for example : TaUtilisateurs Id_Utilisateur Login 1 Nico 2 Philo TaClients Id_Client Entreprise 0 Company 1 4036 Company 2 TaJoinClients_Utilisateurs Id_JoinClient_Utilisateur Id_Utilisateur Id_Client Editeu ...Show All

• Visual FoxPro can i create a private cursor with the same cursor name for each MDI child form?

  Dear all, Can i create a private cursor with the same cursor name for each MDI Child e.g.  i created a temp cursor (say, temp1) for store up a MDI child data. when multiple MDI child called, can each child has its own temp cursor with the same name Otherwise, any suggestion which can perform the same purpose Thx very much. Ash Solved By setting "DataSession" = 2 - Private data session. ...Show All

• Visual C# Form error message after upgrade form Beta 1 to Beta 2

  Everything went smoothly after I upgraded.  I had tons of errors and warnings but I'm getting them all sorted out.  This one, though, I can't track down.  When I open one of my forms I get this error message: Object of type 'System.Drawing.Size' cannot be converted to type 'System.Drawing.SizeF'. at System.ComponentModel.ReflectPropertyDescriptor.SetValue(Object component, Object value) at System.ComponentModel.Design.InheritedP ...Show All

• Visual Basic Need to call external DLL that takes structured parameter

  Hi, My application needs to call an external unmanaged DLL supplied by a third party. That DLL is written in C I suspect, it takes a struct parameter that holds some 30 fields, most of them of type char[x] where x varies for each field. What I did was a wrapper class, that has a declare statement like this Private Declare Ansi Sub ExternalSub Lib "ExternalDll.dll" (ByRef struct As strParam) The struct is defined like this & ...Show All

• Visual Studio Error: Report Parameter 'Value1' is read-only and cannot be modified

  I am using VB 2005 RC and SQL 2005 Dev Edition I am trying to drill-through from one report to another passing the Value1 id field as the parameter. Report1 is a basic list of a table.  Report2 is a view generated data from four linked tables.  Both reports work like a charm on their own. In Report1, I select the column properites and link via jumping to Report2 using Parameter Value1 and defining the Report Parameter in Repo ...Show All