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++)
{
for (int j = 0; j < frmTabledgv.Columns.Count; j++)
{
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 want to achieved this Output :
1,2
3,4
5,6