Asp.net ile MySQL database bağlantısı
ASP.NET ile MySQL veritabanına bağlantı kodu
************************************************** *********
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.Odbc" %>
<%@ Page Language="C#" %> <script runat="server"> public void Page_Load(Object sender, EventArgs e) { DataTable dtRecords = GetDataTable("SELECT * FROM newone"); foreach(DataRow dr in dtRecords.Rows) { Response.Write(dr["FirstName"].ToString() + " " + dr["LastName"].ToString() + "<br/>"); } } private static string GetConnection() { return "DRIVER={MySQL ODBC 3.51 Driver};Server=localhost;Database=testdatabase&quo t;; } public static DataTable GetDataTable(string sql) { DataTable rt = new DataTable(); DataSet ds = new DataSet(); OdbcDataAdapter da = new OdbcDataAdapter(); OdbcConnection con = new OdbcConnection(GetConnection()); OdbcCommand cmd = new OdbcCommand(sql, con); da.SelectCommand = cmd; da.Fill(ds); try { rt = ds.Tables[0]; } catch { rt = null; } return rt; } </script>