在导入时在Datagridview的行中设置前景色 [英] Setting the forecolor in rows of Datagridview on import

问题描述

嗨 我正在将数据从excel导入到datagridview.最初，我将数据集绑定到DGV.导入时，我检查导入的项目是否已经存在于数据集中(如果不可用)，我将该行添加到DS中，然后进行绑定.我想突出显示DGV中excel中从excel导入的数据，这些数据在导入时已经存在，我该如何实现这一目标，任何人都可以帮助我，
这是我到目前为止所做的

Hi I''m importing data from excel to datagridview. Initially I''m bind the dataset to DGV. When I''m importing I''m checking whether the imported item is already existing in dataset if not available I''m adding the row to DS and then binding. I want to highlight the imported data from excel in DGV from those which is already existing at the time of import, how can I achieve this, can anyone help me,
Here is what Ive done so far

workbook = excelApp.Workbooks.Open(filename, 0, true, 5, "", "", true,
                        Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
                    worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Sheets.get_Item(1);
                    range = worksheet.UsedRange;
                    Array myValues = (Array)range.Cells.Value2;
                    int vertical = myValues.GetLength(0);
                    int horizontal = myValues.GetLength(1);
                    workbook.Close(true, null, null);
                    excelApp.Quit();
                    releaseObject(workbook);
                    releaseObject(worksheet);
                    releaseObject(excelApp);
                    for (int i = 1; i <= horizontal; i++)
                    {
                        DataRow objdr = dsobbtemp.Tables[0].NewRow();
                        objdr["objectRevisedName"] = myValues.GetValue(1, i).ToString();
                        srowFilter = "objectRevisedName = ''" + objdr["objectRevisedName"].ToString() + "''";
                        if (dsobbtemp.Tables[0].Select(srowFilter).Length == 0)
                        {
                            dsobbtemp.Tables[0].Rows.Add(objdr);
                        }
                    }
                    objdt = dsobbtemp.Tables[0].GetChanges();
                    for (int i = 0; i < objdt.Rows.Count; i++)
                    {
                        SqlParameter[] sqlparam1 = {
                                                      new SqlParameter("@accountID",iaccountID),                                                  };
                        DBAccess objDBaccess = new DBAccess();
                        iResults = objDBaccess.ExecuteCommand("AddData", sqlparam1);

在此先感谢

Thanks in Advance

推荐答案

在GridView中使用OnRowDataBound事件

Use the OnRowDataBound event in the GridView

这篇关于在导入时在Datagridview的行中设置前景色的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！