Search
Datasource control with MySQL Datasource control with MySQL
Submitted by planetsourcecode on Tue, 06/23/2009 - 20:20
Language:
.NET 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
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
- 1805 reads
MS acess to VB
Please give me a code on how can I display the data in my MS access database to the VB form.
Thank you very much.
re: MS acess to VB
Study Database Programming Made Easy.
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>>>
re: Fees information management system
I will provide a tutorial on VB.NET + mysql in the next coming day.
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.
Post new comment