易语言mysql导出access,通过C#将access数据库导出TXT或者Excel文档

[C#] 纯文本查看 复制代码namespace 管理信息系统

{

public partial class 登录日志 : Form

{

OleDbConnection myCon;

OleDbDataAdapter myDataAdapter;

OleDbCommandBuilder myCmdBuilder;

DataSet dataSet;

BindingSource myBS;

DataView mydv;

string strFilter;

public 登录日志()

{

InitializeComponent();

}

private void 登录日志_Load(object sender, EventArgs e)

{

string dB_con = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + @"\\数据库.mdb";

myCon = new OleDbConnection(dB_con);

try

{

myCon.Open();

}

catch

{

MessageBox.Show("DataBase Connection failed.");

}

string sql = "select * from 登录日志";

myDataAdapter = new OleDbDataAdapter(sql, myCon);

myCmdBuilder = new OleDbCommandBuilder(myDataAdapter);

dataSet = new DataSet();

myDataAdapter.Fill(dataSet, "登录日志");

myBS = new BindingSource();

myBS.DataSource = dataSet.Tables[0];

bindingNavigator1.BindingSource = myBS;

dataGridView1.DataSource = myBS;

mydv = new DataView(dataSet.Tables["登录日志"]);

myCon.Close();

strFilter = "";

}

private void toolStripButton2_Click(object sender, EventArgs e)

{

strFilter = "";

if (txtSname.Text != "")

{

if (strFilter == "")

{

strFilter = strFilter + "用户名='" + txtSname.Text + "'";

}

else

{

strFilter = strFilter + " AND " + "用户名='" + txtSname.Text + "'";

}

}

if (strFilter != "")

{

mydv.RowFilter = strFilter;

}

else

{

mydv.RowFilter = "";

}

dataGridView1.DataSource = mydv;

}

private void toolStripButton3_Click(object sender, EventArgs e)

{

txtSname.Text = "";

strFilter = "";

if (strFilter != "")

{

mydv.RowFilter = strFilter;

}

else

{

mydv.RowFilter = "";

}

dataGridView1.DataSource = mydv;

}

}

}