学步园

                SqlCommand com = new SqlCommand("select ID,Name from ResourceType ORDER BY name");
                com.Connection = conn;
                if (conn.State != ConnectionState.Open)
                    conn.Open();

                SqlDataReader dr = com.ExecuteReader();
                lstResourceTypeID.DataSource = dr;
                lstResourceTypeID.DataValueField = "id";
                lstResourceTypeID.DataTextField = "name";
                lstResourceTypeID.DataBind();
                lstResourceTypeID.SelectedIndex = 0;
                dr.Close();