Member Avatar for zifina

I am new to using xml in c sharp. I am able to enter details to the xml file (name of file "Data1.xml") through text boxes.But before entering details to the xml file,i need to first verify if any other 'well' have the same 'name'. 'name' has to be unique. How to search the xml and find if there exist another well with the same name as in 'textbox1.text'???

Also,i need to get the 'name's of all 'well's and display in a datagridview.And get the value of 'density' and 'depth' in textboxes,for a particular well,on clicking the row in grid view.
may be this is simple,but please help me with this.i always find great help in daniweb,and expect it this time too..
Thanks in advance.

<?xml version="1.0" encoding="utf-8"?>
<wells>
  <well>
    <name>abc</name>
    <density>1000</density>
    <depth>200</depth>
  </well>
</wells>
  • 2 Contributors
  • 1 Reply
  • 229 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by xml_looser

Dani AI

Generated

A compact, practical approach for : use LINQ-to-XML at runtime to check for a duplicate name, bind the wells to the DataGridView, and handle selection to populate the density and depth textboxes. is right that an XSD can validate structure; schema validation is useful, but you still need a runtime check (or an xs:unique constraint plus runtime validation) to prevent duplicates when inserting.

To check uniqueness and append a new well:

using System;
using System.Linq;
using System.Xml.Linq;

var path = "Data1.xml";
var doc = XDocument.Load(path);
var newName = textBoxName.Text.Trim();

bool exists = doc.Descendants("well")
                 .Any(w => string.Equals((string)w.Element("name"), newName, StringComparison.OrdinalIgnoreCase));

if (exists)
{
    MessageBox.Show("A well with that name already exists.");
}
else
{
    var newWell = new XElement("well",
        new XElement("name", newName),
        new XElement("density", textBoxDensity.Text.Trim()),
        new XElement("depth", textBoxDepth.Text.Trim())
    );
    doc.Root.Add(newWell);
    doc.Save(path);
}

To populate the grid and fill textboxes on selection:

var wells = doc.Descendants("well")
               .Select(w => new {
                   Name = (string)w.Element("name"),
                   Density = (string)w.Element("density"),
                   Depth = (string)w.Element("depth")
               }).ToList();

dataGridView1.DataSource = wells;

Selection handler:

private void dataGridView1_SelectionChanged(object sender, EventArgs e)
{
    if (dataGridView1.CurrentRow == null) return;
    textBoxName.Text = dataGridView1.CurrentRow.Cells["Name"].Value?.ToString();
    textBoxDensity.Text = dataGridView1.CurrentRow.Cells["Density"].Value?.ToString();
    textBoxDepth.Text = dataGridView1.CurrentRow.Cells["Depth"].Value?.ToString();
}

Notes: Trim and compare case-insensitively; use int.TryParse when you need numeric values. Handle missing file (create <wells> root) and IO errors. For multi-user scenarios or heavy writes, consider a database instead of editing the XML directly. If you want schema-level enforcement, add an xs:unique constraint to the XSD and validate on save.

Member Avatar for xml_looser

help the user schema describes the structure of the medium and the content of xml file
this man need no additional programming required to operate

http://www.xml.com/pub/a/2000/11/29/schemas/part1.html

so can create an xsd file

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">
  <xs:element name="wells">
    <xs:complexType>
      <xs:sequence>
        <xs:element ref="well"/>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
  <xs:element name="well">
    <xs:complexType>
      <xs:sequence>
        <xs:element ref="name"/>
        <xs:element ref="density"/>
        <xs:element ref="depth"/>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
  <xs:element name="name" type="xs:string"/>
  <xs:element name="density" type="xs:integer"/>
  <xs:element name="depth" type="xs:integer"/>
</xs:schema>

to use in xml file write this

<?xml version="1.0" encoding="utf-8"?>
<wells xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="wells.xsd">
	<well>
		<name>abc</name>
		<density>1000</density>
		<depth>200</depth>
	</well>
</wells>

if one is working with the xml file
use a lot of programming languages ​​as the parser check and throw an exception and then break the reading from the xml

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.