C#, ASP.NET , DEVEXPRESS , SQLSERVER ,MYSQL ,PHP
Download Mysql.data http://dev.mysql.com/downloads/connector/net/1.0.html private void button1_Click(object sender, System.EventArgs e) { string MyConString = “SERVER=localhost;” + “DATABASE=mydatabase;” + “UID=testuser;” + “PASSWORD=testpassword;”; MySqlConnection connection = new MySqlConnection(MyConString); MySqlCommand command = connection.CreateCommand(); MySqlDataReader Reader; command.CommandText = “select * from mycustomers”; connection.Open(); Reader = command.ExecuteReader(); while (Reader.Read()) { string thisrow = “”; for (int i= 0;i<Reader.FieldCount;i++) thisrow+=Reader.GetValue(i).ToString() + “,”; … Read More “C# .Net and the MySql Connector/Net” »
ASP.Net Webpage (.aspx)
<%@ Page Language=”C#” AutoEventWireup=”true” CodeFile=”Default.aspx.cs” Inherits=”_Default” %>
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>
<html xmlns=”http://www.w3.org/1999/xhtml” >
<head runat=”server”>
<title>MySql Test</title>
</head>
<body>