2009年02月05日

转载 Vista UAC: The Definitive Guide

Introduction When I began this project, I didn't think it would take me two weeks to complete. Well, here I am, finally, writing the article portion of the whole thing. Don't worry, I took really good notes. I am splitting this article into three major segments: The first segment is a broad overview for those who really don't care about the nitty-gritty details of UAC and just want to get to the good stuff. The second segment gets into the really nasty stuff...for those of you who enjoy infor阅读全文>

发表于 @ 2009年02月05日 14:03:00|评论(loading...)|举报|收藏

转载 Launch your application in Vista under the local system account without the UAC popup

原文地址：http://www.codeproject.com/KB/vista-security/VistaSessions.aspx
Introduction
In Vista, I came across a problem where I wanted to launch an exe under an administrator account to perform certain tasks. I could not do that because the UAC elevation dialog box would appear for which the user would have to respond. To work around that problem, I came up with the solution of launching the required application from a service into the current user session with local system account pr阅读全文>

发表于 @ 2009年02月05日 14:01:00|评论(loading...)|举报|收藏

2009年02月03日

转载 动态调用WebService(C#)

2008年12月03日 星期三 16:53通 常我们在程序中需要调用WebService时，都是通过“添加Web引用”，让VS.NET环境来为我们生成服务代理，然后调用对应的Web服务。这样 是使工作简单了，但是却和提供Web服务的URL、方法名、参数绑定在一起了，这是VS.NET自动为我们生成Web服务代理的限制。如果哪一天发布 Web服务的URL改变了，则我们需要重新让VS.NET生成代理，并重新编译。在某些情况下，这可能是不能忍受的，我们需要动态调用 WebService的能力。比如我们可以把Web服务的URL保存在配置文件中，这样，当服务URL改变时，只需要修改配置文件就可以了。

说了这么多，实际上我们要实现这样的功能：
复制保存publicstaticobject InvokeWebService(string url, string methodname, object[] args)
其中，url是Web服务的地址，methodname是要调用服务方法名，args是要调用Web服务所需的参数，返回值就是we阅读全文>

发表于 @ 2009年02月03日 17:31:00|评论(loading...)|举报|收藏

转载 Making raw web service calls with the HttpWebRequest class

Sometimes it's really nice to be able to make a raw call to a web service by manaully putting together your own SOAP envelope. The System.Net.HttpWebRequest class makes it really easy. There are a number of good reasons to do this. Maybe you want to call a web service without having to create a proxy class with wsdl.exe, or maybe you want to have more control over the creation of the SOAP envelope or you don't want to have to rely on the XmlSerializer. Maybe you want to create the xml b阅读全文>

发表于 @ 2009年02月03日 12:45:00|评论(loading...)|举报|收藏

2009年01月15日

转载 Excel import gives NULL rows with DTS Sometimes


when the excel column contains numeric and text data, and you try to import the excel data using say DTS, it will give you either the text values or the numeric values and return NULLs for the other. This is a known problem in excel as it scans rows ( based on the set count, which can be 1 ), and determines the datatype for that column. Any row which does not adhere to that guessed datatype, gets imported as NULL for that column. A solution to this problem as shown by the knowledge base i阅读全文>

发表于 @ 2009年01月15日 13:16:00|评论(loading...)|举报|收藏

2008年12月24日

转载 How To: Reset Identity column in SQL Server

This is one of those simple tip posts that may seem obvious and taken for granted by those of us who have been working with SQL Server for a while now but maybe a newbie or two out there will find this helpful.

Every so often (just this morning!) I find myself resetting an identity column value back to 0 after I've deleted all the existing records so the table gets a fresh start at primary key 1. Yes, I know all about primary keys not changing and how the value in the primary key does阅读全文>

发表于 @ 2008年12月24日 15:16:00|评论(loading...)|举报|收藏

2008年11月26日

原创 一个SSIS部署问题的探索过程，实在佩服这家伙

5/2/2006 10:06:01 AM    SSIS Scheduling Failure - AcquireConnection ErrorIn honor of the help that I have recently received in this group, I thought I would post the answer to a problem that had been plaguing me for a couple of weeks in the hopes that this posting will help someone else. Like many people, I am in the middle of upgrading from SQL Server 2000 to 2005. The biggest hurdle is converting the DTS packages to SSIS. (Aside: I truly like many things ab阅读全文>

发表于 @ 2008年11月26日 11:41:00|评论(loading...)|举报|收藏

2008年11月25日

转载 INVEST in Good Stories, and SMART Tasks


INVEST in Good Stories, and SMART TasksAugust, 2003
XP teams have to manage stories and tasks. The INVEST and SMART acronyms can remind teams of the good characteristics of each.
In XP, we think of requirements of coming in the form of user stories. It would be easy to mistake the story card for the "whole story," but Ron Jeffries points out that stories in XP have three components: Cards (their physical medium), Conversation (the discussion surrounding them), and Confirmation (阅读全文>

发表于 @ 2008年11月25日 11:01:00|评论(loading...)|举报|收藏

2008年11月03日

转载 SSIS: Throwing errors from script task/component


I'm working on a project at the moment that entails making calls to external DLLs from within a script task or script component. In our case the DLL in question is a web service proxy and we've been having numerous problems getting it to work. Being able to grab the errors returned from the WS has been a godsend and to do that I've come up with a bit of code that I thought might be worth sharing.
This is probably fairly noddy to any developers reading this but to those SSIS developers阅读全文>

发表于 @ 2008年11月03日 15:05:00|评论(loading...)|举报|收藏

2008年10月31日

转载 Send Mail in SSIS

December 26, 2006
SQL Server 2005 Integration Services - Part 39 - Send Mail Task
By Marcin Policht


Following presentation of the most popular Data Flow transformations in SQL Server 2005 Integration Services, we are revisiting the topic of Control Flow tasks, in order to make our coverage more complete. Among the most common tasks that have not yet been discussed in our series is the Send Mail task, which will be the topic of this article. In addition to describing i阅读全文>

发表于 @ 2008年10月31日 16:50:00|评论(loading...)|举报|收藏

第1页，共11页
第一页 上一页 下一页 最后一页
Csdn Blog version 3.1a
Copyright © Richard yanwei