I want to fetch data from mysql database to asp.net dropdown control. How can I do this.
I can fetch data from ms sql server to asp.net page. Please help me to fetch data from mysql database.
View Complete Post
I added refernece MySql.Data to my project. My web.config looks like that:
<?xml version="1.0"?><configuration> <connectionStrings> </connectionStrings> <system.web> <compilation> <assemblies> <add assembly="MySql.Data, Version=22.214.171.124, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/> </assemblies> </compilation></system.web></configuration>
But when in ServerExplorer I try "Add Connection..." I can't find "MySql Database" in the "Choose Data Source" dialog box?
What the problem can be?
I developed a web site more then a year ago with .net2.0/c#/mssql 2005. it works fine but i was asked to replace mssql with mysql.
I wrote a class to complete data access works (unfortunately, I didnt use nhibernate or other data access tools :((
I edited the class to use System.Data.Odbc objects rather than System.Data.SqlClient.
It works fine in selecting data but not manipulating data. when i try to insert new data it adds null data for all fields in the table.
in debug mode, i noticed that it might be caused by OdbcParameter but not sure.
thanks in advance
Hi dear coders
though a very simple question to ask, but please tell me how to save and retrieve data in/from my textboxes to/from database (MYSQL) on submit button click.
i know its a very simple task but i cant make it done, so i request you to please send me some working example link or post any helpful code here in asp.net
i will be highly thankful for any kind help from you geniuses.
i have a dropdownbox and a gridview
what I want is to have a list item which populates all data in a gridview.
I have tried using list item selected value=0 but to no avail.
what is the easiest way to achieve this?