Click here to Skip to main content
15,881,281 members
Home / Discussions / XML / XSL
   

XML / XSL

 
GeneralHelp with XML Pin
dotnetquery9-Jan-05 18:07
dotnetquery9-Jan-05 18:07 
GeneralWebservices Pin
rgoyal7-Jan-05 18:21
rgoyal7-Jan-05 18:21 
GeneralUsing XML to develop portal. Pin
ruthra30-Dec-04 21:22
ruthra30-Dec-04 21:22 
GeneralRe: Using XML to develop portal. Pin
DavidNohejl31-Dec-04 0:48
DavidNohejl31-Dec-04 0:48 
Generala little OT: SVGViewer and WinXP SP2 Pin
fuel2run29-Dec-04 22:04
fuel2run29-Dec-04 22:04 
GeneralWebservice question Pin
steve_rm29-Dec-04 5:12
steve_rm29-Dec-04 5:12 
GeneralRe: Webservice question Pin
Javier Lozano1-Jan-05 13:57
Javier Lozano1-Jan-05 13:57 
GeneralRead any Xml schema file and write it on a xml file with data's automatically written according to their appropriate datatypes using c# Pin
dhol28-Dec-04 23:53
dhol28-Dec-04 23:53 
Hi I need a help Pls Its very urgent , help me to get out
I have doen a pgm to read
any schema file(.xsd) and load data's into a xml file(resultant file).
Here what I had done inside the Load button is that for any datatypes
in the schema, enter the values as james for string, 100 for interger
like that, I have specified by using the SWITCH statement. But my
requirement is such that , when I entered the .xsd file and resultant xml file then when i click the Load Button, It should create around 200 data's but, the data's should differ form each other.
I dont know how to do this. Pls help me. Here I am sending the coding
again.create a new project with c# windows application, copy this
coding and run and see.

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Xml;
using System.Xml.Schema;

namespace testdatagenerator
{
///
/// Summary description for Form1.
///
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.TextBox txtSchema;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.TextBox txtXml;
private System.Windows.Forms.Button button2;
private System.Windows.Forms.Button button3;
private System.Windows.Forms.DataGrid dataGrid1;
private System.Data.DataSet dataSet1;
///
/// Required designer variable.
///
private System.ComponentModel.Container components = null;

public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();

//
// TODO: Add any constructor code after InitializeComponent call
//
}

///
/// Clean up any resources being used.
///
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}

#region Windows Form Designer generated code
///
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///
private void InitializeComponent()
{
this.txtSchema = new System.Windows.Forms.TextBox();
this.button1 = new System.Windows.Forms.Button();
this.txtXml = new System.Windows.Forms.TextBox();
this.button2 = new System.Windows.Forms.Button();
this.button3 = new System.Windows.Forms.Button();
this.dataGrid1 = new System.Windows.Forms.DataGrid();
this.dataSet1 = new System.Data.DataSet();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet1)).BeginInit();
this.SuspendLayout();
//
// txtSchema
//
this.txtSchema.Location = new System.Drawing.Point(88, 24);
this.txtSchema.Name = "txtSchema";
this.txtSchema.Size = new System.Drawing.Size(440, 20);
this.txtSchema.TabIndex = 0;
this.txtSchema.Text = "";
//
// button1
//
this.button1.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.button1.Location = new System.Drawing.Point(536, 24);
this.button1.Name = "button1";
this.button1.TabIndex = 1;
this.button1.Text = "Browse";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// txtXml
//
this.txtXml.Location = new System.Drawing.Point(88, 64);
this.txtXml.Name = "txtXml";
this.txtXml.Size = new System.Drawing.Size(440, 20);
this.txtXml.TabIndex = 2;
this.txtXml.Text = "";
//
// button2
//
this.button2.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.button2.Location = new System.Drawing.Point(536, 64);
this.button2.Name = "button2";
this.button2.TabIndex = 3;
this.button2.Text = "Load";
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// button3
//
this.button3.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this.button3.Location = new System.Drawing.Point(616, 64);
this.button3.Name = "button3";
this.button3.TabIndex = 4;
this.button3.Text = "Save";
this.button3.Click += new System.EventHandler(this.button3_Click);
//
// dataGrid1
//
this.dataGrid1.DataMember = "";
this.dataGrid1.DataSource = this.dataSet1;
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(0, 120);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.Size = new System.Drawing.Size(776, 320);
this.dataGrid1.TabIndex = 5;
//
// dataSet1
//
this.dataSet1.DataSetName = "NewDataSet";
this.dataSet1.Locale = new System.Globalization.CultureInfo("en-US");
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(808, 454);
this.Controls.Add(this.dataGrid1);
this.Controls.Add(this.button3);
this.Controls.Add(this.button2);
this.Controls.Add(this.txtXml);
this.Controls.Add(this.button1);
this.Controls.Add(this.txtSchema);
this.Name = "Form1";
this.Text = "TestDatagenerator";
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet1)).EndInit();
this.ResumeLayout(false);

}
#endregion

///
/// The main entry point for the application.
///
[STAThread]
static void Main()
{
Application.Run(new Form1());
}

private void button1_Click(object sender, System.EventArgs e)
{
OpenFileDialog fdlg = new OpenFileDialog();
fdlg.Title = "select schema file" ;
fdlg.InitialDirectory = @"c:\CDEV\testdatagenerator" ;
fdlg.Filter = "schema files(*.xsd) |*.xsd| all files(*.*) | *.*";
fdlg.FilterIndex = 2 ;
fdlg.RestoreDirectory = true ;
if(fdlg.ShowDialog() == DialogResult.OK)
{
txtSchema.Text = fdlg.FileName ;
}
}

private void button2_Click(object sender, System.EventArgs e)
{
dataSet1.ReadXmlSchema(txtSchema.Text);

foreach (DataTable dTbl in dataSet1.Tables)
{
object[] oValues = new object[dTbl.Columns.Count];
int i = 0;

foreach (DataColumn dColmn in dTbl.Columns)
{
switch(dColmn.DataType.ToString())
{
case "System.String":
oValues[i] = (string) "This is string";
break;

case "System.Int32":
oValues[i] = (int) 100;
break;

case "System.DateTime":
oValues[i] = new DateTime(2004,10,12);
break;

case "System.Decimal":
oValues[i] = new Decimal(999999999.99);
break;

case "System.Int16":
oValues[i] = (short) 32767;
break;

case "System.Int64":
oValues[i] = (long) 9223372036854775807;
break;

case "System.Double":
oValues[i] = (double) 888888888888888;
break;
}
i += 1;
}
dTbl.Rows.Add(oValues);
}
}
private void button3_Click(object sender, System.EventArgs e)
{

dataSet1.WriteXml(txtXml.Text,XmlWriteMode.WriteSchema );
MessageBox.Show("Saved");
}
}
}

GeneralXML to develop portal. Pin
ruthra28-Dec-04 15:30
ruthra28-Dec-04 15:30 
GeneralXPath navigation with namespaces Pin
Steven Campbell28-Dec-04 9:32
Steven Campbell28-Dec-04 9:32 
GeneralRe: XPath navigation with namespaces Pin
DavidNohejl28-Dec-04 10:16
DavidNohejl28-Dec-04 10:16 
GeneralRe: XPath navigation with namespaces Pin
Steven Campbell28-Dec-04 12:33
Steven Campbell28-Dec-04 12:33 
GeneralRe: XPath navigation with namespaces Pin
DavidNohejl28-Dec-04 13:04
DavidNohejl28-Dec-04 13:04 
GeneralRe: XPath navigation with namespaces Pin
DavidNohejl28-Dec-04 13:15
DavidNohejl28-Dec-04 13:15 
GeneralRe: XPath navigation with namespaces Pin
Steven Campbell30-Dec-04 4:44
Steven Campbell30-Dec-04 4:44 
GeneralXML validation through XSD Pin
Het210927-Dec-04 23:00
Het210927-Dec-04 23:00 
GeneralRe: XML validation through XSD Pin
DavidNohejl28-Dec-04 9:05
DavidNohejl28-Dec-04 9:05 
GeneralRe: XML validation through XSD Pin
Het210931-Dec-04 21:48
Het210931-Dec-04 21:48 
GeneralW3C XML standards Pin
Nosheen Iqbal21-Dec-04 16:20
Nosheen Iqbal21-Dec-04 16:20 
GeneralI want XML to draw the network topology Pin
Mohammed Aijaz Mohiuddin21-Dec-04 6:00
Mohammed Aijaz Mohiuddin21-Dec-04 6:00 
GeneralRe: I want XML to draw the network topology Pin
DavidNohejl21-Dec-04 8:29
DavidNohejl21-Dec-04 8:29 
GeneralSkip blocks of nodes with XSL Pin
Milby00720-Dec-04 0:22
Milby00720-Dec-04 0:22 
GeneralRe: Skip blocks of nodes with XSL Pin
Milby00720-Dec-04 3:13
Milby00720-Dec-04 3:13 
GeneralRe: Skip blocks of nodes with XSL Pin
Milby00720-Dec-04 23:46
Milby00720-Dec-04 23:46 
GeneralBasic XML Pin
sharkbait16-Dec-04 3:55
sharkbait16-Dec-04 3:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.