如何使用Ms Access数据库在C Sharp中搜索数据库，如何使用Forigen Key在C Sharp中进行两个Tabel记录？ [英] How Do I Search Data Base In C Sharp With Ms Access Data Base , And How Can I Diply Two Tabel Record In C Sharp With Forigen Key ,,?

问题描述

OleDbConnection Dc = new OleDbConnection("Provider=Microsoft.Ace.OLEDB.12.0; Data Source=D:\\Dat.accdb");
        OleDbDataAdapter DA = new OleDbDataAdapter();
        DataSet dset = new DataSet();
        DataView Dv = new DataView();
        void fillData()
        {
            Dc.Open();
            DA.SelectCommand = new OleDbCommand();
            DA.SelectCommand.Connection = Dc;
            DA.SelectCommand.CommandText = "Select* From Table1";
            dset = new DataSet();
            DA.Fill(dset, "T1");
            Dv = new DataView(dset.Tables["T1"]);
            Dc.Close();

        }

        void BindtextBoxes()
        {
            textBox1.DataBindings.Clear();
            textBox2.DataBindings.Clear();
            textBox3.DataBindings.Clear();
            //textBox4.DataBindings.Clear();
           // textBox5.DataBindings.Clear();
            textBox1.DataBindings.Add("Text", Dv, "ID");
            textBox2.DataBindings.Add("Text", Dv, "Name");
            textBox3.DataBindings.Add("Text", Dv, "Marks");
           // textBox4.DataBindings.Add("Text", Dv, "Address");
          //  textBox5.DataBindings.Add("Text", Dv, "Age");
        }

推荐答案

我会说，学习 SQL联接 [ ^ ]首先从多个表中选择数据。



基础知识：

http://technet.microsoft.com/en-us /library/ms191517(v=sql.105).aspx [ ^ ]

http://technet.microsoft.com/en-us/library/aa213233(v=sql.80).aspx [ ^ ]



示例：

http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/ [ ^ ]

http://www.mssqltips.com/sqlservertip/1667/sql-server -join-example / [ ^ ]。



似乎很少有数据库编程的基础知识不清楚。所以你可以在这里找到合适的解决方案：

ADO .NET（OleDb） [ ^ ]

http://www.codeproject.com/Articles/8477/Using-ADO-NET-for-beginners [ ^ ]

初学者理解ADO.NET的教程 [ ^ ]



- KR

Well I would say, learn the SQL Joins[^] first for selecting data from multiple tables.

Fundamentals :
http://technet.microsoft.com/en-us/library/ms191517(v=sql.105).aspx[^]
http://technet.microsoft.com/en-us/library/aa213233(v=sql.80).aspx[^]

Examples :
http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/[^]
http://www.mssqltips.com/sqlservertip/1667/sql-server-join-example/[^].

And seems that few of your basics of database programming are not clear. So you may find appropriate solution here :
ADO .NET (OleDb)[^]
http://www.codeproject.com/Articles/8477/Using-ADO-NET-for-beginners[^]
A Beginner's Tutorial for Understanding ADO.NET[^]

-KR

我建​​议从这里开始：使用Microsoft Access 2010进行数据编程 [ ^ ]

阅读完上述文章后，请看这里：从.NET应用程序访问Microsoft Office数据 [ ^ ]



下一页时间，请更具体，并提供有关您的问题的更多详细信息。请阅读CP的规则： Code Project Quick Answers FAQ [ ^ ]

I'd suggest to start here: Data Programming with Microsoft Access 2010[^]
When you finish reading above article, have a look here: Accessing Microsoft Office Data from .NET Applications[^]

Next time, please be more specific and provide more details about your issue. Please, read CP's rules: Code Project Quick Answers FAQ[^]

这篇关于如何使用Ms Access数据库在C Sharp中搜索数据库，如何使用Forigen Key在C Sharp中进行两个Tabel记录？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！