Sum datagridview列 [英] Sum datagridview column

问题描述

我在ms访问数据库中有几个具有相同列名的表。我正在从combobox中选择的datagridview中加载表。我想在文本框/级别中显示列的总和。 。我找到了一些适用于在设计时创建的datagridviews列的代码。有人能为我提供链接或示例代码吗？

 私人适配器正如 新 SqlDataAdapter（字符串 .Empty，我 .con）
 私有数据 As  DataTable 
 私有  Sub  Form1_Load（ ByVal  sender 作为 对象，_ 
  ByVal  e  As  EventArgs）
 con.Open（）
  Me  .ComboBox1.DisplayMember =   TABLE_NAME 
 我 .ComboBox1 .ValueMember =   TABLE_NAME 
 我 .ComboBox1.DataSource = 我.con.GetSchema(  TABLES，新 字符串（）{没什么，没什么， Nothing ，  TABLE}）
 
 con.Close（）
 结束  Sub  
 私有  Sub  ComboBox1_SelectedIndexChanged（ ByVal  sender 作为 对象，_ 
  ByVal  e  As  EventArgs）句柄 ComboBox1.SelectedIndexChanged 
 如果 我 .ComboBox1.SelectedItem  IsNot  没什么 然后 
 我 .data = 新 DataTable 
 我 .adapter.SelectCommand.CommandText = 字符串 .Format（  SELECT * FROM [{0}]， Me  .ComboBox1.SelectedValue）
 我 .adapter.Fill（data）
  Me  .DataGridView1.DataSource =  Nothing  
 我 .DataGridView1.Columns.Clear（）
 我 .DataGridView1.DataSource = 我 .data 
 结束 如果 
 

解决方案

试试这个：

 私有  Sub  ComboBox1_SelectedIndexChanged （ ByVal 发​​件人作为 对象， ByVal  e  As  EventArgs）句柄 ComboBox1.SelectedIndexChanged 
  Dim  WantedValue 作为 整数 =  0  
 对于 每个博士 As  DataGridViewR ow 在 DataGridView1.Rows 
 WantedValue = WantedValue +  CInt （博士（  AccessTableColumnNameYouWant）。value.tostring）
  Next  
 TextBox1.Text = WantedValue.ToString 
 结束  sub  

I have few tables with same column name in ms access database . I am loading tables in datagridview selected from combobox.I want to display sum of a column in text box /level. . I have found some code that works with datagridviews column created in design time. can some one provide me with a link or sample code ?

Private adapter As New SqlDataAdapter(String.Empty, Me.con)
  Private data As DataTable
  Private Sub Form1_Load(ByVal sender As Object, _
                     ByVal e As EventArgs)
      con.Open()
      Me.ComboBox1.DisplayMember = "TABLE_NAME"
      Me.ComboBox1.ValueMember = "TABLE_NAME"
      Me.ComboBox1.DataSource = Me.con.GetSchema("TABLES", New String() {Nothing, Nothing, Nothing, "TABLE"})

      con.Close()
  End Sub
  Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As Object, _
                                         ByVal e As EventArgs) Handles ComboBox1.SelectedIndexChanged
      If Me.ComboBox1.SelectedItem IsNot Nothing Then
          Me.data = New DataTable
          Me.adapter.SelectCommand.CommandText = String.Format("SELECT * FROM [{0}]", Me.ComboBox1.SelectedValue)
         Me.adapter.Fill(data)
         Me.DataGridView1.DataSource = Nothing
         Me.DataGridView1.Columns.Clear()
         Me.DataGridView1.DataSource = Me.data
      End If

解决方案

Try this:

 Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs) Handles ComboBox1.SelectedIndexChanged
Dim WantedValue As Integer = 0
For Each dr As DataGridViewRow In DataGridView1.Rows
    WantedValue = WantedValue + CInt(dr.("AccessTableColumnNameYouWant").value.tostring)
Next
TextBox1.Text = WantedValue.ToString
End sub

这篇关于Sum datagridview列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！