tags:

views:

29

answers:

0

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.

related questions