2011年3月1日
C#连接Excel并构建一个新的DataTable
String targetPath = System.IO.Path.GetFullPath(@"..\..\CopyExcel\temp.xls");string excelonstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + targetPath + ";" + "Extended Properties='Excel 8.0;HDR... Read More
posted @ 2011-03-01 14:21 Jon.Zhiwei@hotmail.com Views(287) Comments(0) Diggs(0)
Asp.Net中DropDownList的使用以及条件筛选
private void Init() { string sql = "select cbdisplayvalue,cbvalue from table where cbid="; int typecustomer = 4; int banzu = 5; int pinzhong = 1; string sql_customer = sql + typecustomer; string sql_banzu = sql + banzu; string sql_pinzhong = sql + pinzhong; DbCommand dcmd_customer = dbsqls Read More
posted @ 2011-03-01 09:42 Jon.Zhiwei@hotmail.com Views(1896) Comments(0) Diggs(0)
C#与存储过程
只是日常开发项目中，涉及总结，而项目是基于三层开发。IDataAccess数据访问层接口：using System;using System.Collections.Generic;using System.Text;using System.Data.Common;using Microsoft.Practices.EnterpriseLibrary.Common;using Microsoft.Practices.EnterpriseLibrary.Data;using System.Collections;using System.Data;namespace IDataAccess{ Read More
posted @ 2011-03-01 01:38 Jon.Zhiwei@hotmail.com Views(558) Comments(0) Diggs(0)
20110228jQuery攻略
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xml Read More
posted @ 2011-03-01 01:09 Jon.Zhiwei@hotmail.com Views(175) Comments(0) Diggs(0)