14.6.txt

《Microsoft Visual C# .NET 2003开发技巧大全》源代码

using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
namespace _14_DataSetToXml
{
/// <summary>
/// Summary description for Form1.
/// </summary>
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.MainMenu mainMenu1;
private System.Windows.Forms.MenuItem menuItem1;
private System.Windows.Forms.MenuItem mnuOpen;
private System.Windows.Forms.MenuItem mnuSave;
private System.Windows.Forms.MenuItem mnuExit;
private System.Windows.Forms.MenuItem menuItem5;
private System.Windows.Forms.MenuItem mnuLoad;
private System.Windows.Forms.MenuItem mnuUpdate;
private System.Windows.Forms.DataGrid dataGrid1;
private System.Data.SqlClient.SqlCommand sqlSelectCommand1;
private System.Data.SqlClient.SqlCommand sqlInsertCommand1;
private System.Data.SqlClient.SqlCommand sqlUpdateCommand1;
private System.Data.SqlClient.SqlCommand sqlDeleteCommand1;
private System.Data.SqlClient.SqlConnection sqlConnection1;
private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
private _14_DataSetToXml.ProductsDS productsDS1;
private System.Windows.Forms.SaveFileDialog saveFileDialog1;
private System.Windows.Forms.OpenFileDialog openFileDialog1;
/// <summary>
/// Required designer variable.
/// </summary>
private System.ComponentModel.Container components = null;
public Form1()
{
InitializeComponent();
// fill the dataset and bind to datagrid
sqlDataAdapter1.Fill( productsDS1 );
dataGrid1.SetDataBinding( productsDS1, “Products” );
}
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
/* Windows Forms Designer Generated Code */
[STAThread]
static void Main()
{
Application.Run(new Form1());
}
private void mnuLoad_Click(object sender, System.EventArgs e)
{
if( productsDS1.HasChanges() )
{
if( AskUser(“The Dataset has changed. “ +
“ Are you sure you want to continue? “)==DialogResult.No )
{
return;
}
}
// clear dataset and get data from database
productsDS1.Clear();
sqlDataAdapter1.Fill( productsDS1 );
dataGrid1.SetDataBinding( productsDS1, “Products” );
}
private DialogResult AskUser(string question)
{
return MessageBox.Show( question, “DatasetToXml”,
MessageBoxButtons.YesNo, MessageBoxIcon.Question );
}
private void mnuSave_Click(object sender, System.EventArgs e)
{
if( saveFileDialog1.ShowDialog() == DialogResult.OK )
{
productsDS1.WriteXml( saveFileDialog1.FileName,
XmlWriteMode.DiffGram);
}
}
private void mnuUpdate_Click(object sender, System.EventArgs e)
{
if( productsDS1.HasChanges() )
{
// update the database
sqlDataAdapter1.Update( productsDS1, “Products” );
}
}
private void mnuOpen_Click(object sender, System.EventArgs e)
{
// implemented in next section
}
private void mnuExit_Click(object sender, System.EventArgs e)
{
this.Close();
}
}
}