display5's Q&A profile

• SQL Server SMO with SQLExpress

  Hello, I was wondering if it is possible to use the SMO API's to query a SQL Server express database. I created an auto.mdf; how do I set it so SMO queries that database, point to localhost\sqlexpress Thanks. This works for me. ServerConnection sc = new ServerConnection ( @".\SQLExpress" ); DMO. Server s = new DMO. Server (sc); System.Collections.Specialized. StringCollection dbPath = new System.Collections.Specialized. StringCollection (); dbPath.Add( @"C:\Temp\auto.mdf" ); s.AttachDatabase( "auto" , dbPath); ...Show All

• Visual Basic VB 6 to VS 2005 questions.

  Hi, I have a project A written in VB 6 and another project written in Visual Studio 2005 (VS2005). I would like to integrate them together: on an interface of project A, I hope to add a button. After I click this button, the start-up main interface in the project B can be shown. I know that it is very easy, if the project A is written and compiled using VS2005. We can use "Process.start("projectB.exe")" to open another process and let project B run. But how can I do that in VB6 Thanks a lot. VB6 uses the Shell() command: shell "ProejctB.exe" Be sure to specify the path if its n ...Show All

• Visual C# printing status question???

  With all the new features in .NET 2005, has anyone seen anything that might make getting print spooling status (or print status) easy I have to do printing to a local printer, via a local web service, and must manage the printer status but I'm not permitted to put up forms or make use of forms to "show" the user a status. Can anyone make any useful suggestions on how to manage a printer without visible forms I've not been around the windows platform long so writing unmanaged code to work with winspool.drv is quite foreign :-( Thanks! There's nothing built into the BCL that will let you deal with ...Show All

• SQL Server SQL Server roles & ASP.NET 2.0 Forms Authentication Roles

  Apologies if my post does not fit into this forum. I initially tried the SQL Server Data Access forum but I now think my question is more security related. Is it possible for a web user who has been successfully authenticated with forms authentication to be authorised to use a SQL Server 2000 role depending on a particular ASP.NET 2.0 role that they have been authorised to use I understand that that I can assign a SQL Server 2000 role to the ASPNET or NETWORK SERVICE account but this will grant access to anonymous web users to the database role. I can ensure that I only call stored procedures which access sensitive data in web pages that ...Show All

• SQL Server Bug in SQL Server 2005 ? - DATEADD function

  Hi When I execute the following , the expected result is 03/31/2006. However the result that you get is 2006-03-28 00:00:00.000 Select DATEADD ( MONTH , 1 , '02/28/2006' ) Is this something how the dateadd is supposed to behave or is this a bug in SQL Server 2005. Regards Imtiaz Hi Imtiaz, I can't actually see anything wrong here. Why would the expected result be 31 March 2006 That is not one month in the future, that is one month and x days. What you are trying for is a "End of Month" function... Cheers Rob ...Show All

• .NET Development Audio streaming in .NET C#/VB possible?

  Hi! Im trying to create a voice chat client and I'm wondering if anyone else has done this before in VB or C# If soo, could you please post some source code :) (I have the client-server solution running using a TCPListener but I have no clue how to send the sound) Regards Per This sounds like an audio capture and encoding question. I don't think this is the best place to ask this question as you already have the networking element working. As a side note, we are investigating the possibility of adding enhanced QoS support to the .Net Framework networking APIs ...Show All

• Windows Forms Default Font Size for Labels

  In VB.NET is there somewhere that the font size for all labels in a project can be set Thanks, Tony From a purely OO point of view, going with Form inheritance as Erik suggests is the way to go.  But that are so many issues with visual inheritance in the designer in the current version of VS.NET that I can't recommend it. That&n ...Show All

• Smart Device Development using ADO recordset in ADO.net

  Hi! i m still new to .net compact frmanework.... Can anyone tell me how to add reference for ADODB in .net compact framework I cant find it at the project->add reference for microsoft ActiveX Data Objects 2.7 library. Thanks in advance....... There's no support for ADODB/ADOCE in NETCF. Providers for SQL Mobile and SQL Server 2000/2005 are included with VS 2005, other might be available from 3rd parties. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Keep mouse inside window

  I'd like to prevent the user from putting their mouse outside the window. Because you target enemies with your mouse in my game, if there's an enemy close to the edge of the screen, there's a good chance the user will overshoot and click outside the window - thus defocusing the window, disrupting gameplay, and angering the user. Yes, I know. Full-screen applications never have this problem. But most of my program is already windowed (only the action sequences need the directX form, not the option menu, map screen, etc), and I'd prefer to keep it windowed. Obviously, if the user alt-tabs out of the window, the restriction on mouse movement ...Show All

• Visual FoxPro Trap F10 in the KeyPress()

  Is there any way I can trap for an F10 in a keypress event We have a legacy app which is using ON KEY LABEL to capture an F10 key press. I can't trap this in the KeyPress, I assume becasue it has the same key code as ALT which KeyPress can't cope with. Changing from F10 to another key is not an option :( One thing I can do is have a macro in effect to convert an F10 to something else and trap that in the KeyPress. Is there a nice way I can do this VFP8 SP1. Thanks, Craig. Hi Craig, In VFP 8 the one possibility is to use ON KEY LABEL to capture the key stroke and then use the KEYBOARD command to map i ...Show All

• Windows Forms Custom VS.NET Add-in

  Hi all, I am developing a custom VS.NET add-in and I want to be able to add a menu option to the context sensitive pop up menu when a user right clicks on a code file. I have no trouble adding items to the standard fixed menu's but am struggling with the pop up menus. Can anyone point me in the right direction Thanks, ...Show All

• .NET Development Type.GetTypeFromProgID vs. GetTypeFromCLSID

  Hi, I am using the above methods to remotely instantiate an object registered in COM+ without using a proxy on the client machine. I want to be able to connect to different servers, so that's why I'm not using a proxy. I noticed that the method GetTypeFromProgID doesn't work (generates an exception) if the server object (or its proxy) is not registered locally. Surprisingly, GetTypeFromCLSID works fine, which makes me believe that the first method only looks into the local registry to resolve the ProgID into a CLSID, and instantiates the remote object afterwards. I was wondering if this is meant to be like that or it could be a bug Am I ...Show All

• Visual Studio WebForm ReportViewer Drillthrough Datasource

  Hi, I am using VWD with the Report Viewer add-in. I am attempting to create a drillthrough report, but keep getting this error: A data source instance has not been supplied for the data source 'DataSet1_DataTable1'. I know you are supposed to handle it with the Drillthrough Event handler, but so far I have only been able to find example of this using .xml files. I created the dataset using a SQL2000 datasource. When I added the report to the designer it also added an 'ObejctDataSource1' object. The first report just shows a few fields from the datasource, and the drillthrough report show all the details. So both reports use the ...Show All

• Visual C# how to get the nonclient rectangle of the form?

  as in subject: how can i get the nonclient rectangle of my form You can use the Form.Bounds (inhireds from Control ) property to the the size and location of the form including its nonclient elemements. ...Show All

• Visual Basic how to open an MSAccess Object using .NET ????

  Hello there.. This is tony.. I'm an access developer and i'm learning .NET to migrate my appz.. I've got a question.. how can i open a MSAccess Form using VB.NET.. I mean i have an application in MSAccess, my idea is open the MSAccess (hidden) and thru vb.Net call its forms and reports to be opened... i think that i need to open the MSaccess Data base in a hidden way, and after that send a command to open a form. I'll really aprecciate any idea.. =) THANKS OOhh... what's the code to open an application i'm thinking on openning the MSAccess DB and send a parameter to a Function located in ...Show All