且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

连接到SQL Server和Windows窗体应用程序

更新时间:2023-02-06 22:47:46

它非常很简单,你将不得不使用实体框架,它自动根据数据库服务器转换sql查询。你将不得不支付
1:复制DAL类并将它们粘贴到DAL中,只需进行一些矿工更改,例如

(i)编写以SqlConnection为主的OracleConnection和OleDbConnection。 br />
它是一个完整的教程,可以解决你的问题



http://www.***.com/watch?v=aoFDyt8oG0k



http://www.***.com/playlist?list=PL6n9fhu94yhX5dzHunAI2t4kE0kOuv4D7

http://csharp-video-tutorials.blogspot.com/十分之二千零一十二/什么-是-ADONET部分-1.HTML

Hi Friends,

I am stuck in a problem and I need a little help. I am creating an application wherein I need to connect to a Database (MSSQL or Access or MySQL). Kindly suggest me to create a front end from where a user (client) can setup this information like: which server?, username?, password? and connection engine? etc.
Also, if I am not wrong, there is a difference between the SQL queries for Access, MSSQL and MySql so I need to create multiple classes to manage those also. Kindly guide me a little.
Thank you very much.

Tushar Srivastava

Its very easy, you will have to use entity framework, which translates sql queries according to the database server automatically. You will have to
1: Copy DAL classes and paste them in DAL, just do some miner changes like
(i) write OracleConnection insteated of SqlConnection, and OleDbConnection.
its a Complete Tutorial which can solve your problem

http://www.***.com/watch?v=aoFDyt8oG0k

http://www.***.com/playlist?list=PL6n9fhu94yhX5dzHunAI2t4kE0kOuv4D7
http://csharp-video-tutorials.blogspot.com/2012/10/what-is-adonet-part-1.html