AlucardHellSing's Q&A profile

• Visual Studio SSIS runs very slow

  When I open up a SSIS project from Visual Studio it takes a long time to start up and I get the following warning message. Microsoft Visual Studio is waiting for an internal operation to complete. If you regularly encounter this delay during normal usage, please report this problem to Microsoft. Are you extending Visual Studio in any way If so, we would need more details on your implementation to assist in debugging this issue. If not, you might have more success in finding an answer in the SQL SIS forums at http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=80&SiteID=1 ...Show All

• SQL Server Wat's the effective way to improve performance in table using indexing?

  Hi guys , assuming there's a table called 'transactions' which contains more than 1 million records and normally will retrieve the records for monthly/yearly summary report. There are 5 fields within the 'transaction' table which are : - transaction_ID (PRIMARY) - transaction_Name - transaction_Date - transaction_Amount - transaction_reference Right now I would like to add indexing feature and I was wondering which use I take it as index for the effective way. Normally those summary report will sort by date. Is it take transaction_Date as non-cluster index n transaction_ID as unique cluster index. Hope able to get any assistance here. Thx a lot. Best Regards, Hans Hi, ye ...Show All

• .NET Development DataTable.Load() Generates InvalidOperationException

  Hello All: I am having a problem with the following code generating a "InvalidOperationException". The exception is thrown sometime, but not all the times. Does anyone have any idea why this code may be causing DataTable.Load() to throw that exception Thank you kindly. Jerry... p.s. Please forgive the cross-post. I must have inadvertantly posted this to WindowsForms. ***** Start Here ***** public partial class CollectionDetailStatusDataTable { public event TableFillingEvent TableFilling = null; private EventWaitHandle tableFilledWaitHandle = new ManualResetEvent(false); private CollectionDetailStatusTableAdapter tableAdapter = null; public CollectionDetailStatusTableAdapter Adapter { get { if (tableAdapter == nu ...Show All

• Connected Services Framework CSF 3.0 Sample

  Hi, I just installed CSF 3.0 Dev edition which is downloaded from msdn. But sample applciations are not available in that. How to get CSF sample applciations Is Microsoft provides seperately Please let me know if you have any ideas. Rgs Vasu Hi Vasu, Even I could not find samples with CSF 3.0 Dev edition. However samples are available with CSF 2.5 edition. Atleast the names of the samples are the same. Rest I cannot comment more. Do let me know in case you need find CSF 3.0 samples. Cheers Ruchi ...Show All

• Visual Basic Adding Item to CheckedListBox

  I am trying to add an item to a checked list box after the datasource has been set. I get an error on compile saying this can not be done. How do I go about adding the following at index 0 to my checked list box: (Select All) Thanks for you help. I was able to get by doing the following: dsNames.Tables( "tblNames" ).Rows.InsertAt(selectAllRow, 0) ...Show All

• Visual Studio communicate/add content to property view

  How can I add content to the Property View When a file is open e.g. a Html file, I'd like to query the property view and get detail on what html control is presently selected etc, then add content to the property view. I've seen how to add information to the property view but I do not know how to query it! Hi Nisham, I see the example is in VB, I'm using C# I should have mentioned this. Is there an equivelent example implemented in C# I see from the blog, Craig is describing editing the Project Properties, is the same method as one would use for extending properties of a control ...Show All

• Visual Studio Express Editions Stupid SQL Question

  I am trying to learn the C# and SQL, and it looks like to run a program using an SQL Database that the user needs to also install a fairly large SQL program. Is this true, or will the compiled program be all that they will need I'm curious, as if this is the case I may need to look into using MS Access or something instead. Any help would be greatly appreciated. Thanks, -Matt Hello All. Matt: Well, I'm not positive because I've never tried it (since I prefer SQL Server), but I'm thinking that if you use a MS Access database, the machine will still need the MS Jet database engine. If you don't want your users to have to install something themselves, then it's no problem, because when you build yo ...Show All

• SQL Server Any hierarchical functionatility in Management Studio in 2005

  I am thinking, if there is the functionality that can hierachically group the tables, views, and stored procedures into different sections within each database, it will be much clearer and logical for maintain the database objects. For example, to create containers in the console tree of Management Studio or Enterprise Manager, or even apply the namespace/subnamespace features to the tables/views/stored procedures of each database. This functionality does not currently exist. You can submit this suggestion through https://connect.microsoft.com/SQLServer . Cheers, Dan ...Show All

• Visual Basic Can I disable Task Manager?

  Hello Can I disable Task Manager in Windows by using VB 2005 Thanks HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\System Modify/Create the Value Data Type(s) and Value Name(s) as detailed below. Data Type : DWORD Value // Value Name: DisableTaskMgr Setting for Value Data: [0 = Enabled (Default) / 1 = Disabled] Exit Registry and Reboot http://www.theeldergeek.com/enable_disable_task_manager.htm ...Show All

• Visual Basic IsDBNull problem

  I am probably doing this wrong If IsDBNull(EDFRow.EStart) Then Me .EStartDateTimePicker.Checked = False Else Me .EStartDateTimePicker.Checked = True End If I get the error that the filed is dbnull Can someone please explain this. Davids Learning If ( EDFRow.isEStartNull = True) Then Me .EStartDateTimePicker.Checked = False Else Me .EStartDateTimePicker.Checked = True End If isEStartNull Method is provided by default for typed datasets. :) ...Show All

• SQL Server Convert row with text field to column

  Hi experts; How can I generate the result using typical SQL statement based on the following tables Table a - Salesman (salesId, Name) pk : salesId Table b - Invoice(InvoiceNo, salesId, InvoiceAmt) pk : invoiceNo fk : salesId -> Table a The result set : salesId, Name, sum(InvoiceAmt), InvoiceNos with comma separator For example: Table a SalesId Name S001 Peter S002 Alice Table b InvoiceNo SalesId InvoiceAmt INV001 S001 $100 INV002 S001 $100 INV003 S001 $400 INV004 S002 $200 Result set SalesId Name Sum(InvoiceAmt) InvoiceNos S001 Peter $600 INV001, INV002, INV00 ...Show All

• Visual Basic What's the deal with Generics

  Hi, I have the following Function Public Function EnterOrder( ByVal custCollection As Generic.List( Of CustomerDTO), ByVal OrderDTO As OrderDTO) As Boolean Dim customerBOCollection As New Generic.List( Of CustomerBO)(custCollection) ...............Do stuff End Function I get an error when I run the program basically saying unable to convert CustomerDTO to CustomerBO. What other way around this do I have CustomerDTO is my serialized object and CustomerBO (name speaks for itself) is the one with the rules etc. With one customer it works like this Dim customerBO as new CustomerBO(CustomerDTO) I now need to pass a collection of customers and I was turning to Generics for assistance. Any ideas ...Show All

• Visual Studio 2008 (Pre-release) Web hosts which support XBAPs

  Does anyone know of a Web host whose servers support XBAPs Thanks for any links. IIS 7 is preconfigured with the WPF MIME types. On Linux servers, you could do this yourself (with a limited account): http://laurenlavoie.com/avalon/111 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. SDK Oct 2006 - CustomUI Sample - UI Controls disappearing

  Just wanted to make sure I am not seeing "double" because of the time of the night :) I fired up the CustomUI sample (the 2005 version) and noticed that UI elements disappear. I first toggled the screen from window- to full-screen and back and noticed the button disappeared visually but continued to work functionally. Then I could make all radibuttons, sliders and check-boxes disappear by randomly clicking on them. However their functionality was still present - if you happen to hit the same spot on the screen where the visual of the control used to be - it did what it was supposed to do. Is my setup somehow causing it or it is a known issue with a known fix. Many thanks for any advice. btw. ... Happy 2007 to ...Show All

• Windows Forms an item with the same key has already been added

  I am trying to change the BackgroundImage property of a UserControl but when I try to do that from properties window VS throws "an item with the same key has already been added" exception. I did that several times in the same project. But it started to complain now. how can I solve that... Hi, I have solved the problem in an interesting way. I have only removed the resource file completely and added it again with renaming my image file. Now it works. thank you very much... aen ...Show All