Cputans's Q&A profile

• SQL Server Primary versus unique keys

  Hi What impact is there in using a unique index instead of a primary key How does this impact performance How does this impact data file size Does it impact anything else Thanks Hi, http://www.mssqlcity.com/FAQ/General/primary_vs_unique_constraints.htm HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Express Editions Best Control To Use For Text/Graphics page that will be printed

  Sorry for all the questions, I am new to VB and having trouble finding satisfactory answers to some questions. The application I am making is going to generate a contract to be printed. The contract will contain dynamic text from a setup form, fixed text and some graphics (like a company logo). Should I Create a windows form and add the images and various text to that and then print the business area of that form One problem I have is that I don't know ahead of time the exact length of some of the text...it will fit on one page, but the length of some sections will vary and I'd like to avoid large gaps between the text. I've been ...Show All

• Software Development for Windows Vista Saving Activities with a specific Formatter

  This question is a little related to another I posted about resolving assemblies. If I implement a custom persistence service that -- in an operation to save a workflow instance -- calls rootActivity.Save(myStream, myFormatter), I typically get an exception that my type (Workflow1) is not marked [Serializable]. If I go into the code editor and add the [Serializable] tag, the system throws an exception saying that my type's base class, SequentialWorkflowActivity, is not marked serializable. I tried this with the standard .NET BinaryFormatter and SoapFormatters as well as a custom formatter. Is this by any chance just a bug The real iss ...Show All

• SQL Server "Transaction Manager not Available" error using July 2005 CTP

  I am having problems when I enable transactions on a container and run my SSIS package on a workstation (as opposed to running it directly on the SQL Server). I have created a simple package consisting of four tasks 1. "Execute SQL Task" to truncate records from two tables (dimTime and dimCommodity) 2. "Sequence Container Task" containing two tasks   a. "Execute SQL Task" to run stored procedure that generates data for dimTime   b. "Data Flow Task" with an OLEDB Source and Target to populate dimCommodity The source and destination databases both reside on a single server (DBSRV) running SQL Server 2005 July CTP. The server is ...Show All

• SQL Server That assembly does not allow partially trusted callers.

  I have a report that references a custom assembly. The assembly loads an xml file from a web site in the code OnInit. The reports designer the code runs fine, because it is called with full trust. I deployed the report to our test sever, and copied the two dll files to c:\Program File\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportService\bin. I have added the following to the rssrvpolicy file. < PermissionSet class = " NamedPermissionSet " version = " 1 " Name = " LexLibrary " Description = " Used by reports to access the Lex Library " > < IPermission c ...Show All

• Smart Device Development Devices! (USB)

  Hi. Just a random question. In WM5 .NET CF 2.0, is there a way to detect on insertion of a USB device on the smartphone If you can, then how can I get the "responses" from the USB device into my application So if I start up my application, the application wants to know if there is a USB device connected, if there is, it will continue. Then with any commands/signals sent through the physical wire, I want the application to be able to get the responses sent. Possible I know it's a long shot and would probably require low level stuff, but thought perhaps there would be a .NET 2.0 way of doing this, or even through the ...Show All

• Windows Live Developer Forums Clarification

  So if i'm right, Microsoft is releasing MSN Messenger Activity API's for the protocol Good, in a way, but will Microsoft change they're licence to allow us to create applications (such as MSN Messenger Robots and 3rd Party MSN Messenger Clients) that will connect to the .NET Messenger Network , because if not, then this is really just for refrence.... Well I think encryption would be fine, given that translation is an example in the documentation.  Photo Sharing is probably out of the question -if- it works like the current Photo Swap (aka, some sort of flickr viewer/sharer would probably be fine -- ...Show All

• Software Development for Windows Vista How to make a StateMachine which show the terminal user to see the status of Squence workflow

  In my case, the second step is from a main table to entry a sub table, however, the main table page does not close. The system can keep this page and reentry into sub table by different option. (It means that, my workflow can go back last state). I think the we should use StateWorkflow to achieve the functionality. However, there a problem. I wish the follow a simple order processing which always from main table to entry the sub table, to show the contain to terminal user.(It's just a simple sequence workflow). How can I achieve the interface layout The scenario is that there are three pages(A,B,C) makes workflow A->B->C (a simp ...Show All

• Smart Device Development Auto-generated Code

  Hey everyone, I have a VB2005 project with a SQL Mobile database. The database is rather large. I've created parameterized queries to load grids and selected the grid task to Generate Data Forms. I delete the New menu option and the editable form. I am just using the detail form that opens when a record in the grid is selected. My problem is that when I click on a record on the main grid during testing, it takes an extremely long time to open the detail form and populate the labels from the corresponding fields. When I originally did this in VB2003, I hand coded everything, and the searching and loading was much, much faster. I ...Show All

• .NET Development Is "Visual Studio" the only tool that generates typed DataSet?

  Hi, I am looking for some alternatives for Typed DataSet generation. Do I have options other than VS2005 IDE for generating Typed DataSets Thank you, Alan Better question is HOW to make own data access or business object generator like MSDataSetGenerator. Any advice would be pleasant. ...Show All

• Windows Forms switch between design-time mode and run-time mode

  Hi all, I'm doing a windows form designer project.  Right now I have the design-time mode made, namely, I can use the project to create different form designs at design time.  My problem is that I need to be able to switch between design-time mode and run-time mode.  Say, when the project is in design-time mode, the user can changes properties of controls in design mode, and when it's in run-time mode, the user can enter data to the controls.  Any idea how to do it   When I switch to the run-time mode, do I have to recreate an instance for each of the controls, and set it's properties as well   Or there's a ...Show All

• Visual Basic Remote Process execution in VB.Net

  hi there, can any one know how to execute a process or applicayion in the remote machine.. reply pls urgent The technology you could use is something called .NET remoting. This requires you to write a client server parts. You client application will call the server and the server will do something. A simple web search with .NET remoting will bring you a wealth of article on its use with examples. As its a rather big topic and one which will generate probably many questions you should read up on it and then try some examples and ask questions on any problems you cant find answers to. To try and answer all about this ...Show All

• Visual Basic sql delete statement to change two tables

  Hi im trying to delete data from one table if it exists in another i have this code but it deletes all data from server table please help DELETE FROM Server WHERE EXISTS (SELECT [Product 1], [Product 2], [Product 3], [Product 4], [Product 5], [Product 6], [Product 7], [Product 8], [Product 9], [Product 10], [Product 11], [Product 12], [Product 13], [Product 14], [Product 15], [Product 16], [Product 17], [Product 18], [Product 19], [Product 20], [Product 21], [Product 22], [Product 23], [Product 24], [Product 25], [Product 26], [Product 27], [Product 28], [Product 29] ...Show All

• Visual Studio Express Editions Recent Projects

  Just a minor question, how do i empty out the Recent projects list is there a way to do this Delete File1, File2, File3, etc. values from the following key using regedit: My Computer\HKEY_USERS\ systemspecificvalue \Software\Microsoft\VisualStudio\8.0\ProjectMRUList Note that systemspecificvalue will be an identifier of your system.  You can find this location easily by launching regedit and then do a Find for "\Software\VisualStudio\8.0\ProjectMRUList". I believe Microsoft should make this a clearable field from the GUI though. A>AM ...Show All

• SQL Server publishing downloading report model

  Hi friends is it possible download a report model (.smdl) from a report server and also how to publish a report model i know how to do this from report manager page but i need to do this programmatically (from C#). any ideas please. Thanks. publish model using SOAP method CreateModel , then bind it to a data source using SetItemDataSources ...Show All