maoyanlong88的专栏

原创 NTLNT.sql

<br />if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Agent]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)<br />drop table [dbo].[Agent]<br />GO<br />if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Code]') and OB

原创 Repeater的使用 前台

<br /><%@ Page Language="C#" AutoEventWireup="true" CodeBehind="FacilityManagement.aspx.cs" Inherits="Web.VIEW.MASTER.FacilityManagement.FacilityManagement" %><br /><%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %><br />

原创 导出数据设置

/// /// 获取Excel的绑定数据 /// 2011/1/17 吕伟 add /// /// public DataSet GetExcelData(String where) { StringBuilder sqlStr = new StringBuilder(); sqlStr.Append(" SELECT"); sqlStr.Append(" tbKFQFZJB.KFQDM,"); //开发区代码 sqlS

原创 导出后台调用

/// /// 导出按钮功能 /// 2011/1/17 limm add /// /// /// protected void btnExport_Click(object sender, EventArgs e) { try { DataSet dsNew = new DataSet

原创 导出

<br />using System;<br />using System.Data;<br />using System.Diagnostics;<br />using System.IO;<br />using System.Reflection;<br />using Microsoft.Office.Interop.Excel;<br />using System.Web;<br />using System.Data.OleDb;<br /><br />namespace DataAccess<b

原创 C# 遍历textboxs 绑定相应数据txt1~txtn

<br />首先：  在前台将textboxs控件的ID 依次写为：txt2~txt96<br />然后：在后台写如下： <br /> 先实例化 ：STYJ_Data styj = new STYJ_Data();<br /> /// <summary><br /> /// 绑定数据<br /> /// 2011/1/11 MYL add<br /> /// </summary><br /> /// <param name="pageIndex"></param><br /> private void Bi

原创 论文

<br />                    <br /><br />南通绿能会员管理系统<br /> <br />用户使用手册<br />v1.2.1<br /> <br /> <br /> <br /> <br /> <br /> <br /> <br />南通华冈计算机系统有限公司<br />NANTONG HUAGANG COMPUTER SYSTEM CO., LTD<br /> <br /> <br /> <br />目录<br />1登录 3<br />2 会员管理 4<br />2.1

原创 关于dropdown调用XML 绑定数据

XML dripdowm

原创 关于XML

XML dripdowm

原创 web.config 连接数据库

<br /><add name="ConnectionString" connectionString="server=172.17.1.220;uid=sa;pwd=as;database=XXXX"/><br /><!--<add name="STPACConnectionString" connectionString="Data Source=S192168001220;Initial Catalog=XXXX;User ID=sa;Password=as" providerName="System

原创 C 中将阿拉伯数字金额装换为中文大写汉字

C#static string ConvertToChinese(double x) { string s = x.ToString("#L#E#D#C#K#E#D#C#J#E#D#C#I#E#D#C#H#E#D#C#G#E#D#C#F#E#D#C#.0B0A"); string d = Regex.Replace(s, @"((?<=-|^)[^1-9]*)|((?'z'0)[0A-E]*((?=[1-9])|(?'-z'(?=[F-L

原创 C#:String.Format数字格式化输出 {0:N2} {0:D2} {0:C2}...

int a = 12345678;   //格式为sring输出//   Label1.Text = string.Format("asdfadsf{0}adsfasdf",a);//   Label2.Text = "asdfadsf"+a.ToString()+"adsfasdf";//   Label1.Text = string.Format("asdfadsf{0:C}a

原创 SQL中char、varchar、text和nchar、nvarchar、ntext的区别

原创 C#实现精确查询和模糊查询

方法一：using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlC