brian2015-CSDN博客

原创分组取最小值的例子

/*分组取最小值的例子找出表中条件为flag=0的，按typeid分组，取title字母最小的一条记录。*/if object_id('tempdb..#A', 'u') is not nulldrop table #Agocreate table #A([id] int,typeid int,title varchar(5),flag int)goin

2014-05-09 07:50:58 974

原创行转列例子

/*行转列例子*/if object_id('tempdb..#score','u') is not nulldrop table #scoregocreate table #score(sname varchar(50),cname varchar(50),score decimal(10,1))goinsert into #score(sname,cname,s

2014-05-09 07:29:18 457

原创 ADO.NET数据更新方法(3)

/// /// 保存/// /// /// public int Save(List list, string empid, bool deleted){ int result = 0; try { if (deleted) //删除模式 { if (Delete(empid))

2014-05-08 09:09:13 526

原创分页存储过程

/// /// 获取分页数据/// readType: 1-数据列表,2-记录总数,3-两者/// public static DataTable GetPagedList(string connectionString, ref Int64 recordCount, Int64 pageSize, Int64 pageIndex, string tableName, string

2014-05-08 08:57:35 525

原创 app.config配置文件

//配置方法 //使用方法1System.Configuration.ConfigurationManager.ConnectionStrings["DBConnectionString1"].ConnectionString;//使用方法2System.Configu

2014-05-08 08:50:24 497

原创 ADO.NET数据更新方法(2)

/// /// ADO.NET数据更新方法(2)/// 适用范围：单表、有主键、不能更新图象列/// public DataSet UpdateByDataSet(DataSet ds,string tableName, string connectionString) { SqlConnection conn = new SqlConnection(connectionS

2014-05-08 08:27:34 485

原创 ADO.NET数据更新方法(1)

public static void BatchUpdate(DataTable dataTable,Int32 batchSize){ string connectionString = GetConnectionString(); using (SqlConnection connection = new SqlConnection(connectionString))

2014-05-08 08:16:10 1227

原创 DataTable转换为List

/// /// DataTable转换为List/// public static IList DataTable2List(DataTable dt){ IList list = new List(); Type type = typeof(T); string piName = ""; foreach (DataRow dr in dt

2014-05-07 22:04:54 394

原创复制DataTable

//////复制DataTable///public static DataTable CopyTable(DataTable srcTable, string rowFilter, string sort){ if (srcTable == null) return null; string oldRowFilter = srcTable.DefaultVie

2014-03-21 09:11:19 369

原创 SqlHelper

using System;using System.Data;using System.Xml;using System.Data.SqlClient;using System.Collections;using System.Text;using System.Configuration;namespace WxLib{ /// ///

2014-03-21 08:52:28 487

brian2015的专栏