¾«Æ·Îĵµ

{

ofDialogFile.InitialDirectory = \;

ofDialogFile.Filter = \; ofDialogFile.RestoreDirectory = true; ofDialogFile.ShowDialog();

txtDRPath.Text = ofDialogFile.FileName.ToString().Trim(); }

private void btnDRevert_Click(object sender, EventArgs e) { try {

datacon.getcom(\ + txtDRPath.Text.Trim() + \);

MessageBox.Show(\Êý¾Ý»¹Ô­³É¹¦£¡\, \Ìáʾ\, MessageBoxButtons.OK, MessageBoxIcon.Information); }

catch (Exception ex) {

MessageBox.Show(ex.Message, \Ìáʾ\, MessageBoxButtons.OK, MessageBoxIcon.Information); } }

private void btnExit_Click(object sender, EventArgs e) {

this.Close(); }

private void frmDataRevert_FormClosed(object sender, FormClosedEventArgs e) {

this.Close(); } }

}

6.3Êý¾Ý±¸·Ý»Ö¸´µ÷ÓÃÎļþDataCon.cs

using System;

using System.Collections.Generic; using System.Text; using System.Data;

using System.Data.SqlClient;

namespace XRX.BaseClass

¾«Æ·Îĵµ

¾«Æ·Îĵµ

{

class DataCon {

#region ½¨Á¢Êý¾Ý¿âÁ¬½Ó ///

/// ·µ»ØSqlConnection¶ÔÏó public SqlConnection getcon() {

string M_str_sqlcon = \id=sa;PWD=\;

SqlConnection myCon = new SqlConnection(M_str_sqlcon); return myCon; }

#endregion

#region Ö´ÐÐSqlCommandÃüÁî ///

/// public void getcom(string M_str_sqlstr) {

SqlConnection sqlcon = this.getcon(); sqlcon.Open();

SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon); sqlcom.ExecuteNonQuery(); sqlcom.Dispose(); sqlcon.Close(); sqlcon.Dispose(); }

#endregion

#region ´´½¨DataSet¶ÔÏó ///

/// /// /// ·µ»ØDataSet¶ÔÏó

public DataSet getds(string M_str_sqlstr, string M_str_table) {

SqlConnection sqlcon = this.getcon();

¾«Æ·Îĵµ