博文
从ACCESS导出数据到SQL(2007-04-02 11:06:00)
摘要: #region 解压ACCESS文件并插入数据到SQL数据库
protected void Button1_Click(object sender, EventArgs e)
{
if (File1.PostedFile != null)
{
System.Web.HttpFileCollection oFiles;
oFiles = System.Web.HttpContext.Current.Request.Files;
if (oFiles.Count < 1)
{
Response.Write("请选择文件。");
Response.End();
}
&n......
从SQL数据库中导出数据到ACCESS(2007-04-02 10:44:00)
摘要:
/// <summary>
/// WebServiceDataDown 的摘要说明
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class WebServiceDataDown : System.Web.Services.WebService {
public WebServiceDataDown () {
//如果使用设计的组件,请取消注释以下行
//InitializeComponent();
}
#region 导入数据到ACCESS并压缩文件
[WebMethod]
public void LoadDataToAccess()
{
DataSet ds = GetDataFromSQL();
InsertDataToAccess(ds);
WinrarFile();
}
#endregion
#region 从SQL数据库里读取数据
[WebMethod]
&......
C# 利用WinRAR (加密)压缩及解压缩 相关文件夹及文件 (转)(2007-03-24 12:06:00)
摘要:本次示例主要实现:
1.压缩文件夹及其下文件
2.压缩文件夹下文件
3.压缩文件夹及其下文件为rar 还是 zip
4.解压缩
5.加密压缩及解加密压缩
-----------
示例代码如下:
protected void Button1_Click(object sender, EventArgs e)
{
string strtxtPath = "C:\\freezip\\free.txt";
string strzipPath = "C:\\freezip\\free.zip";
System.Diagnostics.Process Process1 = new System.Diagnostics.Process();
Process1.StartInfo.FileName = "Winrar.exe";
Process1.StartInfo.CreateNoWindow = true;
//// 1
////压缩c:\freezip\free.txt(即文件夹及其下文件freezip\free.txt)
////到c:\freezip\free.rar
//strzipPath = "C:\\freezip\\free";//默认压缩方式为 .rar
......