c#文档中心

asp.net(C#)实现SQL2000数据库备份和还原
using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;
public partial class databasemanager : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }
    /// <summary>
    /// 数据库恢复和备份
    /// </summary>

        #region SQL数据库备份
        /// <summary>
        /// SQL数据库备份
        /// </summary>
        /// <param name="ServerIP">SQL服务器IP或(Localhost)</param> ......

FileUp.aspx 页面
1<%@ Page language="c#" Codebehind="FileUp.aspx.cs" AutoEventWireup="false" Inherits="TestCenter.FileUp" %>
2<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
3<HTML>
4 <HEAD>
5    <title>多文件上传</title>
6    <script language="JavaScript">
7    function addFile()
8    {
9     var str = '<INPUT type="file" size="50" NAME="File">'
10     document.getElementById('MyFile').insertAdjacentHTML("beforeEnd",str)
11    }
12    </script>
13 </HEAD>
14 <body>
15    <form id="form1" method="post" runat="server" enctype="multipart/form-data">
16      <div align="center">
17        & ......

<HTML><HEAD><TITLE>WMI Scripting HTML</TITLE>
<META http-equiv=Content-Type c>
<SCRIPT language=JScript event="OnCompleted(hResult,pErrorObject, pAsyncContext)" for=foo>
var MACaddress=unescape(MACAddr);
alert(MACaddress);
document.forms[0].txtMACAddr.value=unescape(MACAddr);
//document.formbar.submit();
</SCRIPT>
<META c name=GENERATOR></HEAD>
<BODY>
<SCRIPT language=JScript event=OnObjectReady(objObject,objAsyncContext) for=foo>
    if(objObject.IPEnabled != null && objObject.IPEnabled != "undefined" && objObject.IPEnabled == true){
        if(objObject.MACAddress != null && objObject.MACAddress != "undefined")
        MACAddr = objObject.MACAddress;
    }
</SCRIPT>
<OBJECT id=locator classid=CLSID:76A64158-CB41-11D1-8B02-00600806D9B6 VIEWASTEXT></OBJEC ......

//tree.aspx.cs
using System;
using System.Data;
using System.Configuration;
using System.Collections;
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.SqlClient;
using System.Threading;

public partial class MenuTree : System.Web.UI.Page
{
    SqlDataAdapter da = null;
    SqlConnection con = new SqlConnection("server=test;database=DQYPSite_oa;uid=sa;pwd=mfeilgm");
    int i = 0;
    int count = 0;
    int proID = 0;
    int column = 0;
    string nextClassParentID;
    string nextnode;
    ArrayList columD = new ArrayList();
    DataSet TreeTable = new DataSet();

    protected void Page_Load(object sender, EventArgs e)
& ......

作者: 王者之剑(http://www.albertsong.com/) 日期: 2008-01-05 22:10
字体大小: 小中大
示例演示了用C#操作MySQL的方法，提供了三个可重用的类MySqlDBUtil,MySqlPageUtil,Page。
本示例由 C#操作Access数据库的简单例子（http://www.albertsong.com/read-56.html）修改而来。
1.首先下载MySQL数据库的.NET驱动
http://dev.mysql.com/get/Downloads/Connector-Net/mysql-connector-net-5.0.8.1-noinstall.zip/from/pick#mirrors
将bin目录里的MySql.Data.dll文件复制到工程目录，并且将dll的引用加入到项目中，这样就可以通过相关的类来操作MySQL数据库了。
using MySql.Data.MySqlClient;
using System.Data;
连接字符串：String connectionString = "server=127.0.0.1;user id=root; password=as; database=albertsong; pooling=false;charset=utf8";
连接字符串中各个项目的意思是很明确的，需要注意的是charset应该设置成和数据库表的charset一致，否则可能出现中文乱码。
然后将整个项目中的OleDb用MySql替换，这样基本上就可以了。不同的是带参数的sql语句，
Access中是
string sql="insert into product(name,quantity,pri ......

1.从http://prdownloads.sourceforge.net/mysqldrivercs/MySQLDriverCS-n-EasyQueryTools-3.0.18.exe?download上下载MySQLDriverCS.
2.把MySQLDriverCS.dll.添加到.net的组件
3.使用方法
下面是创建一个数据库链接:
下面是创建一个数据库链接:
using MySQLDriverCS;
MySQLConnection conn = new MySQLConnection( new MySQLConnectionString("localhost","test","root","").AsString );
conn.Open();
如果你使用的是.net的集成开发环境(visual studio.net)那么在代码中输入MySQLDriverCS后再输入一个”.”就可以看到MySQLDriverCS名称空间中的所有的东西了.
下面是commond:
MySQLCommand cmd;
   cmd = new MySQLDriverCS.MySQLCommand("DROP TABLE IF EXISTS test.mysqldrivercs_test",conn);
   cmd.ExecuteNonQuery();
   cmd.Dispose();

   cmd = new MySQLDriverCS.MySQLCommand("CREATE TABLE test.mysqldrivercs_test("+
    "SettingID tinyint(3) unsigned NOT NULL auto_increment,"+ ......

asp.net(C#)实现SQL2000数据库备份和还原

asp.net(C#)实现SQL2000数据库备份和还原

asp.net(C#)实现SQL2000数据库备份和还原

Asp.net(C#)多文件上传

Asp.net(C#)多文件上传

C# asp.net macaddr

C# asp.net macaddr

C#与SQL Server 2000实现无限级菜单

C#与SQL Server 2000实现无限级菜单

C#操作MySQL数据库的简单例子

C#操作MySQL数据库的简单例子

C# 连接MySql的方法

C# 连接MySql的方法