Rozee's Q&A profile

• .NET Development Query all Table Names in Access Database

  I would like to write a function which queries a list of all tables within a certain Access Database using the OleDB classes. This is what I'm trying so far (I found the big SQL select string online somewhere): Dim AccessDBConnection As New OleDb.OleDbConnection( "Provider= Microsoft.Jet.OLEDB.4.0;Data Source=c:\Northwind.mdb" ) AccessDBConnection.Open() Dim AccessDBAdapter As New OleDb.OleDbDataAdapter( "SELECT [Name] FROM MSysObjects WHERE Type=1 And Left([Name],1)<>'~' And Left([Name],4) <> 'MSys' Order By [Name]" , AccessDBConnection) Dim AccessDataSet As New DataSet() ' AccessDBAdapter.Fill(AccessDataSet) --- Unfortunately, I get this run-time error messa ...Show All

• Visual Studio Express Editions I'm an absolute beginner to programming and need some advice

  ^^^^^ I've been reading alot about vb and i'd like to know which program to buy. I've heard vb studio/express is the way to go. I just need something user friendly and compatible with all vb langauge, excluding C langauges. Any links to help me on my way would be appretiated. Btw Your forums could do with a "beginner's forum". Thank you for your help I thought about using vb.net express for its simplicity, but I wasn't sure if it could be used to correct flaws in other vb programs. You see I got interested in programming by playing games and using applications, and then my parents wanted me to fix some fitness software that they own. I've had to accelerate my learning pace to try to f ...Show All

• SQL Server Data Flow Task - Conditions to add value for a field.

  Hi: I have a data flow task in which i have multiple OLEDB sources going to a one OLEDB destination via UNION component. I also have a derived column component sitting behind the union, because there are some columns, which exist in the destination table, but are not coming from source, but I am responsible of providing values for those fields. The question is that some of those values are conditional, for eg. Lets say we have a column called RecStatusCode in the derived column component. The value for that column depends on a condition/criteria, so I need to query a db and based on the value of another field, I set the value of the recstatus code. How do i accomplish that I am thinking expressions, but I need clear direction in steps i ...Show All

• Windows Forms about DataGridView

  how can make copy the all column and rows that contain information and paste them into MS Excel file or MS Word file Reads these samples for clipboard handling: http://www.codeproject.com/csharp/clipboard01.asp http://www.codeproject.com/csharp/clipboard02.asp Charles ...Show All

• Visual Studio Express Editions Loading SWF from Memory Stream

  Hi, I'm using the ShockwaveFlash ActiveX control in a VB.NET Windows Forms application and i'm wondering. Is it possible to load an SWF file into the ShockwaveFlash ActiveX object from a memory stream rather then from a file name I've noticed that the ActiveX object has such properties as "InlineData" and "MovieData", possibly these could be used. I've also noticed someone has used Windows Messaging to send a pointer to a stream to the ActiveX control, has anyone seen this done Thanks ...Show All

• Visual Studio Team System Feature Enhancement Request - Column Filtering For Data Changes

  I'd like to make a feature request that I think would be helpful. After doing a data comparison, you're given the option to deselect certain rows you don't want to update. It would be helpful if there were also checkboxes on the column headings themselves, where you could deselect them. There are scenarios where you want to move all data except a certain column (ex. LastUpdatedTime or something of that nature). It would be great if you could consider this option for implementation. Thanks, -M- Hi Yes I now see what you mean. We will definetely add this to the list of items to look at for future versions of Data Dude. We really appreciate the feedback so keep it coming:-) Kind Re ...Show All

• Visual Studio Team System Updating a stored procedure

  I think I must be doing something stupid here. I have a stored procedure defined that already exists in my test database. I make a quick change to the procedure in Visual Studio and then I want to test it on my test environment. I therefore right-click the code and select 'Execute SQL', but am told the procedure already exists. If I add some code before the CREATE PROCEDURE line to check if the procedure exist and delete it then I get parse errors popping up in the IDE. I can't change the CREATE to a MODIFY as this causes parse errors. I don't see an option to 'overwrite' stored procedures when executing them, and I don't want to have to use the Compare Schema option to create a full release script whenever I make a small procedure chan ...Show All

• SQL Server How SQL Server deals with on the occasion if I imput unicode characters into a varchar column?

  Hi all, I want to know how SQL Server deals with it if I imput unicode characters into a varchar column Will it truncate or do something else Thanks! Samsudeen B wrote: Hi Robert, SQL Server implictly converts the unicode character to the Varchar type,If the unicode character is same as the (say English) the SQL Server installed Language ( say Language) and there will not be any data loss.If the unicode character is some other language there are chances of Data Loss Regards, Samsudeen B Hi Sam, I think what you said is right on the occasion that the collation was set to the default SQL_Latin1_General_CP1_CI_AS. But if the collation was set to Chinese_PRC_CS_AI, the si ...Show All

• Visual Studio Tools for Office SMS distribution of VSTO 2005 Outlook Addin - All users/current user problem

  Hello! I have developed an addin for Outlook 2003 with VSTO 2005. The addin is to be distributed to about 30 users with SMS. I have created an MSI which includes the SetSecurity project from the walk-through. http://msdn.microsoft.com/library/default.asp url=/library/en-us/odc_vsto2005_ta/html/OfficeVSTOWindowsInstallerWalkthrough.asp This MSI manages to install everything correctly if a user runs it "manually" on his/her machine. It correctly shows up in "Tools/Options/Other/Advanced Options/COM Add-Ins" and starts up when Outlook starts. However, when we try this with SMS the addin is nowhere to be found. If the user repairs the installation from Add/remove Programs it works however. So we think that this is due to ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Maya Programming Resources

  Hey, i know this isn't an XNA:GSE question at all, but its a noob question and i think its something that will also be topical to others like me who are new to game programming, with or without xna, who are getting art content into their game, are there any good maya programming resources (books websites etc..) out there that anyone can recommend that explain and have good examples of programming maya plugins (i'm using maya 7) something that also walks one through the process of setting up visual studio 2005 so that it can be used to write these plugins would also be handy. Its pretty tricky to find newer resources. Thanks all, sorry, i hate to be posting all these noob questions all the time ...Show All

• Visual Studio 2008 (Pre-release) First Remote Function Call takes too long

  Hi Dears When ever i call a remote function first time it takes too long so my transaction gets fail before remote function gets called. I m using TcpBindings with sendTimeout and transaction time out more than 20 mints. but i still getting this problem. it throws following exception. "The flowed transaction could not be unmarshaled. etc" ok fine if there is no solution of this delay on first call then there might be some timeout settings so my transaction should not fail. Regards This KB article may help for OleTx: http://support.microsoft.com/Default.aspx id=922430 For WS-AT, there is no direct 1:1 equivalent here. If operations are taking longer than expected to complete ( ...Show All

• SQL Server Help with installing VS Tools

  Hi, I have a problem with the installation of SSCE31VSTools-ENU.exe into VS2005. The installation ended after a few seconds although in the event log there is information that the product is successfuly installed. However, when I run Visual studio there is no project under Smart Device regarding SQL Compact database or something similar (there are only templates for: device application, class library, control library, console application, empty project and nothing more) VS2005 is in this version 8.0.50727.762 (SP.050727-7600) In application event log there is: Product: Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 [ENU] -- Configuration completed successfully.'" Has anyone some idea if there is a ...Show All

• Software Development for Windows Vista How to support dragging a subnetwork of activities onto the designer?

  Context - Sequential workflow with a number of custom activities - Custom application that hosts the WF designer Question I want to drag a custom activity from the toolbox onto a WF designer surface and when the activity is dropped, a subnetwork of activities appears on the design surface. ...kind of a like a "design macro" activity - drop one activity and an entire activity subnetwork is inserted at the drop point. How can this be implemented using WF Thanks, Michael. Create a custom ToolboxItem and override the CreateComponentsCore to create all of your activities and return them in the array. You can derive from the ActivityToolboxItem if your want to inherit some behavior. Matt ...Show All

• Smart Device Development Detecting a change in Orientation

  I am developing an application on a PDA for Window CE. And I would like to be able to detect when the screen orientation changes before it happens. I tried using this event handler: SystemState OrientationChanged = new SystemState ( SystemProperty .DisplayRotation); OrientationChanged.Changed += new ChangeEventHandler (OrientationChanged_Changed); but that of course fires the event handler only after the orientation has changed. Is there some sort of Changing event that I can create an event handler for The application will be run on different kinds of devices so I can't detect a hardward button push or anything like that. Thanks in advance for any assistance you can give. Priscilla Priscilla, It does ...Show All

• .NET Development Internal vs. Public

  Sorry if this is simplistic, but is it a viable design choice to restrict visibility of as many type members as possible in a Windows application exe to internal, rather than public This client will necessarily never be consumed by any other class or application. It also suppresses various VS warnings about uncommented members, which are irrelevant anyway in many cases. Thoughts, comments Obfuscator I see no request for obfuscation mentioned anywhere in this thread. However, obfuscators can rename public classes too . ...Show All