Andreas Johansson's Q&A profile

• Windows Forms Suppressing Checkboxes for some nodes in a TreeView

  The web version of the TreeNode class has a ShowCheckBox property. The Windows version does not. Is there a workaround to hiding checkboxes for some items in a TreeView I need to suppress showing the checkbox for the root nodes in the tree. Thanks, Paul Whitaker Technically, it is possible by setting the DrawMode to OwnerDrawAll. Practically, it is not; you have to draw the nodes as well as the checkboxes, a large undertaking. As an alternative, consider using the checkbox for the parent node to indicate the state of the child nodes. A tri-state checkbox would be useful for this, check out this project . ...Show All

• Windows Forms expression in a StronglyTyped Dataset returns only the default value

  Hi. I have a stronglytyped dataset that contains column from where the data is made from an expression. When I preview the data in the designer I get correct results but when I call the function from a client I get columns default value. Why is there a difference between these two and how can I fix it ...Show All

• SQL Server The partner transaction manager has disabled its support for remote/network transactions.

  I'm trying to run an SSIS package. The package runs on an SQL 2005 server on Win2k3 server. The package tries to connect to another win2k3 server with sql 2000 to retrieve some data. However, I recieve the errormessage shown in the topic. I found info about modifying the MSDTC security settings under "component services" and did so. I made sure everything was allowed. However, the result was the same. Does anyone have any other idea about what could cause this problem PS. The package works fine if I set up both databases on the same physical machine... Regards Andreas Hey go here,You have the answer over there http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=230390&SiteID=1 ...Show All

• Visual Studio Team System TF30063: You are not authorized to access <servername>

  Every few days one of our team members receives this error when attempting to check files out of version control. I have seen other postings related to this error, but it seems that it occurs when using proxies or other configurations. These solutions do not apply to use because we are using the single deployment model for TFS.  At present time our workaround is to have the developer reboot their workstation. Is anyone aware of the root cause of this problem and how to solve it Thanks Mario. I have been unable to reproduce this to help identify the problem, but I will be sure to post again if it happens. ...Show All

• SQL Server Datareader Destination as source for other datareader source ?

  HI! as far as I know from docs and forum datareader is for .NET data in memory. So if a use a complex dataflow to build up some data and want to use this in other dataflow componens - could i use data datareader source in the fist dataflow and then use a datareader souce in the second dataflow do read the inmemoty data from fist transform to do fursther cals how to pass in memory data from one dataflow to the next one (i do not want to rebuild the logic in each dataflow to build up data data Is there a way to do this and is the datareader the proper component (because its the one and only inmemory i guess, utherwise i need to write to temp table and read from temp table in next step) (I have only found examples fro .NET VB or C# ...Show All

• SQL Server No compatibilty level 90 option after upgrade from SQL 2000 to 2005

  I did an in place upgrade of my SQL 2000 server to SQL 2005. Now all the system and user databases are set to compatibilty mode 80 and in the options tab there is no compatibilty mode 90 option. How can I set the databasbes to compatibility mode 90 Thanks! Stange thing, did you try using the TSQL command for that sp_dbcmptlevel [ [ @dbname = ] name ] [ , [ @new_cmptlevel = ] version ] 90 = SQL Server 2005 HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual C# Run exe from command prompt

  Can i create a console application to run a exe in the ms-dos prompt, on a timer application Has anyone every done this before If so can someone shoot me a link thanks why don't you just use the Process class to execute your process, giving the arguments to your vbscript file, if it needs them System.Diagnostics.Process.Start(" yourVBScriptFile .vbs arg1 arg2 "); you could do this:   ProcessStartInfo theProcessStartInfo = new ProcessStartInfo(" fileName "); theProcessStartInfo.WorkingDirectory = yourDirectoryHere ; Process.Start(theProcessStartInfo);   this would execute your file, setting its working directory to be the directory you specify, then of course you could give your file the arguments ...Show All

• .NET Development how can i know whether i net.framework already installed in my laptop?

  i am having problem when reinstall dvd decoder and media direct to my laptop after i reformat my laptop. this make my computer does not recognised and autoplay the dvd whn inserted..it keeps telling me that the system need 1.1 net. framework or higher in order for me to proceed the installation. i try to download the net. framework from microsoft website but another problem occur tells me that " the upgrade cannot be install by windows installer service because the program to be upgrade may be missing or the upgrade patch may update different version of the program. verify the program to be upgrade on ur computer and that u hv correct the upgrade patch. what can i do to solve tis problem Sorry. You q ...Show All

• Windows Live Developer Forums How to do search in sql server database for all properties (with long, lat) that fall within selected map area?

  Would like to create site with similar functionality tohttp://www.realtysouth.com/consumer/listing/ListingSearch.aspx SearchType=map&ListingType=1&ListingSearchID=&RECoJumpSearchID=&action=&defaultlevel= for our site www.mls.ca How to do search in sql server database for all properties (with long, lat) that fall within selected map area thanks steph thanks very much for all your help...as you can tell Im new to the platform. what logic would i include in "If you put your logic on the "onchangeview" event " i assume this is standard process. thanks steph ...Show All

• Visual Studio Team System Static Data Management

  Hello, This is probably a stupid question, but I'm starting to play around with Data Generation scripts for unit tests in my database project, and I have a query about what I would call static or system data. For example, the data generation scripts take care of user data, but what about tables of types or the equavalent of enums for instance, a UserType table which contained data such as: UserTypeId | Description ---------------------------------- 1 | Standard User 2 | System administrator 3 | Editor Or similar The IDs would have to stay constant thoughout the system, so either I create a deployment script that creates the data or use the data generation tools. If I use a deployment script, will (1) the data ...Show All

• Windows Forms Attempted to read or write protected memory. This is often an indication that other memory is corrupt

  I get this error when I try read the FbDataReader Friend FbConnection As FirebirdSql.Data.FirebirdClient.FbConnection Friend SQL As String Friend dbDataAdapter As FirebirdSql.Data.FirebirdClient.FbDataAdapter Friend dbDataSet As New Data.DataSet Friend dr As FbDataReader .................. FbConnection = New FirebirdSql.Data.FirebirdClient.FbConnection(CadenaConexion) dbDataSet.Clear() If (FbConnection.State = ConnectionState.Closed) Then FbConnection.Open() End If ........ SQL = "select CATE_ID from T_CATEGORIAS WHERE CATE_NOMBRE='@v_categoria'" Dim prm As New FbParameter Dim cmd As FbCommand Dim Transaccion As FbTransaction Transaccion = FbConnection.BeginTransaction cmd = New FbCommand(SQL, FbConnection, Transaccio ...Show All

• Visual Studio error :operation is not valid due to the current state of the object

  hi , I tried to compile sample dsl project or start a new dsl project , But I am getting "operation is not valid due to the current state of the object" error . I am following instructions under :http://msdn2.microsoft.com/en-us/vstudio/aa718368.aspx for creating a new dsl project. thanks Michael Hi Michael, Sorry for the delayed response. Can you tell us what version of DSL Tools are you using and what is your platform Does this happen when you transform the text templates or build the solution I would recommend uninstalling all previous versions of VS SDK and installing the RTM release version of DSL Tools shipped with the latest version of VS SDK which can be found here . Let us know if ...Show All

• SQL Server RS 2005 Initialize greyed out ???

  HI There I have installed Reportin Services 2005 , X64. I selected install but do not configure. Afterwards i applied Service Pack 1 and ran all the hotfixes for sql components as per KB 918222. The i launch the RS configuration manager i succesffuly setup Report Server/Manager Virtual DIrectory and servcie identity. I then setup the database, i create a new database to the local 2005 instance i just installed with RS, the databse is created successfully. Basically i have green ticks all the way, however Initialize is greyed out i cannot take the option to initialize the server When i try to restart the RS service it says that the service failed to repond in a timely fashion, when i check the even log the servcie only s ...Show All

• Visual C# ReportGeneration Application

  I have to create a web app. that prints out the statistics for student applicants in a .txt file. The data in form of Tables resides in a SQL server. Now, the user provides a date range(for eg. from 12/1/2006 to 1/1/2007) and the outputted text file will have the following: - The Number of applications received - The number of applications approved - Number of students with a criminal background and the type of background - Number of applicants who applied last year. I was wondering that from a design standpoint, what would be an elegant and effecient way to extract the data from the server, store it in some kind of data structure and output the contents in a text file. I was looking at Enterprise library and interfaces but ...Show All

• .NET Development About SmtpMail.Send() Method

  Hi all, This is Hari, In my application I need to generate a report for different people and send it through mail as attachment, and my approach to this task is I will generate a report for single person ,And send it to his Mail ID and then I will delete the report and generates next person’s report and send it. To send the report I am using SMTP server. I am able to send the mails if all the mail ids are correct, if the mail id of a person is incorrect in between I am able to handle the exception but I am not able to delete the report of that person the error I am getting is "Internal system error. Access to the path.... "Even I am not able to delete the file manually .How can I come out of this plea ...Show All