>how does datapipe or dataset works?
Datapipe code in C#:
string strConnection = "SERVER=(local);Trusted_Connection=Yes ";
string strSQLforListBox = "select distinct ap_applpg as master_page from depappl where ap_applpg <> ' ' order by 1 " ;
SqlConnection objConnection = new SqlConnection(strConnection);
SqlCommand objCommand = new SqlCommand(strSQLforListBox, objConnection);
objConnection.Open();
MmDropDownList10.DataSource = objCommand.ExecuteReader();
MmDropDownList10.DataTextField = "master_page";
MmDropDownList10.DataBind();
objConnection.Close();
DataSet can be done through your GUI. Just click away. Read the help too.
__Stephen