simon burgess's Q&A profile

• Visual Studio Express Editions Storing stream information

  I've written an application that uses the StreamReader class to read through a number of files. The only real issue is not knowing where to store the information I need. I've tried using a DataTable, but the rows seem to add information that isn't there. For example, I've tested my information "extracting" method, and it works perfectly. But when each needed line in the file is sent to a row, it's somehow modified to something entirely different. Is there some other way I can store such information I'd love to help but I need a lot more information. What datatypes are you putting into the table What "Additional information" is being added by the table How are you creating ...Show All

• SQL Server moving data in ssis from sql server 2000 to 2005 on same server

  hi, does anyone know how I can make a connection to a 2000 db thru ssis LISA86 wrote: what if they have the same db name. do I need to rename one Wait a minute... How can you have SQL Server 2000 and 2005 running on the same server and expect to connect to them on port 1433 ...Show All

• Visual Studio Express Editions about array?

  hi there i have a problem regarding array....here's the situition i'm supposing to count a number of area... so i used select command count to count... i want is to compute all the number of area and put the result in textbox...(each result has seperate textbox)  txtbox1, txtbox2 and txtbox3... in my code below the dataset overwrite the result instead of to retaining and print the result of area(1) and area(2)...   dim conn as new oledb.oledbconnecion("connectionstring") dim area() as string = {"area1","area2","area3"} dim i as integer for i=0 to 2 dim sqlcom as new oledb.oledbcommand("select count(*) from table where area ' " & area(i) " ' ", connectionstring) dim ds as new dataset() 'whe ...Show All

• Visual Studio Team System renaming branches in TFS

  Hey guys - I have 3 branches setup in TFS as follows Dev -> Staging -> Production I want to rename the staging branch to test, but I also want to keep the hierarchy. My concern is that if I create a new branch called test off Dev, then delete the staging branch, that the Production branch shall be orphaned. Is there an easy way to point the new "test" branch to the production branch to preserve the merging flow etc Thanx Stephen I did not think that it was possible to rename branches - is there an easy way to perform this Thanx! Stephen ...Show All

• Visual Studio Team System How can I tell if SP 1 is installed on TFS

  Hi everybody, I’m not sure if my installation of SP1 went through successfully. How can we find out if we have SP1 running Kind regards, Rudi Rudi, the easiest way is to use Add/Remove Programs and look for SP1 under the Team Foundation Server entry. Make sure you have "Show Updates" checked. ...Show All

• Visual Studio problem debugging t-sql with local 2k3 win/2k sql server, vs 2k3

  Hi, Lots trouble getting stored procs debugged in VS 2k3 from a C# project. After correct the sql server name and apply sp_sdidebug 'legacy_on'. I can right click a SP and step thru sql code. But, when setting a break point and calling from C#, I can not get it to setp thru the t-sql source code as it trys to disassemble each line in sql. I can see the sql variable values. Yes, debug build with SQL debug turned on. Using admin account as win/domain user and sql con str (sa). Any help appreciated. Here's the top of the stack: > 00000000() dbo.MyStoredProc(mybox.mydb)(varchar[] @p1='xxx',int @p2=1) Line 10 T-SQL system.data.dll!System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(System.Data.Common.U ...Show All

• Visual Studio Automatically exclude undocumented classes, methods, properties etc.

  Is there any way to automatically exclude undocumented classes, methods, properties etc. I understand that the <exclude> tag will be supported in the future. This is not really want I want here but I can see where it would be useful. Any idea when this feature will be available I don't remember that option in NDoc.  Do you know what option it was   There is no Sandcastle documentation for the extra tags.  However, I think most of the requests have been to "make it like NDoc" so if you have NDoc, you can probably use its description of the tags in its help file for the time being.  They should be quite similar in behavior. Eric   ...Show All

• Visual C# ClickOnce Deployment Provider URL

  Got a problem with VC# 2005 Express and ClickOnce deployment. I've created a program that will be deployed and executed online only. I must have mistyped something initially which has since been corrected, but I'm now unable to run the app. Here's the relevant part of the ClickOnce error: PLATFORM VERSION INFO Windows : 5.1.2600.131072 (Win32NT) Common Language Runtime : 2.0.50727.42 System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200) mscorwks.dll : 2.0.50727.42 (RTM.050727-4200) dfdll.dll : 2.0.50727.42 (RTM.050727-4200) dfshim.dll : 2.0.50727.42 (RTM.050727-4200) SOURCES Deployment url : http://eng_laptop/StreamDownloader/Stream%20Downloader.application Server : Microsoft-IIS/7.0 X-Powered-By : ASP.NET Deployment P ...Show All

• Visual Studio Express Editions dbase querys

  ok, bashing my head in the wall again. I am using Visual C# exp. 2005 , sql exp 2005 on a winXP Box I have a table called options, to make it easy, lets say it has a season column, which contains the season data such as spring, somer, winter, fall. It also has a choices column, which would contain the choices to pick from for each season. so,, the first row maybe Season = spring with choice = blue, second row is Season = fall with choice = green and thrid row is season = spring and choice = red. now the form. I want a seasonal form, say SPRING FORM, and have that form would have a combo box to pick the choices for spring from. i dont want the other seasons to show up . just the ones under the spring season. i ...Show All

• .NET Development open port on server

  Hi I'm Brett, I"m trying to figure out how to see if a particular port is being listened on a remote server. For example: Client software that needs to detect whether a server's software is listening on port 6009. I'd appreciate the help. Regards, Brett Grentell ...Show All

• Visual Studio Express Editions Setting Node Backcolor Property Value

  If reader.GetAttribute("level") = "2" Then reader.Read() Dim nd As New TreeNode nd.Text = reader.ReadString reader.Read() nd.Name = reader.ReadString nd.BackColor = Color.Yellow TreeView1.TopNode.Nodes(TreeView1.TopNode.GetNodeCount(False) - 1).Nodes.Add(nd.Name, nd.Text, 2) End If I do the same for "level = 1" nodes, and the color value is changed as expected. However, when I try it on level 2 nodes, no color change is made. I double click the parent node to expand, and the color is not changed to yellow. Btw, this is in the form load event. I can change the parent node (leve 1) to blue (or any color), but the le ...Show All

• Visual Basic TNS error through visual studio connection string

  I am trying to connect to an Oracle database (I think it is 9.x) on a network using VS 05'. I made a form (form1) and started adding a new data source (strongly typed). This is where I get the TNS error - ORA-12154: TNS:could not resolve the connect identifier specified. My tnsnames.ora file is correct, and I can connect to the server using PL/SQL, I just can't connect through VS. So my question is- does VS require the tnsnames file to be located someplace else other than in the Oracle directory I am able to connect without trouble on my laptop through VS without changing the directory location of the tnsnames file. datawhse = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = datawhse.home.com)(PORT = 1521)) ...Show All

• Smart Device Development Selecting multiple records from the EDB using mfc

  hi all, I m new to MFC. I have created the database using EDB related functions. I want to select multiple records from the database having the search criteria matching, how to do that.Plz help me. I m using .net 2005. Use MFC Database classes. Following link will be helpful http://msdn2.microsoft.com/en-gb/library/4dtbk25b(VS.80).aspx Thanks, Achal, VSD, Microsoft ...Show All

• SQL Server Delte from 3 table in one procedure

  HI I have 3 table in table 1 i have a ID i use in table 2 and in table 2 i have a ID i use en table 3 In table one i have a datetime field What i want is to delete all from this 3 table when the datetime value are more than one hour old. I can delete old from the table one by: delete from tableName where datettimeField < dateadd ( hour , - 1 , getdate ()) But how do i delete all the records from table 2 and table 3 off course where the ID in table one are the same as in table 2 and the ID in table 2 are the same as in table3 Hope someone can help LN Hi Thank again I have done it in the rules for the diagram But i have another problem with the same delete This is allr ...Show All

• SQL Server Permit user to select columns for a report: why not use Dynamic SQL?

  I certainly have read lots of negative comments about using Dynamic SQL. And I have read some of the excellent web pages on the subject, such as http://www.sommarskog.se/dynamic_sql.html I have learned much from those discussions. But I still find myself faced with a problem for which Dynamic SQL seems like the only reasonable solution: letting a user select the columns to include in a report, and the sort order for the output data. In the application of concern, there are maybe seven columns that one might want to have in a report. If the user can choose any combination of these seven columns, and the order in which they are displayed (as well as the SORT order), it would be necessary to write something like 7! (7-factorial = ...Show All