Datasource control with MySQL Datasource control with MySQL

Submitted by planetsourcecode on Tuesday, June 23, 2009 - 20:20.

We can use the Datasource control with MySQL, for this we have to require two things. This can be done without writing any codes,simpy we have to assign the ConnectionsString in the SQLDataSource control. the string will be like that


DS1.ConnectionString="Driver={MySQL ODBC 3.51 Driver};server=YourServerIP;database=" & _
"YourDB;user=YourUID;pwd=YourPWD;option=3;"

we can use the obove line in the pageload event in code behind module second thing is that setting the SqlDataSource property, first change the SqlDataSource property providerName="System.Data.Odbc" and we can use that SQLDatsourece control with any Data Bound control like Gridview, Reapeater, Datalist etc. About the author: PlanetSourceCode.in is a place for all developer providing free source codes, articles, complete projects,complete application in PHP, C/C++, Javascript, Visual Basic, Cobol, Pascal, ASP/VBScript, AJAX, SQL, Perl, Python, Ruby, Mobile Development

Comments

ODBC Connection failed

hello....sir, First: Before we're using MSACCESS 2003. The database is running smoothly and works fine. A years ago Microsoft Office released the 2007 version and mostly is using these version my boss and users also want to upgrade our system in 2007 but when I test the 2003 running in 2007 version it works without any conversion yet their were some codes and expressions to be modified. My question is; do I have to encounter any problem or how will affect the Queries, Forms, Reports, Macro and Module and specially the DATA? Second: I am a newbie in SQL SERVER I have been converted and migrate the file connecting to SQL SERVER 2005 thru ODBC DSN the Tables link into a local pc and it works but when I try connecting to network for the users machine opening ms access link to ODBC tables was failed or cannot connect thru ODBC DATA SOURCE. Can someone send me a batch of file for a tutorial. Please help I'm already stuck for a week. Thanks in advance...More power to you and sourcecodester.com.. here is my email add... benjieptan_benjz@yahoo.com

re: ODBC Connection failed

Answer to question # 1: I think all code in 2003 are compatible with 2007. I don't even remember that my 2000 version of Access has any problem after opening it in 2007. All queries, forms, reports, macros, and modules are not affected by the new version of access. But most often the problem I encounter with 2007 is the strict implementation of its security. All you have to do is to disable this so all your code will run smoothly. Question # 2 have been answered from your previous post.

Fees information management system

Hi! I'm a newbie and i really need help. I have to make a fees information management system for my thesis... I do understand the principles in vb.net and the elements needed in the fims. I just don't know how to start. I need to use the mysql as my database.pls help>>>