Kea's Q&A profile

• Visual Basic Login via Access Database help

  Hi, I recently got VB 2005 and really like the new features. However, I am on an intermediate level learning Visual Basic. For a test project, I plan to create a login form that validates users through an access database located on a server. Basically, there is a set username and password in the access database and I want my program to execute the main program once the user is validated via the database. I was struggling on this for about a week, but I have no idea on how to do it. I can arrange the controls on my form, but I just need to know how to validate the users. Any ideas Hi, I had to write my code differently than the ones above because errors would appear in VB2005, but mine seems ...Show All

• Visual Studio View .rpt on .NET client without client install?

  Is this possible at all We'd love to find a way for our app to utilize the CR .NET viewer by utilizing external references to the CR assemblies. Does anyone know of a way to achieve this We, of course, can use the merge module to create a client install but running such an install on all our clients simply isn't an option. We have a number of 3rd party assemblies that we've been able to utilize without a client install through the use of external references but it doesn't appear the CR assemblies will operate in that fashion. Any input you can provide would be greatly appreciated. I do not believe this is possible, mainly because most of their assemblies are just wrappers around com dll's which are setup i ...Show All

• Visual Studio Team System How to copy files to a fixed drop location

  Currently, I can successfully drop the build files in a drop location, but I've been asked to put them in a specific folder for testers as well. Currently, every copy goes in a specially named folder including the build type name, the date and a sequential #. Is there a property I can reference to find the location of the freshly built files Something along the lines of this Thanks! Mike ... </ ItemGroup > < Target Name = " CopyFilesToStageMachine " > < Message Text = " Copying files for Testers... " /> < Copy SourceFiles = " @(BinDirectory) " DestinationFolder = " \\MyTestBox\Program Files\MyCompany\ProjectX " /> </ T ...Show All

• Visual C# Best external data storing

  Good day, I'm almost not experienced with C#, and lately I have been doing the Absolute Beginners Tutorial with the RSS Reader thing ( url ). Anyway, the person who made these video's prefered Microsoft SQL Server Database File to store the data, which is indeed very handy to use. But after finishing my RSS Reader I found out no one else could use it simply because they don't have an SQL server running. I was quite surprised because I didn't even know there was one running on my PC, it seems VS did that all in the background. Actually it's quite stupid I didn't think of this earlier. :p Now my question is, what's actually the most regular way to store a database withouth having to run an SQL server in the background I could of course use f ...Show All

• SQL Server SSRS and Teradata

  Is anyone out there using SSRS with a Teradata data source R Ron, A couple of things. First off, thanks for the dynamic string. The above code does work for me in VS Designer when I select the 'All' option. Are you running SQL Server SP2 like I am Second, I talked to some of the MS folks at Tech Ed earlier this year. The execute immediately is by design. At that time they recommended we create our own website that wraps the report viewer instead of the default report manager. We were not thrilled with that answer. In short, you are out of luck. Have you run into any other issues with respect to access TD from MSRS I seem to be a few steps behind you which is making my life a little easier ...Show All

• Visual Studio 2008 (Pre-release) ListBox items filling entire width

  How do I make the contents of a listbox item fill the entire width of the listbox I want to build a UI that places some text on the left and a button always on the far right of the listbox. I can't make the container of the text and button stretch right across the listbox to enable this. Have I missed something simple Thanks in advance. Try setting HorizontalContentAlignment="Stretch" on the listbox. For example: <Page xmlns=" http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x=" http://schemas.microsoft.com/winfx/2006/xaml " xmlns:sys="clr-namespace:System;assembly=mscorlib"> <ListBox HorizontalContentAlignment="Stret ...Show All

• Visual Studio Document Activate Event, and TextSelection (ActiveDocument Text)

  I am writing an addin for Javascript files - a dropdown similar to what you see when you open up a .cs file - with a list of all member variables and functions. I have a solution that works, but its got a couple hacks that I would like to know if there is a better way to solve: 1) To get the text of the currently active document, I do this: int currentLine = textSelection.CurrentLine; textSelection.SelectAll(); _Code = textSelection.Text; textSelection.GotoLine(currentLine, false ); while this works great, it causes the screen to flicker on the select all, and the scroll is lost when I go back to the line I was on . Is there a better way to get the text of the active document 2) Is there a way for me to know that ...Show All

• Visual Studio 2008 (Pre-release) Using routed events

  Hi! I was really looking forward to the routed events mechanism. But is it possible to use routed events from classes which don't derive from UIElement If so, how Because AddHandler and RemoveHandler are methods of the type UIElement... Thanks! Thanks. Actually, what I ended up doing was to emulate the pieces of the event system that I needed. I wrote my own LogicalTreeNode object (couldn't think of a better generic name), RoutedEventArgs, RoutedEvent and RoutedEventHandlerInfo. The behavior is a tad different in some regards and it's not directly usable from WPF, but it does provide similar logical tree functionality. Let me know if anyone wants to see the code, though it's not all tha ...Show All

• Commerce Server BizTalk/CS2007 Nant deployment

  Hi there, I am currently trying to Automate our deployment of our Biztalk/CS2007 using nant. However i have come unstuck when trying to import the previously saved bindings file. When the bindings file is exported the password used in the CS2007 adapters gets obfuscated. Therefore when we import the bindings we have to manually reset the password. Does anybody have any idea how to persist the correct password in the exported bindings file Cheers Glyn Hey Glyn, Unfortunately, you are going to have to manually set the correct password after you import the bindings. Due to security reasons, you are not going to get the password in clear text in the bindings files, from our adapters. Hope this helps a ...Show All

• Software Development for Windows Vista Superimposing of text on moving video in DirectShow

  Hi All, I m novice to DirectShow application programming and this is my first project in my career.I have to make an application which plays a movie file and superimposes the text upon it.Can i have the sample code please for reference. In this project i m able to run the movie file by using the sample code given in MSDN, after that i dont have any idea to how to display text.please help me Asap. Thanks for your time JD Prasad I'm coding in C#, so this is of interest to me. I would really appreciate seeing a code sample to use SampleGrabber and GDI methods to overlay formatted text on running video. Thanks for any help ...Show All

• Visual C# Round to 2 decimal places

  Hi all, I had a formula as follow : Count/TotalCount *100; // in percent whereby count is an integer and TotalCount is a double. My result is also a double. How can I convert the result to 2 decimal places Thanks Int32 Count = 10; Double TotalCount = 7; Double Output = Count / TotalCount * 100; // Math.Round(value, decimals) Console.WriteLine(Math.Round(Output, 2).ToString()); ...Show All

• .NET Development SourceTable and SourceField

  Hi I'm upgrading my code based on DAO to ADO.NET in VB2005 and got stuck looking for SourceTable and SourceField properties of DataTable fields. DAO.Recordset.Fields have .SourceTable and .SourceField properties which tell you the original table/field which provides the data in that particular field of the recordset. This is useful in my application where I am filtering users' queries to the database to see whether I want to allow them access to that particular bit of data.  Although I can imagine that there are maybe other solutions to security issues, I've already built a whole system around this method, and would like for simplicity's sake just upgrade it without changing the methodology. Can anyone advise where to g ...Show All

• Visual Studio Express Editions Changing Background?

  Is there a code that lets you change your desktop background programmatically Microsoft Document on How to Use SystemParametersInfo API for Control Panel Settings http://support.microsoft.com/kb/97142/EN-US/ Showing how to chnage the wallpaper. ...Show All

• Windows Forms Web Services VS 2005 Calling to Populate DropDownList

  I am working with visual basic, web service, and VS 2005. Im trying to populate a drop down list with a web service. How do I do this Thanks, Sam Sure. Well lets make an example. Lets create a web method in the web service which will return us back an Array of numbers... Imports System.Web.Services Imports System.Web.Services.Protocols Imports System.ComponentModel <System.Web.Services.WebService( Namespace := "http://tempuri.org/" )> _ <System.Web.Services.WebServiceBinding(ConformsTo:=WsiProfiles.BasicProfile1_1)> _ <ToolboxItem( False )> _ Public Class Service1 Inherits System.Web.Services.WebService <WebMethod( ...Show All

• Software Development for Windows Vista "Tracking workflows which are already tracked" - Problem

  Following screnario: I have business objects of the type Order and OrderItem. For each of these a workflow is started. I use the SqlTrackingService, so running workflows get written to the db, and I am able to track them with the WorkflowMonitor (included in the Windows SDK I think). If such an Order- or OrderItemWofklow gets aborted or canceled the chance of restarting the workflow with the same objects is still present. The only problem is that the Guid of the started workflows was chosen by myself to be the same as the Order / OrderItems. But if a workflow gets aborted, or canceled, it is still in the tracking database. And when I restart the workflow for the same Order / OrderItem (which is possible by the design of the applic ...Show All