本文整理汇总了C#中System.Data.DataRow类的典型用法代码示例。如果您正苦于以下问题:C# DataRow类的具体用法?C# DataRow怎么用?C# DataRow使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
DataRow类属于System.Data命名空间,在下文中一共展示了DataRow类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。
示例1: DataRowToModel
/// <summary>
/// 得到一个对象实体
/// </summary>
public HisClient.Model.his_comm_dict_type DataRowToModel(DataRow row)
{
HisClient.Model.his_comm_dict_type model=new HisClient.Model.his_comm_dict_type();
if (row != null)
{
if(row["ID"]!=null)
{
model.ID=row["ID"].ToString();
}
if(row["TYPE_CODE"]!=null)
{
model.TYPE_CODE=row["TYPE_CODE"].ToString();
}
if(row["TYPE_NAME"]!=null)
{
model.TYPE_NAME=row["TYPE_NAME"].ToString();
}
if(row["HELP_CODE"]!=null)
{
model.HELP_CODE=row["HELP_CODE"].ToString();
}
if(row["CREATE_DATE"]!=null && row["CREATE_DATE"].ToString()!="")
{
model.CREATE_DATE=DateTime.Parse(row["CREATE_DATE"].ToString());
}
if(row["CREATE_BY"]!=null)
{
model.CREATE_BY=row["CREATE_BY"].ToString();
}
}
return model;
}
开发者ID:liyuanli66,项目名称:His,代码行数:35,代码来源:his_comm_dict_type.cs
示例2: GetFactory
public static DbProviderFactory GetFactory(DataRow providerRow)
{
ADP.CheckArgumentNull(providerRow, "providerRow");
DataColumn column = providerRow.Table.Columns["AssemblyQualifiedName"];
if (column != null)
{
string str = providerRow[column] as string;
if (!ADP.IsEmpty(str))
{
Type type = Type.GetType(str);
if (null == type)
{
throw ADP.ConfigProviderNotInstalled();
}
FieldInfo field = type.GetField("Instance", BindingFlags.Public | BindingFlags.Static | BindingFlags.DeclaredOnly);
if ((null != field) && field.FieldType.IsSubclassOf(typeof(DbProviderFactory)))
{
object obj2 = field.GetValue(null);
if (obj2 != null)
{
return (DbProviderFactory) obj2;
}
}
throw ADP.ConfigProviderInvalid();
}
}
throw ADP.ConfigProviderMissing();
}
开发者ID:pritesh-mandowara-sp,项目名称:DecompliedDotNetLibraries,代码行数:28,代码来源:DbProviderFactories.cs
示例3: DataBind
public virtual void DataBind(DataRow row)
{
this.PONum = (int)row["PONum"].GetInt();
this.Revision = (int)row["Revision"].GetInt();
this.OpenOrder = (int)row["OpenOrder"].GetInt();
this.VoidOrder = (int)row["VoidOrder"].GetInt();
this.EntryPerson = (string)row["EntryPerson"].GetString();
this.OrderDate = (DateTime)row["OrderDate"].GetDate();
this.TermsCode = (string)row["TermsCode"].GetString();
this.VendorNum = (int)row["VendorNum"].GetInt();
this.SupplierName = (string)row["SupplierName"].GetString();
this.CurrencyCode = (string)row["CurrencyCode"].GetString();
this.ExchangeRate = (int)row["ExchangeRate"].GetInt();
this.ApprovedDate = (DateTime)row["ApprovedDate"].GetDate();
this.ApprovedBy = (string)row["ApprovedBy"].GetString();
this.Approve = (int)row["Approve"].GetInt();
this.ApprovalStatus = (string)row["ApprovalStatus"].GetString();
this.ApprovedAmount = (int)row["ApprovedAmount"].GetInt();
this.CustId = (string)row["CustId"].GetString();
this.CustomerName = (string)row["CustomerName"].GetString();
this.MakerCode = (string)row["MakerCode"].GetString();
this.MakerName = (string)row["MakerName"].GetString();
this.MillCode = (string)row["MillCode"].GetString();
this.MillName = (string)row["MillName"].GetString();
this.SaleContractNum = (string)row["SaleContractNum"].GetString();
this.SaleContractDate = (DateTime)row["SaleContractDate"].GetDate();
this.ImportCode = (string)row["ImportCode"].GetString();
this.CalculateCode = (string)row["CalculateCode"].GetString();
this.SectionCode = (string)row["SectionCode"].GetString();
}
开发者ID:swankham,项目名称:Epicoil,代码行数:30,代码来源:POHeaderModel.cs
示例4: GetPetFromDatabaseRow
public static Pet GetPetFromDatabaseRow(DataRow Row)
{
return new Pet((uint)Row["id"], (string)Row["name"], (int)Row["type"], (int)Row["race"],
(uint)Row["user_id"], (uint)Row["room_id"], Vector3.FromString((string)Row["room_pos"]),
(double)Row["timestamp"], (int)Row["experience"], (int)Row["energy"], (int)Row["happiness"],
(int)Row["score"]);
}
开发者ID:habb0,项目名称:Snowlight,代码行数:7,代码来源:PetFactory.cs
示例5: UCPersonnelAddOrEdit
public UCPersonnelAddOrEdit(DataRow dr, string parentName)
{
InitializeComponent();
this.dr = dr;
this.parentName = parentName;
Update = new UpdateDele(DBHelper.WebServHandlerByFun);
}
开发者ID:caocf,项目名称:workspace-kepler,代码行数:7,代码来源:UCPersonnelAddOrEdit.cs
示例6: Add
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DataRow dr, SqlTransaction trans)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO hrCompanyShopInfo(");
strSql.Append("MainID,sShopID,sShopCName,sShopEName,sRemark,sUserID)");
strSql.Append(" VALUES (");
strSql.Append("@MainID,@sShopID,@sShopCName,@sShopEName,@sRemark,@sUserID)");
strSql.Append(";SELECT @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@MainID", SqlDbType.Int,4),
new SqlParameter("@sShopID", SqlDbType.VarChar,30),
new SqlParameter("@sShopCName", SqlDbType.VarChar,50),
new SqlParameter("@sShopEName", SqlDbType.VarChar,50),
new SqlParameter("@sRemark", SqlDbType.VarChar,200),
new SqlParameter("@sUserID", SqlDbType.VarChar,30)};
parameters[0].Value = dr["MainID"];
parameters[1].Value = dr["sShopID"];
parameters[2].Value = dr["sShopCName"];
parameters[3].Value = dr["sShopEName"];
parameters[4].Value = dr["sRemark"];
parameters[5].Value = dr["sUserID"];
object obj = DbHelperSQL.GetSingle(strSql.ToString(), trans, parameters);
if (obj == null)
{
return -1;
}
else
{
return Convert.ToInt32(obj);
}
}
开发者ID:ViniciusConsultor,项目名称:belself-wang,代码行数:35,代码来源:hrCompanyShopInfoDAL.cs
示例7: Init
private void Init(DataRow dataRow)
{
if (_dataRow == null && dataRow != null)
_createColumns = dataRow.Table.Columns.Count == 0;
_dataRow = dataRow;
}
开发者ID:MajidSafari,项目名称:bltoolkit,代码行数:7,代码来源:DataRowMapper.cs
示例8: DataBind
public override void DataBind(DataRow row)
{
base.DataBind(row);
this.PONum = (int)row["PONum"].GetInt();
this.PONumber = (string)row["PONumber"].GetString();
}
开发者ID:swankham,项目名称:Epicoil,代码行数:7,代码来源:StoreInPlanDialogModel.cs
示例9: Volunteer
public Volunteer(DataRow row)
{
this.ID = (int)row["ID"];
this.FirstName = row["FirstName"] as string;
this.MiddleNames = row["MiddleName"] as string;
this.LastName = row["Surname"] as string;
}
开发者ID:RBC-SWG,项目名称:RBCTools.Library,代码行数:7,代码来源:Volunteer.cs
示例10: Create
public string Create( DataRow p)
{
string id = Guid.NewGuid().ToString();
string sql = "";
sql = " insert into Templet( "
+" id, "
+ " corp_id,"
+ " name,"
+ " docpath,"
+ " creatorid,"
+ " createtime,"
+ " status"
+ " ) values("
+ " '" + StringHelper.ChkSQL(id) + "',"
+ " '" + StringHelper.ChkSQL(p["corp_id"].ToString()) + "',"
+ " '" + StringHelper.ChkSQL(p["name"].ToString()) + "',"
+ " '" + StringHelper.ChkSQL(p["docpath"].ToString()) + "',"
+ " '" + StringHelper.ChkSQL(p["creatorid"].ToString()) + "',"
+ " getdate() ,"
+ " 1 " //status
+ " ) ";
commonDAL.ExecSQL( sql);
return id;
}
开发者ID:kissmettprj,项目名称:col,代码行数:25,代码来源:TempletDAL.cs
示例11: TypedUserFind
/// <summary>
/// Initializes a new instance of the <see cref="TypedUserFind"/> class.
/// </summary>
/// <param name="row">
/// The row.
/// </param>
public TypedUserFind(DataRow row)
{
this.UserID = row.Field<int?>("UserID");
this.BoardID = row.Field<int?>("BoardID");
this.Name = row.Field<string>("Name");
this.Password = row.Field<string>("Password");
this.Email = row.Field<string>("Email");
this.Joined = row.Field<DateTime?>("Joined");
this.LastVisit = row.Field<DateTime?>("LastVisit");
this.IP = row.Field<string>("IP");
this.NumPosts = row.Field<int?>("NumPosts");
this.TimeZone = row.Field<int?>("TimeZone");
this.Avatar = row.Field<string>("Avatar");
this.Signature = row.Field<string>("Signature");
this.AvatarImage = row.Field<byte[]>("AvatarImage");
this.RankID = row.Field<int?>("RankID");
this.Suspended = row.Field<DateTime?>("Suspended");
this.LanguageFile = row.Field<string>("LanguageFile");
this.ThemeFile = row.Field<string>("ThemeFile");
this.Flags = row.Field<int?>("Flags");
this.PMNotification = row.Field<bool?>("PMNotification");
this.Points = row.Field<int?>("Points");
this.IsApproved = row.Field<bool?>("IsApproved");
this.IsActiveExcluded = row.Field<bool?>("IsActiveExcluded");
this.UseMobileTheme = row.Field<bool?>("OverrideDefaultThemes");
this.AvatarImageType = row.Field<string>("AvatarImageType");
this.AutoWatchTopics = row.Field<bool?>("AutoWatchTopics");
this.TextEditor = row.Field<string>("TextEditor");
this.DisplayName = row.Field<string>("DisplayName");
this.Culture = row.Field<string>("Culture");
this.NotificationType = row.Field<int?>("NotificationType");
this.DailyDigest = row.Field<bool?>("DailyDigest");
this.IsGuest = row.Field<bool>("IsGuest");
this.ProviderUserKey = this.IsGuest ? null : ObjectExtensions.ConvertObjectToType(row.Field<string>("ProviderUserKey"), Config.ProviderKeyType);
}
开发者ID:RH-Code,项目名称:YAFNET,代码行数:41,代码来源:TypedUserFind.cs
示例12: DataToField
public void DataToField(DataRow row, object record) // TypedReference t)
{
try
{
GetColumnIndex(row);
if (mCheckTypeFlag == 0)
{
mColumnType = row.Table.Columns[mDataColumnIndex].DataType;
if (mColumnType == mField.FieldType)
mCheckTypeFlag = 1;
else
mCheckTypeFlag = 2;
}
if (mCheckTypeFlag == 1)
mField.SetValue(record, row[mDataColumnIndex]);
else if (row[mDataColumnIndex] != DBNull.Value)
mField.SetValue(record, Convert.ChangeType(row[mDataColumnIndex], mField.FieldType));
else // IS DB NULl
{
if (mColumnType == typeof (string))
mField.SetValue(record, string.Empty);
}
}
catch
{
throw new FileHelpersException(string.Format("Error converting value: {0} to {1} in the column with index {2} and the field {3}", row[mDataColumnIndex], mField.FieldType, mDataColumnIndex, mField.Name));
}
}
开发者ID:modulexcite,项目名称:Transformalize,代码行数:30,代码来源:MappingInfo.cs
示例13: SpellViewInfo
public static void SpellViewInfo(DataRow spellInfo, RichTextBox _rtSpellInfo)
{
_rtSpellInfo.SelectionColor = Color.Blue;
_rtSpellInfo.AppendText(ViewTextInfo(spellInfo));
_rtSpellInfo.SelectionColor = Color.Black;
_rtSpellInfo.AppendText(ViewAttribute(spellInfo));
_rtSpellInfo.AppendText(ViewMask(spellInfo));
_rtSpellInfo.AppendText(ViewProcFlag(spellInfo));
_rtSpellInfo.AppendText(ViewFlags(spellInfo));
_rtSpellInfo.AppendText(ViewSpellFields(spellInfo, typeof(SpellFieldBloc1)));
_rtSpellInfo.AppendText(ViewSpellFields(spellInfo, typeof(SpellFieldBloc2)));
_rtSpellInfo.AppendText(ViewSpellFields(spellInfo, typeof(SpellFieldBloc3)));
_rtSpellInfo.AppendText(ViewInfoFromOtherTable(spellInfo));
_rtSpellInfo.AppendText(ViewReagent(spellInfo));
_rtSpellInfo.AppendText(ViewSpellFields(spellInfo, typeof(SpellFields2), 2));
_rtSpellInfo.AppendText(ViewSpellFields(spellInfo, typeof(SpellFields3), 3));
_rtSpellInfo.AppendText(ViewSpellItemInfo(spellInfo));
}
开发者ID:Derass,项目名称:spellwork,代码行数:29,代码来源:SpellInfo.cs
示例14: LoadData
public override void LoadData(DataRow CurrentDataRow, IDbConnection conn)
{
IsLoaded = false;
CurrentFRDBase = (GISADataset.FRDBaseRow)CurrentDataRow;
IsLoaded = true;
}
开发者ID:aureliopires,项目名称:gisa,代码行数:7,代码来源:PanelSeleccaoUnidadesFisicas.cs
示例15: DataRowToModel
/// <summary>
/// 得到一个对象实体
/// </summary>
public ECommerce.Admin.Model.Logs DataRowToModel(DataRow row)
{
ECommerce.Admin.Model.Logs model = new ECommerce.Admin.Model.Logs();
if (row != null)
{
if (row["LID"] != null && row["LID"].ToString() != "")
{
model.LID = Convert.ToInt64(row["LID"].ToString());
}
if (row["LLID"] != null && row["LLID"].ToString() != "")
{
model.LLID = Convert.ToInt64(row["LLID"].ToString());
}
if (row["OValue"] != null)
{
model.OValue = row["OValue"].ToString();
}
if (row["NValue"] != null)
{
model.NValue = row["NValue"].ToString();
}
if (row["FName"] != null)
{
model.FName = row["FName"].ToString();
}
}
return model;
}
开发者ID:harvey-chennnnn,项目名称:CatchForm,代码行数:31,代码来源:Logs.cs
示例16: ConvertToObject
private EntityHandler.CustomerMaster ConvertToObject(DataRow row)
{
EntityHandler.CustomerMaster obj = new EntityHandler.CustomerMaster();
try
{
// obj.Active = Convert.ToInt32(row["Active"].ToString());
//obj.Address = row["Address"].ToString();
// obj.ApprovedBy = Convert.ToInt32(row["ApprovedBy"].ToString());
// obj.ApprovedDate = Convert.ToDateTime(row["ApprovedDate"].ToString());
// obj.Area = Convert.ToInt32(row["Area"].ToString());
// obj.Category = row["Category"].ToString();
// obj.Credits_Limits = Convert.ToDecimal(row["Credits_Limits"].ToString());
// obj.CusFINCode = row["CusFINCode"].ToString();
obj.Customer_Code = Convert.ToInt32(row["Customer_Code"].ToString());
// obj.Customer_Type = row["Customer_Type"].ToString();
//obj.Date = DateTime.Parse(row["Date"].ToString());
obj.Name = row["Name"].ToString();
// obj.Other_Names = row["Other_Names"].ToString();
// obj.ProductCategory = row["ProductCategory"].ToString();
// obj.SalesMethod = row["SalesMethod"].ToString();
// obj.Status = Convert.ToInt32(row["Status"].ToString());
// obj.UserID = Convert.ToInt32(row["UserID"].ToString());
}
catch (Exception ex)
{ }
return obj;
}
开发者ID:manjulaup,项目名称:LinkRepo,代码行数:31,代码来源:CustomerMaster.cs
示例17: CreateRowUpdatedEvent
protected override RowUpdatedEventArgs CreateRowUpdatedEvent(DataRow dataRow, IDbCommand command,
StatementType statementType,
DataTableMapping tableMapping)
{
NpgsqlEventLog.LogMethodEnter(LogLevel.Debug, CLASSNAME, "CreateRowUpdatedEvent");
return new NpgsqlRowUpdatedEventArgs(dataRow, command, statementType, tableMapping);
}
开发者ID:seeseekey,项目名称:CSCL,代码行数:7,代码来源:NpgsqlDataAdapter.cs
示例18: DataRowToModel
/// <summary>
/// 得到一个对象实体
/// </summary>
public la.Model.friendchange DataRowToModel(DataRow row)
{
la.Model.friendchange model=new la.Model.friendchange();
if (row != null)
{
if(row["friendchange_ID"]!=null && row["friendchange_ID"].ToString()!="")
{
model.friendchange_ID=int.Parse(row["friendchange_ID"].ToString());
}
if(row["friend_id"]!=null && row["friend_id"].ToString()!="")
{
model.friend_id=int.Parse(row["friend_id"].ToString());
}
if(row["user_telphone"]!=null)
{
model.user_telphone=row["user_telphone"].ToString();
}
if(row["friendchange_time"]!=null && row["friendchange_time"].ToString()!="")
{
model.friendchange_time=DateTime.Parse(row["friendchange_time"].ToString());
}
if(row["friendchange_op"]!=null)
{
model.friendchange_op=row["friendchange_op"].ToString();
}
if(row["friendchange_comment"]!=null)
{
model.friendchange_comment=row["friendchange_comment"].ToString();
}
}
return model;
}
开发者ID:LuckyXuan,项目名称:lvaiServer,代码行数:35,代码来源:friendchange.cs
示例19: DataBind
public virtual void DataBind(DataRow row)
{
this.CommodityCode = (string)row["Key1"];
this.CommodityName = (string)row["Character01"];
this.CoatingRequire = Convert.ToBoolean(row["CheckBox01"].GetBoolean());
this.LicenceRequire = Convert.ToBoolean(row["CheckBox02"].GetBoolean());
}
开发者ID:swankham,项目名称:Epicoil,代码行数:7,代码来源:CommodityModel.cs
示例20: ApplyFyCzInterService
private static void ApplyFyCzInterService(DataRow drRow)
{
AutoPlanEntity _autohotelplanEntity = new AutoPlanEntity();
_autohotelplanEntity.AutoHotelPlanDBEntity = new List<AutoHotelPlanDBEntity>();
AutoHotelPlanDBEntity appcontentDBEntity = new AutoHotelPlanDBEntity();
_autohotelplanEntity.AutoHotelPlanDBEntity.Add(appcontentDBEntity);
string AgentID = ConfigurationManager.AppSettings["AgentID"].ToString();
string Money = ConfigurationManager.AppSettings["FYMON"].ToString();
appcontentDBEntity.AgentId = AgentID;
appcontentDBEntity.Money = Money;
appcontentDBEntity.OrderId = drRow["RESVID"].ToString().Trim();
appcontentDBEntity.MobileNum = drRow["MOBILE"].ToString().Trim();
appcontentDBEntity.UNIT_ID = drRow["UNIT_ID"].ToString().Trim();
appcontentDBEntity.ORDER_STATUS = drRow["ORDER_STATUS"].ToString().Trim();
appcontentDBEntity.NAME = drRow["NAME"].ToString().Trim();
appcontentDBEntity.ARRD = drRow["ARRD"].ToString().Trim();
appcontentDBEntity.DEPD = drRow["DEPD"].ToString().Trim();
appcontentDBEntity.CHANNEL = drRow["CHANNEL"].ToString().Trim();
appcontentDBEntity.PLATFORM_CODE = drRow["PLATFORM_CODE"].ToString().Trim();
appcontentDBEntity.GUEST_ID = drRow["GUEST_TD"].ToString().Trim(); ;
_autohotelplanEntity.AutoHotelPlanDBEntity.Add(appcontentDBEntity);
AutoHotelPlanSA.ApplyFYCZInterface(_autohotelplanEntity);
}
开发者ID:WuziyiaoKingIris20140501,项目名称:KFC,代码行数:26,代码来源:AutoPlanBP.cs
注:本文中的System.Data.DataRow类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论