`
bailangfei3344
  • 浏览: 43741 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论
文章列表
  using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.IO; public partial class _Default ...
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- ============================================= -- Author: 华岭 -- Create date: 2008-10-28 -- Description: 将表数据生成Insert脚本 -- Demo : exec pCreateInsertScript 'BexmCodeType','dictypeid = 61' -- ========================================== ...
  stuff((select ','+ltrim(pu_id) from v_prod_unit where UnitCode in ('P1_Down','P2_Dwon') for xml path('')),1,1,'')  
  create function dbo.splitFuhao(@CID nvarchar(2000), @delimiter nchar) returns varchar(60) as begin declare @idx as int declare @count as int declare @tempCID as varchar(50) declare @tempt as varchar(50) declare @t as varchar(50) set @count = 1 set @t = '' while len(@CID) > 0 begin ...

使用游标 SQL

    博客分类:
  • SQL
  declare my_cursor cursor scroll for select pf_id,BedshaftMeter,WatchSpindleMeter,result from UDT_PaperFault where event_num = @event_num open my_cursor fetch next from my_cursor into @pf_id,@BedshaftMeter,@WatchSpindleMeter,@result while(@@fetch_status=0) begin if(@result='T ...
     改变属性值时触发事件 public class ValueChangeTest { public event EventHandler PropertyChanged; private string strValue; public string StrValue { set { this.strValue = value; OnPropertyChanged(new Event ...
压缩(ProgressBar pbFile是进度条控件) public static void ZipFile(string strFile, string strZip, ProgressBar pbFile) { if (strFile[strFile.Length - 1] != Path.DirectorySeparatorChar) strFile += Path.DirectorySeparatorChar; ZipOutputStream s = new ZipOutpu ...
    复制文件夹 public static void CopyDirectory(string sourceDirName, string destDirName, ProgressBar pbFile) { if (!Directory.Exists(destDirName)) { Directory.CreateDirectory(destDirName); File.SetAttributes(destDirName, File.GetA ...
  前几天项目上用到了水晶报表的条码打印功能 最开始用的字体,code39 code128都试了,可以正常打印,但是扫描枪不识别, 据说code39值两边加*可以扫描到,我没能成功 又在网上找到以下方法,可以打印和扫描。   大致思路 ...
             08年来北京,高中之后就没念书,来北京培训软件开发,10年参加工作直到现在,             慢慢知道学历对于像我这种脑袋不灵光,没啥上进心的人很重要             现在想再开始念书,念个成人的,二月了,不知道能不能不考试,直接去念呢?专科~~             我今年21,男
        using System; using System.Collections.Generic; using System.Text; using System.IO; using System.Security.Cryptography; namespace Ship.GlobalMethod { public class SymmetricMethod { private SymmetricAlgorithm mobjCryptoService; private string Key; ...
  添加DLL报这个错误的时候   类型Universe无法解析程序集:System.Design,Version=2.0.0.0,Culture=neutral,PublickeyToken=b03f5f7f11d50a3a   需要右键【解决方案资源管理器】的项目名,进入属性页面,修改【目标框架】的.Net Framework 4 Client Profile 为 .Net Framework 4 就不会报错了
  Dim xDoc As New DOMDocument30 Dim root As IXMLDOMElement Dim s As String Dim j As Integer, N As Integer xDoc.async = False '获取数据     xDoc.loadXML (strXml) 'xDoc.load(xmlFileName) 'c:\test.xml N = xDoc.documentElement.childNodes.Length Dim x As ...
  1. 用OLE的方法为工作表添加控件,返回值是OLEObject,返回值 .object就是被添加控件的类型,例如下面这个添加一个图表控件,myTChart 就是被添加控件,可以设置相关属性和调用方法 dim oleObject as OLEObject dim myTChart as TeeChart.TChart set oleObject = ActiveSheet.OLEObjects.Add(ClassType:="TeeChart.TChart.8", Link:=False, _ DisplayAsIcon:=False, Left:=Acti ...
调用Process类,strFileName是被调用exe文件的路径 public void CallSteven(string strFileName) { System.Diagnostics.Process prc = new System.Diagnostics.Process(); try { prc.StartInfo.FileName = strFileName; prc.Start(); } ...
Global site tag (gtag.js) - Google Analytics