35
Load table
from SQLServer: ASPX data sets, C#
l<%@ Page language="C#"
debug="true"%><%
lint i; long j=0,k=0; string cNotes; object oField;
string cFields;
long
nStart=System.DateTime.Now.Ticks;
cFields="_ID,Appointment_Notes
FROM Visit_"; cFields="* FROM Visit_";
System.Data.DataRowCollection
oRows=
GetData("SERVER=(local);DATABASE=test;UID=user;Password=pass;",
l "SELECT
"+cFields+" WHERE Appointment_Notes IS NOT NULL");
Response.Write("Done
"+((System.DateTime.Now.Ticks-nStart)/10000000.0).ToString()+
l "
"+oRows.Count.ToString()+"<br>");
l%>
<script
runat="server">
System.Data.DataRowCollection
GetData(string lcConnection,string lcQuery) {
System.Data.DataSet oDS=new System.Data.DataSet();
System.Data.SqlClient.SqlConnection oSqlClient=
l new
System.Data.SqlClient.SqlConnection(lcConnection);
l
System.Data.SqlClient.SqlDataAdapter oSqlDA=
l new
System.Data.SqlClient.SqlDataAdapter(lcQuery,oSqlClient);
oDS.Clear();
oSqlDA.Fill(oDS,"History");
return oDS.Tables["History"].Rows;}
</script>
l
lOn 850 MHz PIII: First cFields list gives (SQLClient)
.18s [compare ASP at .25s]
lSecond cFields list (SQLClient) .98s [compare asp at
.70s]