ssfftt's Q&A profile

• Visual Studio Team System Test Methods that Retrieve Data from Different Tables

  Hi, Is there anyway I can allow my test method to access data from multiple tables For example, in the following code snippet, I have two data field value retrieved from two different tables: string val1 = ( string ) this .TestContext.DataRow[ "Table1Field" ]; // From Table1 string val2 = ( string ) this .TestContext.DataRow[ "Table2Field" ]; // From Table2 So how should my DataSource attribute looks like Or are there any other solutions Regards chionhhm ...Show All

• SQL Server SQL CLR Stored Proc Reads

  I have written a same stored proc in TSQL and SQL CLR which basically takes an input xml and returns xml document. In SQL Profiler, I am getting reads value about five times more for the CLR. Does anyone has any idea why the CLR is doing more reads than TSQL Thanks in advance. Can you show us some code   Hard to say without knowing what it is that you're doing!   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     < Sequel2k5@discussions..microsoft.com > wrote in message news:dc077a90-5e82-48b6-b0c1-914480aad1eb@discussions.microsoft.com ... I have written a same stored proc ...Show All

• Visual C# Keyboard Input

  I am working on a 2D game. I am wondering how to use the keyboard arrow keys to move a sprite around. By the way they are sprites from files. If your form has focus, you can handle the KeyDown event as followings: private void Form1_KeyDown(object sender, KeyEventArgs e) { switch (e.KeyCode) { case Keys.Up: case Keys.Down: case Keys.Left: case Keys.Right: MessageBox.Show(e.KeyCode.ToString()); break; } } ...Show All

• SQL Server Adding comments to a Report

  I would like to allow users to add a comment to a report. What is the best way to do this When the report is run I would like users to be able to see all comments and which user reported them and the date and time the comment was entered Hi, Reporting Services doesn't include such functionality. I think that the best way to do it is to implement it in the context where the report is viewed. For example, if users view there report starting from a Sharepoint application, you can add comment functionality in Sharepoint. Eventually, you can create an ASP.NET page that displays reports (Report Viewer Control) and gives the possibility to display comments. Greetz, Geert Geert Verhoeven Consul ...Show All

• Visual Basic Strange Picturebox behavior

  Using VB 2003 (.NET 1.1), I have a panel containing a 6x6 grid of picture boxes on a form. Each picture box has a background color, and 6 of the boxes contain a background image (small, single colored shape) loaded in as a bitmap for the MakeTransparent feature. In addition, the user can move around the boxes with the arrow keys, and each time the keys are pressed the current box's image property is filled with another bitmap (a cursor made of black lines). The problem I am running into is that when a picture box contains a background image, it ignores its own background color and uses the background color of the picture box to its right. (It will wrap around if it is the rightmost box in the row) Also, if the picture box to the righ ...Show All

• Visual Basic how can I attach documents using vb.net 2005

  Please explain me how to write code to attach documents in vb.net 2005 take a look at this at emails and attachments: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=616274&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=980379&SiteID=1 ...Show All

• SQL Server Runtime data source error

  Hello I have a defined data source to an oracle server . I've alredy intalled oracle client, and setup my data source to save the user and password. I'm using .NET provider/OracleClient DataProvider Connection. When I click on "Test Connection" Button, SSIS reports SUCCESS. In Connection Manager TAB I created on connection called "OracleServer" from my oracle data source, described above. In my package, I defined a DataReaderSource task, I specified "OracleServer" as a connection to it. I can preview data and view oracle's columns name..., so it make me think that everything is fine. But when It execute the task it FAIL and notify logon error and that password can't be blank. Please help, I need read f ...Show All

• Visual Studio Express Editions C# Newb - XMLSerializing a List

  Hi, I'm pretty new to C# and am trying to write a class with data in it that i can save and load from an XML file, are there any built in Generic Containers/Collection, something like List or Stack that XML can serialize, my code is below, but whatever container i use i get an exception complaining about how it can't serialize the collection i am using (List) in this case. How do i have to go about serializing a collection of objects Is it something that can be done with a similar amoutn of code as below or am i dreaming namespace Test { public class ClassA { public List<ClassB> Events; public ClassA() { Events = new List<ClassB>(); Events.Add(new ClassB()); } #region Load/Save Code ...Show All

• Visual Studio Team System Renaming Build Types causing Workspace problems?

  I was just wondering if anyone else has run into this issue as well. I have been working on a new Build Type for one of our projects and finally had everything completed and running fine. Last night after several tests I went to the Source Control Explorer (using Team Foundation Server) and renamed the Build Type. I checked everything in and went home. This morning some initial <Exec tf.exe get operations were failing with the error: 'Unable to determine workspace." I couldn't figure it out and spent quite a bit of time investigating the issue to no avail, everything seemed to be fine, plus it was working last night with no changes besides the Build Type rename. I finally renamed the Build Type back to its orignal name and ever ...Show All

• Windows Forms Vertical scrollbars on multi-column listbox.

  I am developing an application with Visual Studio 2005, C# and SQL which will replace an ageing application we use in our office. My application requires a listbox with multiple columns which has a vertical scrollbar only. However, when working with the form designer, the moment the listbox is switched to multi-column mode, the form designer automatically switches to a listbox with horizontal scroll bars only. I am hoping to make my application so that horizontal scrollbars are not required by fixing the width of the columns I want. The listbox will show a list of SQL databases which the user can select. The additional columns are only to show various dates when the databases were extracted/updated. The reason for a listbox is be ...Show All

• Visual C# Pointer

  as far as me know, this statement MyClass o = new MyClass(); are actually create instance of [MyClass] in memory and [ o ] are not the instance but the pointer which point to memory. am me right My problem is : Dictionary<string,MyClass> myCollection = new Dictionary<string,MyClass>(); myCollection.Add("Object01",new MyClass()); // and somewhere else MyClass obj = myCollection["Object01"]; ok, here the problem, according to theory above, [ obj ] are also the pointer which point to the momery, when me :- myCollection.Remove("Object01"); the instance are still exist, because what me have remove/kill are only the pointer which point to the "real" instance, so the [obj] are still able t ...Show All

• Microsoft ISV Community Center Forums Validation with List drop down?

  Hi I want to add some simple validation to my Excel sheet but can not for the life of me remember how to do it! Basically i have a drop down list as in the image below and want so that when 'No' is selected, the user is forced to enter the reason in the next cell http://i102.photobucket.com/albums/m82/sc0ttb_2006/excel_list.jpg I can remember doing this before and used some VBA code but can not remember how i did it :( Please put me out of my misery! Thanks... Hi, Thanks so much for the info. I've had a look at it but to be honest i haven't a clue where to start! I'll have another look after Xmas and see if i can get it working... Thanks again ...Show All

• Windows Forms Moving back and forth between records in a DataView

  Hi, Here is the scenario I currently have: I have a DataGridView bound to a DataView containing a number of records (form1). When a user double clicks on a row it brings up a form (form2) containing details on the selected row. I have this part working without a problem. On form2 there are two buttons enabling the user to move back and forth through the records displayed in the DataGridView. I want to know if it is possible to move back and forth through the records in a DataView and if so how. I am using Visual Studio 2005 and C#. Thanks Any chance of a code example Thanks ...Show All

• SQL Server Page break after X items

  Is it possible to force a page break after a specified number of items in a table For instance, I have a name badge report but I'm running into a problem where some badges are sliced down the middle at page breaks when exporting to pdf or tiff.  If I could force a page break after every 2nd or 3rd badge it would alleviate that problem. Thanks in advance. Hi Nblankton thank you for the response, after I wrote the note I searched the forum and found this "=Ceiling(RowNumber(Nothing)/4)" you can put any number (2,5,20) it works, without having to add any code. Thank you for your help. adding a group to control the amount of record per page is a great idea. MQ ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Are they bugs?

  Hy! I'm trin' XNA since 1.0 was released, so I'm kind of newbe. The first thing, what I expected as a bug is that SynchronizeWithVerticalRetrace seems to do nothing. I use the base Windows Game project for test, and in the Initialize function I set some parameters: _graphics.GraphicsDevice.PresentationParameters.FullScreenRefreshRateInHz = 70; _graphics.SynchronizeWithVerticalRetrace = true; _graphics.IsFullScreen = true; But it do nothing. The problem is: I can turn on/off VSyns, but I can't handle the refreh rate! I set it to 60, then to 70, but in fullscreen, my application runs with 85Hz -> 85 FPS instead of 60 or 70. Addition to this, my app throw an error, and Express must be restarted... The second is with multi ...Show All