Monday, 16 September 2013

Get all data from xml


public List<State> getAllState()
        {
           
            List<State> state = new List<State>();
          
            string XMLFile1 =HttpContext.Current.Server.MapPath("~/XMLFiles/State.xml");
            DataSet dsxml = new DataSet();
            // Create new FileStream with which to read the schema.
            System.IO.FileStream fsReadXml = new System.IO.FileStream
                (XMLFile1, System.IO.FileMode.Open);
            try
            {
                dsxml.ReadXml(fsReadXml);

            }
            catch (Exception ex)
            {
                string e = ex.Message;
            }
            finally
            {
                fsReadXml.Close();
            }


            ////-------------------------

            for (int i = 0; i < dsxml.Tables[0].Rows.Count; i++)
            {

                state.Add(new State
                {
                    stateId = (dsxml.Tables[0].Rows[i][0].ToString()),
                    stateName = (dsxml.Tables[0].Rows[i][1].ToString())

                });
            }

            return state;
        }

No comments:

Post a Comment