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>