How to set an attribute value of a date field?

Hi, I'm using C# and Livelink 9.5I read all my data to be used in AttrSetValues commands as strings using an OracleDataReader. So strings are straight forward, and with integers data types, I've gotten away with converting datatypes in the last moment, for example here is an AddFileWithAttributes line:static int AddFileWithAttributes(string File, string Title, string attribute1, string attribute2,string attribute3, string attribute4,string attribute5, string attribute6, LAPI_ATTRIBUTES attr,LLValue catID,LLSession session,LAPI_DOCUMENTS documents,LLValue mobjID, int parentVol, int parentId, int dataID)Followed by an example of a specific attrValues.add line for an integer field: attrValues.add(Convert.ToInt16(attribute6));status=attr.AttrSetValues(catVersion, "Year (YYYY)", LAPI_ATTRIBUTES.ATTR_DATAVALUES, attrValuesPath, attrValues);Notice the ToInt16 which did the trick there. Now I have some date attributes to deal with. The strings look like this: "13-APR-2006".I'm not sure if I can't get away with a similar approach. Dealing with DateTime in C# is a weakness for me. I would appreciate any clues on how to set date attributes within C#.Thanks,- Mark

Find more posts tagged with

Comments

Nair_Krishnankutty_(nairkrishnankutty_-_(deleted))

I have used this approach with dates before see if this helpshttp://www.tek-tips.com/viewthread.cfm?qid=1290619

Mark Runyan

I guess in that approach a time stamp is constructed from previously defined variables, i.e.System.DateTime testDate = new System.DateTime(intLLISS_YEAR, intLLISS_MONTH, intLLISS_DAY);//make up a time stampThis doesn't look like it matches my Oracle date/time format, and I'm not sure how to make it match. Do you think I could just use DateTime.Parse? I'm not sure of the IFormatProvider argument to make it work.

Mark Runyan

Thanks Nair, I finally figured out the significance of the LLValueNET object in the link you posted. In order to read the Oracle dates which in my case can be null, I read them as strings from the database, and if not empty cast them into C# DateTime, then LLValueNET.if date_text.Length > 0 {DateTime date_data = DateTime.Parse(date_text);LLValueNET date_value = new LLValueNET(date_data);attrValues.add(date_value);}Regards, - Mark