資源簡介
詳細的用短小簡明的實例舉出了如何在datagridview中添加一個合計行

代碼片段和文件信息
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.SqlClient;
namespace?doom
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1()
????????{
????????????InitializeComponent();
????????}
????????private?void?Form1_Load(object?sender?EventArgs?e)
????????{
????????????string?strConn?=?“Data?Source=.;Initial?Catalog=hgdb;Integrated?Security=True“;
????????????SqlConnection?conn?=?new?SqlConnection(strConn);
????????????
????????????SqlCommand?comm?=?new?SqlCommand(“select?*?from?p_orders“?conn);
????????????conn.Open();
????????????SqlDataReader?reader?=?comm.ExecuteReader();
????????????int?i=0;
????????????while?(reader.Read())
????????????{
????????????????dataGridView1.Rows.Add();
????????????????dataGridView1.Rows[i].Cells[“A“].Value?=?reader[0].ToString();
????????????????dataGridView1.Rows[i].Cells[“B“].Value?=?reader[“nums“].ToString();
????????????????i++;
????????????}
????????????reader.Close();
????????????dataGridView1.Rows.Add();
????????????dataGridView1.Rows[i].Cells[“A“].Value?=?“?合計“;
????????????double?num?=?0;
????????????for?(int?j?=?0;?j?????????????{
????????????????num?+=?Convert.ToDouble(dataGridView1.Rows[j].Cells[“B“].Value);
????????????}
????????????dataGridView1.Rows[i].Cells[“B“].Value?=?num;
????????}
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件??????10240??2008-09-01?14:34??添加合計行\doom\bin\Debug\doom.exe
?????文件??????22016??2008-09-01?14:34??添加合計行\doom\bin\Debug\doom.pdb
?????文件??????14328??2008-09-01?13:29??添加合計行\doom\bin\Debug\doom.vshost.exe
?????文件????????372??2008-09-01?11:29??添加合計行\doom\bin\Debug\doom.vshost.exe.config
?????文件????????490??2007-07-21?01:33??添加合計行\doom\bin\Debug\doom.vshost.exe.manifest
?????文件???????3754??2008-09-01?14:29??添加合計行\doom\doom.csproj
?????文件???????1496??2008-09-01?14:34??添加合計行\doom\Form1.cs
?????文件???????3480??2008-09-01?14:31??添加合計行\doom\Form1.Designer.cs
?????文件???????6348??2008-09-01?14:31??添加合計行\doom\Form1.resx
?????文件????????703??2008-09-01?14:33??添加合計行\doom\obj\Debug\doom.csproj.FileListAbsolute.txt
?????文件????????847??2008-09-01?14:31??添加合計行\doom\obj\Debug\doom.csproj.GenerateResource.Cache
?????文件??????10240??2008-09-01?14:34??添加合計行\doom\obj\Debug\doom.exe
?????文件????????180??2008-09-01?14:31??添加合計行\doom\obj\Debug\doom.Form1.resources
?????文件??????22016??2008-09-01?14:34??添加合計行\doom\obj\Debug\doom.pdb
?????文件????????180??2008-09-01?14:29??添加合計行\doom\obj\Debug\doom.Properties.Resources.resources
?????文件??????86016??2008-09-01?14:18??添加合計行\doom\obj\Debug\TempPE\hgdbDataSet.Designer.cs.dll
?????文件??????40960??2008-09-01?11:32??添加合計行\doom\obj\Debug\TempPE\hgdbDataSet1.Designer.cs.dll
?????文件????????485??2008-09-01?11:26??添加合計行\doom\Program.cs
?????文件???????1364??2008-09-01?11:26??添加合計行\doom\Properties\AssemblyInfo.cs
?????文件???????2858??2008-09-01?11:26??添加合計行\doom\Properties\Resources.Designer.cs
?????文件???????5612??2008-09-01?11:26??添加合計行\doom\Properties\Resources.resx
?????文件???????1672??2008-09-01?11:30??添加合計行\doom\Properties\Settings.Designer.cs
?????文件????????955??2008-09-01?11:29??添加合計行\doom\Properties\Settings.settings
?????文件????????902??2008-09-01?11:26??添加合計行\doom.sln
????..A..H.?????14848??2008-09-01?14:35??添加合計行\doom.suo
?????目錄??????????0??2008-09-01?14:18??添加合計行\doom\obj\Debug\TempPE
?????目錄??????????0??2008-09-01?13:30??添加合計行\doom\bin\Debug
?????目錄??????????0??2008-09-01?14:34??添加合計行\doom\obj\Debug
?????目錄??????????0??2008-09-01?13:29??添加合計行\doom\bin
?????目錄??????????0??2008-09-01?11:26??添加合計行\doom\obj
............此處省略6個文件信息
評論
共有 條評論