C#访问SQL/Accsee数据库实例

最新推荐文章于 2022-02-11 17:35:01 发布

xzf158

最新推荐文章于 2022-02-11 17:35:01 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

分类专栏： C# 文章标签：数据库 c# dataset exception security cmd

本文链接：https://blog.youkuaiyun.com/xzf158/article/details/2570843

C# 专栏收录该内容

4 篇文章

订阅专栏

本文介绍如何使用C#中的SqlConnection和OleDbConnection来分别从SQL Server和Access数据库中读取数据，并填充到DataSet和DataTable中。示例代码展示了连接数据库、执行查询及异常处理的过程。

 public DataSet FillDataSet()

        {

            SqlConnection conn = new SqlConnection("server=(local);Integrated Security=true;Initial Catalog=master;");

            SqlCommand cmd = new SqlCommand("SELECT [name], [filename] FROM dbo.sysdatabases", conn);

            SqlDataAdapter da = new SqlDataAdapter(cmd);



            DataSet ds = new DataSet();



            try

            {

                conn.Open();



                try

                {

                    da.Fill(ds);    // fill DataSet with data

                }

                catch (Exception)

                {

                    return null;

                }

                finally

                {

                    conn.Close();

                    conn.Dispose();

                }

            }

            catch (Exception)

            {

                return null;

            }



            return ds;

        }        private DataTable FillDataTableByAccess()

        {

            string connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/"" + System.IO.Path.GetFullPath("db1.mdb") + "/"";



            System.Data.OleDb.OleDbConnection oledbConn = new System.Data.OleDb.OleDbConnection(connString);

            System.Data.OleDb.OleDbCommand oledbCom = new System.Data.OleDb.OleDbCommand("SELECT * FROM 客户表",oledbConn);

            System.Data.OleDb.OleDbDataAdapter oledbDr = new System.Data.OleDb.OleDbDataAdapter(oledbCom);



            DataTable dt = new DataTable();

            try

            {

                oledbConn.Open();



                try

                {

                    oledbDr.Fill(dt);

                }

                catch (Exception exc)

                {

                    MessageBox.Show(exc.Message);

                }

                finally

                {

                    oledbConn.Close();

                    oledbConn.Dispose();

                }

            }

            catch (Exception exc)

            {

                MessageBox.Show(exc.Message);

            }            



            return dt;

        }