I have wrote code for getting dropdown based value from Sharepoint list.
But it give me error Operation is not valid due to the current state of the object when i set it to textbox.
Please take look of my code.
public void group2_Validating(object sender, XmlValidatingEventArgs e)
{
// Write your code here.
XPathNavigator elementddlCostCenter = this.MainDataSource.CreateNavigator().SelectSingleNode("//my:myFields/my:group1/my:group2/my:ddlFirstName", this.NamespaceManager);
string ddlDepartedFrom = elementddlCostCenter.Value;
XPathNavigator elementddlArrivalAt = this.MainDataSource.CreateNavigator().SelectSingleNode("//my:myFields/my:group1/my:group2/my:ddlLastName", this.NamespaceManager);
string ddlArrivalAt = elementddlArrivalAt.Value;
if (ddlDepartedFrom != null && ddlDepartedFrom != "" && ddlArrivalAt != null && ddlArrivalAt != "")
{
// ListWebServices.Lists listServices = new ListWebServices.Lists();
SPQuery qry = new SPQuery();
string camlquery = "<Where><And><Eq><FieldRef Name='Title' /><Value Type='Text'>" + ddlDepartedFrom + "</Value></Eq>" + "<Eq><FieldRef Name='Categories' /><Value Type='Text'>" + ddlArrivalAt + "</Value></Eq></And></Where>";
// string camlquery = "<Where><Eq><FieldRef Name='Categories'/><Value Type='Text'>"+ ddlArrivalAt +"</Value></Eq></Where>";
qry.Query = camlquery;
SPSite site = null;
SPWeb web = null;
try
{
SPSecurity.RunWithElevatedPrivileges(
delegate()
{
string m_sharepointUrl = "http://ProductionServer";
using (site = new SPSite(m_sharepointUrl))
{
if (site != null)
{
using (web = site.OpenWeb())
{
SPList list = web.Lists["Age"];
if (list != null)
{
DataTable _table = new DataTable();
DataColumn dc = new DataColumn("Mileage");
_table.Columns.Add(dc);
SPListItemCollection listItemsCollection = list.GetItems(qry);
foreach (SPListItem item in listItemsCollection)
{
DataRow _row = _table.NewRow();
_row[0] = SPEncode.HtmlEncode(item["Age"].ToString());
Milage = Convert.ToInt32(SPEncode.HtmlEncode(item["Age"].ToString()));
//Mileage = Convert.ToInt32(_row[0].ToString());
_table.Rows.Add(_row);
}
XPathNavigator domNav = MainDataSource.CreateNavigator();
string xhtmlRTFField = domNav.SelectSingleNode("//my:myFields/my:group1/my:group2/my:txtAge", NamespaceManager).InnerXml;
domNav.SelectSingleNode("//my:myFields/my:group1/my:group2/my:txtAge", NamespaceManager).InnerXml = Milage.ToString(); ---> I got error here
//domNav.SelectSingleNode("//my:myFields/my:group1/my:group2/my:txtAge", NamespaceManager).SetValue(Milage.ToString());
}
web.Close();
}
site.Close();
}
}
}
);
}
catch (Exception ex)
{
}
}
}
Please help on this.
Thank you.