从其他单元格中获取值并在datagridview中打印到其他单元格中 [英] get the value from other cell and print into other cell in datagridview
本文介绍了从其他单元格中获取值并在datagridview中打印到其他单元格中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何从2或3列值获取总数并在datagridview中的第4列打印出来datagridview与ms sql数据库连接.....
解决方案
< blockquote>
公共 Sub Form1_Load( ByVal 发件人作为 对象, ByVal e As EventArgs)句柄 MyBase .Load
Me .Wnt_stockTableAdapter.Fill( Me .WintelDataSet.wnt_stock)
Dim i As 整数 = 0
当 i< DataGridView1.Rows.Count - 1
DataGridView1.Rows(i).Cells( 4 ) .Value = Convert.ToInt32(DataGridView1.Rows(i).Cells( 1 )。Value)+ Convert.ToInt32(DataGridView1.Rows(i).Cells(< span class =code-digit> 2 )。Value)+ Convert.ToInt32(DataGridView1.Rows(i).Cells( 3 )。值)
i = i + 1
结束 虽然
结束 Sub
您好,
检查以下代码
私人 void dataGridView1_CellValueChanged( object sender,DataGridViewCellEventArgs e)
{
if (( (e.ColumnIndex == 0 )|| (e.ColumnIndex == 1 ))&& e.RowIndex!= - 1)
{
int a = 0 ;
int b = 0 ;
if (dataGridView1.Rows [e.RowIndex] .Cells [ 0 ]。值。 ToString()!= string .Empty)
a = Convert.ToInt32(dataGridView1.Rows [e.RowIndex] .Cells [ 0 跨度>] Value.ToString())。
if (dataGridView1.Rows [e.RowIndex] .Cells [ 1 ] .Value.ToString()!= string .Empty)
b = Convert.ToInt32(dataGridView1.Rows [e.RowIndex] .Cells [ 1 跨度>] Value.ToString())。
dataGridView1.Rows [e.RowIndex] .Cells [ 2 ]。值= a + b;
}
}
私有 void Form1_Load( object sender,EventArgs e)
{
DataTable dt = new DataTable() ;
dt.Columns.Add( Num1);
dt.Columns.Add( Num2);
dt.Columns.Add( Sum);
dataGridView1.DataSource = dt;
}
最好的问候
Muthuraja
>
how to get a total from 2 or 3 column value and print it on 4th column in datagridview here datagridview is connected with ms sql database.....
解决方案
Public Sub Form1_Load(ByVal sender As Object, ByVal e As EventArgs) Handles MyBase.Load Me.Wnt_stockTableAdapter.Fill(Me.WintelDataSet.wnt_stock)
Dim i As Integer = 0 While i < DataGridView1.Rows.Count - 1 DataGridView1.Rows(i).Cells(4).Value = Convert.ToInt32(DataGridView1.Rows(i).Cells(1).Value) + Convert.ToInt32(DataGridView1.Rows(i).Cells(2).Value) + Convert.ToInt32(DataGridView1.Rows(i).Cells(3).Value) i = i + 1 End While End Sub
Hi,
Check the below code
private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { if (((e.ColumnIndex == 0) || (e.ColumnIndex == 1)) && e.RowIndex !=-1) { int a = 0; int b = 0; if(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString() != string.Empty) a = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString()); if(dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString() != string.Empty) b = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString()); dataGridView1.Rows[e.RowIndex].Cells[2].Value = a+b; } } private void Form1_Load(object sender, EventArgs e) { DataTable dt = new DataTable(); dt.Columns.Add("Num1"); dt.Columns.Add("Num2"); dt.Columns.Add("Sum"); dataGridView1.DataSource = dt; }
Best Regards
Muthuraja
这篇关于从其他单元格中获取值并在datagridview中打印到其他单元格中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文