1 public void InitData()
2        {
3            string sql = @"select  * from orders";
4
5            SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=sa;database=NorthWind");
6            SqlDataAdapter sda = new SqlDataAdapter(sql, con);
7            DataTable dt = new DataTable();
8            sda.Fill(dt);
9
10            Hashtable htt = new Hashtable(5);
11
12            foreach (DataRow dr in dt.Rows)
13            {
14                htt.Add(dr["orderID"], dr["CustomerID"]);
15
16            }
17            ArrayList al = new ArrayList(htt.Keys);
18            al.Sort();
19            foreach (DictionaryEntry de in htt)
20            {
21               if (de.Value.ToString == "ALFKI")
22               {
23                   Response.Write(de.Key + "Next .");
24               }
25            }
26            GridView1.DataSource = dt;
27            GridView1.DataBind();
28
29        }