DataTable的成员方法及其数据成员的调用

?

1

1.取数据成员：

?

1 2	DataTable dt = AdDA.GetAdPos(keyword); WidthTextBox.Text = dt.Rows[0]["Width"].ToString();

?

1	DataRow dr = dt.Rows[0];

?

1	string str = dr["title"];

?

1	2.Datatable数据转存入ArrayList：

?

1 2 3 4 5 6 7 8 9 10

private ArrayList allCitys;  public void FillList(){      DataTable dt = CityDA.GetAllCityStatu();      allCitys = new ArrayList();      foreach (DataRow dr in dt.Rows)      {          City city = new City(int.Parse(dr["City_ID"].ToString()), dr["city_name"].ToString());          allCitys.Add(city);      }  }

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

3. 与CreateCommand配合使用，专用于存储过程的执行         /// </summary>         /// <param name="command"></param>         /// <returns></returns>         public static DataTable ExecuteSelectCommand(SqlCommand command)         {             DataTable table;             try             {                 command.Connection.Open();                 SqlDataReader reader = command.ExecuteReader();                 table = new DataTable();                 table.Load(reader);                 reader.Close();             }             catch (Exception ex)             {                 Utilities.LogError(ex);                 throw ex;             }             finally             {                 command.Connection.Close();             }             return table;         }