C# DataRow.SetField方法代码示例

        private bool IntiRow(DataRow row)
        {
            string pid = tbId.Text.Trim();
            string innerid = tbInnerId.Text.Trim();
            string size = tbSize.Text.Trim();
            string colornum = tbColorNum.Text.Trim();
            string name = tbName.Text.Trim();
            string pos = tbPosition.Text.Trim();

            decimal price = nudPrice.Value;
            decimal cost = nudCost.Value;
            decimal store = nudStore.Value;
            decimal pkgnum = nudPkgNum.Value;

            if (String.IsNullOrEmpty(innerid))
            {
                MessageBox.Show("编号不能为空!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return false;
            }

            row.SetField<string>("productid", pid);
            row.SetField<string>("innerid", innerid);
            row.SetField<string>("size", size);
            row.SetField<string>("colornum", colornum);
            row.SetField<string>("name", name);
            row.SetField<string>("position", pos);
            row.SetField<decimal>("price", price);
            row.SetField<decimal>("cost", cost);
            row.SetField<decimal>("storenum", store);
            row.SetField<decimal>("packagenum", pkgnum);
            row.SetField<string>("opr", GlobalVar.LogInfo.Name);
            return true;
        }

        private void frmColumnSorting_Load(object sender, EventArgs e)
        {
            ds_ViewColumns = obj_bllFormCustomization.LoadDefaultColumnsSorting();

            for (int i = 0; i <= ds_TakeQryData.Tables[0].Columns.Count - 1; i++)
            {
                dr_ViewColumn = ds_ViewColumns.Tables[0].NewRow();
                //dr_ViewColumn = new DataRow();

                dr_ViewColumn.SetField("Column Name", ds_TakeQryData.Tables[0].Columns[i].Caption.ToString());
                dr_ViewColumn.SetField("ASC", 0);
                dr_ViewColumn.SetField("DESC", 0);

                ds_ViewColumns.Tables[0].Rows.Add(dr_ViewColumn);
                ds_ViewColumns.AcceptChanges();
            }
            gridView1.GridControl.DataSource = ds_ViewColumns.Tables[0];

            foreach (GridColumn column in gridView1.Columns) // disable editing for all columns
            {
                if (column.AbsoluteIndex == 0)
                {
                    column.OptionsColumn.AllowEdit = false;
                }
                //column.OptionsColumn.AllowEdit = false;
            }
            gridView1.BestFitColumns(true);
            for (int i = 0; i <= gridView1.Columns.Count - 1; i++)
            {
                gridView1.Columns[i].BestFit();
            }
        }

 /// <summary>
 /// 将合同信息加入行中
 /// </summary>
 /// <param name="row"></param>
 /// <param name="con"></param>
 /// <returns></returns>
 public static DataRow getRowFromContract(DataRow row, Contract con)
 {
     row.SetField(0, con.proCate);
     row.SetField(1, con.proName);
     row.SetField(2, con.proId);
     row.SetField(3, con.unicomLinkMan);
     row.SetField(4, con.linkPhone);
     row.SetField(5, con.groupCusManager);
     row.SetField(6, con.proSignUnitName);
     row.SetField(7, con.unitAdd);
     row.SetField(8, con.proSign);
     row.SetField(9, con.signUnitLinkMan);
     row.SetField(10, con.signUnitLinkPhone);
     row.SetField(11, con.payPhone); ;
     row.SetField(12, con.payStand);
     row.SetField(13, con.proSignDate);
     row.SetField(14, con.proSignExeDate);
     row.SetField(15, con.proDeadLine);
     row.SetField(16, con.proExpireData);
     row.SetField(17, con.proDesc);
     row.SetField(18, con.remark);
     row.SetField(19, con.dltdh);
     row.SetField(20, con.fileName);
     return row;
 }

 private void calcExtraColumns(DataRow row)
 {
     // For some reason, if the file was selected from the ComboBox,
     // then the FileNumber text was not displayed if it was bound
     // to the expression column expr_FileNumber.
     // So, I'm making it much more explicit here.
     if (row == null)
     return;
     int fileid = row.Field<int>("FileID");
     var file = fileDropTable.FindByFileID(fileid);
     string filenum = file == null ? "" : file.FileNumber;
     row.SetField<String>("extra_FileNumber", filenum);
 }

 private void ReadStringField(int colIndex, ColumnMeta meta, DataRow dataRow, BinaryReader br)
 {
     if (m_dbreader is WDBReader)
         dataRow.SetField(colIndex, br.ReadStringNull());
     else if (m_dbreader is STLReader)
     {
         int offset = br.ReadInt32();
         dataRow.SetField(colIndex, (m_dbreader as STLReader).ReadString(offset));
     }
     else
     {
         try
         {
             dataRow.SetField(colIndex, m_dbreader.IsSparseTable ? br.ReadStringNull() : m_dbreader.StringTable[br.ReadInt32(meta)]);
         }
         catch
         {
             dataRow.SetField(colIndex, "Invalid string index!");
         }
     }
 }