Use of SqlDataAdapter and Dataset
SqlCommand cmd = new SqlCommand("your command ", con);
cmd.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
DataList2.DataSource = ds;
DataList2.DataBind();
tell me if you got it