摘要：Mysql操作 -- [待续]using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Data.SqlClient;using MySql.Data.MySqlClient;using System.Text.RegularExpressions;namespace importTxtToMysql{ class oMySql { //private static String mysqlcon = ... 阅读全文

摘要：之前用PHP写了一个库存的网站，写得太差的了不能算网站，用的数据库是MYSQL5.几的。用的全是utf8编码在C#里连接MYSQL ，开始用的是MySQLDriverCS 但是连接进去，显示中文时乱码。在网上查了下用MySQL Connector Net 这个就正常了。[官网有得下]用法与sqlclient里的自带函数一样。注意：要在添加引用里引用 Mysql.Datausing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;u 阅读全文

摘要：<?xml version="1.0" encoding="utf-8" ?><configuration> <connectionStrings> <add name = "myconnstr" connectionString="server=192.168.15.175;database=wentest;user id=sa;password=19831221" providerName="System.Data.SqlClient"/> & 阅读全文

摘要：简单分页using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace opdata{ public partial class Form1 : Form { private static String con... 阅读全文

摘要：先在MSSQL创建一个分页存储过程：use wentestif exists(select * from sys.sysobjects where type='p' and name='myfy_one') drop procedure myfy_onegocreate procedure myfy_one @size int, --每页大小 @number int --分页编码with encryption --加密asbegin --declare @sql varchar(256) declare @did datetime declare @curr.. 阅读全文

摘要：建一个表，主键为varchar型，从00000 开始，每一条加1MSSQL代码以下：declare @autoid varchar(20),@name varchar(50),@addr varchar(256)declare @i int,@cnum int,@tempi intdeclare @dt datetimedeclare @min30 datetimeset @min30 =GETDATE()set @i=0select @cnum = COUNT(*) from adonetif @cnum=0 begin while @i<200000 b... 阅读全文