OOMama's Q&A profile

• SQL Server Mon- Fri Bit fields Query

  I am having trouble figuring out how to complete this any help is appreiciated. I have Mon , Tues , Weds , Thurs , Fri as bit fields I need to write a query for a report to see if the value is true, and display M , T , W , Th , F in a column Days if they are scheduled that day example: Mon and Wed I got on the bus the checkboxes are set to True, I want one column in the report Days : to display M, W That is exactly what mastros' code does: Replace(RTrim( Case When Mon = 1 Then 'M ' Else '' End + Case When Tues = 1 Then 'T ' Else '' End + Case When Wed = 1 Then 'W ' Else '' End + Case When Thur = 1 Then 'TH ' Else '' End + Case When Fri = 1 Then 'F ' Else '' End) , ' ', ',') As Da ...Show All

• Visual Basic Add columns from different tables in SQL to a datagridview to show info via SQL Query including joint statement.

  The problem I have is the following: I need to have a datagridview in which I can add columns from different tables in my database (SQL), not only from one table. The idea is that I want to make a query in which I use a joint statement to obtain from certain table that has an idnumber, the name of this id number which is obtain from another table. And all of this I need to be presented elegantly in the datagridview, in which I present columns from the first table and columns from the second table, thanks that I have made the joint in the query. I have read a lot and still I haven’t found what I’m looking for. I’m using Visual Studio 2005 (need and answer in visual basic form not in C#). Thanks people in advance ...Show All

• .NET Development how to detect parameter values passed to method

  i want to log the method's name and the list of parameters along with there values. Retrieving the name and names, position of parameters is easy, but can someone help me out in finding values to these parameters whenever an exception occurs, i do the following Dim paramInfo() As System.Reflection.ParameterInfo = ex.TargetSite.GetParameters() Dim i As Integer = 0 For i = 0 To paramInfo.Length - 1 Response.Write("Parameter " & i + 1 & " Name : " & paramInfo(i).Name & "<br><br>") Response.Write("Parameter " & i + 1 & "Type : " & paramInfo(i).ParameterType.ToString & "<br><br>&q ...Show All

• Visual Studio Sandcastle - XML Commnet Tags and their properties

  Anand, Would it be possible, for the FEB CTP, to get a document that has listing of all the different XML comment tags and their properties or better yet - a "Hello World" solution. I have searched everywhere trying to find this but I have come up empty handed and my MSDN documentation has an incomplete list. Thank you, Noral For Feb CTP I will improve the test.cs included as a part of Examples/Sandcastle folder with tags to address the "Hello World" situation. Hope this will help you. Also have you visited Anson Horton's blog at http://blogs.msdn.com/ansonh/archive/2006/09/11/750056.aspx#750968 . In this blog he hasa word document with detailed description on tag refe ...Show All

• Visual C# How do I create and use C# DLLs?

  Hello all, I am trying to create my first C# DLL and I am having some difficulty. This DLL will house some common authentication functions. I will need to use the DLL functions on the front of many different C#.NET web applications. I do understand the basic concept of DLLs and thought I could just jump in and create one. So I created my DLL, added my functions, and referenced the DLL in a test web page. But when I tried to access the functions in the test app there were no functions available in the namespace. So I clearly did not create the DLL correctly. I am looking for a tutorial or a step-by-step example that I can follow. Thank you in advance for any help/references you can supply, Chris ...Show All

• Community Chat web server... on a USB flash drive!

  check this little baby out! i just did a series of test drives on a freeware web server at purplenova.com ... and managed to host files from my Sandisk Cruzer Micro! and get this... i moved the flash drive from home to office... and the same URLs i'd set earlier worked... but the less i talk, the better it is... see for yourself ...Show All

• Visual Basic Help with Windows API for a button

  Ok, so i have the handle of the button i want to press on another applications window. I have managed to call BM_Click and it clicks the button. But is there a way to send a message to that button so it just excutes its code Instead of seeing the button actually click I am not sure if this is what you are wanting to do, but this code is an example of how to make one control, run a second control: Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Button1.PerformClick() End Sub ...Show All

• Windows Live Developer Forums MSN Video Conversation

  Which audio codec uses MSN during a video conversation. If it is a standard codec what is its waveformat code. Where can I find the codec. At last check it is a proprietary codec based on some Logitech IP and has been reverse engineered... however due to the legal issues of linking to such a thing you’ll have to find it on your own I am afraid. ...Show All

• Windows Forms Making a typed resource file public

  Hi! I made this question before during the beta period but I'm coming back just in case something changed after the final release of vs2005. Is there any way for a typed resources class to be generated as public so that they are accessible by other projects expect the project containing it. The ResXFileCodeGenerator custom tool generates this class as friend. The only work around I found is to clear the custom tool property from the resource file to executer the resgen.exe manually. Isn't there any other more elegant way Hi, I have fixed the tool, it should be working fine in VB.Net projects by now. Please let me know if it's still broken. Sorry for the trouble. Gokhan gokhan (AT_SIGN) altinoren (DOT) com ...Show All

• Visual Studio Team System How to modify email template sent via Project Alerts

  I want to be able to modify the email template that states that a build was successful or not that is sent via Project Alerts Specifically, I want to be able to add a link to a report that is run via the daily. Can I do this Where can I find the template and how do I modify it Thanks, Staffan This worked me : I added this to : BuildCompletionEvent.xsl found in C:\Program Files\Microsoft Visual Studio 2005 Team Foundation Server\Web Services\Services\v1.0\Transforms Code added: <tr> <td>Daily Changes Report:</td> <td> <a href=" file://\\dalweb01\MSS_DROP\Reports">Change Sets</a> </t ...Show All

• SQL Server UsedInQuery working in 2005 RDL?

  When supporting interactive grouping in reports using an execution snapshot, In 2000 I used: <UsedInQuery>False</UsedInQuery>  in the RDL below the appopriate Report Paramater names as well as using stored procedure based reports with Prompts set to certain paramaters. These prompted parameters would still show up after an excecution snapshot was run with default parameters. The UsedInQuery was just used to determine if it would rerun vs database or not.   I'm trying to do the same in 2005 but can't seem to get it to work anymore. Per books online: "The UsedInQuery element must contain one of the following string values: True False Auto You use the UsedInQuery to determine whether q ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. TargetElapsedTime and Animated Sprites

  So I'm looking at the help on Animate a Sprite. It suggests using TargetElapsedTime to set the rate the animation frames play back. Say I have an explosion that is 6 frames and I want them to play back at 4 fps. Well if I set TargetElapsedTime that slows the entire game world down to 4 fps. How do I go about keeping the Game running at the default of 60 fps but my animation running at 4 fps The obvious way is to roll your own solution using elapsed time in the update but then why does the tutorial want you to use TargetElapsedTime I keep feeling like I'm missing something obvious. Thanks for any help. I'm working on a 2D shooter and I'm trying to use the above example to produce an animated explosion. I ...Show All

• Visual Studio Team System MSTest.exe gives a misleading error when running tests located on a remote share

  The short story: Running MSTest.exe from the command line on a test computer returns "No tests to execute." Running MSTest.exe on my developer box executes all 63 tests. After poking this for a bit and trying to come up with why this wasn't working, I figured I would try copying my test assembly from the "network" location where it was sitting. Now, it worked just fine. It would've been more helpful if the error message was something like, "No tests to execute. Are you running from an unsafe location " Thanks! Rory Hello Rory, We really appreciate your feedback... we are working on providing a much better user experience on these kinds of scenarios, and feedback like yours will definite ...Show All

• .NET Development using List<Predicate<T>> add and remove items ?

  Hi I'm trying to use a List of Predicate<T> predicates to filter a list dynamically (a custom BindingListView implementation) Now I can add predicates to the list just fine. but removing them poses a problem. The list does not seem to recognize a predicate when I ask to remove it. For example: // Define the List List<Predicate<Someclass>> l = new List<Predicate<SomeClass>>(); // Define the Predicate Predicate<Someclass> p = new Predicate<Someclass>(function); // Add the predicate to the list l.Add(p); // Remove the predicate from the list l.Remove(p); And it is in this last statement my problem resides. Even tho the predicate is identical (it is the same function pointer) the l ...Show All

• Visual Studio sql express server . cannot process stored procedure

  sql express server . cannot process stored procedure from the management studio ...Show All