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;
            
        }
    }
}
posted on 2008-09-06 21:46  晃晃悠悠  阅读(1096)  评论(1)    收藏  举报