Rick Sivernell's Q&A profile

• SQL Server SSIS & SharePoint Lists

  Hi, is there any example how to extract values from a SharePoint list I searched in Google but I only found something about that someone failed using the web service task for it... If possible I would like to get around any custom .net code (Scripts would be OK), but if I can't get around that, I have to follow that path... Thanks, I would prefer doing something which is supported...On the other hand direct OLEDB would be ...Show All

• Software Development for Windows Vista Windows Vista Activation

  How does one activate Windows Vista The online wizzard does not work. I'm having the same problem has anyone got a solution for this Thanks graham ...Show All

• Visual Studio VSS storing DLL's for Web Site (how do I disable this?)

  We're using the new version of Source Safe, and using .NET / VSS Integration. We're also using the net Beta2 of VS.NET 2005 and Source Safe. Our code is developed in VB.NET, and all the development workstations are running WinXP Pro. I've got a solution that has several projects in it: Application.Data (.NET Class Library) Application.Business (.NET Class Library) Application (Web Site). The Web Site has a project level reference to the Business ...Show All

• .NET Development Detecting SQL Server database existance

  I'm a beginner at using Visual Studio 2005 pro & SQL Server 2005 Express Edition and have just learned how to create a database file by issuing SQL Server commands through C# programming. I just want to find out what is the best way to detect if a database already exists on the system. My application currently creates my database, but I want to add in the ability to check if it is already present so that I can bypass the creation of the ...Show All

• .NET Development System.Security.Cryptography.Pkcs

  The emvelopedcms object doesnt seem to support decryption of objects encrypted with aes128-cbc. Any idea on how to get this to work, or decrypt the contentinfo by hand with another object Dim cmse As New EnvelopedCms cmse.Decode(final) cmse.Decrypt Decode goes fine - parses all enveloped data perflectly. Decrypt returns cryptographic exception: "Unknown cryptographic algorithm" Thanks! Hmm ... as a UMass a ...Show All

• Visual Studio Express Editions I need to make a backup of my project - how?

  I will shortly be re-formatting my HDD and so I need to make a backup of my project and be able to re-install it later. I've looked through forums and help files but can't find any straightforward answers (I could do it easily in VB6). Any help appreciated. Thanks. Your entire project is contained in a single folder, so all you need do is copy or archive that folder to whatever location you want.  Al ...Show All

• Visual C# Waiting for a statement to get executed!

  Hi, I'm facing a small problem and it would be great if someone could help me out. I'm having the following lines of code lets say its as follows int retVal=0; statement 1; ....... ....... ....... statement 5; retVal=obj.CallingWebservice(); statement 7; In the above statements the line "obj.CallingWebservice()" is calling a webservice which will return a value. Lets say if the webservice is executed properly executed ...Show All

• Windows Forms Need ideas on creating an email To: recipient textbox with underlining

  In outlook, when an email or contact exists in the To: recipients text box, it is underlined. Any idea how I can create a similar control It is just a simple textbox which keeps checking a list at every keypress event. When the textbox text matches any item of the list. The textbox font changes and underline.. ...Show All

• SQL Server CLR Stored Procedure Exception Handling

  Hi, 1) Is there a way to define a global unhandled exception handler in managed stored procedures Something like we're used to in Winform project: AppDomain.CurrentDomain.UnhandledException     += new UnhandledExceptionEventHandler(MyHandler); (I've tried the latter but get some security exception.) 2) Same question about MS Office CLR unhandled exceptions handler... 3) Also, for WebServices Stored Procedure, is there a way to c ...Show All

• Visual Studio Express Editions Activation

  I've just installed Visual C# Express Beta 2 and the activation is required for each user in my Windows. I'm the only who my computer use. Will be any solution for me in final release to not activate separately for administrator account and for user account The activation key is not same now. Thanks. HI Martin, Yes, it is by design that each user on the computer need to register and activate the products right no ...Show All

• SQL Server Problem when creating a new named calculation

  I have a Customer dimension in my model, and now I want to count the # unique customers in one of my fact tables. Therefore I created a new named calculation in the fact table which does a count distinct of the customerkey in the fact table. And when I try to add a new report model i get the following error message, even when I don't select anything in the Select report model generation rules screen: TITLE: Microsoft Visual Studio ...Show All

• Visual C# state management

  Hi all!! I'm newbye in c#. I'm looking state management for web apps. I read about web.config, Application[".."], Session[".."], ViewState... It's OK. My question is: I'm writing a web user control and i need to expose a connection (to DB) or a connection string. It's a sensible data! How can store it in my control I''m using Session["..."]. Is it correct (i'm not using web.config because it changes from app to app and i'm writing us ...Show All

• .NET Development Specifying user account to run a Thread

  Hi, I want to start some asynchronous operations in a thread and I want the new thread to run under a specific user account. Is it possible to achieve this in threading and how Thanks, Prakash Hello Prakash, The type of functionality I believe you are looking for is called 'impersonation'. Effectively, you want your code to impersonate another identity or role during some portion of execution. Impersonation ha ...Show All

• Windows Forms DataGrid column with a different..

  ..embedded control on each row. I know a column can be created that will show a combobox, then all rows of that datagrid will have a combobox in that column. BUT... Is it possible to have a column that will allow you to show different controls& ...Show All

• Windows Forms Why is DataGridView so slow?

  I created a databound DataGrid, and then researched DataGridView to find it would fit my needs better. I have a DataGridViewCheckBoxColumn as my first column in my DataGridView then set its datasource to a DataSet. Sometimes the DataSet may contain a table with over 1000 rows. The user has a button that will select all checkboxes in the DataGridView. It takes about 5 minutes for my foreach loop to complete this task with the DataGridView. With t ...Show All