Friday, October 23, 2009

To Read XML Data in the DataGridView

This code will allow you to read the data from the XML file and display it in the datagridview.

DataSet ds = new DataSet();
private void Form1_Load(object sender, EventArgs e)
{
ds.ReadXml(“Data.xml”);
dataGridView1.DataSource = ds.Tables[0];
}


To Delete a Row from the DataGridView use the Following Code

private void button1_Click(object sender, EventArgs e)
{
dataGridView1.Rows.RemoveAt(rIndex);
}
int rIndex;
private void dataGridView1_RowEnter(object sender, DataGridViewCellEventArgs e)
{
rIndex = e.RowIndex;
}

The XML File is as Follows

<School>

<student>

<rNumber>1rNumber>

<SName>HefinSName>

<SMarks1>100SMarks1>

<SMarks2>50SMarks2>

<SMarks3>70SMarks3>

student>

School>