dbproxy.asp:
<%
Response.ContentType = "text/plain"
Set con = Server.CreateObject("ADODB.Connection")
con.Open "Driver={MySQL};Database=Test;User Id=root;Password=;"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open CStr(Request("query")),con
Do While Not rs.EOF
For i = 1 To rs.Fields.Count
Response.Write rs.Fields.Item(i-1)
If i < rs.Fields.Count Then
Response.Write ","
End If
Next
Response.Write vbCrLf
rs.MoveNext
Loop
Set rs = Nothing
Set con = Nothing
%>
demo.cs:
using System;
using System.IO;
using System.Net;
using System.Web;
class MainClass
{
public static void Main(string[] args)
{
WebRequest wr = WebRequest.Create("
http://localhost/dbproxy.asp?query=" + HttpUtility.UrlEncode("SELECT * FROM T1"));
StreamReader sr = new StreamReader(wr.GetResponse().GetResponseStream());
string line;
while((line = sr.ReadLine()) != null)
{
string[] fields = line.Split(",".ToCharArray());
for(int i = 0; i < fields.Length; i++)
{
Console.Write(" " + fields[i]);
}
Console.WriteLine();
}
}
}