Paul Middlin's Q&A profile

• .NET Development DetailsView insert record

  Hi. When there is no records in database Detailsview is emty and not visuable. Is there a way to add the first record with Detailsview (Display Detailsview in Insertmode ) Thanks......... ...Show All

• Architecture Windows Zip

  Hi Is it possible to use the windows zip function on the command line I want to incorporate this into my program. I know there is an add on for win zip but was wondering if its possible to do with the windows own version... Cheers Hi! You mean using Compressed Folders I think it's possible if use Shell API, because Compressed Folders incorporated into Windows shell. ...Show All

• SQL Server Need to refine the query. I get an error

  update datusers set u.password = ua . [passwordsha1] from dbo . datusers du join dbo . datusersall da on du . UserObjectID = da . UserObjectID I'm getting the error: Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "ua.passwordsha1" could not be bound. I dont know what it means. I'm trying to update the password column from 'da' table. both tables have same records. and UserObjectID is the identity pk. How do i resolve it thank you for all your help what table is "password" and "passwordsha1" from You're precedin ...Show All

• SQL Server How to create an SSIS package correctly by programming?

       Recently I try to create a package completely by c# code,not the ETL tool.      The package is designed to transfer data from source table to destination table.      And I wrote the following codes by referring to the msdn library,but unfortunately,it doesn't work.       //this is my code ///////////////////////////////////////////////////////////////////////  Package package = new Package();     MainPipe dataFlow = ((TaskHost)package.Executables.Add("DTS.Pipeline.1")).InnerObject as MainPipe;    ...Show All

• Visual Basic Does VB allow assignment of data with Row Column

  In a Table, where multiple rows and columns have been defined, CounterTable.ColumnCount, is there a way to supply data (letters and numbers) to that location An apparent solution SetColumn(CounterTable, c1) only refers to controls - is this a case of vocabulary .text never seems to show up as an option. This extreme wordiness is one of the things that bugs me about VB, seems like interior decorating with military vocabulary. Public Sub SetCellPosition (ByVal control As System . Windows . Forms . Control , ByVal position As System . Windows . Forms . TableLayoutPanelCellPosition ) Looking at definitions finds ...Show All

• Windows Forms MDIContainer

  I have MDI Form, I want to add Panel control to the MDIParent. The problem is when I open MDI child, it always come behind the Panel in the MDIParent. so if the panel is docked FILL then  I never see the MDIChild Any Solution I am also having doubts about the Splitter control being replaced by the SplitContainer control.  While it is so much easier to use the container in a regular form, when you're talking about a scenario like above (docked panels in an MDI container) the splitter does come in handy, since the SplitContainer would negate the MDI functionality.  Theoretically, you can still access the splitter control ...Show All

• Visual Studio Tools for Office New button in navigation pane in Oulook 2003

  Hello! I would like to add my own button to navigation pane in Oulook 2003, where on click on the right side of the sceen a internet page would show. Button should have pictue and text ( like Mail button, where is a picture of envelope an mail caption ). I started with this problem, but i didn't come far, because I don't know  which object should I use. This internet page is interactive, so it have a lot of buttons, edit fileds and drop down lists, and should send information to ERP program. Can anyone help me with this problem.  Thanks for your answers. There is no supported way of adding a butt ...Show All

• Visual Studio Express Editions Compile fails on network drive

  I installed VCX (VC++ Express) on my local drive, but my project files are on a network drive mounted as S:  I created a simple HelloWorld Win32 Console App and the compile fails due to: 1>cl : Command line error D8022 : cannot open 's:\project\TestExpress\TestExpress\Debug\RSP0000024283524.rsp' However, it works fine on a local drive.  I read about this problem with other products but I can no longer find the reference. Anyone know how to fix this Thanks What, no one has done this before   Doesn't Microsoft read these forums   This is such a "grasshopper" thing for them ...Show All

• Visual Studio Express Editions Linker error LNK2022 Inconsistent method declarations using TableAdapter

  I am following the October 2005 "New Dataset Features in Visual Studio 2005" article by Jackie Goldstein that tells how to create a Master-Child set of forms using the TableAdapter. I am using my SQL-Server DB for the source tables, and after adding the second table, following the instructions, the compilation errors out with: Error 1 error LNK2022: metadata operation failed (80131187) : Inconsistent method declarations in duplicated types (types: EmployeeHoursDataTable; methods: FindByHoleNumber): (0x06000030). ShiftTable2.obj Error 2 error LNK2022: metadata operation failed (801311D6) : Differing number of ...Show All

• SQL Server Serious limitation in SQL server installation

  I am trying to install the server in a non-system drive.  I have to install the server in a diffferent folder like (E:) instead of the default C: due to existing partition that I have to continue to have (due to reasons that include security). Even though I selected this drive and every thing else (Program Files etc) the same, the install program still asks for over 2 GB on C drive. I checked each of the install options and found that most of this space is required by Books and client services which themselves need 1GB.  So I can do without them for now.  But then how do I get them installed   I can accomo ...Show All

• SQL Server Problem to install SQL Server 2005 CTP June edition...

  Hi When I tried to install, I kept getting the following problem with System Configuration Check: A previous installation required a reboot of the machine for changes to take effect. To proceed, restart your computer and then run SQL Server Setup again. I've rebooted many times (with AntiVirus turned off) and yet the above problem remains. Anyone has a solution to the above problem Thanks. Rgds OngCF ACtually worked it out and if anyone comes across this then: 1. Hit Start > Run type SQLServerManager.msc or if you have the shortcut on your start menu feel free to use that. 2. Expand SQL Native Client Conf ...Show All

• Visual C# Math

  Ok. I know this isnt a math class, but I have some questions about the Math Classes in C#. For example, lets say I have 3 numbers. Each can be 0-10. How would I be able to LIST all the combiniations of that. Can someone please help me out There's nothin inherent to the Math namespace to do what you want. do you want all combinations of the 3 specific numbers, or all the combinations of 3 numbers in the range 0-10 ...Show All

• Visual C# Question about making object instance visible to other objects

  I have 3 classes: MainClass SettingsClass FormClass Now, Mainclass handles most operations and does it's job well, upon being instantiated it creates an instance of SettingsClass, we'll call this instance _settings.  SettingsClass holds global settings for the application... like the user name, state of various things, that sort of stuff.  During the lifetime of MainClass, a FormClass may or may not be instantiated as well.  FormClass needs to be able to access _settings (the same instance of SettingsClass that MainClass uses).  At first, I was making the constructor for FormClass take a reference of SettingsClass, which ...Show All

• Windows Forms TreeNode LabelEdit ends prematurely

  I am attempting to inherit from TreeView control. The goal is to have my control sit in an MDI Form and list a subset of the MDI children. I would like to edit the window Text of these MDI children by edititing labels in the TreeView. However, when I put a TreeNode into LabelEdit mode, the edit will end after a single character is input. It looks like the first window listed in the TreeView is being activated, therefore causing the edit control to lose focus and end the edit operation. If this window is already selected, the edit operation will work, so you can edit the topmost root node and its first child, but any other nodes will only get ...Show All

• SQL Server Query:Source from multiple tables to a Fact table

  Greetings, Iam new to SQLl2005. Iam using DTS to transfer data from my source to the warehouse. I have a couple of tables in my source whein I have to join these to tables fields and insert the same in teh warehouse fact table. I have used a Join query in my Oledb source component, What other component needs to be used to insert the data into the fact table. I also need to extract same data with aggregation and insert the same into an another Fact table. Kindly help. Use an OLE DB Destination Adapter for the insertion. Use the Aggregate component to aggregate the data. -Jamie ...Show All