joeslide's Q&A profile

• Visual Studio Team System TFS Source Control Remote Working

  Hi, I hope I am missing the obvious, but I can't find any info on how TFS will work for remote workers. I know that it will work fine for those connected to the office network via VPN or such, but what about remote users who only have standard internet access I was under the impression that there was some kind of web access, but I can't find any details anywhere. I imagine there has to be some serious setup if this kind of external access through to a TFS server running on a corporate network so if anyone has any info, please let me know! Thanks Dan We're trying to get SSL access to FS to work right no ...Show All

• .NET Development .Net Oracle process error

  hi This is regarding a performance issue in my windows application... Maximum possible process in my oracle server is 150... Sometimes my users wont be able to log on to my application since it exceeds maximum processes.. so we have to restart my oracle server.... Can anyone suggest the best practise to avoid this...im using Visual studio 2003 and coding in VB.Net Thanks Raju, I don't have any Oracle knowledge, but at a guess, are you making sure that you are calling Dispose on your database connections when finished with them How are you connected to the Oracle server ...Show All

• SQL Server Having a drilldown report "go back" to original report

  Hi, I have a main/summary report which returns a list of records.  Each record on this main report contains a link to a detailed report for more information on that particular record.  That all works just fine.  But on my detailed report, I want to provide a button to allow the user to easily "go back" to the original report. I noticed that at the top of my detailed report is a toolbar, with icons to print, search, etc., so this seems like the place where it would be nice to have another icon with the back arrow that would be linked to the original report.  The user can use the Back button on the browser, but I think it w ...Show All

• Visual Studio Installing Visual Studio 2005 on Windows x64

  I am installing Visual Studio 2005 on a Windows x64 operating system.  As you know there are 2 directories for Program Files on a Windows x64 system.  The setup is stating that it is installing x64 components like net frameworkd and etc.  but the default for the installation is in the Program Files (x86) directory.  Is this correct or should it get installed in the Program Files directory VS 2005 itself is not native 64 bit. The only native 64 bit components are the framework and the remote debugger. Visual Studio will run under WOW on a 64 bit machine. ...Show All

• Visual Studio Team System Branch or second workspace?

  I have a simple problem I'm trying to solve, but I'm hung up on the workflow best practices with TFS version control. I'm accustomed to using copy project to move applications from my machine up to a web server. Now with things stored in the repository it's unclear the best way to move them (promote them) through the rest of the life-cycle. Suppose I have a new team project....I've added my solution everything works fine. I checkout some files, mod them and check back in. I've been working in my own personal workspace on c:\blah. I'm happy with my changes, but now my field testers want to test it. I need to move that exact version of the app ...Show All

• SQL Server Please help with explicit permissions for a database

  Hello! I've just installed SQL Server 2005 CTP and now I have a question.  If I open any database properties window, click "Permissions" tab in the bottom grid (under the title "Explicit permissions for...") I see several columns and one of them is "With grant". When I click a check box in this column then "Grant" chek box is automatically checked as well. Please explain me the purpose and meaning of "With Grant" check box. (I do understand the purpose of "Grant" and "Deny" checkboxes). Thanks in advance for help! Regards, Vasily "With Grant" is short for "Grant With Grant", that is,&nbs ...Show All

• SQL Server SSMS scripting Stored Procedures to separate files

  I have noticed that in (SQL Server Management Studio) SSMS the ability to individually script stored procedures appears to have been removed (it was there in Enterprise Manager (SQL Server 2000) and I found a comment in another thread which appears to confirm this: Steven Twitchell wrote: >We've had several requests from various sources for functionality to script objects to their own files rather than one large file. I have been scripting stored procedures to individual files and then using sourcesafe to compare databases to ensure syncronisation with a client. I can do this on one file but it does not give the same granularity ...Show All

• Visual Studio Generate and Open Visual Studio Report's inside Word for further modifications?

  If (yes) then "how "   ;-) Thanks Peter I guess this is a stupid question. sorry! Word export is not available in this release. You an export reports to .XLS and modify the report using Excel. ...Show All

• Visual C++ How to access a database

  Dear All, I am new to Visual C++ 2005 and I would like to write a network application that uses native win32 C++ and that stores and restores data to and from a different databases (depending on the setup). I am planing to make this application portable to be launched and executed on both platforms Windows and Linux. My question is that is there a generic iterface that enables me to connect the C++ application to an ORACLE or MySQL database (depending on my setup) so that I can restore or store my data using SQL commands from within the C++ program. Take note that this interface should be compatable with Windows and Linux plateform ...Show All

• Smart Device Development Connection error in SQLServer CE

  Hi, I'm trying to test a VB.net program which connects to my sqlserver CE database. I don't encounter errors while building the solution, but when it starts triggering the procedure via command button, i always encounter a "An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll". I can't find what's wrong in my code since i just copied it from one of the msdn technical documents. Here's my code: Dim cn As New SqlServerCe.SqlCeConnection("Data Source=\My Documents\sqldb.sdf") cn.Open() Dim sqlSelect As New SqlServerCe.SqlCeCommand("SELECT * FROM m_co ...Show All

• Windows Forms DataGridView: why not remove new row when saving?

  I have a DataGridView bound to a BindingSource which in turn is bound to a collection of objects. In the BindingSource's AddingNew event, I will create a blank object, like this:     private void myBindingSource_AddingNew(object sender,         AddingNewEventArgs e)     {         MyClass obj = new MyClass();         e.NewObject = obj;     } The problem is after I finish editing the current row, and press Tab key, it will go to the next row and a blank object will be inserted in the collection. Then whe ...Show All

• SQL Server About SQL Server

  Hi, Need some help regarding the SQL Server 2005 installation on Windows server 2005. I have installed the SQL server 2005 on Windods 2003 server. I have a database of 20 GB. Two of my db tables have about 4 millions of records. My Sql server has Ram of 2 GB. But As soon as some 10 users fire the queries, SQL server get jammed.It reach the aloocated limit of Max memory.There after It takes too much time to respond. Can any one suggest me the best configuration parameters for SQL server and for windows server 2003(like virtual memory and paging files etc). Thanks & Rgds Vyankatesh Hi, I would first ...Show All

• Visual C# Highlight multiple found word in RTB in C#

  hello, i have highlighted the searched word in richtext box. but, the thing i have to do is search multiple words at once and highlight them with different colors in rich text box in C#. i know the only the concept i.e. one should use the array for storing the words that are going to searched. but, i dont know the actual coding method as i am only a beginner learner of C#. plz help me by sending some code snippets pr the sites links. Here is a little example code that highlight a specific string: string wordToFind = "melp"; int index = richTextBox1.Text.IndexOf( wordToFind ); wh ...Show All

• SQL Server Updating a record from table with data from a column of another record from the same table

  Hey guys, I have a table say as follows id, id2, field1, field2, date1, date2 I want to update the date1 field to the date2 field of the very next record with the same id2. In short I want to update a record id(x) by putting in the date2 field if id(y) in the date1 of id(x) where id2(x) = id2(y) and id(y) > id(x) (as id is a sequence). I have written a query as below: update t_remarks te set out_date = (select TOP 1 date_remark_entered from t_remarks ta where ta.record_id = te.record_id and ta.remark_id > te.remark_id order by ta.remark_id) the above query throws an error: Line 1: Incorrect syntax near 'te'. Incorrect syntax near t ...Show All

• Windows Forms DataGridView v DataGrid Performance

  Hi I have just started using the Datagridview and have noticed a significant performance difference over a Datagrid. Below is 2 methods calling the same Stored procedure from two separate buttons. The datagrid view takes about 4.5 seconds to populate, the datagrid about 0.2 seconds. The problem seems to be with the number of columns (with a few the performance is similar but with 50 + this is where the differences occur. Any help would be gratefully received. private void Load_DataGridView() { SqlConnection sqlConnection = theDatabaseConnectionPool.Connection; SqlDataAdapter adapterDataGridView = ...Show All