01.using System;
02.using System.Collections.Generic;
03.using System.Linq;
04.using System.Web;
05.using System.Web.UI;
06.using System.Web.UI.WebControls;
07.using System.Data;
08.using System.Data.SqlClient;
09.namespace test.dev
10.{
11. public partial class send : System.Web.UI.Page
12. {
13. dbConfig clsdb = new dbConfig();
14. SqlConnection conn;
15. SqlDataReader dtReader;
16. string sql;
17. SqlCommand cmd;
18.
19.
20. protected void Page_Load(object sender, EventArgs e)
21. {
22. call();
23. }
24. void call()
25. {
26. conn = clsdb.Conn();
27. sql = "select * from mytable";
28. cmd = new SqlCommand(sql, conn); dtReader = cmd.ExecuteReader();
29. sendres.InnerHtml = "";
30. while (dtReader.Read())
31. {
32. sendres.InnerHtml += dtReader["name"].ToString() + " : ";
33. sendres.InnerHtml += dtReader["email"].ToString() + "<br>";
34. }
35. Response.Write(DateTime.Now.ToString("hh:mm:ss"));
36. }
37. }
38.}
