VisualBasicGuruWannabe's Q&A profile
SQL Server SSIS: Inserting unknown members from fact table
Looking up surrogate keys in a dimension table and adding these to your data flow is easy when there is a match in your dimension table for every key in your fact table. However, I am puzzled by how to manage the data flow when no match can be found for a specific key in the fact table when doing the lookup AND I then want to insert this unknown key as an unknown/inferred member in the dimension table. The problem is further complicated by the fact that when I have inserted the unknown member in the dimension table and it has been assigned a surrogate key there, I want to add this surrogate key to my fact table - just as if there h ...Show All
.NET Development Issue with XmlWriter/XmlTextWriter.
Hi, I have a piece of code as below: static void Main(string[] args) { XmlTextWriter tw = new XmlTextWriter("c:\\tw.xml", Encoding.UTF8); string Text = "<Script><![CDATA[int i=0; if (i < 0) i = 0; ]]></Script>"; tw.WriteElementString("Text", Text); tw.Close(); } I am trying to output the string Text to a xml file. The string self has CDATA in it. I assume the contents within CDATA section will not be touched. However, the output I got is: <Text><Script><![CDATA[int i=0; if (i < 0) i = 0; ]]></Scr ...Show All
Windows Forms Path
I have the following code: Option Strict Off Option Explicit On Friend Class clsMain Public Function OpenConnect() As ADODB.Connection Dim com As Object com = New ADODB.Command Dim dbPath As String 'dbPath = VB6.GetPath & "\" & "ss.mdb" &nbs ...Show All
Visual Basic enum.parse newby question
I've researched this and I believe it's what I need to do...but I could use a little guidance on how... I've got a basic updown program which goes up or down in .5 increments. Press the plus button it talleys upward and press downbutton it reduces downward. The result shows in a label, as a string. I've added some functions like a clear button to reset to zero, etc., and also to export the subtotal string to a RichTextBox1 document as "Points: #...." Now I'd like to add a "total" label so that these individual talleys are added ...Show All
SQL Server Sql srv 2005 client components ?
I have a machine where I have Sql server 2000 installed. Now i want to install sql server 2005 client components on another machine. Is it possible for me to access the databases on 1st machine(which has sql 2000) from the sql srv 2005 client components Thank you, Yes, you can access SQL 7.0, 2000, and 2005 databases from the SQL 2005 client tools. Obviously, 2005 features within the client tools are only usable on 2005 servers, etc. ...Show All
Windows Forms Fixed Length Strings
How do I declare a fixed length string In VB6 it was Dim myString as String * 80 Visual Basic 6.0 In Visual Basic 6.0, you can specify the length of a string in its declaration. This causes the string to have a fixed length, as in the following example: Dim Name As String * 30 Visual Basic .NET In Visual Basic .NET, you ...Show All
Software Development for Windows Vista win32 application
Error 1 error LNK2019: unresolved external symbol _MAPIFreeBuffer@4 referenced in function "public: virtual long __stdcall CMailRuleClient::ProcessMessage(struct IMsgStore *,unsigned long,struct ENTRYID *,unsigned long,struct ENTRYID *,unsigned long *,enum _MRCHANDLED *)" ( ProcessMessage@CMailRuleClient@@UAGJPAUIMsgStore@@KPAUENTRYID@@K1PAKPAW4_MRCHANDLED@@@Z ) mapirule2.obj I get this error when I build my project. Can you help me what is the problem I tried to change some settings about linker but nothing changed. thanks. You should write a wrapped class in order to migrate your code into the managed code. Th ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Pass int array to the pixel shader
I want to pass an int array to the pixel shader. I used SetIntArray(name, val)..the problem is that in the shader I do not know the exact size of the array, therefore in declaring it i am trying to use an int *. It seems as if the compiler does not like this. Is is it possible to use pointers in the shader If not how can I pass a variable length array to the shader can someone give me an example of the usage of this function You can't use pointers in a shader ( well, not in the way you're wanting... ) - HLSL might look very C/C++ like, but it's nowhere near as powerful Also, unless you choose to send your array da ...Show All
Smart Device Development Today background image transparency level.
When you select an image as the background image for the today screen using the "use this picture as background" option, the image appears washed out. The transparency level is not set to 0. Where is this transparency value coming from Is this a registry value Thanks In 2003, the transparency level was hard-coded. It was not made a registry value until Windows Mobile 5.0. ...Show All
Visual Studio Team System TFS Not Ready for Prime time...not even close...
I hate to say this but TFS has to be the worst application install I have ever seen. The documentation is lacking and the entire thing feels like a kludge. I cannot imagine this being ready any time soon. Many of the same bugs I saw in previous versions are still there. Just bad. After 7 reinstall attempts (because of many different reasons...one of which was that the TFS accounts ALL need to currently be admins or it wont work!) I finally got it to work. But only when I went with an ActiveDirectory structure would it work. No way would it work properly in a work group. Now after slaving to get it working, I find that it has bad performance ...Show All
Windows Forms Problems with setup project - am I thick?
I've a c# forms project that uses SQLExpress and Managed DirectX (developed under Beta 2) I'm trying to build a setup program for it. I need to do the following:- Include DotNet 2.0 Beta redist Include SQLExpress redist Provide a .exe.config which is not the same as in the development project (e.g. some directories will be different on the target) Provide a link on the desktop and the programs menu. Included more than one executable (ideally in the same directory) I would LIKE to populate the database with a script during installation. I can do the redist inclusion with the 'Publish' option. I can do the links with a Setup Pr ...Show All
Visual Studio Tools for Office Deploying Word Solution
I have a VSTO project (Word Template) that I want to deploy to our users' local pcs - I want them to be able to create a document based on that template and have that document stored on a network share. Is it then possible for other users to open that document from the network share and 'run' the assembly (uses a task pane to update or revise the document) If so, how do I go about setting this up Also - does anyone know of a good step by step how-to on setting up security for solutions developed by using VSTO I have found tons of info but it is overwhelming - one article links to another article and that one to another......etc! An ...Show All
Visual C# POPUP window accepting data
I have created a popup app that I want called when another program opens it. C:\screenpop UUI: XXXXXXX How do I accept the UUI value into a search text field in my popup app upon openning the popup app Thanks Hi, I'm thinking what you want is to capture command line arguments. http://msdn.microsoft.com/library/default.asp url=/library/en-us/csref/html/vcwlkcommandlineparameterstutorial.asp Have a look at the tutorial in the link. If you application is called with C:\screenpop UUI: XXXXXXX The first command line argument UUI:XXXXX can be obtained from the args[] array in the Main method. So, args[0] will co ...Show All
Smart Device Development Error for selecting file which doesnt exist in c#
Hi How do you go about validating a number which the user enters to ensure that it actually exists in the database. I have a program set up which allows the user to search by number. When they enter the number i want the program to check whether the file exists in the database. If the number does not exist then display an error message to the user. Thanks in advance You can use Count keyword in a query as described here: http://msdn2.microsoft.com/en-us/library/ms173276.aspx Then run ExecuteScalar() and you'll get Count of whatever's in your query: http://msdn2.microsoft.com/en-us/li ...Show All
Windows Forms Caching
Hi, How can I implement caching of data coming from a database in Windows Forms. In Web forms we have Cache, Session objects and I could use them, is there any equivalent in Windows Forms Is there any other alternative also Regards, Kunal Yes, you are right, the data could be the same also and thats why I was looking at cahing it, I will do it now by implementing a singleton class at the server and using its dataset member to respond to the clients. Thanks to both of you. ...Show All