MSsql每天自动备份数据库每天自动清除log
作者:admin 日期:2009-02-15
1、每日自动备份
打开企业管理器，进入“管理”-“数据库维护计划”，在右侧窗口点击右键，选择“新建维护计划”，启动“数据库维护计划向导”;点击“下一步”选择需要维护的数据库，维护特性数据库时，选择最后一个单选框并勾选需要维护的数据库名称;“下一步”选择更新数据优化信息、“下一步”检查数据库完整性、“下一步”指定数据库备份计划、“下一步”指定备份存放位置、“下一步”指定事务日志备份计划、“下一步”指定报表，“下一步”指定历史纪录维护，最后设定维护作业名称;通常来说，如果只需要备份数据库文件，则只需要指定备份计划以及存放位置即可，其他项目不做改动。
在指定备份计划时候，由于需要每日备份，因此要更改调度。点击“更改”编辑调度。发生频率选择每天;每日频率选择作业开始时间，最好选择数据库访问量小时进行，多为半夜时间，可根据流量图确定具体时间;持续时间通常不用做改动，开始日期为编辑日期，无结束日期。
编辑好上述维护计划后，还要注意下 sql server代理服务是否启动了，因为每日调度维护计划是要启动这个服务才能执行的。如果该服务没有启动，需要手动启动一下，这是可以在其子项“作业”中看到刚刚添加过的数据库维护计划。
2、定期自动清理数据库日志文件
数据库日志文件是随着时间增长而增长的，如果长时间不清理，文件会变得特别大，因此需要定期清空，但是日至文件是恢复数据库的重要依据，不用日志文件也是不明智的。手工清除单个数据库的还好说，但数据库多了，或者临时没有来得及清理，可能硬盘空间就会占满了，影响访问。因此设置自动清理数据库日志文件还是比较实用的。
手动清理方法：右键单击需要清理的数据库，选择“属性”，在“选项”卡上，把故障还原模型设定为简单，确定后关闭;再右键单击该数据库，“所有任务”-“收缩数据库”，确认后即可清除日志文件，最后记得重新选择“属性”，将故障还原模型设置为完全。
自动清理方法：同样是利用sql server代理服务，执行自动作业。
打开企业管理器，进入“管理”-“sql server代理服务”-“作业”，在右侧窗口点击右键，选择“新建作业”。“常规”选项卡中，填写作业名称，具体描述，注意所有者最好还是用sa或者默认的管理帐号。
转到“步骤”选项卡，新建作业步骤，填写步骤名称，类型为脚本，数据库为需要清理日志的数据库，在下边命令中填写以下命令：
DUMP TRANSACTION 数据库名称 WITH NO_LOG
DBCC SHRINKFILE(数据库日志文件名,1)
上边的数据库名称填写需要维护的数据库名称，数据库日志文件名填写其对应的日志文件名，注意，不是资源管理器里看到的带后缀名的那个名字，而是企业管理器里，数据库属性里日志选项卡中日志的名字(通常也只是差一个后缀名……)，确定后添加一个作业步骤。 如果需要维护多个数据库，用上述方法重复添加作业步骤，注意每个步骤成功或失败后的动作即可，最后选择一下开始的步骤。
在“调度”选项卡中，类似备份的维护计划，填写调度周期，即定期清理的周期，不再细述。如果需要，可以在最后的“通知”选项卡上设置作业完成后的通知项，需要设置操作员，以及设置相应的服务，这里也不具体说明了，通常不用……
Asp.net生成静态页面
作者:admin 日期:2009-02-15
环境:Microsoft .NET Framework 2.0
OS:Windows Server 2008 中文版
ASP.Net生成静态HTML页
在Asp中实现的生成静态页用到的FileSystemObject对象!
在.Net中涉及此类操作的是System.IO
以下是程序代码 //生成HTML页
public static bool WriteFile(string strText,string strContent,string strAuthor)
{
string path = HttpContext.Current.Server.MapPath("/news/");
Encoding code = Encoding.GetEncoding("gb2312");
// 读取模板文件
string temp = HttpContext.Current.Server.MapPath("/news/text.html");
StreamReader sr=null;
StreamWriter sw=null;
string str="";
try
{
sr = new StreamReader(temp, code);
str = sr.ReadToEnd(); // 读取文件
}
catch(Exception exp)
{
HttpContext.Current.Response.Write(exp.Message);
HttpContext.Current.Response.End();
sr.Close();
}
string htmlfilename=DateTime.Now.ToString("yyyyMMddHHmmss")+".html";
// 替换内容
// 这时,模板文件已经读入到名称为str的变量中了
str =str.Replace("ShowArticle",strText); //模板页中的ShowArticle
str = str.Replace("biaoti",strText);
str = str.Replace("content",strContent);
str = str.Replace("author",strAuthor);
// 写文件
try
{
sw = new StreamWriter(path + htmlfilename , false, code);
sw.Write(str);
sw.Flush();
}
catch(Exception ex)
{
HttpContext.Current.Response.Write(ex.Message);
HttpContext.Current.Response.End();
}
finally
{
sw.Close();
}
return true;
此函数放在Conn.CS基类中了
在添加新闻的代码中引用 注：工程名为Hover
if(Hover.Conn.WriteFilethis.Title.Text.ToString),this.Content.Text.ToString),this.Author.Text.ToString)))
{
Response.Write("添加成功");
}
else
{
Response.Write("生成HTML出错!");
}
-------------------------------------------------------------------------
模板页Text.html代码
-------------------------------------------------------------------------
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>ShowArticle</title>
<body>
biaoti
<br>
content<br>
author
</body>
</HTML>
------------------------------------------------------------------------
提示添加成功后会出以当前时间为文件名的html文件!上面只是把传递过来的几个参数直接写入了HTML文件中,在实际应用中需要先添加数据库，然后再写入HTML文件
而且需要把生成的文件名等写入数库以便以后调用等，此实例只是实现了根据提交过来参数替换模板中的相应的字段!
PHPCMS的地区表
作者:admin 日期:2009-02-15
在PHPCMS中使用了地区字段，但是系统自带的只有两个地区。参考论坛上 tchjoseph 发布的方法，这里说明一下如果添加完整的中国地区列表到系统中。包含市区及以上行政单位。
利用PHPCMS的自带SQL工具执行下面两个语句（经测试似乎PHPCMS都自带工具只能一条一条的执行）：执行完后利用系统设置 ---> 系统工具 ---> 刷新缓存。
说明：本方法适用于2008.10.31后发布的版本，与以前PHPCMS版本的差别是area表中删除了`hits_day`, `hits_week`, `hits_month`这三个字段。
如果嫌麻烦，可以在这里下载.sql备份文件，直接从系统设置 ---> 数据库管理 ---> 数据库恢复 中导入。
1.清空表中原有的两个地址：
TRUNCATE TABLE `phpcms_area` ;
Insert INTO `phpcms_area` (`areaid`, `name`, `style`, `parentid`, `arrparentid`, `child`, `arrchildid`, `template`, `listorder`, `hits`) VALUES
(1, '北京市', '', 0, '0', 1, '1,52', 'area', 1, 0),
(2, '天津市', '', 0, '0', 1, '2,70', 'area', 2, 0),
(3, '河北省', '', 0, '0', 1, '3,81', 'area', 3, 0),
(4, '山西省', '', 0, '0', 1, '4,92', 'area', 4, 0),
(5, '内蒙古自治区', '', 0, '0', 1, '5,104', 'area', 5, 0),
(6, '辽宁省', '', 0, '0', 1, '6,118', 'area', 6, 0),
(7, '吉林省', '', 0, '0', 1, '7,127', 'area', 7, 0),
(8, '黑龙江省', '', 0, '0', 1, '8,141', 'area', 8, 0),
(9, '上海市', '', 0, '0', 1, '9,160', 'area', 9, 0),
(10, '江苏省', '', 0, '0', 1, '10,173', 'area', 10, 0),
(11, '浙江省', '', 0, '0', 1, '11,184', 'area', 11, 0),
(12, '安徽省', '', 0, '0', 1, '12,201', 'area', 12, 0),
(13, '福建省', '', 0, '0', 1, '13,210', 'area', 13, 0),
(14, '江西省', '', 0, '0', 1, '14,221', 'area', 14, 0),
(15, '山东省', '', 0, '0', 1, '15,238', 'area', 15, 0),
(16, '河南省', '', 0, '0', 1, '16,255', 'area', 16, 0),
(17, '湖北省', '', 0, '0', 1, '17,268', 'area', 17, 0),
(18, '湖南省', '', 0, '0', 1, '18,282', 'area', 18, 0),
(19, '广东省', '', 0, '0', 1, '19,303', 'area', 19, 0),
(20, '广西壮族自治区', '', 0, '0', 1, '20,304,305,306,307,308,309,310,311,312,313,314,315,316,317', 'area', 20, 0),
(21, '海南省', '', 0, '0', 1, '21,318,319', 'area', 21, 0),
(22, '重庆市', '', 0, '0', 1, '22,359', 'area', 22, 0),
(23, '四川省', '', 0, '0', 1, '23,380', 'area', 23, 0),
(24, '贵州省', '', 0, '0', 1, '24,389', 'area', 24, 0),
(25, '云南省', '', 0, '0', 1, '25,405', 'area', 25, 0),
(26, '西藏自治区', '', 0, '0', 1, '26,412', 'area', 26, 0),
(27, '陕西省', '', 0, '0', 1, '27,422', 'area', 27, 0),
(28, '甘肃省', '', 0, '0', 1, '28,436', 'area', 28, 0),
(29, '青海省', '', 0, '0', 1, '29,444', 'area', 29, 0),
(30, '宁夏回族自治区', '', 0, '0', 1, '30,449', 'area', 30, 0),
(31, '新疆维吾尔自治区', '', 0, '0', 1, '31,463', 'area', 31, 0),
(32, '台湾省', '', 0, '0', 0, '32', 'area', 32, 0),
(33, '香港特别行政区', '', 0, '0', 0, '33', 'area', 33, 0),
(34, '澳门特别行政区', '', 0, '0', 0, '34', 'area', 34, 0),
(35, '东城区', '', 1, '0,1', 0, '35', 'area', 35, 0),
(36, '西城区', '', 1, '0,1', 0, '36', 'area', 36, 0),
(37, '崇文区', '', 1, '0,1', 0, '37', 'area', 37, 0),
(38, '宣武区', '', 1, '0,1', 0, '38', 'area', 38, 0),
(39, '朝阳区', '', 1, '0,1', 0, '39', 'area', 39, 0),
(40, '丰台区', '', 1, '0,1', 0, '40', 'area', 40, 0),
(41, '石景山区', '', 1, '0,1', 0, '41', 'area', 41, 0),
(42, '海淀区', '', 1, '0,1', 0, '42', 'area', 42, 0),
(43, '门头沟区', '', 1, '0,1', 0, '43', 'area', 43, 0),
(44, '房山区', '', 1, '0,1', 0, '44', 'area', 44, 0),
(45, '通州区', '', 1, '0,1', 0, '45', 'area', 45, 0),
(46, '顺义区', '', 1, '0,1', 0, '46', 'area', 46, 0),
(47, '昌平区', '', 1, '0,1', 0, '47', 'area', 47, 0),
(48, '大兴区', '', 1, '0,1', 0, '48', 'area', 48, 0),
(49, '怀柔区', '', 1, '0,1', 0, '49', 'area', 49, 0),
(50, '平谷区', '', 1, '0,1', 0, '50', 'area', 50, 0),
(51, '密云县', '', 1, '0,1', 0, '51', 'area', 51, 0),
(52, '延庆县', '', 1, '0,1', 0, '52', 'area', 52, 0),
(53, '和平区', '', 2, '0,2', 0, '53', 'area', 53, 0),
(54, '河东区', '', 2, '0,2', 0, '54', 'area', 54, 0),
(55, '河西区', '', 2, '0,2', 0, '55', 'area', 55, 0),
(56, '南开区', '', 2, '0,2', 0, '56', 'area', 56, 0),
(57, '河北区', '', 2, '0,2', 0, '57', 'area', 57, 0),
(58, '红桥区', '', 2, '0,2', 0, '58', 'area', 58, 0),
(59, '塘沽区', '', 2, '0,2', 0, '59', 'area', 59, 0),
(60, '汉沽区', '', 2, '0,2', 0, '60', 'area', 60, 0),
(61, '大港区', '', 2, '0,2', 0, '61', 'area', 61, 0),
(62, '东丽区', '', 2, '0,2', 0, '62', 'area', 62, 0),
(63, '西青区', '', 2, '0,2', 0, '63', 'area', 63, 0),
(64, '津南区', '', 2, '0,2', 0, '64', 'area', 64, 0),
(65, '北辰区', '', 2, '0,2', 0, '65', 'area', 65, 0),
(66, '武清区', '', 2, '0,2', 0, '66', 'area', 66, 0),
(67, '宝坻区', '', 2, '0,2', 0, '67', 'area', 67, 0),
(68, '宁河县', '', 2, '0,2', 0, '68', 'area', 68, 0),
(69, '静海县', '', 2, '0,2', 0, '69', 'area', 69, 0),
(70, '蓟县', '', 2, '0,2', 0, '70', 'area', 70, 0),
(71, '石家庄市', '', 3, '0,3', 0, '71', 'area', 71, 0),
(72, '唐山市', '', 3, '0,3', 0, '72', 'area', 72, 0),
(73, '秦皇岛市', '', 3, '0,3', 0, '73', 'area', 73, 0),
(74, '邯郸市', '', 3, '0,3', 0, '74', 'area', 74, 0),
(75, '邢台市', '', 3, '0,3', 0, '75', 'area', 75, 0),
(76, '保定市', '', 3, '0,3', 0, '76', 'area', 76, 0),
(77, '张家口市', '', 3, '0,3', 0, '77', 'area', 77, 0),
(78, '承德市', '', 3, '0,3', 0, '78', 'area', 78, 0),
(79, '沧州市', '', 3, '0,3', 0, '79', 'area', 79, 0),
(80, '廊坊市', '', 3, '0,3', 0, '80', 'area', 80, 0),
(81, '衡水市', '', 3, '0,3', 0, '81', 'area', 81, 0),
(82, '太原市', '', 4, '0,4', 0, '82', 'area', 82, 0),
(83, '大同市', '', 4, '0,4', 0, '83', 'area', 83, 0),
(84, '阳泉市', '', 4, '0,4', 0, '84', 'area', 84, 0),
(85, '长治市', '', 4, '0,4', 0, '85', 'area', 85, 0),
(86, '晋城市', '', 4, '0,4', 0, '86', 'area', 86, 0),
(87, '朔州市', '', 4, '0,4', 0, '87', 'area', 87, 0),
(88, '晋中市', '', 4, '0,4', 0, '88', 'area', 88, 0),
(89, '运城市', '', 4, '0,4', 0, '89', 'area', 89, 0),
(90, '忻州市', '', 4, '0,4', 0, '90', 'area', 90, 0),
(91, '临汾市', '', 4, '0,4', 0, '91', 'area', 91, 0),
(92, '吕梁市', '', 4, '0,4', 0, '92', 'area', 92, 0),
(93, '呼和浩特市', '', 5, '0,5', 0, '93', 'area', 93, 0),
(94, '包头市', '', 5, '0,5', 0, '94', 'area', 94, 0),
(95, '乌海市', '', 5, '0,5', 0, '95', 'area', 95, 0),
(96, '赤峰市', '', 5, '0,5', 0, '96', 'area', 96, 0),
(97, '通辽市', '', 5, '0,5', 0, '97', 'area', 97, 0),
(98, '鄂尔多斯市', '', 5, '0,5', 0, '98', 'area', 98, 0),
(99, '呼伦贝尔市', '', 5, '0,5', 0, '99', 'area', 99, 0),
(100, '巴彦淖尔市', '', 5, '0,5', 0, '100', 'area', 100, 0),
(101, '乌兰察布市', '', 5, '0,5', 0, '101', 'area', 101, 0),
(102, '兴安盟', '', 5, '0,5', 0, '102', 'area', 102, 0),
(103, '锡林郭勒盟', '', 5, '0,5', 0, '103', 'area', 103, 0),
(104, '阿拉善盟', '', 5, '0,5', 0, '104', 'area', 104, 0),
(105, '沈阳市', '', 6, '0,6', 0, '105', 'area', 105, 0),
(106, '大连市', '', 6, '0,6', 0, '106', 'area', 106, 0),
(107, '鞍山市', '', 6, '0,6', 0, '107', 'area', 107, 0),
(108, '抚顺市', '', 6, '0,6', 0, '108', 'area', 108, 0),
(109, '本溪市', '', 6, '0,6', 0, '109', 'area', 109, 0),
(110, '丹东市', '', 6, '0,6', 0, '110', 'area', 110, 0),
(111, '锦州市', '', 6, '0,6', 0, '111', 'area', 111, 0),
(112, '营口市', '', 6, '0,6', 0, '112', 'area', 112, 0),
(113, '阜新市', '', 6, '0,6', 0, '113', 'area', 113, 0),
(114, '辽阳市', '', 6, '0,6', 0, '114', 'area', 114, 0),
(115, '盘锦市', '', 6, '0,6', 0, '115', 'area', 115, 0),
(116, '铁岭市', '', 6, '0,6', 0, '116', 'area', 116, 0),
(117, '朝阳市', '', 6, '0,6', 0, '117', 'area', 117, 0),
(118, '葫芦岛市', '', 6, '0,6', 0, '118', 'area', 118, 0),
(119, '长春市', '', 7, '0,7', 0, '119', 'area', 119, 0),
(120, '吉林市', '', 7, '0,7', 0, '120', 'area', 120, 0),
(121, '四平市', '', 7, '0,7', 0, '121', 'area', 121, 0),
(122, '辽源市', '', 7, '0,7', 0, '122', 'area', 122, 0),
(123, '通化市', '', 7, '0,7', 0, '123', 'area', 123, 0),
(124, '白山市', '', 7, '0,7', 0, '124', 'area', 124, 0),
(125, '松原市', '', 7, '0,7', 0, '125', 'area', 125, 0),
(126, '白城市', '', 7, '0,7', 0, '126', 'area', 126, 0),
(127, '延边朝鲜族自治州', '', 7, '0,7', 0, '127', 'area', 127, 0),
(128, '哈尔滨市', '', 8, '0,8', 0, '128', 'area', 128, 0),
(129, '阿城区', '', 8, '0,8', 0, '129', 'area', 129, 0),
(130, '齐齐哈尔市', '', 8, '0,8', 0, '130', 'area', 130, 0),
(131, '鸡西市', '', 8, '0,8', 0, '131', 'area', 131, 0),
(132, '鹤岗市', '', 8, '0,8', 0, '132', 'area', 132, 0),
(133, '双鸭山市', '', 8, '0,8', 0, '133', 'area', 133, 0),
(134, '大庆市', '', 8, '0,8', 0, '134', 'area', 134, 0),
(135, '伊春市', '', 8, '0,8', 0, '135', 'area', 135, 0),
(136, '佳木斯市', '', 8, '0,8', 0, '136', 'area', 136, 0),
(137, '七台河市', '', 8, '0,8', 0, '137', 'area', 137, 0),
(138, '牡丹江市', '', 8, '0,8', 0, '138', 'area', 138, 0),
(139, '黑河市', '', 8, '0,8', 0, '139', 'area', 139, 0),
(140, '绥化市', '', 8, '0,8', 0, '140', 'area', 140, 0),
(141, '大兴安岭地区', '', 8, '0,8', 0, '141', 'area', 141, 0),
(142, '黄浦区', '', 9, '0,9', 0, '142', 'area', 142, 0),
(143, '卢湾区', '', 9, '0,9', 0, '143', 'area', 143, 0),
(144, '徐汇区', '', 9, '0,9', 0, '144', 'area', 144, 0),
(145, '长宁区', '', 9, '0,9', 0, '145', 'area', 145, 0),
(146, '静安区', '', 9, '0,9', 0, '146', 'area', 146, 0),
(147, '普陀区', '', 9, '0,9', 0, '147', 'area', 147, 0),
(148, '闸北区', '', 9, '0,9', 0, '148', 'area', 148, 0),
(149, '虹口区', '', 9, '0,9', 0, '149', 'area', 149, 0),
(150, '杨浦区', '', 9, '0,9', 0, '150', 'area', 150, 0),
(151, '闵行区', '', 9, '0,9', 0, '151', 'area', 151, 0),
(152, '宝山区', '', 9, '0,9', 0, '152', 'area', 152, 0),
(153, '嘉定区', '', 9, '0,9', 0, '153', 'area', 153, 0),
(154, '浦东新区', '', 9, '0,9', 0, '154', 'area', 154, 0),
(155, '金山区', '', 9, '0,9', 0, '155', 'area', 155, 0),
(156, '松江区', '', 9, '0,9', 0, '156', 'area', 156, 0),
(157, '青浦区', '', 9, '0,9', 0, '157', 'area', 157, 0),
(158, '南汇区', '', 9, '0,9', 0, '158', 'area', 158, 0),
(159, '奉贤区', '', 9, '0,9', 0, '159', 'area', 159, 0),
(160, '崇明县', '', 9, '0,9', 0, '160', 'area', 160, 0),
(161, '南京市', '', 10, '0,10', 0, '161', 'area', 161, 0),
(162, '无锡市', '', 10, '0,10', 0, '162', 'area', 162, 0),
(163, '徐州市', '', 10, '0,10', 0, '163', 'area', 163, 0),
(164, '常州市', '', 10, '0,10', 0, '164', 'area', 164, 0),
(165, '苏州市', '', 10, '0,10', 0, '165', 'area', 165, 0),
(166, '南通市', '', 10, '0,10', 0, '166', 'area', 166, 0),
(167, '连云港市', '', 10, '0,10', 0, '167', 'area', 167, 0),
(168, '淮安市', '', 10, '0,10', 0, '168', 'area', 168, 0),
(169, '盐城市', '', 10, '0,10', 0, '169', 'area', 169, 0),
(170, '扬州市', '', 10, '0,10', 0, '170', 'area', 170, 0),
(171, '镇江市', '', 10, '0,10', 0, '171', 'area', 171, 0),
(172, '泰州市', '', 10, '0,10', 0, '172', 'area', 172, 0),
(173, '宿迁市', '', 10, '0,10', 0, '173', 'area', 173, 0),
(174, '杭州市', '', 11, '0,11', 0, '174', 'area', 174, 0),
(175, '宁波市', '', 11, '0,11', 0, '175', 'area', 175, 0),
(176, '温州市', '', 11, '0,11', 0, '176', 'area', 176, 0),
(177, '嘉兴市', '', 11, '0,11', 0, '177', 'area', 177, 0),
(178, '湖州市', '', 11, '0,11', 0, '178', 'area', 178, 0),
(179, '绍兴市', '', 11, '0,11', 0, '179', 'area', 179, 0),
(180, '金华市', '', 11, '0,11', 0, '180', 'area', 180, 0),
(181, '衢州市', '', 11, '0,11', 0, '181', 'area', 181, 0),
(182, '舟山市', '', 11, '0,11', 0, '182', 'area', 182, 0),
(183, '台州市', '', 11, '0,11', 0, '183', 'area', 183, 0),
(184, '丽水市', '', 11, '0,11', 0, '184', 'area', 184, 0),
(185, '合肥市', '', 12, '0,12', 0, '185', 'area', 185, 0),
(186, '芜湖市', '', 12, '0,12', 0, '186', 'area', 186, 0),
(187, '蚌埠市', '', 12, '0,12', 0, '187', 'area', 187, 0),
(188, '淮南市', '', 12, '0,12', 0, '188', 'area', 188, 0),
(189, '马鞍山市', '', 12, '0,12', 0, '189', 'area', 189, 0),
(190, '淮北市', '', 12, '0,12', 0, '190', 'area', 190, 0),
(191, '铜陵市', '', 12, '0,12', 0, '191', 'area', 191, 0),
(192, '安庆市', '', 12, '0,12', 0, '192', 'area', 192, 0),
(193, '黄山市', '', 12, '0,12', 0, '193', 'area', 193, 0),
(194, '滁州市', '', 12, '0,12', 0, '194', 'area', 194, 0),
(195, '阜阳市', '', 12, '0,12', 0, '195', 'area', 195, 0),
(196, '宿州市', '', 12, '0,12', 0, '196', 'area', 196, 0),
(197, '巢湖市', '', 12, '0,12', 0, '197', 'area', 197, 0),
(198, '六安市', '', 12, '0,12', 0, '198', 'area', 198, 0),
(199, '亳州市', '', 12, '0,12', 0, '199', 'area', 199, 0),
(200, '池州市', '', 12, '0,12', 0, '200', 'area', 200, 0),
(201, '宣城市', '', 12, '0,12', 0, '201', 'area', 201, 0),
(202, '福州市', '', 13, '0,13', 0, '202', 'area', 202, 0),
(203, '厦门市', '', 13, '0,13', 0, '203', 'area', 203, 0),
(204, '莆田市', '', 13, '0,13', 0, '204', 'area', 204, 0),
(205, '三明市', '', 13, '0,13', 0, '205', 'area', 205, 0),
(206, '泉州市', '', 13, '0,13', 0, '206', 'area', 206, 0),
(207, '漳州市', '', 13, '0,13', 0, '207', 'area', 207, 0),
(208, '南平市', '', 13, '0,13', 0, '208', 'area', 208, 0),
(209, '龙岩市', '', 13, '0,13', 0, '209', 'area', 209, 0),
(210, '宁德市', '', 13, '0,13', 0, '210', 'area', 210, 0),
(211, '南昌市', '', 14, '0,14', 0, '211', 'area', 211, 0),
(212, '景德镇市', '', 14, '0,14', 0, '212', 'area', 212, 0),
(213, '萍乡市', '', 14, '0,14', 0, '213', 'area', 213, 0),
(214, '九江市', '', 14, '0,14', 0, '214', 'area', 214, 0),
(215, '新余市', '', 14, '0,14', 0, '215', 'area', 215, 0),
(216, '鹰潭市', '', 14, '0,14', 0, '216', 'area', 216, 0),
(217, '赣州市', '', 14, '0,14', 0, '217', 'area', 217, 0),
(218, '吉安市', '', 14, '0,14', 0, '218', 'area', 218, 0),
(219, '宜春市', '', 14, '0,14', 0, '219', 'area', 219, 0),
(220, '抚州市', '', 14, '0,14', 0, '220', 'area', 220, 0),
(221, '上饶市', '', 14, '0,14', 0, '221', 'area', 221, 0),
(222, '济南市', '', 15, '0,15', 0, '222', 'area', 222, 0),
(223, '青岛市', '', 15, '0,15', 0, '223', 'area', 223, 0),
(224, '淄博市', '', 15, '0,15', 0, '224', 'area', 224, 0),
(225, '枣庄市', '', 15, '0,15', 0, '225', 'area', 225, 0),
(226, '东营市', '', 15, '0,15', 0, '226', 'area', 226, 0),
(227, '烟台市', '', 15, '0,15', 0, '227', 'area', 227, 0),
(228, '潍坊市', '', 15, '0,15', 0, '228', 'area', 228, 0),
(229, '济宁市', '', 15, '0,15', 0, '229', 'area', 229, 0),
(230, '泰安市', '', 15, '0,15', 0, '230', 'area', 230, 0),
(231, '威海市', '', 15, '0,15', 0, '231', 'area', 231, 0),
(232, '日照市', '', 15, '0,15', 0, '232', 'area', 232, 0),
(233, '莱芜市', '', 15, '0,15', 0, '233', 'area', 233, 0),
(234, '临沂市', '', 15, '0,15', 0, '234', 'area', 234, 0),
(235, '德州市', '', 15, '0,15', 0, '235', 'area', 235, 0),
(236, '聊城市', '', 15, '0,15', 0, '236', 'area', 236, 0),
(237, '滨州市', '', 15, '0,15', 0, '237', 'area', 237, 0),
(238, '菏泽市', '', 15, '0,15', 0, '238', 'area', 238, 0),
(239, '郑州市', '', 16, '0,16', 0, '239', 'area', 239, 0),
(240, '开封市', '', 16, '0,16', 0, '240', 'area', 240, 0),
(241, '洛阳市', '', 16, '0,16', 0, '241', 'area', 241, 0),
(242, '平顶山市', '', 16, '0,16', 0, '242', 'area', 242, 0),
(243, '安阳市', '', 16, '0,16', 0, '243', 'area', 243, 0),
(244, '鹤壁市', '', 16, '0,16', 0, '244', 'area', 244, 0),
(245, '新乡市', '', 16, '0,16', 0, '245', 'area', 245, 0),
(246, '焦作市', '', 16, '0,16', 0, '246', 'area', 246, 0),
(247, '濮阳市', '', 16, '0,16', 0, '247', 'area', 247, 0),
(248, '许昌市', '', 16, '0,16', 0, '248', 'area', 248, 0),
(249, '漯河市', '', 16, '0,16', 0, '249', 'area', 249, 0),
(250, '三门峡市', '', 16, '0,16', 0, '250', 'area', 250, 0),
(251, '南阳市', '', 16, '0,16', 0, '251', 'area', 251, 0),
(252, '商丘市', '', 16, '0,16', 0, '252', 'area', 252, 0),
(253, '信阳市', '', 16, '0,16', 0, '253', 'area', 253, 0),
(254, '周口市', '', 16, '0,16', 0, '254', 'area', 254, 0),
(255, '驻马店市', '', 16, '0,16', 0, '255', 'area', 255, 0),
(256, '武汉市', '', 17, '0,17', 0, '256', 'area', 256, 0),
(257, '黄石市', '', 17, '0,17', 0, '257', 'area', 257, 0),
(258, '十堰市', '', 17, '0,17', 0, '258', 'area', 258, 0),
(259, '宜昌市', '', 17, '0,17', 0, '259', 'area', 259, 0),
(260, '襄樊市', '', 17, '0,17', 0, '260', 'area', 260, 0),
(261, '鄂州市', '', 17, '0,17', 0, '261', 'area', 261, 0),
(262, '荆门市', '', 17, '0,17', 0, '262', 'area', 262, 0),
(263, '孝感市', '', 17, '0,17', 0, '263', 'area', 263, 0),
(264, '荆州市', '', 17, '0,17', 0, '264', 'area', 264, 0),
(265, '黄冈市', '', 17, '0,17', 0, '265', 'area', 265, 0),
(266, '咸宁市', '', 17, '0,17', 0, '266', 'area', 266, 0),
(267, '随州市', '', 17, '0,17', 0, '267', 'area', 267, 0),
(268, '恩施土家族苗族自治州', '', 17, '0,17', 0, '268', 'area', 268, 0),
(269, '长沙市', '', 18, '0,18', 0, '269', 'area', 269, 0),
(270, '株洲市', '', 18, '0,18', 0, '270', 'area', 270, 0),
(271, '湘潭市', '', 18, '0,18', 0, '271', 'area', 271, 0),
(272, '衡阳市', '', 18, '0,18', 0, '272', 'area', 272, 0),
(273, '邵阳市', '', 18, '0,18', 0, '273', 'area', 273, 0),
(274, '岳阳市', '', 18, '0,18', 0, '274', 'area', 274, 0),
(275, '常德市', '', 18, '0,18', 0, '275', 'area', 275, 0),
(276, '张家界市', '', 18, '0,18', 0, '276', 'area', 276, 0),
(277, '益阳市', '', 18, '0,18', 0, '277', 'area', 277, 0),
(278, '郴州市', '', 18, '0,18', 0, '278', 'area', 278, 0),
(279, '永州市', '', 18, '0,18', 0, '279', 'area', 279, 0),
(280, '怀化市', '', 18, '0,18', 0, '280', 'area', 280, 0),
(281, '娄底市', '', 18, '0,18', 0, '281', 'area', 281, 0),
(282, '湘西土家族苗族自治州', '', 18, '0,18', 0, '282', 'area', 282, 0),
(283, '广州市', '', 19, '0,19', 0, '283', 'area', 283, 0),
(284, '韶关市', '', 19, '0,19', 0, '284', 'area', 284, 0),
(285, '深圳市', '', 19, '0,19', 0, '285', 'area', 285, 0),
(286, '珠海市', '', 19, '0,19', 0, '286', 'area', 286, 0),
(287, '汕头市', '', 19, '0,19', 0, '287', 'area', 287, 0),
(288, '佛山市', '', 19, '0,19', 0, '288', 'area', 288, 0),
(289, '江门市', '', 19, '0,19', 0, '289', 'area', 289, 0),
(290, '湛江市', '', 19, '0,19', 0, '290', 'area', 290, 0),
(291, '茂名市', '', 19, '0,19', 0, '291', 'area', 291, 0),
(292, '肇庆市', '', 19, '0,19', 0, '292', 'area', 292, 0),
(293, '惠州市', '', 19, '0,19', 0, '293', 'area', 293, 0),
(294, '梅州市', '', 19, '0,19', 0, '294', 'area', 294, 0),
(295, '汕尾市', '', 19, '0,19', 0, '295', 'area', 295, 0),
(296, '河源市', '', 19, '0,19', 0, '296', 'area', 296, 0),
(297, '阳江市', '', 19, '0,19', 0, '297', 'area', 297, 0),
(298, '清远市', '', 19, '0,19', 0, '298', 'area', 298, 0),
(299, '东莞市', '', 19, '0,19', 0, '299', 'area', 299, 0),
(300, '中山市', '', 19, '0,19', 0, '300', 'area', 300, 0),
(301, '潮州市', '', 19, '0,19', 0, '301', 'area', 301, 0),
(302, '揭阳市', '', 19, '0,19', 0, '302', 'area', 302, 0),
(303, '云浮市', '', 19, '0,19', 0, '303', 'area', 303, 0),
(304, '南宁市', '', 20, '0,20', 0, '304', 'area', 304, 0),
(305, '柳州市', '', 20, '0,20', 0, '305', 'area', 305, 0),
(306, '桂林市', '', 20, '0,20', 0, '306', 'area', 306, 0),
(307, '梧州市', '', 20, '0,20', 0, '307', 'area', 307, 0),
(308, '北海市', '', 20, '0,20', 0, '308', 'area', 308, 0),
(309, '防城港市', '', 20, '0,20', 0, '309', 'area', 309, 0),
(310, '钦州市', '', 20, '0,20', 0, '310', 'area', 310, 0),
(311, '贵港市', '', 20, '0,20', 0, '311', 'area', 311, 0),
(312, '玉林市', '', 20, '0,20', 0, '312', 'area', 312, 0),
(313, '百色市', '', 20, '0,20', 0, '313', 'area', 313, 0),
(314, '贺州市', '', 20, '0,20', 0, '314', 'area', 314, 0),
(315, '河池市', '', 20, '0,20', 0, '315', 'area', 315, 0),
(316, '来宾市', '', 20, '0,20', 0, '316', 'area', 316, 0),
(317, '崇左市', '', 20, '0,20', 0, '317', 'area', 317, 0),
(318, '海口市', '', 21, '0,21', 0, '318', 'area', 318, 0),
(319, '三亚市', '', 21, '0,21', 0, '319', 'area', 319, 0),
(320, '万州区', '', 22, '0,22', 0, '320', 'area', 320, 0),
(321, '涪陵区', '', 22, '0,22', 0, '321', 'area', 321, 0),
(322, '渝中区', '', 22, '0,22', 0, '322', 'area', 322, 0),
(323, '大渡口区', '', 22, '0,22', 0, '323', 'area', 323, 0),
(324, '江北区', '', 22, '0,22', 0, '324', 'area', 324, 0),
(325, '沙坪坝区', '', 22, '0,22', 0, '325', 'area', 325, 0),
(326, '九龙坡区', '', 22, '0,22', 0, '326', 'area', 326, 0),
(327, '南岸区', '', 22, '0,22', 0, '327', 'area', 327, 0),
(328, '北碚区', '', 22, '0,22', 0, '328', 'area', 328, 0),
(329, '万盛区', '', 22, '0,22', 0, '329', 'area', 329, 0),
(330, '双桥区', '', 22, '0,22', 0, '330', 'area', 330, 0),
(331, '渝北区', '', 22, '0,22', 0, '331', 'area', 331, 0),
(332, '巴南区', '', 22, '0,22', 0, '332', 'area', 332, 0),
(333, '黔江区', '', 22, '0,22', 0, '333', 'area', 333, 0),
(334, '长寿区', '', 22, '0,22', 0, '334', 'area', 334, 0),
(335, '江津区', '', 22, '0,22', 0, '335', 'area', 335, 0),
(336, '合川区', '', 22, '0,22', 0, '336', 'area', 336, 0),
(337, '永川区', '', 22, '0,22', 0, '337', 'area', 337, 0),
(338, '南川区', '', 22, '0,22', 0, '338', 'area', 338, 0),
(339, '綦江县', '', 22, '0,22', 0, '339', 'area', 339, 0),
(340, '潼南县', '', 22, '0,22', 0, '340', 'area', 340, 0),
(341, '铜梁县', '', 22, '0,22', 0, '341', 'area', 341, 0),
(342, '大足县', '', 22, '0,22', 0, '342', 'area', 342, 0),
(343, '荣昌县', '', 22, '0,22', 0, '343', 'area', 343, 0),
(344, '璧山县', '', 22, '0,22', 0, '344', 'area', 344, 0),
(345, '梁平县', '', 22, '0,22', 0, '345', 'area', 345, 0),
(346, '城口县', '', 22, '0,22', 0, '346', 'area', 346, 0),
(347, '丰都县', '', 22, '0,22', 0, '347', 'area', 347, 0),
(348, '垫江县', '', 22, '0,22', 0, '348', 'area', 348, 0),
(349, '武隆县', '', 22, '0,22', 0, '349', 'area', 349, 0),
(350, '忠 县', '', 22, '0,22', 0, '350', 'area', 350, 0),
(351, '开 县', '', 22, '0,22', 0, '351', 'area', 351, 0),
(352, '云阳县', '', 22, '0,22', 0, '352', 'area', 352, 0),
(353, '奉节县', '', 22, '0,22', 0, '353', 'area', 353, 0),
(354, '巫山县', '', 22, '0,22', 0, '354', 'area', 354, 0),
(355, '巫溪县', '', 22, '0,22', 0, '355', 'area', 355, 0),
(356, '石柱土家族自治县', '', 22, '0,22', 0, '356', 'area', 356, 0),
(357, '秀山土家族苗族自治县', '', 22, '0,22', 0, '357', 'area', 357, 0),
(358, '酉阳土家族苗族自治县', '', 22, '0,22', 0, '358', 'area', 358, 0),
(359, '彭水苗族土家族自治县', '', 22, '0,22', 0, '359', 'area', 359, 0),
(360, '成都市', '', 23, '0,23', 0, '360', 'area', 360, 0),
(361, '自贡市', '', 23, '0,23', 0, '361', 'area', 361, 0),
(362, '攀枝花市', '', 23, '0,23', 0, '362', 'area', 362, 0),
(363, '泸州市', '', 23, '0,23', 0, '363', 'area', 363, 0),
(364, '德阳市', '', 23, '0,23', 0, '364', 'area', 364, 0),
(365, '绵阳市', '', 23, '0,23', 0, '365', 'area', 365, 0),
(366, '广元市', '', 23, '0,23', 0, '366', 'area', 366, 0),
(367, '遂宁市', '', 23, '0,23', 0, '367', 'area', 367, 0),
(368, '内江市', '', 23, '0,23', 0, '368', 'area', 368, 0),
(369, '乐山市', '', 23, '0,23', 0, '369', 'area', 369, 0),
(370, '南充市', '', 23, '0,23', 0, '370', 'area', 370, 0),
(371, '眉山市', '', 23, '0,23', 0, '371', 'area', 371, 0),
(372, '宜宾市', '', 23, '0,23', 0, '372', 'area', 372, 0),
(373, '广安市', '', 23, '0,23', 0, '373', 'area', 373, 0),
(374, '达州市', '', 23, '0,23', 0, '374', 'area', 374, 0),
(375, '雅安市', '', 23, '0,23', 0, '375', 'area', 375, 0),
(376, '巴中市', '', 23, '0,23', 0, '376', 'area', 376, 0),
(377, '资阳市', '', 23, '0,23', 0, '377', 'area', 377, 0),
(378, '阿坝藏族羌族自治州', '', 23, '0,23', 0, '378', 'area', 378, 0),
(379, '甘孜藏族自治州', '', 23, '0,23', 0, '379', 'area', 379, 0),
(380, '凉山彝族自治州', '', 23, '0,23', 0, '380', 'area', 380, 0),
(381, '贵阳市', '', 24, '0,24', 0, '381', 'area', 381, 0),
(382, '六盘水市', '', 24, '0,24', 0, '382', 'area', 382, 0),
(383, '遵义市', '', 24, '0,24', 0, '383', 'area', 383, 0),
(384, '安顺市', '', 24, '0,24', 0, '384', 'area', 384, 0),
(385, '铜仁地区', '', 24, '0,24', 0, '385', 'area', 385, 0),
(386, '黔西南布依族苗族自治州', '', 24, '0,24', 0, '386', 'area', 386, 0),
(387, '毕节地区', '', 24, '0,24', 0, '387', 'area', 387, 0),
(388, '黔东南苗族侗族自治州', '', 24, '0,24', 0, '388', 'area', 388, 0),
(389, '黔南布依族苗族自治州', '', 24, '0,24', 0, '389', 'area', 389, 0),
(390, '昆明市', '', 25, '0,25', 0, '390', 'area', 390, 0),
(391, '曲靖市', '', 25, '0,25', 0, '391', 'area', 391, 0),
(392, '玉溪市', '', 25, '0,25', 0, '392', 'area', 392, 0),
(393, '保山市', '', 25, '0,25', 0, '393', 'area', 393, 0),
(394, '昭通市', '', 25, '0,25', 0, '394', 'area', 394, 0),
(395, '丽江市', '', 25, '0,25', 0, '395', 'area', 395, 0),
(396, '普洱市(*)', '', 25, '0,25', 0, '396', 'area', 396, 0),
(397, '临沧市', '', 25, '0,25', 0, '397', 'area', 397, 0),
(398, '楚雄彝族自治州', '', 25, '0,25', 0, '398', 'area', 398, 0),
(399, '红河哈尼族彝族自治州', '', 25, '0,25', 0, '399', 'area', 399, 0),
(400, '文山壮族苗族自治州', '', 25, '0,25', 0, '400', 'area', 400, 0),
(401, '西双版纳傣族自治州', '', 25, '0,25', 0, '401', 'area', 401, 0),
(402, '大理白族自治州', '', 25, '0,25', 0, '402', 'area', 402, 0),
(403, '德宏傣族景颇族自治州', '', 25, '0,25', 0, '403', 'area', 403, 0),
(404, '怒江傈僳族自治州', '', 25, '0,25', 0, '404', 'area', 404, 0),
(405, '迪庆藏族自治州', '', 25, '0,25', 0, '405', 'area', 405, 0),
(406, '拉萨市', '', 26, '0,26', 0, '406', 'area', 406, 0),
(407, '昌都地区', '', 26, '0,26', 0, '407', 'area', 407, 0),
(408, '山南地区', '', 26, '0,26', 0, '408', 'area', 408, 0),
(409, '日喀则地区', '', 26, '0,26', 0, '409', 'area', 409, 0),
(410, '那曲地区', '', 26, '0,26', 0, '410', 'area', 410, 0),
(411, '阿里地区', '', 26, '0,26', 0, '411', 'area', 411, 0),
(412, '林芝地区', '', 26, '0,26', 0, '412', 'area', 412, 0),
(413, '西安市', '', 27, '0,27', 0, '413', 'area', 413, 0),
(414, '铜川市', '', 27, '0,27', 0, '414', 'area', 414, 0),
(415, '宝鸡市', '', 27, '0,27', 0, '415', 'area', 415, 0),
(416, '咸阳市', '', 27, '0,27', 0, '416', 'area', 416, 0),
(417, '渭南市', '', 27, '0,27', 0, '417', 'area', 417, 0),
(418, '延安市', '', 27, '0,27', 0, '418', 'area', 418, 0),
(419, '汉中市', '', 27, '0,27', 0, '419', 'area', 419, 0),
(420, '榆林市', '', 27, '0,27', 0, '420', 'area', 420, 0),
(421, '安康市', '', 27, '0,27', 0, '421', 'area', 421, 0),
(422, '商洛市', '', 27, '0,27', 0, '422', 'area', 422, 0),
(423, '兰州市', '', 28, '0,28', 0, '423', 'area', 423, 0),
(424, '嘉峪关市', '', 28, '0,28', 0, '424', 'area', 424, 0),
(425, '金昌市', '', 28, '0,28', 0, '425', 'area', 425, 0),
(426, '白银市', '', 28, '0,28', 0, '426', 'area', 426, 0),
(427, '天水市', '', 28, '0,28', 0, '427', 'area', 427, 0),
(428, '武威市', '', 28, '0,28', 0, '428', 'area', 428, 0),
(429, '张掖市', '', 28, '0,28', 0, '429', 'area', 429, 0),
(430, '平凉市', '', 28, '0,28', 0, '430', 'area', 430, 0),
(431, '酒泉市', '', 28, '0,28', 0, '431', 'area', 431, 0),
(432, '庆阳市', '', 28, '0,28', 0, '432', 'area', 432, 0),
(433, '定西市', '', 28, '0,28', 0, '433', 'area', 433, 0),
(434, '陇南市', '', 28, '0,28', 0, '434', 'area', 434, 0),
(435, '临夏回族自治州', '', 28, '0,28', 0, '435', 'area', 435, 0),
(436, '甘南藏族自治州', '', 28, '0,28', 0, '436', 'area', 436, 0),
(437, '西宁市', '', 29, '0,29', 0, '437', 'area', 437, 0),
(438, '海东地区', '', 29, '0,29', 0, '438', 'area', 438, 0),
(439, '海北藏族自治州', '', 29, '0,29', 0, '439', 'area', 439, 0),
(440, '黄南藏族自治州', '', 29, '0,29', 0, '440', 'area', 440, 0),
(441, '海南藏族自治州', '', 29, '0,29', 0, '441', 'area', 441, 0),
(442, '果洛藏族自治州', '', 29, '0,29', 0, '442', 'area', 442, 0),
(443, '玉树藏族自治州', '', 29, '0,29', 0, '443', 'area', 443, 0),
(444, '海西蒙古族藏族自治州', '', 29, '0,29', 0, '444', 'area', 444, 0),
(445, '银川市', '', 30, '0,30', 0, '445', 'area', 445, 0),
(446, '石嘴山市', '', 30, '0,30', 0, '446', 'area', 446, 0),
(447, '吴忠市', '', 30, '0,30', 0, '447', 'area', 447, 0),
(448, '固原市', '', 30, '0,30', 0, '448', 'area', 448, 0),
(449, '中卫市', '', 30, '0,30', 0, '449', 'area', 449, 0),
(450, '乌鲁木齐市', '', 31, '0,31', 0, '450', 'area', 450, 0),
(451, '克拉玛依市', '', 31, '0,31', 0, '451', 'area', 451, 0),
(452, '吐鲁番地区', '', 31, '0,31', 0, '452', 'area', 452, 0),
(453, '哈密地区', '', 31, '0,31', 0, '453', 'area', 453, 0),
(454, '昌吉回族自治州', '', 31, '0,31', 0, '454', 'area', 454, 0),
(455, '博尔塔拉蒙古自治州', '', 31, '0,31', 0, '455', 'area', 455, 0),
(456, '巴音郭楞蒙古自治州', '', 31, '0,31', 0, '456', 'area', 456, 0),
(457, '阿克苏地区', '', 31, '0,31', 0, '457', 'area', 457, 0),
(458, '克孜勒苏柯尔克孜自治州', '', 31, '0,31', 0, '458', 'area', 458, 0),
(459, '喀什地区', '', 31, '0,31', 0, '459', 'area', 459, 0),
(460, '和田地区', '', 31, '0,31', 0, '460', 'area', 460, 0),
(461, '伊犁哈萨克自治州', '', 31, '0,31', 0, '461', 'area', 461, 0),
(462, '塔城地区', '', 31, '0,31', 0, '462', 'area', 462, 0),
(463, '阿勒泰地区', '', 31, '0,31', 0, '463', 'area', 463, 0);
c#中Split用法
作者:admin 日期:2009-02-05
一、引入命名空间
using System.Text.RegularExpressions;
1、用字符串分隔：
string str="aaajsbbbjsccc";
string[] sArray=Regex.Split(str,"js",RegexOptions.IgnoreCase);
foreach (string i in sArray) Response.Write(i.ToString() + "<br>");
输出结果：
aaa
bbb
ccc
2、用多个字符来分隔：
string str="aaajbbbscccjdddseee";
string[] sArray=str.Split(new char[2]{'j','s'});
foreach(string i in sArray) Response.Write(i.ToString() + "<br>");
输出结果：
aaa
bbb
ccc
ddd
eee
3、用单个字符来分隔：
string str="aaajbbbjccc";
string[] sArray=str.Split('j');
foreach(string i in sArray) Response.Write(i.ToString() + "<br>");
输出结果：
aaa
bbb
ccc
asp.net(C#)用datagrid和datalist显示数据
作者:admin 日期:2009-02-04
SqlConnection con = new SqlConnection("server=(local);uid=sa;pwd=sa;database=your databease");
con.open();
string Provincesql = "Select * FROM table1";
SqlCommand comm = new SqlCommand(Provincesql, conn);
SqlDataReader dr = comm.ExecuteReader();
datagrid1.DataSource = dr;
datagrid1.DataBind();
datalist如下:
SqlConnection con = new SqlConnection("server=(local);uid=sa;pwd=sa;database=your databease");
con.open();
string Provincesql = "Select * FROM table1";
SqlDataAdapter adapter = new SqlDataAdapter(Provincesql, conn);
DataSet ds = new DataSet();
adapter.Fill(ds, "company");
DataList1.DataSource=ds;
DataList1.DataBind();
页面部分的操作如下:
<asp:DataList ID="DataList1" runat="server">
<ItemTemplate>
<%#DataBinder.Eval(Container.DataItem,"field(在table1中的任意字段)") %>
</ItemTemplate>
</asp:DataList>
C# 中文在URL中的编码
作者:admin 日期:2009-02-04
问题来源：
正在研究一个程序，输入一个关键字，能够把这个关键字发送到Google，yahoo等搜索引擎，进行搜索，然后打开结果网页。原理很简单。比如在Google搜索China，搜索结果页面的URL就是“http://www.google.com/search?hl=zh-CN&q=China&lr=”。只要替换红颜色的内容，就可以按照不同的关键字搜索。
但是如果关键字是中文，就会出现问题。比如在google搜索“中国”，Url是“http://www.google.com/search?hl=zh-CN&newwindow=1&q=%E4%B8%AD%E5%9B%BD&lr=”。汉字“中国”被按照UTF-8的格式进行编码。
不仅汉字进行编码，一些特殊字符也会进行编码。比如搜索“C#”，URL是“http://www.google.com/search?hl=zh-CN&newwindow=1&q=C%23&lr=”。
一般来说，国外的网站都是按照UTF-8编码，而“百度”是按照“GB2312”进行编码的。比如搜索“中国”，URL是“http://www.baidu.com/s?wd=%D6%D0%B9%FA&cl=3”
我们对比一下：C#中国的编码
编码 结果 网站
UTF-8 C%23%E4%B8%AD%E5%9B%BD Google
GB2312 C%23%D6%D0%B9%FA BaiDu
总结：
UTF-8中，一个汉字对应三个字节，GB2312中一个汉字占用两个字节。
不论何种编码，字母数字都不编码，特殊符号编码后占用一个字节。
//按照UTF-8进行编码
string tempSearchString1 = System.Web.HttpUtility.UrlEncode("C#中国");
//按照GB2312进行编码
string tempSearchString2 = System.Web.HttpUtility.UrlEncode("C#中国",System.Text.Encoding.GetEncoding("GB2312"));
广告位
