richard22's Q&A profile

• SQL Server Problem Attaching a database

  I've created a simple database using Visual Web Developer Express. I is located in "C:\Documents and Settings\Roman\My Documents\Visual Studio 2005\WebSites\NewSite\App_Data" Folder. When I try to attach this database using SQL SERVER Management Studio Express: it doesn't allow me to view the contents of "C:\Documents and Settings\Roman" Folder - it just won't expand any further!!!!! Anyone had a similar problem. I think it is some sort of a bug, maybe Please help! Thanx Michael Hi Michael, This is expected behavior. SQL Express runs as Network Service, which is a li ...Show All

• SQL Server SQL Server 2000 Personal Edition or Enterprise Edition

  I am trying to access SQL Server from a seperate VMWare session. I have instsalled SQL Server 2000 Personal Edition on my main PC and am trying to access it from a seperate VMWare session. When I do this, I get the following message: Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. I have checked my Enterprise Manager and is is setup with SQL Server and Windows authentication. Am I able to do this with the Personal Edition of SQL Server 2000, or do I need to either install the Personal Edition on my WMWare session or use the Enterprise version of SQL Server 2000 on my PC ...Show All

• Visual Studio Express Editions Package and Deployment problem

  Dear Guys,     I am a new VB Programmer. I have developed a saimple database application using some activeX controls. Now I want to distribute my application to some of clients or friends who don't have Visual Basic or other activeX control files are not installed. So I went through Package and Deployment tool and Build a setup file for installation. I am using Windows Xp platform to package the application. Now when I run the setup file on my friends computer on which windows 98 is installed it doesn't. I says "Some of the files on your system are outdated. You need to restart to update the files. Do you want to restart the c ...Show All

• Software Development for Windows Vista HandleExternalEvent: event filter / correlation

  Hello folks, I am new to WF and I am completely baffled by correlation. What I am trying to do is very simple: I have a State workflow activated by a single event from my local service with a parameter in the event args to do the disambiguation. The HandleExternalEvent activities knows those values at design time, but not at compile time. What I wanted to do initially, and what is my preferred solution, is to derive a new class from HandleExternalEventActivity, add a design-time property that will match the eventarg and filter the events for events matching the property. The problem with this approach is that HandleExternalEventActivity's vi ...Show All

• Visual Studio 2008 (Pre-release) Is there a possibility to increase the SqlCommand execution timeout?

  Hello! Is there a possibility to increase the SqlCommand execution timeout Best regards, Henrik Dahl The SqlCommand object is some low level internally held object, so how do you mean its timeout property should be set Best regards, Henrik Dahl ...Show All

• Windows Forms How can I stop page tracking after it finished printing?

  Hello, I want to Stop my printer after it finished printing. But when printing of a page finished (even it contains only one line), the printer ejectes the page. I want to have control on tracking pages. What should I do VB or VB.Net solutions are better for me. Thank you I believe all you have to do is set the property of the  ...Show All

• Windows Forms scrolling message

  Hi All, I have been tasked with adding a scrolling message at the bottom of an application.  Apparently, management wants to pass information to it's associates with this 'ticker tape'.  I think it's a distracting annoyance and hey, what ever happened to 'face to face' contact !  Anyway, I digress. I guess I will have to use GDI+, but I was wonder ...Show All

• Visual Basic Screensavers in forms..

  Hi everyone,                      I want to know how to show screensavers in a windows form & also want to change the the windows color schemes and themes from my application.Please help me I need this (quickly) for my academic project.                                                    &n ...Show All

• SQL Server UDAs with .NET

  I have a question about why I would want to do this. Some examples say to create some mathematical aggregations and use stuff like STDDEV, but isn't that part of SQL . Are there other math functions I guess aren't part of the SQL standard in the rich .NET framework. My other question is how does the optimizer know to route a query to this aggregate Or is it there for the application to be told to get there. When would you recommend a UDA vs an Indexed View thanks. Sure, how about trimmed mean (same as AVG, but disregards the highest and lowest values in order to reduce the probability ...Show All

• SQL Server How Can I Do This Better in SQL 2005?

  I have two tables, one contains ids(very small, less than 100) and the other contains history(very large, over 1000 mil); table a (id int) table b (id int, contact_datetime datetime, id2 int, id3 int) I need to pull latest contact date and other id fields from table b fastest possible. in 2000, I did following sql query, select a.id, b.contact_datetime, b.id2, b.id3 from table a inner join table b on b.id = a.id where b.contact_datetime = (select max(contact_datetime) from table b where id = b.id) Do you have any better ways to do this in 2005 That is probably the best way without modifying any code (assuming ...Show All

• Visual Basic VB.net 2003, Access the registry SymbolicName for a flash drive

  Does anybody know if it is possible for me to Access the windows registry, specifically the driver for a flash drives decription in the registry...I need to be able to read the SymbolicName information for all the flash drive drivers in windows... Anybody have any sample code... Thanks... ...Show All

• .NET Development Calling a method and getting that method from xml

  I am not sure if this is even possible but here goes... I have a program that uses databases. I have made it so if I need to change the type of database I can go in to my Data Access Layer, make the changes and thats it. My only problem is, within the code for the program, there are calls to methods within that DAL whos names could possibly change. Is it possible for me to store the name for that method in XML them call that method. That way, if I make changes to the DAL, I could just update the XML with the new method names and no need to enter the program code and recompile. Does that make sense Basically I am trying to do this: str ...Show All

• Visual Studio ReportViewer bug over SSL / HTTPS

  Hello, Recently I was testing the new ReportViewer Control and found some behaviour of which I think it's a bug. I developed my asp.net 2.0 application using the asp.net development server. I configured a Web User Control containing a ReportViewer. Everything worked until I wanted to publish the web site. I had an exception. The problem is mentioned in several threads, including this one: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=232869&SiteID=1 Prior to using the control I had to install the ReportViewer located here: http://www.microsoft.com/downloads/details.aspx FamilyID=8A166CAC-758D-45C8-B637-DD7726E61367&d ...Show All

• Software Development for Windows Vista Confusing statement in MSDN article on WWF

  In this month's MSDN magazine article on WWF by Don Box and Dharma Shukla  there is the following paragraph: " Despite the inherently asynchronous nature of the runtime/activity contract, the runtime will never make concurrent calls to a given activity. Rather, any given activity is guaranteed to have at most one method invocation executing at a given instant. This vastly simplifies the task of writing activities in languages like C# or Visual Basic. " Is this per workflow instance, or per activity period   For example, let's say I have a sequential workflow that has a sequence activity that contains two code activities.  ...Show All

• Windows Forms name of selected listbox item

  I've tried about everything without success. It seems like such a simple question, but msdn doesn;t provide an answer. Neither did a search here. If I have selected an item in a databound listbox, and the item says 'Strategic Commentary', how do I capture that I tried any number of things, including Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim instance As String = listConcepts0.SelectedItem.ToString() MsgBox(instance) End Sub but the answer I get is system.data.datarowview Any help out there dennist685 Dim str As String = Yo ...Show All