Click here to Skip to main content
15,894,539 members
Home / Discussions / C#
   

C#

 
GeneralNumber to Word Pin
| Muhammad Waqas Butt |29-Dec-04 0:57
professional| Muhammad Waqas Butt |29-Dec-04 0:57 
GeneralRe: Number to Word Pin
Marc Clifton29-Dec-04 3:11
mvaMarc Clifton29-Dec-04 3:11 
Generalchanging row color in a datagrid Pin
Salmanzz28-Dec-04 19:47
Salmanzz28-Dec-04 19:47 
GeneralRe: changing row color in a datagrid Pin
Identity Undisclosed28-Dec-04 20:25
Identity Undisclosed28-Dec-04 20:25 
GeneralRe: changing row color in a datagrid Pin
Robert Rohde28-Dec-04 22:08
Robert Rohde28-Dec-04 22:08 
GeneralAutonumber is not showing up in the child table Pin
msogun28-Dec-04 18:16
msogun28-Dec-04 18:16 
GeneralRe: "This row already belongs to this table." Pin
Robert Rohde28-Dec-04 22:05
Robert Rohde28-Dec-04 22:05 
Generalread a .xsd file and write it on a xml file with data's automatically written Pin
dhol28-Dec-04 16:55
dhol28-Dec-04 16:55 
Hi I need a help Pls Itsvery 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");
}
}
}
Generalscreen capture using WMEncoder Pin
Member 161799928-Dec-04 13:11
Member 161799928-Dec-04 13:11 
GeneralCapture the Fn key on a laptop Pin
sparker6228-Dec-04 9:31
sparker6228-Dec-04 9:31 
GeneralRe: Capture the Fn key on a laptop Pin
Heath Stewart28-Dec-04 10:08
protectorHeath Stewart28-Dec-04 10:08 
GeneralRe: Capture the Fn key on a laptop Pin
sparker6228-Dec-04 10:37
sparker6228-Dec-04 10:37 
GeneralRe: Capture the Fn key on a laptop Pin
Heath Stewart28-Dec-04 10:39
protectorHeath Stewart28-Dec-04 10:39 
QuestionHow to write { character to a text file? Pin
James Rossiter28-Dec-04 7:43
James Rossiter28-Dec-04 7:43 
AnswerRe: How to write { character to a text file? Pin
Guinness4Strength28-Dec-04 7:53
Guinness4Strength28-Dec-04 7:53 
AnswerRe: How to write { character to a text file? Pin
leppie28-Dec-04 8:21
leppie28-Dec-04 8:21 
Questionupdate listview subitems without redrawing the whole row? Pin
dfsgdsfgdfg28-Dec-04 7:39
dfsgdsfgdfg28-Dec-04 7:39 
GeneralA customized TabControl (no tabs..) Pin
R W Briggs28-Dec-04 7:23
R W Briggs28-Dec-04 7:23 
GeneralTextBox color Pin
picasso228-Dec-04 7:22
picasso228-Dec-04 7:22 
GeneralRe: TextBox color Pin
Identity Undisclosed28-Dec-04 7:42
Identity Undisclosed28-Dec-04 7:42 
GeneralRe: TextBox color Pin
R W Briggs28-Dec-04 9:09
R W Briggs28-Dec-04 9:09 
GeneralCombo ControlArray - Selected Item Pin
Sylesh28-Dec-04 7:19
Sylesh28-Dec-04 7:19 
GeneralRe: Combo ControlArray - Selected Item Pin
Guinness4Strength28-Dec-04 7:56
Guinness4Strength28-Dec-04 7:56 
GeneralRe: Combo ControlArray - Selected Item Pin
Identity Undisclosed28-Dec-04 8:09
Identity Undisclosed28-Dec-04 8:09 
GeneralRe: Combo ControlArray - Selected Item Pin
Sylesh29-Dec-04 3:03
Sylesh29-Dec-04 3:03 

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.