give c# code for foreach

Question

Aaisha QWRtaW4xMjM0 savings chennai support U3RvcmUwOTg3 savings Madurai amazon service Rm9vZDEyMzQ= savings Pandy mahi MTIzNFVtZXNo savings Madurai Ramesh MTIzNFVtZXNo savings Coiambattur Rajesh MTIzNFVtZXNo savings Coiambattur Ragav MTIzNFVtZXNo current Pandy Rani MTIzNFVtZXNo current Pandy Avi QWRtaW4xMjM0 savings chennai read from xml file add only city to to commbobox .then if i select city in dropdownlist it will show the users in datagrid please tell me

Manas Mohapatra · Answer

Use below code to bind value in dropdown: XDocument xdoc = XDocument.Load(Server.MapPath( Daily_schedule.xml )); // If you have file XDocument xdoc = XDocument.Parse( xmlContent )); // If you have data only List string > cityList = (from rec in xdoc.Descendants( User ) select rec.Attribute( City ).Value).ToList(); Dropdownlist1.DataSource = cityList; Once you select the value in dropdown list then fire an event SelectedIndexChanged. protected void comboBox1_SelectedIndexChanged( object sender EventArgs e) { List string > userList = (from rec in xdoc.Descendants( User ) where ( string )rec.Element( id ) == comboBox1.SelectedValue select rec.Attribute( UserName ).Value).ToList(); dataGridView1.DataSource = userList; }

Vinay Singh · Answer

Hi check the solution protected void Page_Load( object sender EventArgs e) { if (!IsPostBack) { GetData(); } } public void GetData() { try { DataSet dsResult = new DataSet (); dsResult.ReadXml(Server.MapPath( ~/XML/XMLFile1.xml )); if (dsResult.Tables.Count != 0) { if (dsResult.Tables[0].Rows.Count > 0) { GridView1.DataSource = dsResult.Tables[0]; GridView1.DataBind(); } } } catch ( Exception ex) { } } protected void Button1_Click( object sender EventArgs e) { XDocument doc = XDocument .Load(Server.MapPath( ~/XML/XMLFile1.xml )); var records = ( from data in doc.Root.Elements( User ) where TextBox1.Text ==  ? true : data.Element( User ).Value.ToUpper().Contains(ddlItem.SelectedItem) select data); if (records != null ) { DataTable dt = new DataTable (); dt.Columns.Add( UserName  typeof ( string )); dt.Columns.Add( UserPassword  typeof ( string )); dt.Columns.Add( Account  typeof ( string )); foreach ( var item in records) { DataRow dr = dt.NewRow(); dr[  UserName  ] = ( string )item.Element(  UserName  ); dr[  UserPassword  ] = ( string )item.Element(  UserPassword  ); dr[  Account  ] = ( string )item.Element(  Account  ); dt.Rows.Add(dr); } GridView1.DataSource = dt; GridView1.DataBind(); } else { } } For detail refrence check the link http://www.aspdotnet-pools.com/2014/10/bind-search-xml-file-data-and-display.html

Midhun T P · Answer

Hi Please try below code - DataSet dataSet = new DataSet(); public Form1() { InitializeComponent(); bindcombo(); } public void bindcombo() { string xmlFile = Environment.CurrentDirectory + @\XMLFile.xml; dataSet.ReadXml(xmlFile XmlReadMode.InferSchema); DataView view = new DataView(dataSet.Tables[0]); DataTable distinctValues = view.ToTable(true city); comboBox1.DataSource = distinctValues; comboBox1.DisplayMember = City; comboBox1.ValueMember = City; comboBox1.SelectedIndex = 0; dataSet.Tables[0].DefaultView.RowFilter = City = ' + comboBox1.SelectedValue + '; view = dataSet.Tables[0].DefaultView; distinctValues = view.ToTable(); dataGridView1.DataSource = distinctValues; } protected void comboBox1_SelectedIndexChanged(object sender EventArgs e) { dataSet.Tables[0].DefaultView.RowFilter = City = ' + comboBox1.SelectedValue + '; dataGridView1.DataSource = dataSet.Tables[0].DefaultView; }

Suraj Pant · Answer

Below two article should solve your problem.. http://www.c-sharpcorner.com/UploadFile/167ad2/read-xml-file-using-xml-reader-in-C-Sharp/ http://www.c-sharpcorner.com/blogs/display-records-from-database-to-datagridview-using-datareader1