using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace test_db
{
public partial class Form1 : Form
{
string dbfile = "ccd.mdb";
string connstr = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
string userpwd = ";Jet OLEDB:Database Password=123456;Persist Security Info=False;";
public Form1()
{
InitializeComponent();
connstr = connstr + Application.StartupPath +"\\" +dbfile;
connstr = connstr + userpwd;
}
private void buttonX1_Click(object sender, EventArgs e)
{
//MessageBox.Show(connstr);
//OleDbConnection conn = new OleDbConnection(connstr);
//string strSQL = "insert into quickstart (qsort) values('应用程序')";
//SqlExecute(strSQL);
string strSQL = "select * from quickstart";
OleDbDataReader odr = SqlGetReader(strSQL);
if (odr.Read())
{
MessageBox.Show(odr["qsort"].ToString());
}
odr.Close();
odr.Dispose();
}
//执行sql语句
private void SqlExecute(string strSQL)
{
using (OleDbConnection conn = new OleDbConnection(connstr))
{
OleDbCommand command = new OleDbCommand(strSQL, conn);
conn.Open();
command.ExecuteNonQuery();
conn.Close();
}
}
//取得记录集
private OleDbDataReader SqlGetReader(string strSQL)
{
OleDbConnection conn = new OleDbConnection(connstr);
conn.Open();
OleDbCommand command = conn.CreateCommand();
command.CommandText = strSQL;
OleDbDataReader odr = command.ExecuteReader();
return odr;
}
}
}
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace test_db
{
public partial class Form1 : Form
{
string dbfile = "ccd.mdb";
string connstr = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
string userpwd = ";Jet OLEDB:Database Password=123456;Persist Security Info=False;";
public Form1()
{
InitializeComponent();
connstr = connstr + Application.StartupPath +"\\" +dbfile;
connstr = connstr + userpwd;
}
private void buttonX1_Click(object sender, EventArgs e)
{
//MessageBox.Show(connstr);
//OleDbConnection conn = new OleDbConnection(connstr);
//string strSQL = "insert into quickstart (qsort) values('应用程序')";
//SqlExecute(strSQL);
string strSQL = "select * from quickstart";
OleDbDataReader odr = SqlGetReader(strSQL);
if (odr.Read())
{
MessageBox.Show(odr["qsort"].ToString());
}
odr.Close();
odr.Dispose();
}
//执行sql语句
private void SqlExecute(string strSQL)
{
using (OleDbConnection conn = new OleDbConnection(connstr))
{
OleDbCommand command = new OleDbCommand(strSQL, conn);
conn.Open();
command.ExecuteNonQuery();
conn.Close();
}
}
//取得记录集
private OleDbDataReader SqlGetReader(string strSQL)
{
OleDbConnection conn = new OleDbConnection(connstr);
conn.Open();
OleDbCommand command = conn.CreateCommand();
command.CommandText = strSQL;
OleDbDataReader odr = command.ExecuteReader();
return odr;
}
}
}