cgillum's Q&A profile

• Visual Studio Team System Is it possible to set recursion to false?

  Currently when automation script is run, an item is duplicated and incremented in subsequent runs. Is it possible to set recursion to false Thanks Test consultant Thanks for the reply. I was under the impression that there is a property in web test. Each time the test is run, it is expected to add only one item to the shopping cart and create a ‘virtual request’. However on first run it created 2 instances of the same item in the ‘virtual request’. On second run, there were 3 instances. Test Consultant ...Show All

• SQL Server how to query against two instances of SQL Server in Query Pane

  I have registered two SQL Server instances in Management Studio. I can see the tables and databases from both instances. My problem is how to combine data from both the servers in a single query I tries the following SELECT s.consortium_contact_data_request_id , s.copy_to_exchange_address_book,i.consortium_contact_data_request_id , i.copy_to_exchange_address_book FROM sandbox . gbiv . dbo . consortium_contact_data_request s, ivhost04 . gbiv . dbo . consortium_contact_data_request i WHERE (s. copy_to_exchange_address_book IS NOT NULL) go but received a message Msg 7202, Level 11, State 2, Line 1 Could not find server 'sandbox' in sysservers. Execute sp_addlinkedserver to add the server to s ...Show All

• Windows Forms How to bind and modify data from multiple tables?

  I was wondering if someone could point me to a tutorial that might help me I have an application that I'm developing that will display a tabbed form which needs to contain data from different tables. For example, my database has a contact table with typicall information and then it also has a lead table which contains information if the contact is a sales lead. They are linked together by a common contactID column. There are a few other normalized tables also like an AlternateAddress table. My first problem was that I could only get the binding source to connect to a particular table. This was a problem cause the data that I need to modify is normalized across a few different tables. My solution to that problem was to create a v ...Show All

• Visual C# IndexOf for

  Hi! There's probably a simple answer but I'm afraid I can't see it: I have a table with two columns, the first being indexed. I'm trying to use IndexOf on the table's binding source to get the index number of an entry in the first column but no indexnumber is found... what am I overlooking int indexNo = this .diagnosisListBindingSource.IndexOf( "ARDS " ); ( I know the entry "ARDS " does exist as an entry in the indexed column and the following function gives the correnct number of rows in the table, so I know I'm 'hooked up' correctly....) int count = this .diagnosisListBindingSource.Count; Thank you. JohnF. Try removing the spaces: int indexNo = t ...Show All

• Internet Explorer Development invoking download dialog box upon clicking on a link

  Hi, I am preparing one html file which contains link to trx files (test results file generated by VSTT). These trx files are present on a local share. When I click on the link I want either to open the file in the devenv or pop up the dialog box to download the file. Currently file is getting opened in IE only as a XML file which I don't want. I am more interested in first option: "That is by default file gets opened in devenv after user clicked on the link." How can I do it -Aaryan Dave, I am using VSTT to tun some tests. It gives me one Test Result File (extension .trx) as output. I am preparing a html report which contain various piece of information useful for testers. I am al ...Show All

• Windows Forms switch (listBox1.SelectedItem.ToString()) {} & video lesson #5

  I entered this coding as instructed, ran the program and did not select an item so the program had an unhandled exception and hung! System.NullReferenceException was unhandled Message="Object reference not set to an instance of an object." Source="lesson05" StackTrace: at lesson05.Form1.button1_Click(Object sender, EventArgs e) in C:\Documents and Settings\DOSrelic\Local Settings\Application Data\Temporary Projects\lesson05\Form1.cs:line 51 at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) a ...Show All

• SQL Server Peer-to-Peer Transactional Replication and deadlock

  Hi all, I have implemented Peer-to-Peer Transactional Replication only for two servers.Everything works fine but in highlevel of concurrency some updates are rolled back due to deadelocks(Never comes without replication).Is there any type of document which can guide me to avoid deadlocks (under Peer-to-Peer Transactional Replication env). Replication in general does nothing more than inserts, updates and deletes. Updates and deletes are qualified with primary key lookup, this is as simple as it can get. Without knowing exactly what your SELECT query looks like, or what the exact plan looks like, I can guess that you would get deadlocks whether it was replication or some other application doing the ins/upd/del. If you ...Show All

• Visual C# Obsolete System.Net classes.

  Im trying to run this snippet using System; using System.Net; class showIPs { public static void Main( string[] args ) { string name = ( args.Length < 1 ) Dns.GetHostName() : args[0]; try { IPAddress[] addrs = Dns.Resolve(name).AddressList; foreach( IPAddress addr in addrs ) { Console.WriteLine( "{0}/{1}", name, addr ); } }catch( Exception e ) { Console.WriteLine( e.Message ); } } } but I keep getting the following error :( c:\c-sharp\arr.cs(10,30): warning CS0618: 'System.Net.Dns.Resolve(string)' is obsolete: 'Resolve is obsoleted for this type, please use GetHostEntry instead. http://go.microsoft.com/fwlink/ linkid=14202' I went to the link.. I just dont understand how to fix it. As far as I know.. I think I ...Show All

• Windows Forms Copying visual studio window forms

  Dear All, I have a question say I have done a windows form then I want to make another new form which is similar to my earlier form with slight changes. So I want to copy my original form and make changes to it. How can I do it in visual studio 2005. This because when I copy and paste my original name of my class remains there. So how to do this type of copy My another question is that I have 2 different visual studio project. So I want to copy one windows form from project1 to project2. So how can I do this Thanks. HI , I think you can: right click your project then add new item, choose inherited form, you can inherited controls form forms you already have. best regards! ...Show All

• Windows Forms Display a specific item from a DataGrid

  I've successfully created a datagrid using an oledbdataadapter. The application displays and updates as advertised! Now I'd like to create a button that would generate a message box. In the message box I'd like to display a single, specific item from the data grid. Here's the question(s) - is this possible - and if so how do I specify the item For simplicities sake please assume that the first record(row) is where we'll find the record. Here's some sample information: Target dataset: Properties.Locations Data Table: Demographics Specific Item: Customer_Name (fifth item/column in the grid) Thanks I would use the datatable's defaultview to get the value. The default view will get the right value ...Show All

• SQL Server ExecutionLog duration - is it settable?

  Please forgive the stupidity of this question - it should be something very easy and I'm just not seeing it. I am trying to set the duration of the ExecutionLog table. Currently it is ~ 1 week, and I would like to up the lifetime of the records - say, to 1 year. I would think this is as easy as changing a .config file value, but am unable to find something for this. I found the entry for the log files, but nothing for the execution log. In the past I have tinkered with the Execution History DTS package, which would need to be scheduled to run and pull over only the newest records - is there anything else besides this (just let them sit in the table ) Thanks in advance, John I do apologize abo ...Show All

• SQL Server Paging data on SQL Server side using derived tables

  I am using derived tables to Page data on the SQL Server side. I used this link as my mentor for doing paging on the SQL Serverhttp://msdn2.microsoft.com/en-us/library/ms979197.aspx I wanted to use USER PAGING, thus I used the following code: CREATE PROCEDURE UserPaging ( @currentPage int = 1, @pageSize int =10 ) AS DECLARE @Out int, @rowsToRetrieve int, @SQLSTRING nvarchar(1000) SET @rowsToRetrieve = (@pageSize * @currentPage) SET NOCOUNT ON SET @SQLSTRING = N'select CustomerID,CompanyName,ContactName,ContactTitle from ( SELECT TOP '+ CAST(@pageSize as varchar(10)) + 'CustomerId,CompanyName,ContactName,ContactTitle from ( SELECT TOP ' + CAST(@rowsToRetrieve as varchar(10)) + 'CustomerID,CompanyName,ContactName,ContactTitl ...Show All

• .NET Development Drawing on web pages

  After way too much research and study, I have not been able to determine how to draw on web pages (not forms). Is it possible If not, how do I launch a seperate form, and can I draw on that (as the client) Thanks in advance. Sinan, Thanks for your response. What I need to draw (like drawing on forms) is lots of small rectangles. Then the client interacts with them by selecting some of them for various purposes. I currently do this in VB6 on forms where the operator interacts with the graphics (by keeping track of X and Y coodinates), but this doesn't seem possible using browser pages, since they don't have form methods, such as paint or mousemove. Could I open a form, paint on that, and interact w ...Show All

• Visual C++ Capture virtural keys in textboxes

  Question: How to capture virtural keys like VK_F1 or VK_F3 in a textbox that has keyboard input focus. Thanks...     Sorry I got you confused with that other guy who was asking the same question. PreTranslateMessage is the function to override. If you do it at the App level you'll be able to get any keystroke. Pretty much the same thing you are doing except within the MFC framework. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=986431&SiteID=1 ...Show All

• .NET Development XP Pro IIS/Framework 2.0 and Srv03/Framework 2.0

  I'm having challenges moving my working asp.net app in VS05 running on xp to production server running srv03/iis6/FW 2.0. Are there do's and dont's that i should know about I've posted two other threads to no avail. Please advice. ( First thread ) was directed to post here after first thread (Second thread) I will take the assumption that you are intelligent in the field of IIS and the .NET framework, and know beyond a doubt that my problem is code and not IIS or the Framework. I hope that the solution lies in my code, and that IIS or the framework is not the issue, because it is extremely frustrating that to have someone say "post in asp.net forum" and come to find out asp.net is not t ...Show All