Tuesday, June 3, 2008

Sql-server to Mysql migration C# Asp.net Code Issue

1. Download connector .
2 add in your code using MySql.Data.MySqlClient;
3. Change connection string to ConnectionString="<%$ ConnectionStrings:ConnectionString %>"ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
4.in SqlDataSource change @ with ? in sql command SelectCommand="SELECT * FROM vnflsch WHERE (week = ?week)
5. replace all "[" and "]" with blanks.

www.visli.com

No comments: