Surfsune's Q&A profile

• SQL Server Displaying selected parameters in a report

  Hi, In the report I'm working on, I want to display a list of the parameters selected by the user, as in: Selected Cars: Toyota Camry Ford Taurus Chevy Corvette Saturn Ion Note that these are selected items from a multi-value parameter. How can I go about doing this with Reporting Services 2005 In ASP.NET, I'd just use the parameter array as the datasource for a repeater/datagrid/gridview. Could I do something similar with SSRS I'd really like to use the format specified above, whether or not it is in a table; I really don't want to do the following: Selected Cars: Toyota Camry, Ford Taurus, Chevy Corvette, Saturn Ion. Thanks, Mark Okay, I figured out how to do this using the following expression: =Join( ...Show All

• SQL Server what is the best way to do this search?

  what is the best way to do this search I want a stored procedure which can serach in any of the filled form on my C# windows application. The textBoxes are: txtFileNo txtIDNumber txtContactNumber txtName txtBuilding txtBlock txtBox txtEmail I want SQL Server to search for any fiiled text, so if the user enterred txtName and txtEmail this it will onlt search for txtName and txtEmail. I know how to do this directly from the form but I want to perform this using stored procedure. If this is the SQL that was printed in @sql_string, your problem is: SELECT file_no, id_number, person_name FROM persons WHERE 1 = 1 AND id_number = @string_id_number ORDER BY person_name This should have been replaced with the actual i ...Show All

• SQL Server URGENT: Error Message: The user is not associated with a trusted SQL Server connection

  We have currently migrated our Reporting service Server to a new Domain. We also have renamed the server. Now when we go to reporting services we are getting this error message below The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help Login failed for user ''. The user is not associated with a trusted SQL Server connection. We believe we have added the new user account to everything, but we are missing something. Can someone tell me what to change when you convert a machine from one domain to another and rename it Thanks I had much more luck by using a sql login ...Show All

• Visual C++ Problem using #import with ADODB in VS2005

  I have a VS2003 project that I am migrating to VS2005. It currently compiles just fine under VS2003, but when I try to compile it under VS2005, I get a whole slew of C2327 errors. The root cause appears to be the different way that VS2005 handles nested classes. However, the code that the compiler is having a problem with is generated by VS itself as a result of a #import: #import "C:\Program Files\Common Files\System\ado\msado25.tlb" rename( "EOF" , "adoEOF" ) rename( "BOF" , "adoBOF" ) rename_namespace( "ADODB" ) An example of the error that I receive is: error C2327: 'ADODB::_ADO::Properties' : is not a type name, static, or enumerator Has anyone else encoun ...Show All

• Internet Explorer Development IE7 Title bar shows up in Chinese instead of my language

  Hello, Downloaded and installed: IE7-WindowsXP-x86-enu.exe OS: Windows XP Home (legal version) I had IE6 with SP2. I downloaded at first the IE7 RC1 but then I downloaded the file I mentionned above. With both RC1 and IE7-WindowsXP-x86-enu version I got the weird Chinese titles in my Blue Titlebar. The tab-titles tho are correct. I've uploaded a screenshot to be downloaded here . This screenshot gives you the view of my IE7 browser with the blue titlebar. My Language is Dutch and at the Tools - Internet Options - General tab I've set my appearance language at Dutch (screenshot here ). Could somebody please help me out I really really love to have my own language or the english titlebar instead of Chinese. Yours Sincerely ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Game State Class - Sharing Information

  I'm using the default XNA game template for the time being, as I'm not intimate with C# yet. I'm trying to set up a game state stack, using a class derived from the game class. The GameState class has UpdateMe and DrawMe functions that basically call protected methods Update and Draw in the Game part of the inherited class. I also have a gameState handler class that has a stack of GameState objects that it keeps track of, etc. If I use this encapsulated method of game states, how do I share information between game states. For instance, if I have a menu screen that shows character info, how do I share the character's stats between the main game state and the menu state. I figured using static class members was a bit crude, but I'm unsure o ...Show All

• SQL Server Loop Through Flat Files Based On A Date Range

  Hello, I currently have a For Each File container that loops through all files from a specific directory. The files have a naming convention that looks like this; CDNSC.CDNSC.SC00015.01012007 The last segment of the file name is the date of the data in the file (mmddyyyy). The create date for these files is always a day later than indicated in the file name. What I would like to do is to have more control over the 'range' of files that are looped through by using the date portion of the file name to define what group of files should be looped through. Ideally, I would like to have a 'StartDate' variable and an 'EndDate' variable that I could define at run time for the package, and the package would loop through all of the files ...Show All

• Software Development for Windows Vista Custom Activity Approach

  I am working on a custom activity that will provide the following functionality: 1) Allow user to enter a usercontrolurl as a property 2) Allow user to enter a resource/roll as a property 3) Execute invoke method and pass the above parameters 4) Execute event sink to wait for the user to complete the page I have finished 1-3, I am stuck on 4. How could I make my eventsink trigger based on a identifer that was sent to the host in step 3, instead of a predefined event that was defined in the interface service at design time Thanks in advance. Mardo Mardo, There isn't a way to dynamically choose which event will be listened for by the EventSink activity.  Why can't the control/form raise the event defined on the int ...Show All

• Windows Forms Form to form data passage.

  I have two forms. The first form, Form1 has a read only text box on it. The second form, Form2, has a editable text box on it. The user will click a button on Form1 that launches Form2. In Form2, the user will enter some data into the text box. They will then hit the "Apply" button that is on Form2. What I want to do is send the text of the editable text box on Form2 to the read only text box on Form1. I was wondering if there was a way to access the control itself from another form. Meaning: IN FORM2: Form1. textBox1 .Paste(this. textBox1 .Text); Where the text box in blue is the read only text box in Form1, and the green text box is the editable text box in Form2. The second method I was thinking of using was a way for Form1 t ...Show All

• Visual C# Special Assignement

  Hi guys, I have there variables setup like this, I would like in one line be able to assign OldID to ID and "1111" to OldID, is it possible ID = null OldID= "0000" ID = OldID = "1111" ; final result would be: ID = "0000" OldID = "1111" There is no language construct that would allow you to do this in one line. You could easily write a helper method to accomplish this, though. Are you expecting this operation to be atomic (i.e. Multiple threads can call the helper method and you won't lose or duplicate IDs.) If so, you would need to use synchronization primitives like Monitor (aka C# lock) to ensure that it is thread-safe. ...Show All

• SQL Server Suggest me a simple and good tutorial for T-SQL

  Hi, Can someone suggest me a simple and nice tutorial that can explain T-SQL with examples. Plizzz.... Regards.., Aazad hi i think below links are good: http://www.mssqlserver.com/tsql/ http://www.trainingbyemail.com/SQL/TSQL.aspx http://msdn.microsoft.com/library/default.asp url=/library/en-us/tsqlref/ts_tsqlcon_6lyk.asp if you need more info please say to me. good luck ...Show All

• Smart Device Development Which event fires when Ok button is clicked?

  Hi, Does any one know what event is raised when i click on the close( i.e. OK) button of a form in a PPC application My app needs to perform different actions based on the way the form is closed. Basically, a form can be closed in 2 ways. First, by hitting the Ok button. Second, by calling form.Close() programmatically. In both the cases 'closing' and 'closed' events are raised. So i can't use any of these. What event fires when Ok is clicked, and how to handle it Thanks. - Hari Hi Alex, I've a problem in using Closing event. Actually in the app, I've a mainMenuitem "LogoffAllSessions" which when clicked sh ...Show All

• .NET Development retrieving Active Directory properties via web service problem

  Hi I'm trying retrieve the description property in ActiveDirectory of a userID via a web service method. When I run the web service the retrieved string comes out as " System.DirectoryServices.ResultPropertyValueCollection" instead of the description value of the UserID.. Does it have something to do with the directory searcher class Please see my code... Thanks in advance in my Service.cs file>>>> [ WebMethod (Description = "This web method spits out data from AD" )] public string GetAllUserData( string UserID) { string path = "LDAP://" + ConfigurationManager .AppSettings.Get( "ADServer" ) + "/OU=USERS,OU=IT,DC=someorg,DC=com" ; string aduser = ConfigurationManager .AppSe ...Show All

• .NET Development NullReferenceException vs. invalid address

  Hi, The ECMA Standard states "The results of all CIL instructions that return addresses (e.g., ldloca and ldarga) are safely aligned." Now, let us assume that I have a local variable V whose declared type is a (managed) pointer type. Moreover, let us assume that V has not been initialized. In other words, that would mean that V carries an arbitrary address. Depending on the target architecture, this address might be unaligned, i.e., invalid! If I now use the instruction "ldloc V" to load V's value, I will practically push onto the stack that arbitrary address carried by V, right That arbitrary address is regarded as V's value. An attempt to use that address with "ldind" or "stind" can throw a Null ...Show All

• Visual Studio Installation Error.

  Can't this company make software that just installs as it should Why am I getting the founding error when installing the trail version of Visual Studio Pro 2005 Error 1406. Could not write value to key \Software\Classes\.xsd\OpenWithList\devenv.exe. Verify that you have sufficient access to that key, or contact your support personnel. All other programs WERE closed and my anti-virus WAS disabled Mike I doubt it is a corrupted account. It's probably worth uninstalling, re-booting and installing again, though knowing Microsoft I'll probably still get the error. Isn't crazy that you have to BUY the product to get it to work Thanks Bill! :( I'll get back to you on the res ...Show All