в 15:31, 26 мая 2010

2010-05-26T15:31:53Z

Admin: 1 версия

2010-05-26T12:19:08Z

1 версия

Новая страница

==Delete data and reload to DataGrid==

<source lang="csharp">using System;
using System.Drawing;
using System.Collections;
using System.ruponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
public class DeleteDataLoadDataGrid : System.Windows.Forms.Form
{
private System.Windows.Forms.DataGrid dataGrid1;
private System.Windows.Forms.Button InsertCommand;
private System.Windows.Forms.Button UpdateCommand;
private System.Windows.Forms.Button DeleteCommand;
private System.Windows.Forms.CheckBox checkBox1;
private System.ruponentModel.Container components = null;
public DeleteDataLoadDataGrid()
{
InitializeComponent();
}
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
private void InitializeComponent()
{
this.dataGrid1 = new System.Windows.Forms.DataGrid();
this.InsertCommand = new System.Windows.Forms.Button();
this.UpdateCommand = new System.Windows.Forms.Button();
this.DeleteCommand = new System.Windows.Forms.Button();
this.checkBox1 = new System.Windows.Forms.CheckBox();
((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
this.SuspendLayout();
//
// dataGrid1
//
this.dataGrid1.DataMember = "";
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(8, 8);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.Size = new System.Drawing.Size(336, 304);
this.dataGrid1.TabIndex = 0;
//
// InsertCommand
//
this.InsertCommand.Location = new System.Drawing.Point(368, 24);
this.InsertCommand.Name = "InsertCommand";
this.InsertCommand.Size = new System.Drawing.Size(120, 32);
this.InsertCommand.TabIndex = 1;
this.InsertCommand.Text = "Insert Command";
this.InsertCommand.Click += new System.EventHandler(this.InsertCommand_Click);
//
// UpdateCommand
//
this.UpdateCommand.Location = new System.Drawing.Point(368, 72);
this.UpdateCommand.Name = "UpdateCommand";
this.UpdateCommand.Size = new System.Drawing.Size(120, 32);
this.UpdateCommand.TabIndex = 2;
this.UpdateCommand.Text = "Update Command";
this.UpdateCommand.Click += new System.EventHandler(this.UpdateCommand_Click);
//
// DeleteCommand
//
this.DeleteCommand.Location = new System.Drawing.Point(368, 120);
this.DeleteCommand.Name = "DeleteCommand";
this.DeleteCommand.Size = new System.Drawing.Size(120, 32);
this.DeleteCommand.TabIndex = 3;
this.DeleteCommand.Text = "Delete Command";
this.DeleteCommand.Click += new System.EventHandler(this.DeleteCommand_Click);
//
// checkBox1
//
this.checkBox1.Location = new System.Drawing.Point(368, 192);
this.checkBox1.Name = "checkBox1";
this.checkBox1.Size = new System.Drawing.Size(112, 24);
this.checkBox1.TabIndex = 4;
this.checkBox1.Text = "SqlCommand";
//
// DeleteDataLoadDataGrid
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(496, 325);
this.Controls.AddRange(new System.Windows.Forms.Control[] {
this.checkBox1,
this.DeleteCommand,
this.UpdateCommand,
this.InsertCommand,
this.dataGrid1});
this.Name = "DeleteDataLoadDataGrid";
this.Text = "DeleteDataLoadDataGrid";
((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.ResumeLayout(false);
}
[STAThread]
static void Main()
{
Application.Run(new DeleteDataLoadDataGrid());
}
private void InsertCommand_Click(object sender, System.EventArgs e)
{
}
private void UpdateCommand_Click(object sender, System.EventArgs e)
{
}

private void DeleteCommand_Click(object sender, System.EventArgs e)
{

string ConnectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;"+
"Data Source=c:\\Northwind.mdb";
OleDbConnection conn =
new OleDbConnection(ConnectionString);
DataSet ds = new DataSet();

try
{
conn.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter(
"SELECT * FROM Customers", conn);

OleDbCommandBuilder cmdBuilder =
new OleDbCommandBuilder(adapter);
adapter.MissingSchemaAction =
MissingSchemaAction.AddWithKey;

adapter.Fill(ds, "Customers");

DataRow row1 = ds.Tables["Customers"].Rows.Find("001");
row1.Delete();
adapter.Update(ds, "Customers");
dataGrid1.DataSource = ds.DefaultViewManager;
}
catch(OleDbException exp)
{
MessageBox.Show(exp.Message.ToString());
}
if(conn.State == ConnectionState.Open)
conn.Close();
}
}</source>

==Insert Data and reload to DataGrid==

<source lang="csharp">using System;
using System.Drawing;
using System.Collections;
using System.ruponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
public class InsertDataLoadDataGrid : System.Windows.Forms.Form
{
private System.Windows.Forms.DataGrid dataGrid1;
private System.Windows.Forms.Button InsertCommand;
private System.Windows.Forms.Button UpdateCommand;
private System.Windows.Forms.Button DeleteCommand;
private System.Windows.Forms.CheckBox checkBox1;
private System.ruponentModel.Container components = null;
public InsertDataLoadDataGrid()
{
InitializeComponent();
}
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
private void InitializeComponent()
{
this.dataGrid1 = new System.Windows.Forms.DataGrid();
this.InsertCommand = new System.Windows.Forms.Button();
this.UpdateCommand = new System.Windows.Forms.Button();
this.DeleteCommand = new System.Windows.Forms.Button();
this.checkBox1 = new System.Windows.Forms.CheckBox();
((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
this.SuspendLayout();
//
// dataGrid1
//
this.dataGrid1.DataMember = "";
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(8, 8);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.Size = new System.Drawing.Size(336, 304);
this.dataGrid1.TabIndex = 0;
//
// InsertCommand
//
this.InsertCommand.Location = new System.Drawing.Point(368, 24);
this.InsertCommand.Name = "InsertCommand";
this.InsertCommand.Size = new System.Drawing.Size(120, 32);
this.InsertCommand.TabIndex = 1;
this.InsertCommand.Text = "Insert Command";
this.InsertCommand.Click += new System.EventHandler(this.InsertCommand_Click);
//
// UpdateCommand
//
this.UpdateCommand.Location = new System.Drawing.Point(368, 72);
this.UpdateCommand.Name = "UpdateCommand";
this.UpdateCommand.Size = new System.Drawing.Size(120, 32);
this.UpdateCommand.TabIndex = 2;
this.UpdateCommand.Text = "Update Command";
this.UpdateCommand.Click += new System.EventHandler(this.UpdateCommand_Click);
//
// DeleteCommand
//
this.DeleteCommand.Location = new System.Drawing.Point(368, 120);
this.DeleteCommand.Name = "DeleteCommand";
this.DeleteCommand.Size = new System.Drawing.Size(120, 32);
this.DeleteCommand.TabIndex = 3;
this.DeleteCommand.Text = "Delete Command";
this.DeleteCommand.Click += new System.EventHandler(this.DeleteCommand_Click);
//
// checkBox1
//
this.checkBox1.Location = new System.Drawing.Point(368, 192);
this.checkBox1.Name = "checkBox1";
this.checkBox1.Size = new System.Drawing.Size(112, 24);
this.checkBox1.TabIndex = 4;
this.checkBox1.Text = "SqlCommand";
//
// InsertDataLoadDataGrid
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(496, 325);
this.Controls.AddRange(new System.Windows.Forms.Control[] {
this.checkBox1,
this.DeleteCommand,
this.UpdateCommand,
this.InsertCommand,
this.dataGrid1});
this.Name = "InsertDataLoadDataGrid";
this.Text = "InsertDataLoadDataGrid";
((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.ResumeLayout(false);
}
[STAThread]
static void Main()
{
Application.Run(new InsertDataLoadDataGrid());
}
private void InsertCommand_Click(object sender, System.EventArgs e)
{
string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\Northwind.mdb";
OleDbConnection conn = new OleDbConnection(ConnectionString);
DataRow row;
DataSet ds = new DataSet();

try
{
conn.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter(
"SELECT * FROM Customers", conn);

OleDbCommandBuilder cmdBuilder =
new OleDbCommandBuilder(adapter);
adapter.MissingSchemaAction =
MissingSchemaAction.AddWithKey;
adapter.Fill(ds, "Customers");
row = ds.Tables["Customers"].NewRow();
row["CustomerId"] = "001";
row["ContactName"] = "L";
row["CompanyName"] = "M";
ds.Tables["Customers"].Rows.Add(row);

adapter.Update(ds, "Customers");
dataGrid1.DataSource = ds.DefaultViewManager;
}
catch(OleDbException exp)
{
MessageBox.Show(exp.Message.ToString());
}
if(conn.State == ConnectionState.Open)
conn.Close();
}
private void UpdateCommand_Click(object sender, System.EventArgs e)
{
}
private void DeleteCommand_Click(object sender, System.EventArgs e)
{
}
}</source>

==Update data and reload to DataGrid==

<source lang="csharp">using System;
using System.Drawing;
using System.Collections;
using System.ruponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
public class UpdateDataLoadDataGrid : System.Windows.Forms.Form
{
private System.Windows.Forms.DataGrid dataGrid1;
private System.Windows.Forms.Button InsertCommand;
private System.Windows.Forms.Button UpdateCommand;
private System.Windows.Forms.Button DeleteCommand;
private System.Windows.Forms.CheckBox checkBox1;
private System.ruponentModel.Container components = null;
public UpdateDataLoadDataGrid()
{
InitializeComponent();
}
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
private void InitializeComponent()
{
this.dataGrid1 = new System.Windows.Forms.DataGrid();
this.InsertCommand = new System.Windows.Forms.Button();
this.UpdateCommand = new System.Windows.Forms.Button();
this.DeleteCommand = new System.Windows.Forms.Button();
this.checkBox1 = new System.Windows.Forms.CheckBox();
((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
this.SuspendLayout();
//
// dataGrid1
//
this.dataGrid1.DataMember = "";
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(8, 8);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.Size = new System.Drawing.Size(336, 304);
this.dataGrid1.TabIndex = 0;
//
// InsertCommand
//
this.InsertCommand.Location = new System.Drawing.Point(368, 24);
this.InsertCommand.Name = "InsertCommand";
this.InsertCommand.Size = new System.Drawing.Size(120, 32);
this.InsertCommand.TabIndex = 1;
this.InsertCommand.Text = "Insert Command";
this.InsertCommand.Click += new System.EventHandler(this.InsertCommand_Click);
//
// UpdateCommand
//
this.UpdateCommand.Location = new System.Drawing.Point(368, 72);
this.UpdateCommand.Name = "UpdateCommand";
this.UpdateCommand.Size = new System.Drawing.Size(120, 32);
this.UpdateCommand.TabIndex = 2;
this.UpdateCommand.Text = "Update Command";
this.UpdateCommand.Click += new System.EventHandler(this.UpdateCommand_Click);
//
// DeleteCommand
//
this.DeleteCommand.Location = new System.Drawing.Point(368, 120);
this.DeleteCommand.Name = "DeleteCommand";
this.DeleteCommand.Size = new System.Drawing.Size(120, 32);
this.DeleteCommand.TabIndex = 3;
this.DeleteCommand.Text = "Delete Command";
this.DeleteCommand.Click += new System.EventHandler(this.DeleteCommand_Click);
//
// checkBox1
//
this.checkBox1.Location = new System.Drawing.Point(368, 192);
this.checkBox1.Name = "checkBox1";
this.checkBox1.Size = new System.Drawing.Size(112, 24);
this.checkBox1.TabIndex = 4;
this.checkBox1.Text = "SqlCommand";
//
// UpdateDataLoadDataGrid
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(496, 325);
this.Controls.AddRange(new System.Windows.Forms.Control[] {
this.checkBox1,
this.DeleteCommand,
this.UpdateCommand,
this.InsertCommand,
this.dataGrid1});
this.Name = "UpdateDataLoadDataGrid";
this.Text = "UpdateDataLoadDataGrid";
((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.ResumeLayout(false);
}
[STAThread]
static void Main()
{
Application.Run(new UpdateDataLoadDataGrid());
}
private void InsertCommand_Click(object sender, System.EventArgs e)
{
}
private void UpdateCommand_Click(object sender, System.EventArgs e)
{
string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;"+
"Data Source=c:\\Northwind.mdb";
OleDbConnection conn =
new OleDbConnection(ConnectionString);
DataSet ds = new DataSet();

try
{
conn.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter(
"SELECT * FROM Customers", conn);

OleDbCommandBuilder cmdBuilder =
new OleDbCommandBuilder(adapter);
adapter.MissingSchemaAction =
MissingSchemaAction.AddWithKey;
adapter.Fill(ds, "Customers");
DataRow row1 = ds.Tables["Customers"].Rows.Find("001");
row1["ContactName"]="S";
row1["CompanyName"] = "M";

adapter.Update(ds, "Customers");
dataGrid1.DataSource = ds.DefaultViewManager;
}
catch(OleDbException exp)
{
MessageBox.Show(exp.Message.ToString());
}
if(conn.State == ConnectionState.Open)
conn.Close();
}
private void DeleteCommand_Click(object sender, System.EventArgs e)
{
}
}</source>

← Предыдущая	Версия 15:31, 26 мая 2010
(нет различий)

Csharp/CSharp Tutorial/ADO.Net/OleDbCommandBuilder - История изменений

в 15:31, 26 мая 2010

Admin: 1 версия