Click here to Skip to main content
15,896,207 members
Articles / Programming Languages / XML

Create Data Classes

Rate me:
Please Sign up or sign in to vote.
4.88/5 (31 votes)
4 Mar 2011CPOL10 min read 135.9K   2.5K   167  
An application that creates a C# class to read/write data to/from an Access, SQLite, or XML database.
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

/*
 * Copyright Jeff Gaines 2007 - 2011 (jeff@jgaines.co.uk)
 * Free licence for private use
 * Please contact the author if you wish to use the code commercially
*/

namespace JGCreateDataClasses
{
	/// <summary>
	/// Allows creation of an XML database for current project
	/// </summary>
	public partial class FormCreateXMLSchema : Form
	{
		//	Tooltip for buttons
		private ToolTip m_ToolTip = new ToolTip();

		public FormCreateXMLSchema()
		{
			InitializeComponent();

			//	ToolTips
			m_ToolTip.SetToolTip(btnCreateSchema, "Create XML Schema File");
			m_ToolTip.SetToolTip(btnClose, "Close Dialog");
		}

		private void FormCreateXMLSchema_Load(object sender, EventArgs e)
		{
			jFileFolderPicker1.Focus();
		}

		private void btnClose_Click(object sender, EventArgs e)
		{
			Close();
		}

		private void btnCreateSchema_Click(object sender, EventArgs e)
		{
			if (!IsDataComplete(true))
				return;

			this.DialogResult = DialogResult.OK;
			Close();
		}

		private string GetFileName()
		{
			string fileName = txtXMLFileName.Text;
			if (!fileName.EndsWith(".xml", true, System.Globalization.CultureInfo.CurrentCulture))	
				fileName += ".xml";

			return fileName;
		}

		private bool IsDataComplete(bool showMessage)
		{
			bool blnOK = true;
			string strMissing = "";

			if (string.IsNullOrEmpty(jFileFolderPicker1.SelectedPath))
			{
				strMissing += "XML Folder, ";
				blnOK = false;
			}
			if (string.IsNullOrEmpty(txtXMLFileName.Text))
			{
				strMissing += "XML File Name, ";
				blnOK = false;
			}
			if (string.IsNullOrEmpty(txtXMLNamespace.Text))
			{
				strMissing += "Namespace, ";
				blnOK = false;
			}
			if (string.IsNullOrEmpty(txtXMLDataSetName.Text))
			{
				strMissing += "Dataset Name, ";
				blnOK = false;
			}
			if (string.IsNullOrEmpty(txtXMLTableName.Text))
			{
				strMissing += "Table Name, ";
				blnOK = false;
			}

			if (showMessage && !blnOK)
				ShowMessage("These Fields Must Be Completed: " + strMissing, true);

			return blnOK;
		}

		private void ShowMessage(string strMes, bool blnBeep)
		{
			tslblMessage.Text = strMes;
			if (blnBeep)
				JCommon.MessageBeep(-1);
		}

		private void txtXMLFolderName_TextChanged(object sender, EventArgs e)
		{
			btnCreateSchema.Enabled = IsDataComplete(false);
		}

		public string XMLFolderName
		{
			get { return this.jFileFolderPicker1.SelectedPath; }
		}

		public string XMLFileName
		{
			get { return GetFileName(); }
		}

		public string XMLNameSpace
		{
			get { return this.txtXMLNamespace.Text; }
		}

		public string XMLDataSetName
		{
			get { return this.txtXMLDataSetName.Text; }
		}

		public string XMLTableName
		{
			get { return this.txtXMLTableName.Text; }
		}

		

		

	}
}

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Retired
United Kingdom United Kingdom
I have been a keen hobbyist programmer since getting my first computer - a Vic 20 (you had to be able to write programs then since few programs were available and all were expensive).
Retired and now living in Pewsey, Wiltshire, where I spend (far too much of) my time writing computer programs to keep my mind active.

Comments and Discussions