SQLDataSource + Mysql, asp.net 2.0
Posted by: Deepak Palkar
Date: September 21, 2006 12:59AM

Hello Everyone,

I am using Mysql as backend in my asp.net 2.0 Web Application. I am using FormView Web Control to display/edit/insert the Data directly from Database.

we can use SQLDataSource to make the FormView work as it's a Bound Control.

SQLDataSource has a Wizard which allows us to make the Select/Insert/Update/Delete Queries.

it also lets us create the Connection Strings etc. which is ok. But the problem is when it creates the SQL Queries, it puts the Square Brackets around the Database Object names (ie, around table names, field names etc..) and as we know Mysql Doesn't understand the Square Brackets, it wouldn't let me test the Query which is a lil frustrating.

I know i can just finish the Wizard and then edit the queries manually in the ASPX. But i was just wondering if there is any workaround to this?

thanks
Deepak

Options: ReplyQuote


Subject
Written By
Posted
SQLDataSource + Mysql, asp.net 2.0
September 21, 2006 12:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.