asp.net×Ô¶¯Éú³É¾²Ì¬Ò³Ãæ´úÂë
asp.net×Ô¶¯Éú³É¾²Ì¬Ò³Ãæ´úÂë
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.IO;
using System.Text;
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string[] format = new string[4];//¶¨ÒåºÍhtmlyem±ê¼ÇÊýĿһÖµÄÊý×é
StringBuilder htmltext = new StringBuilder();
try
{
using (StreamReader sr = new StreamReader("E:/WebSite2/template.htm"))
{
String line;
while ((line = sr.ReadLine()) != null)
{
htmltext.Append(line);
}
sr.Close();
}
}
catch
{
Response.Write("<Script>alert('¶ÁÈ¡Îļþ´íÎó')</Script>");
}
//---------------------¸ø±ê¼ÇÊý×鸳ֵ------------ ¡¡¡¡
format[0] = "background="bg.jpg"";//±³¾°Í¼Æ¬
format[1] = "#990099";//×ÖÌåÑÕÉ«
format[2] = "150px";//×ÖÌå´óС
format[3] = "<marquee>Éú³ÉµÄÄ£°åhtmlÒ³Ãæ</marquee>";//ÎÄ×Ö˵Ã÷www.beijingaoyun.net.ru
//----------Ìæ»»htmÀïµÄ±ê¼ÇΪÄãÏë¼ÓµÄÄÚÈÝ
for (int i = 0; i < 4; i++)
{
htmltext.Replace("$htmlformat[" + i + "]", format);
}
//----------Éú³ÉhtmÎļþ------------------¨D¨D ¡¡¡¡
try
{
using (StreamWriter sw = new StreamWriter("E:/WebSite2/DDD.HTM", false, System.Text.Encoding.GetEncoding("GB2312")))
{
sw.WriteLine(htmltext);
sw.Flush();
sw.Close();
}
}
catch
{
Response.Write("The file could not be wirte:");
}
}
}
Ïà¹ØÎĵµ£º
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.Data.OleDb;
/// <summary>
/// Data ......
protected void Page_Load(object sender, EventArgs e)
{
/*
sql½Å±¾-´´½¨Ñ§Éú±í
create table student(id int,name varchar(50))
......
×î½üÔÚ×öÒ»¸öÍøÕ¾£¬ÏÔʾÊý¾ÝʱΪÁË·½±ãʹÓÃÁËGridView¡£ËäÈ»GridViewÏÔʾÊý¾ÝµÄ¹¦ÄܺÜǿҲºÜ·½±ã£¬µ«ËüµÄÑùʽȴ²¢²»ÃÀ¹Û¡£ÎªÁËʹGridViewµÄÏÔʾÑùʽÃÀ¹ÛһЩ£¬¾³£ÐèÒªÉèÖñíÍ·µÄ±³¾°£¬ÎÒ×ܽá³öµÄ·½·¨ÈçÏ£º
·½·¨Ò»£º
ÔÚGridViewµÄOnRowDataBoundʼþÖÐÉèÖñ³¾°£¬´úÂëÈçÏ£º
protected void GridView1_RowDataBound(ob ......
1. Êý¾Ý¿âµÄ²¿Êð
£¨1£©Èí¼þµÄ°²×°
A. MySql——±ØÐë°²×°ÔÚCÅÌÏ£¬·ñÔò°²×°mysql-connector-net-6.2.2ºóÎÞÕýÈ·ÅäÖÃ
B. mysql-connector-net-6.2.2——½«MySql.Data.dll·ÅÔÚBinÎļþ¼ÐÏÂ
£¨2£©Êý¾Ý¿âµÄµ¼³öµ¼Èë
MySQL-FrontµÄ"Áí´æÎª"¹¦ÄÜ¿ÉÒÔ½«Êý¾Ý¿âµ¼³öΪ.sqlÎļþ£¬È»ºóÔÙͨ¹ýËüÖ±½Óµ¼Èë.sqlÎļþ¿ ......
//ExcelÅúÁ¿µ¼Èëµ½Êý¾Ý¿â
protected void btnUpload_Click(object sender, EventArgs e)
{
string IsXls = System.IO.Path.GetExtension(UploadExcel.FileName.ToString().ToLower ......