<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<!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>subin</title>
</head>
<%
%>
<body>
<form id="form1" runat="server">
<div>
by Subin
</div>
</form>
<div>
<%
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
strConnection += Server.MapPath("ls.su");
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbCommand objCommand = new OleDbCommand("select * from al", objConnection);
objConnection.Open();
OleDbDataReader objDataReader = objCommand.ExecuteReader();
while (objDataReader.Read())
{
Response.Write (Convert.ToString(objDataReader["s_name"])+"<br>");
//objDataReader.NextResult;
}
Response.Write(Server.MapPath("."));
%>
</div>
</body>
</html>
