give c# code for foreach

shekar reddy

10y1.1kVisual Basic .NET

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra10y ago
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;
}
0
Vinay Singh10y ago
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
0
Midhun Tp10y ago
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;
}

0
Suraj Pant10y ago
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
0