ITPub博客

Sometimes, you want the value of an Excel cell coming from a data list preseted. see the figure below: Now follow me to set a data list for excel cells. 1. Select a cell you want to set data list. 2. Click "Data" main menu. 3. Click "Data Validation" button. 1. On the "Data Validation" window,select "Settings" Tab. 2. Select "List" from "Allow" dropdownlist, and make sure "Ignore blank" and "In-cell dropdown" check

Much of my day job involves database design, maintenance and manipulation. I use SQL scripts to quickly build my databases from scratch. In order to test them I need piles of data and find it is often too much work to generate all those inserts manually or figure out sqlcmd or osql code to import bulk data.The best programmers, as many say, are lazy and the quickest way I’ve found to generate the inserts is to use Excel. If any of the following isn’t clear please attach a comment and I’ll be

In my recent project,I use Team Foundation Server as source control and project management tool. It is the first time I have a chance to touch TFS, and it has taken me nearly a week time to setup and config it successfully. It is really not a simple job to setup TFS if you are newer to it.I would like to share my expierence with you, I hope it can give you helps and save your time.GoalI'd like to adapt Team Foundation Server Single-Server Deployment.Hardware RequirementsProcessor : 2.2 GHz Penti

Follow these steps to install Microsoft Windows SharePoint Services with Service Pack 2 for Team Foundation Server to run silently from the command line or interactively use the setup wizard. Before installing Team Foundation Server on a localized version of Windows SharePoint Services, you must first install the Windows SharePoint Services language pack that matches the Team Foundation Server language you are going to install. For example, you must install the English Windows SharePo

OverviewVisual Studio 2005 Team Foundation Server provides team collaboration tools that enable organizations to manage and track the progress and health of software projects. Team Explorer integrates the project work products found on the project site into the Visual Studio IDE for efficient team access. Team Foundation also provides extensible work item tracking and enterprise-class version control systems.Start Here to InstallTo successfully install Team Foundation Server on new computers, yo

I installed Windws Server 2003 enterprise version on my server, then I use windows update to install sp2. now I open IE, it popup an exception as below:After googled, I found a solution for this question.After Visual Studio is installed on a server, the default behavior when an unhandled exception occurs is to show an Exception dialog that requires user intervention to either start Just-In-Time debugging or ignore the exception. This may be undesirable for unattended operation. To configure the

MagicDraw UML 是目前最受欢迎的UML建模工具之一。经同事推荐，我也下载了个最新版本体验和学习一下。下载URL：http://www.nbdown.net/file/1400.html使用MagicDraw UML建模的过程中，发现输入中文字符显示为乱码。在网上查找也没有得到答案。经过反复尝试，终于找到了解决办法，在这里和大家分享。选择主菜单栏的“Options”-->“Project”，打开“Project Options”属性窗体，单击左侧Frame的“Symbols properties styles”下的“Default（Default）”，右侧Frame中的“Font”项，默认值为“Arial ”。将其设置为“Times New Roman”

安装完成MOSS 2007，并运行配置向导后，管理中心首页显示“服务器场配置未完成”。然后单击“操作”链接，选择“拓扑结构和服务”下的“服务器上的服务”，“Office SharePoint Server 搜索”服务是“已停止”状态。单击“启动”链接，进入配置界面。填写完各项信息后单击“开始”，提示错误信息：“用户界面中发生未处理的异常。异常信息: OSearch (Administrator)”。经查找资料，发现是用户名和密码输入不正确的缘故。这里的用户名和密码就是在安装过程中系统提示你输入的windows账户名和密码，但是要在用户名前加上本机名或域名称。如

场景：在Visual Studio 2005中，给ASP.Net控件重命名时，提示“目录名无效”，并且不能重命名。解决办法：采用下列措施之一即可。a. 重启Visual Studio 2005；b. 切换到HTML（源）模式下，修改控件的ID属性值；c. 重新启动操作系统。[@more@]

打开Visual Studio 2005 Solution时，提示以下错误信息：“项目文件已被重命名或已不在解决方案中”。原因可能是solution中引用的proj文件路径与本地环境不一致，导致找不到项目文件。解决办法：把出错项目先从solution中移除；如果项目文件确实存在，重新加入到现有solution中就可以了。[@more@]