DataGridView 統計欄位

 int sum = 0;
            for (int i = 0; i < dataGridView1.Rows.Count; ++i)
            {
                sum += Convert.ToInt32(dataGridView1.Rows[i].Cells[1].Value);
            }

            labelTotal.Text = sum.ToString();

comboBox 讀取資料庫來源

            using (xxxEntities db = new xxxEntities())
            {
                comboBox1.DataSource = db.xxxx;
                comboBox1.DisplayMember = "TB001";
                comboBox1.ValueMember = "TB002";
            }

mvc 多筆新增

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

public void InsertElementList(IEnumerable < TransferOrderColumn > elementItemNumList, int transferOrderID) { using(xxxEntities db = new xxxEntities()) { foreach(var item in elementItemNumList) { var newElementList = new ElementList() { ElementItemNum = item.ElementItemNum, TransferOrderID = transferOrderID }; db.ElementList.AddObject(newElementList); db.SaveChanges(); } }

TempData 轉 List

  ElementItemNumList = ((List<TransferOrderModels.TransferOrderColumn>)TempData["ElementItemNumList"]);

部屬ReportViewer到遠端主機

http://www.am22tech.com/s/22/FORUM1/default.aspx?g=posts&m=12

MVC INSERT

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

Controller public ActionResult Save([Bind(Exclude = "ID")]Models.TransferOrder transferOrder) { TOM.InsertTransferOrder(transferOrder); return null; } Models public void InsertTransferOrder(Models.TransferOrder transferOrder) //欄位會自動聯繫 { using xxxEntities db = new xxxEntities()) { try { //db.AddToTransferOrder(transferOrder); db.TransferOrder.AddObject(transferOrder); db.SaveChanges(); } catch (Exception e) { throw e; } } }

刪除檔案總管的網址列所有歷史紀錄

開啟檔案總管，將滑鼠移動到網址列上方，按滑鼠右鍵，選擇【刪除歷程記錄】。