Alazekabi's Q&A profile

• SQL Server Annoying Inner Join Problem

  Greetings SSIS friends, I have the following problem in SSIS and it's driving me nuts!!!!! My situation is as follows : Data Source 1 & Data Source 2are joined using a merge join. This bit works fine. The output of the above join is then joined to a third data source but this time, I only get 63 rows coming through instead of 77097 even though the join key in the second merge join component is the same as the first one!!! I thought I was going mad so I decided to see if the same problem occurs if I was to do this with T-SQL. I created 3 temporary tables for each of my data sources. I did an inner join between tmpTable_Source1 and tmpTable_Source2, I then stored the result in tempTable4 The final inner join was perf ...Show All

• Windows Forms Closing child modal form after calculations in parent form is complete

  Hi, I was trying to show a modal form just before I began some calculations within my main form and then after it was done I wanted to close the modal form. But the modal form never closes and my main form remains disabled. Here's how I did it: private void button1_Click(object sender, EventArgs e) { ModalForm modalForm = new ModalForm(); modalForm.ShowModal(); ........ some calculations ........ modalForm.close(); } Can someone tell me how I can accomplish this in an efficient & secure manner> Thanks If you're just trying to show a message like "Please wait while calculating", just don't show the form modally; Use .Show instead of .ShowModal. (May need an Application.DoEvents in there to g ...Show All

• .NET Development Can I specify the type library name (not filename) generayted from an assembly?

  By default (and I cant find out to change this) the tlb file has a library name of the same as the assembly name. This doesnt suit me and I'd like to be able to specify the name. This is a some IDL from the top of a tlb file: // typelib filename: Foo _XXX_Fred .tlb [ uuid({E3238AFC-2943-48CF-89B9-506C84645D6D}), version(1.0) ] library Foo_XXX_Fred ( The bit in yellow is what I want to be able to specify. My assembly is called "Foo.XXX.Fred.dll" but I want the tlb libary to be called something else. I strongly suspect there is a assembly attribute I can specify. I've changed the progids of exported types using the ProgIdAttribute , but would like the tlb name to be the same. Neither Tlbexp.exe nor Regasm.ex ...Show All

• SQL Server Import export failed : Data conversion failed

  [Source - chn_employee_vew_test_txt [1]] Error: Data conversion failed. The data conversion for column "Column 42" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". [Source - chn_employee_vew_test_txt [1]] Error: The "output column "Column 42" (136)" failed because truncation occurred, and the truncation row disposition on "output column "Column 42" (136)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. I using Locale (People's Republic of China) and code page of 936 (Simplied Chinese GBK) with header row delimiter {CR}{LF}. I am us ...Show All

• Visual Studio Read/Modify property of a Project

  Hello, I have need to read and to modify the property of a Project with VSIP of Visual Study 2003 .Net, C++ language. Using the EnvDTE namespace you can do it with the EnvDTE.Project.Properties collection. Using VSIP see also: Managing Configuration Options http://msdn2.microsoft.com/en-us/library/6dwcaww2.aspx ...Show All

• Visual Basic Send output to stdout from gui app...possible?

  I have a simple vb.net gui application (an alternative file requester in a form) that I would like to run from the command line. It executes fine, but I find that I cannot send any output (a string representing the file selected) to the command line upon completion. It appears that "console.writeline" doesn't actually write to the console Any suggestions as to how to send info back to the console window upon completion Keep in mind that this is a gui app (not straight console). Dim Si As New ProcessStartInfo Dim P As New Process P . StartInfo = Si Si . FileName = ( "MyExePath" ) Si . UseShellExecute = False Si . RedirectStandardOutput = ...Show All

• SQL Server How do I display info on the report parameters on the face of the report ?

  I have several parameters used to constrain which data to select from the database. Examples of prompts for these parameters ; "Include accesstype:" "Include activationdate:" "Include speed data:" The user chooses Yes or No to each of these. On the face on the report I want to put some textboxes to display all the parameters with the prompt (as stated above) and the actual value chosen by the user (Y/N). For clarity, I'm not talking about the report parameter area, but about what you will see on a report print-out. However, working with a parameter in the expression editor, I can only select members Value, Label, Count and IsMultivalue. I would have expected to be able to select "Prompt", but that is ...Show All

• Windows Live Developer Forums using the 3d activex in winforms

  i am currently trying to find out how to use the 3d activex control in my winform app, anybody got it yet If you figure it out or have any examples I would be interested in seeing them, I am working in vb.net so switching to java etc isnt that simple. I thought maybe using the web browser control might be a place to look ...Show All

• Gadgets Using Settings to Choose Color of Gadget

  I have a simple gadget where I have 4 different color .png bachground colors. The default is red and I want a user to be able to enter settings and choose the background color. I think I'm close, but if someone could give some pointers, I would really appreciate it. You see the bold else If I add and remove that by hand, I can change the color and then change the color back after I remove it. Any thoughts looking at the code I am a beginner, so any help is once again very moch appreciated. <html xmlns=" http://www.w3.org/1999/xhtml "> <head> <title>Settings</title> <script type='text/javascript' src="js\Settings.js"></script> <script> System.Gadget.onSettingsClosin ...Show All

• Visual Studio Express Editions Remote communication(Look at home computer from internet)?

  I am building a program that is used in the home. It will gather some info and save it in files and such. But I am looking to let the user look at some of that info via the internet. Through our website(that is not started yet). I have worked with TCP/IP connection on VB6. The users compuer will most likely be on a dynamic IP as well. I really am not sure what ports would be best or really where to start. Any help would be appreciated. I have done a search but I couldn't find anything. Sorry if this is a dumb question.. Thanx in advance.. My program on the home computer will always be running whether on the screen or in the tray. So it will be able to initiate or watch for a socket connection.. I h ...Show All

• .NET Development Database data copy

  Hello, Don't know if this is the most suitable forum for my question but... i have 2 databases on the same pc.i want to query the first database and get some data as a result from more than one table.and using an application i would like to copy that data to another database in one table that i have created... how can this be done thnx in advance.... If databases located on a same server, you could use INSERT SQL statement with the names of the databases like INSERT INTO MySecondDatabase.dbo.MyTableInSecondDatabaseHere SELECT Filed1, Filed2, ..... FROM MyFirstDatabase.dbo.Table1 LEFT JOIN MyFirstDatabase.dbo.Table2 ON ....... First part of the statement defined destination and sub SELECT ...Show All

• SQL Server "Sql Broswer" vs. "Hide Sql Instance"

  I was never clear what the sql 2005 Browser service is about. But now that I've found the "Hide Instance" property of a server (SQL Server Configuration manager, select Protocols for MSSQLSERVER, right-click, go to Properties) I'm more confused than ever. What is the difference between these two items TIA, Barkingdog That makes sense but if I stop the Sql Browser won't that have the same impact TIA, Barkingdog ...Show All

• Visual Studio Team System Team Project Creation Failed

  Hi all, I've just encountered an error when creating a new Team Portal Site using Team Explorer which I wondered if anyone may be able to offer a solution to. I ran through the wizard though I didn't add a source control db at this time however, on clicking Finish I received the following error, is this something that you've experienced before and if so was it easily fixed Error TF30004: The New Team Project Wizard encountered an unexpected error while initializing the Microsoft.ProjectCreationWizard.Reporting plug-in. Explanation TF30171: The Microsoft.ProjectCreationWizard.Reporting plug-in used to create the new team project could not be initialized and returned the following error: TF30222: The New Team Project Wizard could no ...Show All

• Visual Basic Coerce a byte string to a structure?

  I have a file that contains a series of packets. I've created a set of structures that map the elements of the packets. My question... Is there a technique in VB to map the string of bytes read from the file to the structures In 'C' this would be simple. In VB.NET I don't know. Suggestions are appreciated. Thanks, Johnny   Hi, If you have an array in your STRUCTURES(s) you could use the string.split method. See.>> http://msdn2.microsoft.com/en-us/library/b873y76a(VS.80).aspx see also the StreamReader.Readline method.>> http://search.msdn.microsoft.com/search/default.aspx siteId=0&tab=0&query=readline Hope these help you....   Regards, S_DS   ...Show All

• Microsoft ISV Community Center Forums Help with comma separated values in report

  Hi! A bit of a stuck-up. It’s no problem in creating a coma separated fields in .txt kind of file. But I have another problem which is probably simple to manage (not for me though - my brains work 24hrs/day and don’t come up with nothing). I want to show several different values from one field (in query) on the report - now check this - They have to be separated by a comma in one line. If anybody is familiar with the solution just show me the direction and I’ll try to solve it by myself. Thanks in advance Hi The below example uses a recordset to scroll through the records and add the entries into one string. Hope this helps Public Sub test() Dim rs As Recordset Dim MyStr As String Dim FirstRec As Boolean Dim Responce Set ...Show All