Henrik Dahl's Q&A profile

• .NET Development Is it ok for multiple threads to access different properties of same instance of object?

  Hi, I have two theads. They both have access to the same instance of an object mSettings, an instance of a class inhereted from ApplicationSettingsBase. mSettings has different properties, e.g. mSettings.BackgroundColor and mSettings.FontSize. Is it ok for two different threads to access mSettings.BackgroundColor and .FontSize at the same time (one thread accessing BackgroundColor and the other FontSize), or could this cause problems (All settings have internal locks on them, so that the properties/values themselves cannot be accessed simultaneously. Does ApplicationSettingsBase implement its own locking on the properties ) Thanks :-) Hi, If you are not going to change the content of tho ...Show All

• Windows Forms XML,DataSet and Grid

  Hi, I've an XMl which has many nodes in terms of different Names. I need to fetch the Selected node and display that into a dataGrid since XMLDocument and C# doesnot allow to a load a part of a xml document. Is there any way to achive it Thanks when you load an xml file in to a data set it creats a schima for it in a ceratin way given you xml file your data setbecomes some thing like the following   E rss (rss) E channal (channel) A version string       E channal (channel)   title string ...Show All

• SQL Server File Metadata and the Foreach Loop Container

  Hello, I want to set up a Foreach loop container to loop through several flat files. I have a connection manager set up for individual flat files. The metadata for the files is all the same. They are fixed width files, and contain sixty five columns. I didn't see a place in the container properties to configure the metadata of the files. How can a Foreach Loop Container 'know' the metadata of the flat files that I want to loop through Thank you for your help! cdun2 I tried to implement this by following SSIS Tutorial Lesson 2 and the pkg only processed the last file in the list. From one I can tell from the project log, it didn't even loop through the other files, though it did process the las ...Show All

• SQL Server SQL Server Management Studio - Licensing

  We currently have SQL Server 2005 with a single processor license. We have the SQL Server Management Studio running on the same server. Can we deploy the full version of the Management Studio to other machines as well as the server within our company network on our current processor license what u meant by "full version of the Management Studio" Client tool then i think there is no problem, you can install client tool in any number of machine... Refer this link also :http://www.microsoft.com/sql/howtobuy/faq.mspx Madhu ...Show All

• Visual Basic Triggered Events

  My application reads an Access Db. My form has a list box which displays a list of the records from the Db table. My form also has individual textboxes that show the other related info from each of the records in the Db table. In my source code : for one of the text boxes QOH I am implementing the TextBox1_TextChanged Method On another, a checkbox , I am using the CheckBox1_CheckedChanged method. Now when I originaly decided to use these methods, my intention was that, if the user made a change to either of these two fields then take some actions. But, I have realized that as I scroll through the records in the listbox, if the values of these two fields change because of the data in the record then these methods ...Show All

• SQL Server execution of Stored procedure has become extremely slow

  Hello, i am having a bizarre problem with the execution of a stored procedure on SQL server. up to now, the execution time was taking maximum ten minutes and then suddenly since a few days ago, it takes more than 40 minutes, without exception!! i have tried to diagnose this problem with some tools that are provided out there such as executing a stored procedure called "proc track_waitstats" from which i learned that the “max degree of parallelism”. needed to be set (i set it to 3, it used to be zero. there are 4 processors). after rerunning the diagnosis, my SQL server seemed very happy with wait times. zero wait time for almost everything, but my stored procedure is still running as slow. what is going on how come it was running so much f ...Show All

• Software Development for Windows Vista The requested operation requires elevation.

  I am connected to wireless network in my city. The problem is that when I want to connect to city wireless I need to add a route in Command prompt. In XP it works fine, but when I type this in Vista: route -p add 10.0.0.0 mask 255.0.0.0 10.46.2.1 I recive this message: The requested operation requires elevation. I realy need to do that, otherwise I can't access any page on wireless except 10.46.2.*. When I tried to add a persistent route using the following (in elevated mode): route -p ADD 192.168.1.0 MASK 255.255.255.0 192.168.0.50 The route is added and I get an OK! prompt, but is not persistent, nor is it listed as a persistent route on the route print screen, can anyone tell me why ...Show All

• Windows Forms Iterating through the DataSource property via a Foreach Loop

  I've created a custom drop down list control which inherits from DropDownList: public partial class CustomDropDownList : DropDownList I need to add a method to this class which will iterate through the items contained in the DataSource property via some sort of loop (foreach or for) and attempt to match one of the items to a variable value that is set earlier. But I can't figure out to loop through the DataSource property. If anybody can show me how to do that I'd be very grateful. Thank you in advance. Sean. Your question seems a little strange at first, since most objects only have one DataSource property, rather than a collection to iterate through. However, the Micro ...Show All

• SQL Server Move table from one filegroup to another?

  Hi guys, I'm in middle of database re-development as part of performance enhancement, I have re-group the tables to optimize query IO and created corresponding filegroups to house the data. Is there a way (or code) to move each table to their respective filegroups At the moment all the tables are on Primary filegroup. I have group the table into 6 section each to with the view to move each section into one of the 6 filegroups - each filegroup on different diskdrive I have looked at alter table command but can't find anything to allow me accoplished this task. Any ideas please thanks. Red: From books online: "Because the leaf level of a clustered index and its data pages ...Show All

• SQL Server Grant Database Access

  I am setting up report services after I installed the report server add-ins on sharepoint 2007. at first step, Reporting services integration, I put report server web service URL -- http://ssrsdev1/reportserver authentication mode -- windows authentication it went OK. at second step, Grant Database Access, I put ssrsdev1 for server name (default instance) and then click OK and then I put the user name (a member of local admin group on ssrsdev1) and password, but I always got errors says: Unable to log on with the given username and password. what wrong here what should I check I am sure the user and password is right and I can log on to ssrsdev1 physically with admin right without any problem. thanks for any thought on this. zwp ...Show All

• SQL Server Analysis Services, msmdpump.dll and IIS.

  Hello: I have two servers, one hosting Analysis Services and the other just serves as webserver. I have configured msmdpump.dll on the Analysis Services server succesfully using basic authentication. But now I need the webserver to provide Analysis Services data. I thought that I would be sufficient to repeat on the webserver the same configuration steps that I folowed on the Analysis Services server and change the <ServerName> tag in the msmdpump.ini file to point to the last one. Well, this isn't working. What am I missing Is there any tutorial or resource to accomplished I guess the problem you are having has to do with configuring permissions. First make sure you can connect from your web se ...Show All

• SQL Server Unable to retrieve column information in Flatfile connection within foreach loop container

  Hello, I am getting very frustrated! I have got a Foreach loop container which I am processing files within a folder. I have a flatfile connection manager which I have set up using a test file and have updated the expressions attribute to be the package variable I set up in the collection for the loop container however everytime I run it I get the error: 0xC0202094 cannot retrieve the column information from the flatfile connection manager. I can only guess that it is either the variable being passed to the connection manager or the way I set up the connection manager. When I msgbox the variable in a script component before the dataflow step, the variable for the file seems fine. Any suggestions are REALLY appreciated. Yours Jayne ...Show All

• .NET Development ASP.net VB web APP upload CSV to SQL Express database MDF File

  HI, im new to this so please if ive posted this in the wrong place please accept my apologies. Im new to development and recently started using visual studio 2005 with SQL express, ive built my first web app in asp.net 2 vb and it all works fine and so far all went well but ive hit a major snag. Scenario: I have an application that searches an MDF file for local post offices depending on a town or postcode, Admins can insert, edit, delete but after building it i was advised that they update information each month and require the ability to upload a csv file into the sql database. The new information in the csv must overwrite the current data but the columns and table must stay the same. Ive looked everywhere and im so confused. ...Show All

• Visual Studio 2008 (Pre-release) Buffer Size error when retrieving Metadata - How to increase size?

  I am trying to retrieve the MetaData from the WCF Service using the following method. // Create a MetadataExchangeClient for retrieving metadata. EndpointAddress mexAddress = new EndpointAddress ( uri ); MetadataExchangeClient mexClient = new MetadataExchangeClient ( mexAddress ); // Retrieve the metadata for all endpoints using metadata exchange protocol (mex). MetadataSet metadataSet = mexClient.GetMetadata(); How do I increase the buffer size Thanks, Dave An exception is being generated Metadata contains a reference that cannot be resolved: 'http://localhost/EventTest/ServiceReport.svc/mex/'. at System.ServiceModel.Description.MetadataExchangeClient.MetadataRetriever.Re ...Show All

• Windows Forms DataGrid Problems

  I have managed to get to the point in a project where I must display a summery of a booking. The details that I have stored in an access database are as follows: First Name, Surname age and activity I need to get these to display in a data grid so that the user can confirm the booking. This is the code that I have so far, what I need is to get the data from the dataset and into the data grid. ' create a connection string Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\holiday.mdb" Dim myConnection As OleDb.OleDbConnection = New OleDb.OleDbConnection() myConnection.ConnectionString = connString ' create a data adapter ...Show All