jest sobie program,
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
namespace xmlDbEditor
{
/// <summary>
/// Summary description for Form1.
/// </summary>
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.GroupBox groupBox1;
private System.Windows.Forms.GroupBox groupBox2;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.ListBox lbTables;
private System.Windows.Forms.TextBox edTableName;
private System.Windows.Forms.Button btnAddTable;
private System.Windows.Forms.Button btnRemoveTable;
private System.Windows.Forms.Button btnChangeTableName;
private System.Windows.Forms.TextBox edColumnName;
private System.Windows.Forms.ComboBox cbColumnType;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.Button btnChangeColumn;
private System.Windows.Forms.Button btnRemoveColumn;
private System.Windows.Forms.Button btnAddColumn;
private System.Windows.Forms.GroupBox groupBox3;
private System.Windows.Forms.DataGrid dgData;
private System.Windows.Forms.ListView lvColumns;
private System.Windows.Forms.ColumnHeader columnName;
private System.Windows.Forms.ColumnHeader columnType;
private System.Windows.Forms.MainMenu mainMenu1;
private System.Windows.Forms.MenuItem menuItem1;
private System.Windows.Forms.MenuItem mnuNew;
private System.Windows.Forms.MenuItem mnuOpen;
private System.Windows.Forms.MenuItem menuItem5;
private System.Windows.Forms.MenuItem mnuSave;
private System.Windows.Forms.MenuItem mnuSaveAs;
private System.Windows.Forms.MenuItem menuItem8;
private System.Windows.Forms.MenuItem mnuExit;
private DataTable currentTable;
private System.Windows.Forms.SaveFileDialog saveFileDialog;
private System.Windows.Forms.OpenFileDialog openFileDialog;
private string fnSchema=null;
private DataSet dataSet = new DataSet();
private GroupBox groupBox4;
private Label label3;
private ComboBox comboBox1;
private Label label6;
private Label label5;
private TextBox textBox1;
private Button button1;
private TextBox textBox2;
private IContainer components;
public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
//
// TODO: Add any constructor code after InitializeComponent call
//
}
/// <summary>
/// Clean up any resources being used.
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.btnChangeTableName = new System.Windows.Forms.Button();
this.btnRemoveTable = new System.Windows.Forms.Button();
this.btnAddTable = new System.Windows.Forms.Button();
this.label1 = new System.Windows.Forms.Label();
this.edTableName = new System.Windows.Forms.TextBox();
this.lbTables = new System.Windows.Forms.ListBox();
this.groupBox2 = new System.Windows.Forms.GroupBox();
this.lvColumns = new System.Windows.Forms.ListView();
this.columnName = new System.Windows.Forms.ColumnHeader();
this.columnType = new System.Windows.Forms.ColumnHeader();
this.label4 = new System.Windows.Forms.Label();
this.cbColumnType = new System.Windows.Forms.ComboBox();
this.label2 = new System.Windows.Forms.Label();
this.edColumnName = new System.Windows.Forms.TextBox();
this.btnChangeColumn = new System.Windows.Forms.Button();
this.btnAddColumn = new System.Windows.Forms.Button();
this.btnRemoveColumn = new System.Windows.Forms.Button();
this.groupBox3 = new System.Windows.Forms.GroupBox();
this.dgData = new System.Windows.Forms.DataGrid();
this.mainMenu1 = new System.Windows.Forms.MainMenu(this.components);
this.menuItem1 = new System.Windows.Forms.MenuItem();
this.mnuNew = new System.Windows.Forms.MenuItem();
this.mnuOpen = new System.Windows.Forms.MenuItem();
this.menuItem5 = new System.Windows.Forms.MenuItem();
this.mnuSave = new System.Windows.Forms.MenuItem();
this.mnuSaveAs = new System.Windows.Forms.MenuItem();
this.menuItem8 = new System.Windows.Forms.MenuItem();
this.mnuExit = new System.Windows.Forms.MenuItem();
this.saveFileDialog = new System.Windows.Forms.SaveFileDialog();
this.openFileDialog = new System.Windows.Forms.OpenFileDialog();
this.groupBox4 = new System.Windows.Forms.GroupBox();
this.label3 = new System.Windows.Forms.Label();
this.label5 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.comboBox1 = new System.Windows.Forms.ComboBox();
this.textBox1 = new System.Windows.Forms.TextBox();
this.textBox2 = new System.Windows.Forms.TextBox();
this.button1 = new System.Windows.Forms.Button();
this.groupBox1.SuspendLayout();
this.groupBox2.SuspendLayout();
this.groupBox3.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dgData)).BeginInit();
this.groupBox4.SuspendLayout();
this.SuspendLayout();
//
// groupBox1
//
this.groupBox1.Controls.Add(this.btnChangeTableName);
this.groupBox1.Controls.Add(this.btnRemoveTable);
this.groupBox1.Controls.Add(this.btnAddTable);
this.groupBox1.Controls.Add(this.label1);
this.groupBox1.Controls.Add(this.edTableName);
this.groupBox1.Controls.Add(this.lbTables);
this.groupBox1.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.groupBox1.Location = new System.Drawing.Point(24, 117);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(320, 256);
this.groupBox1.TabIndex = 0;
this.groupBox1.TabStop = false;
this.groupBox1.Text = "Tabele";
this.groupBox1.Enter += new System.EventHandler(this.groupBox1_Enter);
//
// btnChangeTableName
//
this.btnChangeTableName.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.btnChangeTableName.Location = new System.Drawing.Point(208, 48);
this.btnChangeTableName.Name = "btnChangeTableName";
this.btnChangeTableName.Size = new System.Drawing.Size(104, 24);
this.btnChangeTableName.TabIndex = 2;
this.btnChangeTableName.Text = "&Zmien tabele";
this.btnChangeTableName.Click += new System.EventHandler(this.btnChangeTableName_Click);
//
// btnRemoveTable
//
this.btnRemoveTable.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.btnRemoveTable.Location = new System.Drawing.Point(208, 88);
this.btnRemoveTable.Name = "btnRemoveTable";
this.btnRemoveTable.Size = new System.Drawing.Size(104, 24);
this.btnRemoveTable.TabIndex = 3;
this.btnRemoveTable.Text = "&Usun tabele";
this.btnRemoveTable.Click += new System.EventHandler(this.btnRemoveTable_Click);
//
// btnAddTable
//
this.btnAddTable.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.btnAddTable.Location = new System.Drawing.Point(208, 24);
this.btnAddTable.Name = "btnAddTable";
this.btnAddTable.Size = new System.Drawing.Size(104, 24);
this.btnAddTable.TabIndex = 1;
this.btnAddTable.Text = "&Dodaj tabele";
this.btnAddTable.Click += new System.EventHandler(this.btnAddTable_Click);
//
// label1
//
this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label1.Location = new System.Drawing.Point(8, 24);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(40, 16);
this.label1.TabIndex = 2;
this.label1.Text = "Nazwa:";
//
// edTableName
//
this.edTableName.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.edTableName.Location = new System.Drawing.Point(48, 24);
this.edTableName.Name = "edTableName";
this.edTableName.Size = new System.Drawing.Size(144, 20);
this.edTableName.TabIndex = 0;
//
// lbTables
//
this.lbTables.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.lbTables.Location = new System.Drawing.Point(16, 88);
this.lbTables.Name = "lbTables";
this.lbTables.Size = new System.Drawing.Size(176, 160);
this.lbTables.TabIndex = 4;
this.lbTables.TabStop = false;
this.lbTables.SelectedIndexChanged += new System.EventHandler(this.lbTables_SelectedIndexChanged);
//
// groupBox2
//
this.groupBox2.Controls.Add(this.lvColumns);
this.groupBox2.Controls.Add(this.label4);
this.groupBox2.Controls.Add(this.cbColumnType);
this.groupBox2.Controls.Add(this.label2);
this.groupBox2.Controls.Add(this.edColumnName);
this.groupBox2.Controls.Add(this.btnChangeColumn);
this.groupBox2.Controls.Add(this.btnAddColumn);
this.groupBox2.Controls.Add(this.btnRemoveColumn);
this.groupBox2.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.groupBox2.Location = new System.Drawing.Point(24, 388);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(320, 296);
this.groupBox2.TabIndex = 1;
this.groupBox2.TabStop = false;
this.groupBox2.Text = "Kolumny";
//
// lvColumns
//
this.lvColumns.Columns.AddRange(new System.Windows.Forms.ColumnHeader[] {
this.columnName,
this.columnType});
this.lvColumns.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.lvColumns.FullRowSelect = true;
this.lvColumns.Location = new System.Drawing.Point(16, 96);
this.lvColumns.Name = "lvColumns";
this.lvColumns.Size = new System.Drawing.Size(176, 192);
this.lvColumns.TabIndex = 5;
this.lvColumns.TabStop = false;
this.lvColumns.UseCompatibleStateImageBehavior = false;
this.lvColumns.View = System.Windows.Forms.View.Details;
//
// columnName
//
this.columnName.Text = "Nazwa";
//
// columnType
//
this.columnType.Text = "Typ";
this.columnType.Width = 90;
//
// label4
//
this.label4.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label4.Location = new System.Drawing.Point(8, 48);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(40, 16);
this.label4.TabIndex = 9;
this.label4.Text = "Typ:";
//
// cbColumnType
//
this.cbColumnType.CausesValidation = false;
this.cbColumnType.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cbColumnType.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.cbColumnType.Items.AddRange(new object[] {
"Boolean",
"Byte",
"Char",
"DateTime",
"Decimal",
"Double",
"Int16",
"Int32",
"Int64",
"String"});
this.cbColumnType.Location = new System.Drawing.Point(56, 48);
this.cbColumnType.Name = "cbColumnType";
this.cbColumnType.Size = new System.Drawing.Size(136, 21);
this.cbColumnType.TabIndex = 1;
//
// label2
//
this.label2.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label2.Location = new System.Drawing.Point(8, 24);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(40, 16);
this.label2.TabIndex = 0;
this.label2.Text = "Nazwa:";
//
// edColumnName
//
this.edColumnName.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.edColumnName.Location = new System.Drawing.Point(56, 24);
this.edColumnName.Name = "edColumnName";
this.edColumnName.Size = new System.Drawing.Size(136, 20);
this.edColumnName.TabIndex = 0;
//
// btnChangeColumn
//
this.btnChangeColumn.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.btnChangeColumn.Location = new System.Drawing.Point(208, 48);
this.btnChangeColumn.Name = "btnChangeColumn";
this.btnChangeColumn.Size = new System.Drawing.Size(104, 24);
this.btnChangeColumn.TabIndex = 3;
this.btnChangeColumn.Text = "Zmien kolumne";
this.btnChangeColumn.Click += new System.EventHandler(this.btnChangeColumn_Click);
//
// btnAddColumn
//
this.btnAddColumn.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.btnAddColumn.Location = new System.Drawing.Point(208, 24);
this.btnAddColumn.Name = "btnAddColumn";
this.btnAddColumn.Size = new System.Drawing.Size(104, 24);
this.btnAddColumn.TabIndex = 2;
this.btnAddColumn.Text = "Dodaj kolumne";
this.btnAddColumn.Click += new System.EventHandler(this.btnAddColumn_Click);
//
// btnRemoveColumn
//
this.btnRemoveColumn.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.btnRemoveColumn.Location = new System.Drawing.Point(208, 96);
this.btnRemoveColumn.Name = "btnRemoveColumn";
this.btnRemoveColumn.Size = new System.Drawing.Size(104, 24);
this.btnRemoveColumn.TabIndex = 4;
this.btnRemoveColumn.Text = "Usun kolumne";
this.btnRemoveColumn.Click += new System.EventHandler(this.btnRemoveColumn_Click);
//
// groupBox3
//
this.groupBox3.Controls.Add(this.dgData);
this.groupBox3.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.groupBox3.Location = new System.Drawing.Point(364, 117);
this.groupBox3.Name = "groupBox3";
this.groupBox3.Size = new System.Drawing.Size(416, 569);
this.groupBox3.TabIndex = 2;
this.groupBox3.TabStop = false;
this.groupBox3.Text = "Dane tabeli";
//
// dgData
//
this.dgData.DataMember = "";
this.dgData.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.dgData.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dgData.Location = new System.Drawing.Point(16, 24);
this.dgData.Name = "dgData";
this.dgData.Size = new System.Drawing.Size(384, 528);
this.dgData.TabIndex = 0;
//
// mainMenu1
//
this.mainMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem1});
//
// menuItem1
//
this.menuItem1.Index = 0;
this.menuItem1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.mnuNew,
this.mnuOpen,
this.menuItem5,
this.mnuSave,
this.mnuSaveAs,
this.menuItem8,
this.mnuExit});
this.menuItem1.Text = "Plik";
//
// mnuNew
//
this.mnuNew.Index = 0;
this.mnuNew.Shortcut = System.Windows.Forms.Shortcut.CtrlN;
this.mnuNew.Text = "Nowy";
this.mnuNew.Click += new System.EventHandler(this.mnuNew_Click);
//
// mnuOpen
//
this.mnuOpen.Index = 1;
this.mnuOpen.Shortcut = System.Windows.Forms.Shortcut.CtrlO;
this.mnuOpen.Text = "Otworz";
this.mnuOpen.Click += new System.EventHandler(this.mnuOpen_Click);
//
// menuItem5
//
this.menuItem5.Index = 2;
this.menuItem5.Text = "-";
//
// mnuSave
//
this.mnuSave.Index = 3;
this.mnuSave.Shortcut = System.Windows.Forms.Shortcut.CtrlS;
this.mnuSave.Text = "&Zapisz";
this.mnuSave.Click += new System.EventHandler(this.mnuSave_Click);
//
// mnuSaveAs
//
this.mnuSaveAs.Index = 4;
this.mnuSaveAs.Shortcut = System.Windows.Forms.Shortcut.CtrlA;
this.mnuSaveAs.Text = "Zapisz jako...";
this.mnuSaveAs.Click += new System.EventHandler(this.mnuSaveAs_Click);
//
// menuItem8
//
this.menuItem8.Index = 5;
this.menuItem8.Text = "-";
//
// mnuExit
//
this.mnuExit.Index = 6;
this.mnuExit.Shortcut = System.Windows.Forms.Shortcut.CtrlX;
this.mnuExit.Text = "Zakończ";
this.mnuExit.Click += new System.EventHandler(this.mnuExit_Click);
//
// saveFileDialog
//
this.saveFileDialog.DefaultExt = "xml";
this.saveFileDialog.Filter = "XML Files|*.xml";
this.saveFileDialog.InitialDirectory = ".\\";
this.saveFileDialog.Title = "Save Database As...";
//
// openFileDialog
//
this.openFileDialog.DefaultExt = "xml";
this.openFileDialog.Filter = "\"XML Files|*.xml";
this.openFileDialog.Title = "Open Database...";
//
// groupBox4
//
this.groupBox4.Controls.Add(this.button1);
this.groupBox4.Controls.Add(this.textBox2);
this.groupBox4.Controls.Add(this.textBox1);
this.groupBox4.Controls.Add(this.comboBox1);
this.groupBox4.Controls.Add(this.label6);
this.groupBox4.Controls.Add(this.label5);
this.groupBox4.Controls.Add(this.label3);
this.groupBox4.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold);
this.groupBox4.Location = new System.Drawing.Point(24, 3);
this.groupBox4.Name = "groupBox4";
this.groupBox4.Size = new System.Drawing.Size(320, 108);
this.groupBox4.TabIndex = 3;
this.groupBox4.TabStop = false;
this.groupBox4.Text = "Select";
//
// label3
//
this.label3.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label3.Location = new System.Drawing.Point(13, 34);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(51, 16);
this.label3.TabIndex = 3;
this.label3.Text = "SELECT";
this.label3.Click += new System.EventHandler(this.label3_Click);
//
// label5
//
this.label5.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label5.Location = new System.Drawing.Point(13, 60);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(51, 16);
this.label5.TabIndex = 4;
this.label5.Text = "FROM";
//
// label6
//
this.label6.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label6.Location = new System.Drawing.Point(13, 85);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(51, 16);
this.label6.TabIndex = 5;
this.label6.Text = "WHERE";
//
// comboBox1
//
this.comboBox1.FormattingEnabled = true;
this.comboBox1.Location = new System.Drawing.Point(70, 56);
this.comboBox1.Name = "comboBox1";
this.comboBox1.Size = new System.Drawing.Size(144, 21);
this.comboBox1.TabIndex = 6;
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(70, 83);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(144, 20);
this.textBox1.TabIndex = 7;
//
// textBox2
//
this.textBox2.Location = new System.Drawing.Point(70, 30);
this.textBox2.Name = "textBox2";
this.textBox2.Size = new System.Drawing.Size(144, 20);
this.textBox2.TabIndex = 8;
//
// button1
//
this.button1.Location = new System.Drawing.Point(234, 56);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(78, 45);
this.button1.TabIndex = 9;
this.button1.Text = "pobierz";
this.button1.UseVisualStyleBackColor = true;
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(792, 687);
this.Controls.Add(this.groupBox4);
this.Controls.Add(this.groupBox3);
this.Controls.Add(this.groupBox2);
this.Controls.Add(this.groupBox1);
this.Menu = this.mainMenu1;
this.Name = "Form1";
this.Text = "Edytor Baz XML";
this.groupBox1.ResumeLayout(false);
this.groupBox1.PerformLayout();
this.groupBox2.ResumeLayout(false);
this.groupBox2.PerformLayout();
this.groupBox3.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dgData)).EndInit();
this.groupBox4.ResumeLayout(false);
this.groupBox4.PerformLayout();
this.ResumeLayout(false);
}
#endregion
/// <summary>
/// The main entry point for the application.
/// </summary>
[STAThread]
static void Main()
{
Application.Run(new Form1());
}
// menu
private void mnuNew_Click(object sender, System.EventArgs e)
{
fnSchema=null;
lbTables.Items.Clear();
lvColumns.Items.Clear();
edTableName.Text="";
edColumnName.Text="";
cbColumnType.Text="";
dataSet=new DataSet(); //DataSet odpowiedzialny za 2 warste obslugi bazy
dgData.SetDataBinding(dataSet, null);
}
private void mnuOpen_Click(object sender, System.EventArgs e)
{
DialogResult res=openFileDialog.ShowDialog(this);
if (res==DialogResult.OK)
{
string fn=openFileDialog.FileName;
DataSet ds=new DataSet();
ds.ReadXml(fn);
lbTables.Items.Clear();
foreach (DataTable dt in ds.Tables)
{
lbTables.Items.Add(dt.TableName);
}
dataSet=ds;
lbTables.SelectedIndex=0;
fnSchema=fn;
this.Text="Edytor baz XML - "+fnSchema;
}
}
private void mnuSave_Click(object sender, System.EventArgs e)
{
if (fnSchema==null)
{
mnuSaveAs_Click(sender, e);
}
else
{
SaveSchema(fnSchema);
lbTables.SelectedIndex=lbTables.SelectedIndex;
}
}
private void mnuSaveAs_Click(object sender, System.EventArgs e)
{
DialogResult res=saveFileDialog.ShowDialog(this);
if (res==DialogResult.OK)
{
fnSchema=saveFileDialog.FileName;
SaveSchema(fnSchema);
this.Text="Edytor baz XML - "+fnSchema;
lbTables.SelectedIndex=lbTables.SelectedIndex;
}
}
private void mnuExit_Click(object sender, System.EventArgs e)
{
Application.Exit();
}
//
private void btnAddTable_Click(object sender, System.EventArgs e)
{
string tblName=edTableName.Text;
if (!ValidateTableName(tblName))
{
return;
}
DataTable dt=new DataTable(tblName);
currentTable=dt;
lbTables.Items.Add(tblName);
dataSet.Tables.Add(dt);
lbTables.SelectedItem=lbTables.Items[lbTables.FindStringExact(tblName)];
}
private void btnChangeTableName_Click(object sender, System.EventArgs e)
{
string tblName=edTableName.Text;
if ( (!ValidateTableName(tblName)) || (!ValidateSelectedTable()) )
{
return;
}
int n=lbTables.Items.IndexOf(lbTables.SelectedItem);
string oldTableName=lbTables.Items[n].ToString();
dataSet.Tables[oldTableName].TableName=tblName;
lbTables.Items[n]=tblName;
dgData.SetDataBinding(dataSet, tblName);
}
private void btnRemoveTable_Click(object sender, System.EventArgs e)
{
if (!ValidateSelectedTable())
{
return;
}
int n=lbTables.Items.IndexOf(lbTables.SelectedItem);
string tblName=lbTables.Items[n].ToString();
lbTables.Items.Remove(lbTables.SelectedItem);
DataTable dt=dataSet.Tables[tblName];
dt.Clear();
dt.Columns.Clear();
dataSet.Tables.Remove(tblName);
currentTable=null;
dgData.SetDataBinding(dataSet, null);
}
private void lbTables_SelectedIndexChanged(object sender, System.EventArgs e)
{
string tblName=lbTables.Text;
currentTable=dataSet.Tables[tblName];
ShowColumns();
dgData.SetDataBinding(dataSet, tblName);
dgData.CaptionText="Tabela: "+tblName;
}
private void btnAddColumn_Click(object sender, System.EventArgs e)
{
string colName=edColumnName.Text;
string colType=cbColumnType.Text;
if ( (!ValidateColumnNameAndType(colName, colType)) || (!ValidateSelectedTable()) )
{
return;
}
ListViewItem lvi=lvColumns.Items.Add(colName);
lvi.SubItems.Add(colType);
currentTable.Columns.Add(colName, Type.GetType("System."+colType));
}
private void btnChangeColumn_Click(object sender, System.EventArgs e)
{
if (!ValidateSelectedColumn())
{
return;
}
ListViewItem lvi=lvColumns.SelectedItems[0];
string prevColName=lvi.Text;
lvi.Text=edColumnName.Text;
currentTable.Columns[prevColName].ColumnName=edColumnName.Text;
//nie dziala
// lvi.SubItems[1].Text=cbColumnType.Text;
// currentTable.Columns[edColumnName.Text].DataType=Type.GetType("System."+cbColumnType.Text);
}
private void btnRemoveColumn_Click(object sender, System.EventArgs e)
{
if (!ValidateSelectedColumn())
{
return;
}
ListViewItem lvi=lvColumns.SelectedItems[0];
lvColumns.Items.Remove(lvi);
currentTable.Columns.Remove(lvi.Text);
}
bool ValidateTableName(string tblName)
{
if (tblName=="")
{
MessageBox.Show("Wpisz nazwe tabeli.", "Brak nazway");
return false;
}
int ret=lbTables.FindStringExact(tblName);
if (ret!=ListBox.NoMatches)
{
MessageBox.Show("Taka tabela jest juz w spisie.", "Zła nazwa");
return false;
}
return true;
}
bool ValidateSelectedTable()
{
if (lbTables.SelectedItem==null)
{
MessageBox.Show("Wybierz tabele", "Nie wybrano tabeli");
return false;
}
return true;
}
bool ValidateColumnNameAndType(string colName, string colType)
{
if (colName=="")
{
MessageBox.Show("Wpisz nazwe kolumny.", "Brak nazwy kolumny");
return false;
}
if (colType=="")
{
MessageBox.Show("Wybierz typ kolumny", "Brak typu kolumny");
return false;
}
if (GetLVI(colName)!=null)
{
MessageBox.Show("Kolumna juz istnije zmien nazwa.", "Zla nazwa kolumny");
return false;
}
return true;
}
bool ValidateSelectedColumn()
{
if (lvColumns.SelectedItems.Count==0)
{
MessageBox.Show("Wybierz kolumne z listy", "Nie wybrano kolumny");
return false;
}
return true;
}
ListViewItem GetLVI(string colName)
{
ListView.ListViewItemCollection lvItems=lvColumns.Items;
foreach (ListViewItem lvItem in lvItems)
{
if (lvItem.Text==colName)
{
return lvItem;
}
}
return null;
}
void ShowColumns()
{
lvColumns.Items.Clear();
if (currentTable != null)
{
foreach (DataColumn dc in currentTable.Columns)
{
ListViewItem lvi=lvColumns.Items.Add(dc.ColumnName);
string s=dc.DataType.ToString();
s=s.Split(new Char[] {'.'})[1];
lvi.SubItems.Add(s);
}
}
}
void SaveSchema(string fn)
{
dataSet.WriteXml(fn, XmlWriteMode.WriteSchema);
MessageBox.Show("Schemat bazy i dane zapisane", "OK");
}
private void groupBox1_Enter(object sender, EventArgs e)
{
}
private void label3_Click(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
dgData.Select(3);
}
}
}
interesuje nas ostatnia metoda/zdarzenie button1_Click()
po kliknieciu w button ma zostac wybrana cala zawrtosc rządanej tabeli. Podejrzewam ze bedzie do tego sluzyc wlasnie dgData. Tylko że parametr to id rekordu... a ja potrzebuje wszystkie.
prosze o pomoc