aspx中的mysql操作类sqldatasource使用示例分享

%@ Page Language="VB" %>
!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtmlll/DTD/xhtmlll.dtd">
script runat="server">
/script>
html xmlns="http://www.w3.org/1999/xhtml" >
head runat="server">
title>asp.net to mysql/title>
/head>
body>
asp.net connect mysql
form id="forml" runat="server">
div>
asp:GridView ID="GridViewl" Runat="server"
DataSourceID="SqlDataSourcel">
/asp:GridView>
asp:SqlDataSource ID="SqlDataSourcel" Runat="server"
ProviderName="System.Data.Odbc"
ConnectionString= "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=test;UID=test;PASSWORD=testtest;"
SelectCommand="Select * from dede_admin"
>
/asp:SqlDataSource>
/div>
/form>
/body>
/html>