PsychUK's Q&A profile

• SQL Server Only show field on last page

  Hallo, i would like to show some fields only on the last page on the report. How can i achieve this (The field is in the body area) King regards, Christian Niehaves I'm understood it, but i have the report server project generated by wizard, and seems to me that i don't have VB or C# codebehind, only rdl file with xml syntax. How i can place current page number into the body of report Sorry for my English. Thank you. ...Show All

• Microsoft ISV Community Center Forums Get Excel Sheet Names

  Hi: I am trying to connect an Excel file and get all sheet names in the file. When using ADO.Net, the sheet names contain letters "$, or ' " around the sheet name, not getting the exact sheet name. I wonder why. I am also trying to get sheet names by using Excel as a Com object in VB.Net, like: myExcel =CreateObject("Excel.Application") myWorkBook=myExcel.WorkBook.Open("my Excel File") For i = 1 to myWorkBook.Sheets.Count     myTableName(i) = myWorkBook.Sheets.Item(i).ToString Next But the code does not work. Does anyone know how Thanks. jiao, please reply to this thread when you get a chance. I think it's important that you follow up for two reasons: 1.) If th ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Stuck at Tutorial

  I've been following the tutorial and I'm currently on 'Your First Game: Microsoft XNA Game Studio Express in 2D' and I was thinking about to move on to 'Step 5' but when I build my code there's a problem. * I have made a sprite and put it inside the project and that seems to be right so far. * The problem seem to be a line 24, public project(), as the program states: Class, struct or interface method must have a return type. Shall I add Void or, Return, or similar sign or do anyone have any idea, suggestions and possibly even, a solution, then I would be greatful to see what I've done wrong. Thanks, Here is the code: #region Using Statements using System; using System.Collections.Generic ...Show All

• SharePoint Products and Technologies SQLDataSource Trusted Connection blocked

  I'm attempting to migrate existing user controls to SharePoint 2007 web parts. So far, things are working out well except for the SQLDataSource. Apparently, SP 2007 replaces the standard SQLDataSource UI control at runtime with an SPSqlDataSource . This control doesn't allow Trusted Connection / Integrated Security attribs in connection string. Everything works fine when I switch to SQL authentication on the database (and store UID, PWD in connection string). It also works well if I create a class that inherits from SQLDataSource and then use that tag in the web part. I have some concerns about using this particular method, however. Is there a recommended method for having SqlDataSource in an SP 2007 Web Part (or are we not sup ...Show All

• .NET Development compact access 2007 database

  Does anyone knows how to compact an access 2007 database with .net The previous code with JRO.JetEngine is not working for 2007 format. We used that code for previouse db but not working for the latest one. I don't think ACEDAO.DLL will help you since CompactDatabase doesn't appear to support 2007 file format. And no you cannot legally distribute Microsoft Access application files. You're limited to installing the Access Database Engine package. ...Show All

• Visual C# Intellisense in properties

  Hai I am creating a property on a form . After creating the object for this  form  from a  new form and search for ths property . i got  " form.propertyname " as a descriptive text like the 1 which we can see in .NET . Now i want to show a detailed description of this propery  when i select this propery from the new form. ..How is this possible.. Help me please Thanks Ratheesh     I believe you maybe talking about the Xml markups or something to this effect - the description about the property/method correct if so simply enter 3 forward slashes together just before the property/method name: /// Example I have a method: public void DoSomething(string p ...Show All

• Visual Studio Team System FxCop 1.35: DoNotExposeGenericLists false negative?

  Consider the example below.  FxCop fires a DoNotExposeGenericLists warning for method GetFooCollection, which returns a FooCollection derived from List<T>. Should it not fire the same warning on the FooCollection declaration, i.e. if a publicly visible class derives from List<T> Especially since the fix is to modify FooCollection (derive from Collection<T> instead of List<T>). // No Fxcop warning here public sealed class FooCollection : List<Foo> {    ... implementation ... } ... public class MyClass {    // Fxcop warning DoNotExposeGenericLists here     public FooCollection GetFooCollection()     {         ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Change Log?

  Quick question please - is there any way I can find a log/list of changes from Beta 2 to final release Thanks... Indeed, bug fixes are helpful to know, though new features are the primary concerns (of which there are probably few, we think). ...Show All

• Visual FoxPro Created Menu with Menu Wizard - Now what?

  Hi, I'm a newbie Visual FoxPro 9 user and working on my first application. I used the Menu Wizard to create the desired pull down menus, but I'm not sure what to do with the Menu now Does the menu get associated with a prograrm or with a form What I want is to have a main window with this menu on it that is always displayed. When you select menu options I want pop-up windows to display with the various programs and forms in them. Any advise on what I need to do to get going in the right direction. Derek Thank you, these replies are a big help! The menu has been created as part of a project so following what has been said above should get me going. When I perform the DO mainmenu.mpr and then read the events, should I have the Do ma ...Show All

• Visual C++ how can I provide a static lib to a vc++ project

  One way which I know is Mention the lib file names in the project setting -> link -> library modules and provide the lib path in the Tools->Options->Directories->library files. Is there any other way to provide the lib's ...Show All

• Smart Device Development Packet Sniffer - Windows Mobile

  Greetings all, I have searched around various sources for information, and I thought I would post here to see if anyone may be able to assist.. I am a post grad student, and I have a need to develop an app for my research project, that has the ability to capture, inspect and display the header information from an IP packet, which is recieved through the 802.11 wireless interface of a mobile device (PDA/Smart Phone etc). I have searched for managed code examples on how to obtain packets from a Windows Mobile inbuilt library/managed code but have not found anything... I have looked at the OpenNETCF.org framework for leads on how to achieve this.. also without sucess at present... I have recently been pointed toward Layered Service ...Show All

• Visual Basic Button1_KeyUp

  Why it doesn't work when I quite hold of button1 Private Sub Button1_KeyUp( ByVal sender As Object , ByVal e As System.Windows.Forms.KeyEventArgs) Handles Button1.KeyUp MsgBox( "Button1 is up" ) End Sub Thanks Private Sub Button1_KeyUp ( ByVal sender As Object , ByVal e As System . Windows . Forms . KeyEventArgs ) Handles Button1 . KeyUp MessageBox . Show ( "Enter key just released Button 1" ) End Sub Private Sub Button1_MouseUp ( ByVal sender As Object , ByVal e As System . Windows . Forms . MouseEventArgs ) Handles Button1 . MouseUp MessageBox . Show ( "Mouse just released Button ...Show All

• SQL Server inerting/updating a collection of data values into SQL Server db all at once.

  I'd like to insert/update a collection of data values from VS2005 (C#) into sql server in one insert/update statement. For instance, I'd like to insert all values from a checkboxlist that are checked without having to perform an insert statement for each value. What's the best way to go about this thx.   MarilynJ wrote: I'd like to insert/update a collection of data values from VS2005 (C#) into sql server in one insert/update statement. For instance, I'd like to insert all values from a checkboxlist that are checked without having to perform an insert statement for each value. What's the best way to go about this thx. fill the dataset from data from sql server update on th ...Show All

• Visual C# Attenuating SoundPlayer Volume

  I use SoundPlayer to punctuate long file downloads and other processes and give me sound cues of the app state in broad sense. One problem I have now is that the volume is so loud that after a long pause it might frighten me a bit with some sounds. Manually adjusting volume in SoundPlayer 10 does not seem to help. I cannot get a hang of it although I tried numerous inroads. SendKeys.Send ( "VolumeDown" ); did not work. I tried to exploit Volume.exe: Set Volume Control Levels Using Visual Basic at http://support.microsoft.com/default.aspx scid=KB%3bEN-US%3bQ178456&%5d and another related sites to no avail so far. It may all boil down to controlling volume in MS kernel sound mixer or something, I do not know. Please, h ...Show All

• Windows Forms format 2 decimal places.

  Dear All, I would like to find out how can I can constraint my text box to accept 2 digits after my decimal point example is 2.89 and not 2.878958. Another thing is how can I ensure that when I use the function Convert .ToDouble(textBoxValue.Text) I must get in the format that I get only 2 digits after the decimal point just like 2.89 and not 2.878958. Thanks. Hi, When working in ASP.NET: use RegularExpressionValidator When you are working in WinForms, you can do 2 things: use a MakedTextBox disadvantage: you need to specify the number of numbers before the comma create a RegularExpressionValidator like the one in ASP.NET (see: http://www.codeproject.com/ ...Show All