我如何收集每一行的所有价值 [英] How I Collect All Value Each Row

问题描述

嗨那里，



需要帮助循环数据网格行，

hi There,

Need help with looping on data grid row,

       col   col   col   col  col  col

row 1 - 1      2

row 2 -              3     4

row 3 -                         5    6

我的代码：

My code:

private void iqcsavBtn_Click(object sender, EventArgs e)
        {
            
            string iqcData;
            string iqcData1 = string.Empty;
            iqcData1 = "";
          
            for (int i = 0; i < frmTabledgv.Rows.Count; i++)//loop to collect frmTabledgv cell value
             {
                 for (int j = 0; j < frmTabledgv.Columns.Count; j++)
                    {
                        //if (frmTabledgv.Rows[i].Cells[j].Value != null)
                        if (frmTabledgv[j, i].Value != null)

                        {
                           
                            iqcData = frmTabledgv.Rows[i].Cells[j].Value.ToString() + ",";
                            iqcData1 = iqcData1.ToString() + iqcData.ToString();

                            

                        }
                        
                    }
                    iqcData1 = iqcData1.TrimEnd(',');
                    StringBuilder s1 = new StringBuilder();
                    SqlConnection conn = new SqlConnection(Program.p_connectionString);
                    conn.Open();
                    s1.Length = 0;
                    s1.Append("INSERT INTO UT_SMT_BCP_IQC(MainBCP,IQCDATA ) ");
                    s1.Append(" VALUES('{0}','{1}')");
                    string sql_insert = string.Format(s1.ToString(), Program.bcpnmbrtxtbx1, iqcData1);
                    IMIS_WyfUtility.SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql_insert);
                    conn.Close();

当前输出：

Current Output :

1,2
1,23,4
1,23,45,6
1,23,45,6

i希望实现此输出：

i want to achieved this Output :

1,2
3,4
5,6

推荐答案

请尝试以下

Please try as following

iqcData1=string.Empty
for (int i = 0; i < frmTabledgv.Rows.Count; i++)//loop to collect frmTabledgv cell value
{
for (int j = 0; j < frmTabledgv.Columns.Count; j++)
{

if (frmTabledgv[j, i].Value != null)

{


iqcData1 = iqcData1.ToString() + frmTabledgv.Rows[i].Cells[j].Value.ToString() + ",";



}
iqcData1 = iqcData1.ToString() + "\n";
}

这篇关于我如何收集每一行的所有价值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！