Here’s a simple example of how to populate a dropdown from the ODS using jQuery and Ajax.  This could be used, for example, to pre-populate a drop down list with students in a Form Wizard Pro form.

Default.aspx:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function () {
$.ajax({
type: "POST",
url: "Default.aspx/GetStudents",
//OR url: "your_absolute_url_thats_in_the_same_domain/Default.aspx/GetStudents",
data: "{}",
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (msg) {
$("#students").get(0).options.length = 0;
$("#students").get(0).options[0] = new Option("Select SAHE Student", "");
$.each(msg.d, function (index, item) {                        $("#students").get(0).options[$("#students").get(0).options.length] = new Option(item.Display, item.Value);
});
},
error: function () {
alert("Failed to load genders");
}
});
});
</script>
</head>
<body>
<form id="form1" runat="server">
<select id="students">
</select>
</form>
</body>
</html>

Code-behind for default.aspx:

/// <summary>
/// GetStudents queries ODS and returns an arraylist (later converted to JSON)     /// </summary>
/// <returns></returns>
[WebMethod]
public static ArrayList GetStudents()
{
ArrayList names = new ArrayList();
OracleConnection conn = null;
string connString = ConfigurationManager.ConnectionStrings["ODSConnString"].ConnectionString;
conn = new OracleConnection(connString);
string query = "SELECT NAME FROM CSUBAN.CSUS_FIELD_OF_STUDY_CEN_CUR WHERE (PROGRAM = 'SAHE-MS')";
OracleCommand cmd = new OracleCommand(query, conn);
conn.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

while (dr.Read())
{
names.Add(new { Value = dr["Name"].ToString(), Display = dr["Name"].ToString() });
}

return names;
}