using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?System.Data?.Odbc?;

namespace?網格更新
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}
???????
????????private?DataTable?dt?=?new?DataTable?（）;
????????private?OdbcDataAdapter?da?=?new?OdbcDataAdapter（）;
???????????private?void?Form1_Load_1（object?sender?EventArgs?e）
????????{
??????????OdbcConnection?cn?=?new?OdbcConnection（“driver={IBM?DB2?ODBC?DRIVER};Database=SDDT;hostname=223.1.1.19;port=50000;?protocol=TCPIP;uid=LLL;pwd=BCL987;?CurrentSchema=SDDT;“）;
??????????OdbcCommand?com?=?new?OdbcCommand（“select?*?from?MODEL“?cn）;
??????????da?=new?OdbcDataAdapter?（com?）;
????????????????????????????????
???????????????????
????????????DataTable?dt?=?new?DataTable（）;
???????????
????????????dt?.Locale?=?System?.Globalization?.CultureInfo?.InvariantCulture?;


????????????da.Fill（dt）;
????????????this.dataGridView1.DataSource?=?dt;

????????}

???????????private?void?getupdate（）
???????????{
???????????????dt?=?dataGridView1.DataSource?as?DataTable;//把DataGridView綁定的數據源轉換成DataTable?


???????????????OdbcCommandBuilder?cb?=?new?OdbcCommandBuilder（da）;

???????????????//將數據放到datatable??中????datagridview??的數據源????是datatable??
???????????????//修改datagridview??
???????????????//更新??
???????????????da.Update（dt）;
???????????}
???
????????private?void?button1_Click_1（object?sender?EventArgs?e）
????????{
????????????this.getupdate（）;??????????
????????????MessageBox.Show（“更新成功“）;
????????}

????????private?void?button2_Click（object?sender?EventArgs?e）
????????{
????????????OdbcConnection?con?=?Program.createConnection（）;
????????????con.Open（）;

????????????DataSet??ds?=?new?DataSet（）;
????????????DataTable??dt?=?new?DataTable（）;
????????????string?querysql?=?“select?*?from?MODEL“;
????????????OdbcDataAdapter?da?=?new?OdbcDataAdapter（querysql?con）;
????????????da.Fill（ds?“tab“）;
????????????dt?=?ds.Tables[0];
????????????this.dataGridView1.DataSource?=?dt;
????????????con.Close（）;
????????}

????????private?void?button3_Click（object?sender?EventArgs?e）
????????{
????????????int?row?=?dataGridView1.SelectedRows.Count;
????????????if?（MessageBox.Show（“確認刪除選中的“?+?row.ToString（）?+?“條記錄嗎？“?“請確認“?MessageBoxButtons.YesNo?MessageBoxIcon.Question）?==?DialogResult.Yes）
????????????{
????????????????while?（row?>?0）
????????????????{
????????????????????（（DataRowView）dataGridView1.SelectedRows[0].DataBoundItem）.Row.Delete（）;
????????????????????row?=?row?-?1;
????????????????}
????????????????this.getupdate（）;
????????????????MessageBox.Show（“刪除成功“）;
????????????}

????????}

?????

????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????5612??2008-09-16?11:11??網格更新\網格更新\Properties\Resources.resx

?????文件????????249??2008-09-16?11:11??網格更新\網格更新\Properties\Settings.settings

?????文件???????1436??2008-09-16?11:11??網格更新\網格更新\Properties\AssemblyInfo.cs

?????文件???????2853??2008-09-16?11:11??網格更新\網格更新\Properties\Resources.Designer.cs

?????文件???????1097??2008-09-16?11:11??網格更新\網格更新\Properties\Settings.Designer.cs

?????目錄??????????0??2008-09-16?11:11??網格更新\網格更新\Properties

?????文件???????3735??2008-09-16?11:24??網格更新\網格更新\網格更新.csproj

?????文件????????490??2007-07-21?01:33??網格更新\網格更新\bin\Debug\網格更新.vshost.exe.manifest

?????文件??????14328??2008-09-16?16:16??網格更新\網格更新\bin\Debug\網格更新.vshost.exe

?????文件??????11264??2008-09-16?16:13??網格更新\網格更新\bin\Debug\網格更新.exe

?????文件??????26112??2008-09-16?16:13??網格更新\網格更新\bin\Debug\網格更新.pdb

?????目錄??????????0??2008-09-16?11:11??網格更新\網格更新\bin\Debug

?????目錄??????????0??2008-09-16?11:11??網格更新\網格更新\bin

?????目錄??????????0??2008-09-16?11:11??網格更新\網格更新\obj\Debug\TempPE

?????文件????????180??2008-09-16?16:13??網格更新\網格更新\obj\Debug\網格更新.Form1.resources

?????文件????????180??2008-09-16?11:24??網格更新\網格更新\obj\Debug\網格更新.Properties.Resources.resources

?????文件????????735??2008-09-16?16:16??網格更新\網格更新\obj\Debug\網格更新.csproj.FileListAbsolute.txt

?????文件??????11264??2008-09-16?16:13??網格更新\網格更新\obj\Debug\網格更新.exe

?????文件??????26112??2008-09-16?16:13??網格更新\網格更新\obj\Debug\網格更新.pdb

?????文件????????847??2008-09-16?16:13??網格更新\網格更新\obj\Debug\網格更新.csproj.GenerateResource.Cache

?????目錄??????????0??2008-09-16?11:11??網格更新\網格更新\obj\Debug

?????目錄??????????0??2008-09-16?11:11??網格更新\網格更新\obj

?????文件????????822??2008-09-16?14:33??網格更新\網格更新\Program.cs

?????文件???????5610??2008-09-16?16:13??網格更新\網格更新\Form1.Designer.cs

?????文件???????2980??2008-09-16?16:13??網格更新\網格更新\Form1.cs

?????文件???????5814??2008-09-16?16:13??網格更新\網格更新\Form1.resx

?????目錄??????????0??2008-09-16?11:11??網格更新\網格更新

?????文件????????926??2008-09-16?11:11??網格更新\網格更新.sln

????..A..H.??????8192??2008-09-16?15:03??網格更新\網格更新.suo

?????目錄??????????0??2008-09-16?11:11??網格更新

............此處省略3個文件信息