基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：78630559

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

下载该实例的同学，如果是64位的系统,可能遇到的问题是：未在本地计算机上注册“Microsoft.Jet.OLEDB.4.0”提供程序。

这是需要的操作是：

1.检测你机子是否装有 office,如果没有可以装个Microsoft Office 2013 Professional Plus 64 位 简体中文 批量授权

这是网址 http://www.oyksoft.com/soft/26541.html  网站网址 http://pan.baidu.com/s/1i3gL3bZ 密码  bm25

2.安装完毕后 再安装个AccessDatabaseEngine_X64

3.安装完毕以后 再将该项目 运行平台选择x86 (因为Microsoft.Jet.OLEDB.4.0 不支持64位操作系统)

4.至此完毕了 

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Media;

namespace 主程序
{
    public partial class Form1 : Form
    {
        //DataSet ds = new DataSet();
        //SqlDataAdapter sdapter = new SqlDataAdapter();

        int rowsAll = 0;//总函数
        int pageAll = 0;//总页数
        int pageNum = 0;//第几页
        int count = 20;//返回函数
        int start = 0;//从第start行开始返回

        string strDataMember = "学生表";
             
        public OleDbConnection oledbconn;
        public DataSet ds;
        public OleDbDataAdapter oledbAdapter;
        


        public Form1()
        {
            InitializeComponent();
        }

     

        private void btnStudent_Click(object sender, EventArgs e)
        {
            //创建连接字符串
            //string connStr = "Data Source=.;Initial Catalog=Demo;Integrated Security=True;User ID=sa;PassWord=123456";

            //DataSet ret = new DataSet();

            //SqlConnection sqlconn = new SqlConnection(connStr);

            //string queryStr = "Select *from Person";

            //SqlDataAdapter adapter = new SqlDataAdapter();

           // SqlCommand sqlcomm = new SqlCommand(queryStr, sqlconn);

            //sqlcomm.CommandType = CommandType.Text;

            //adapter.SelectCommand = sqlcomm;
           // adapter.SelectCommand.Parameters.Add("")
            //adapter.Fill(ret, "Person");

            //dataGridView1.DataSource = ret;
           // dataGridView1.DataSource = ret.Tables["Person"];

            


            //内嵌数据库
            //string dataDir = AppDomain.CurrentDomain.BaseDirectory;
           // if (dataDir.EndsWith(@"\bin\Debug\") || dataDir.EndsWith(@"\bin\Release\"))
            //{
               // dataDir = System.IO.Directory.GetParent(dataDir).Parent.Parent.FullName;
               // AppDomain.CurrentDomain.SetData("DataDirectory", dataDir);
           // }


           // using (SqlConnection sqlcon = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDBFilename=|DataDirectory|\Database1.mdf;integrated Security=True;User Instance=True"))
            //{
               // sqlcon.Open();

               // using (SqlCommand cmd = sqlcon.CreateCommand())
                //{
                    //cmd.CommandText = "insert into Table1(Name) values('ccc')";
                  //  cmd.ExecuteNonQuery();
                //}

            //}


            //System.Media.SoundPlayer simpleSound = new SoundPlayer(@"登录页面.wav");
            // simpleSound.Play();//播放声音

            //创建连接字符串
            String conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=scores.mdb";
            oledbconn = new OleDbConnection(conn);

            ds = new DataSet();
            oledbAdapter = new OleDbDataAdapter("", oledbconn);

           

            if (dataGridView1.DataMember == strDataMember)
            {
                MessageBox.Show(strDataMember   "已经打开！");
                return;
            }

            if (ds.Tables.Contains(strDataMember))
            {
                ds.Tables[strDataMember].Clear();
                dataGridView1.Columns.Clear();
            }


            oledbAdapter.SelectCommand.CommandText = "select * from "   strDataMember;
           //oledbAdapter.Fill(ds, 0, count, strDataMember);
            oledbAdapter.Fill(ds, strDataMember);

            dataGridView1.DataSource = ds.Tables[strDataMember];

            rowsAll = ds.Tables[strDataMember].Rows.Count;

            ds.Clear();
            oledbAdapter.Fill(ds, 0, count, strDataMember);

            dataGridView1.DataSource = ds.Tables[strDataMember];

            dataGridView1.ColumnHeadersDefaultCellStyle.BackColor = Color.LightSeaGreen;


            if (0 == rowsAll)
            {
                lalDownPage.Enabled = false;
                lalUpPage.Enabled = false;
                lalHomePage.Enabled = false;
                lalEndPage.Enabled = false;

                lalPageAll.Text = "共0条记录";
                comPageNum.Items.Add("0"); 
            }
            else
            {
                lalDownPage.Enabled = true;
                lalUpPage.Enabled = true;
                lalHomePage.Enabled = true;
                lalEndPage.Enabled = true;

                lalPageAll.Text = "共" rowsAll.ToString() "条记录";                                         
            
                pageNum = 1;//如果有内容，设置为第一页
                start = 0;

                
            }

            int yushu = rowsAll % count;//是否存在余行
            if (yushu == 0)//不存在余行时设置总页数
            {
                if (rowsAll > 0 && rowsAll <= count)
                {
                    pageAll = 1;
                }
                else
                {
                    pageAll = rowsAll / count;
                }
            }
            else//存在余行时设置总页数
            {
                pageAll = rowsAll / count   1;
            }

            lalPageNum.Text = pageNum.ToString() "/" pageAll.ToString();

            for (int i = 1; i <= pageAll; i  )
            {
                comPageNum.Items.Add(i.ToString());
            } 
            
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            this.dataGridView1.RowsDefaultCellStyle.BackColor = Color.White;
            this.dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.LightSkyBlue;
                        
            lalDownPage.Enabled = false;
            lalUpPage.Enabled = false;
            lalHomePage.Enabled = false;
            lalEndPage.Enabled = false;

            lalPageAll.Text = "共0条记录";
        }

        /// <summary>
        /// 上一页单击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void lalUpPage_Click(object sender, EventArgs e)
        {
            if (pageNum == 0)
            {
                return;
            }
            lalPageNum.Text = pageNum.ToString()   "/"   pageAll.ToString();
            pageNum--;             

           // dataGridView1.FirstDisplayedScrollingRowIndex = pageNum * 20;

            ds.Clear();
            oledbAdapter.Fill(ds, pageNum * 20, count, strDataMember);
            
            dataGridView1.DataSource = ds.Tables[strDataMember];
        }

        /// <summary>
        /// 下一页单击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void lalDownPage_Click(object sender, EventArgs e)
        {
            if (pageNum == pageAll)
            {
                return;
            }         
                       
            //dataGridView1.FirstDisplayedScrollingRowIndex = pageNum * 20;
            ds.Clear();
            oledbAdapter.Fill(ds, pageNum*20, count, strDataMember);
          
            dataGridView1.DataSource = ds.Tables[strDataMember];
            pageNum  ;
            lalPageNum.Text = pageNum.ToString()   "/"   pageAll.ToString();
        }

        /// <summary>
        /// 首页点击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void lalHomePage_Click(object sender, EventArgs e)
        {
            pageNum = 1;
            lalPageNum.Text = pageNum.ToString()   "/"   pageAll.ToString();

           
            //dataGridView1.FirstDisplayedScrollingRowIndex = 0;

            ds.Clear();
            oledbAdapter.Fill(ds, 0, count, strDataMember);
            
            dataGridView1.DataSource = ds.Tables[strDataMember];
        }

        /// <summary>
        /// 尾页单击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void lalEndPage_Click(object sender, EventArgs e)
        {
            pageNum = pageAll;
            lalPageNum.Text = pageNum.ToString()   "/"   pageAll.ToString();

            //dataGridView1.FirstDisplayedScrollingRowIndex = (pageNum-1) * 20;

            ds.Clear();
            oledbAdapter.Fill(ds, (pageNum - 1) * 20, count, strDataMember);
          
            dataGridView1.DataSource = ds.Tables[strDataMember];
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void comPageNum_SelectedIndexChanged(object sender, EventArgs e)
        {
            pageNum = comPageNum.SelectedIndex   1;
            lalPageNum.Text = pageNum.ToString()   "/"   pageAll.ToString();

            //dataGridView1.FirstDisplayedScrollingRowIndex = comPageNum.SelectedIndex * 20;

            ds.Clear();
            oledbAdapter.Fill(ds, comPageNum.SelectedIndex * 20, count, strDataMember);
         
            dataGridView1.DataSource = ds.Tables[strDataMember];
        }
    }
}