Monday, August 20, 2007

add 2 column values of a datatable 2 datavaluefield of a dropdown list

DVU_eventsTableAdapter _events = _new _DVU_eventsTableAdapter();

_DataTable _dt = _events._GetData();
_for (_int _i = _0; _i < _dt._Rows._Count; _i++)
{
_DateTime _eventdate = _new _DateTime();
_eventdate = _Convert._ToDateTime(_dt._Rows[i]["event_date"]._ToString());
_string _formatted_date = _String._Format("{0:d}", eventdate);
_ddlEvent._Items._Add(_new _ListItem(_dt._Rows[i]["loc_city"]._ToString() + ", " + _dt._Rows[i]["loc_state"]._ToString() + " (" + _formatted_date + ")", _dt._Rows[i]["event_id"]._ToString()));
}

Reference::::: http://forums.asp.net/p/1088821/1627029.aspx#1627029

No comments: