I don't use datastation but I think you need to create a datastation object. Then you should be able to access all the properties and methods.
HTH! -- Bill Palmer Financial Systems Analyst Mid-Columbia Medical Center 541-296-7417 >>> On 1/17/2010 at 5:02 PM, in message <[email protected]> wrote: > Yes, the configuration file does have the DirectUpdate set to true. The > problem is how do you syntactically update datastation variables from within > .NET? > > > ________________________________ > From: [email protected] [mailto:[email protected]] > Sent: Sunday, January 17, 2010 4:05 PM > To: [email protected] > Subject: [talkbws] RE: .NET and datastation > > What does the .bds look like? There's flag called DirectUpdate that should > be set to true. > > From: [email protected] [mailto:[email protected]] > Sent: Sunday, January 17, 2010 4:00 PM > To: Talk > Subject: [talkbws] .NET and datastation > > Hello All! > I am building a script in .NET (c#) referencing BostonWorkstion to easily > read through an excel spreadsheet and script some data entry through a Java > connection. My problem is this... I have not found a way to update > Datastations variables. In VBA we would use b.D("status"). But that does > not appear to be valid in .NET. I can reference the value of a datastation > variable by using b.Value("status") but that is not updatable. Am I doing > something squirrley or is there a different way to update the datastation > variables in .NET? I am guessing flags wouldn't be updateable either since > they have same syntax (b.F("status")), but I haven't tried them. > > Below is what I attempting to do ... thanks in advance for any suggestions! > > John Mulligan > ProMedica Health System > > > // Create a bws object and the load the spreadsheet into a > collection > BostonWorkStationClass b = new BostonWorkStationClass(); > string mm = ""; > string cc = ""; > > // Open the file > b.D.Open_ (fileName, > BostonWorkStation70.enumFileType.ftExcel,cc,ref mm) ; > > // Go into a loop of all the records > do > { > // Set the user properties > mckUser.ID = b.Value("ID"); > mckUser.LastName = b.Value("LastName"); > mckUser.FirstName = b.Value("FirstName"); > > b.D("MyStatus") = "READY FOR SCRIPTING"; // <<<<<<<<<< > THIS WON'T > WORK > > // Move to the next row > b.D.Next_(); > > } while (b.D.EOF == false); > > > > > _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ > > EMAIL CONFIDENTIALITY NOTICE > > This Email message, and any attachments, may contain confidential > patient health information that is legally protected. This information > is intended only for the use of the individual or entity named above. > The authorized recipient of this information is prohibited from disclosing > this information to any other party unless required to do so by law > or regulation and is required to destroy the information after its stated > need has been fulfilled. If you are not the intended recipient, you are > hereby notified that any disclosure, copying, distribution, or action > taken in reliance on the contents of this message is strictly prohibited. > > If you have received this information in error, please notify > the sender immediately by replying to this message and delete the > message from your system. > > --- > To post a message to this list, send mail to: [email protected] > > --- > To post a message to this list, send mail to: [email protected] > > You are currently subscribed as: [email protected] > > Unsubscribe in the customer center on our website: > http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx > _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ > > EMAIL CONFIDENTIALITY NOTICE > > This Email message, and any attachments, may contain confidential > patient health information that is legally protected. This information > is intended only for the use of the individual or entity named above. > The authorized recipient of this information is prohibited from disclosing > this information to any other party unless required to do so by law > or regulation and is required to destroy the information after its stated > need has been fulfilled. If you are not the intended recipient, you are > hereby notified that any disclosure, copying, distribution, or action > taken in reliance on the contents of this message is strictly prohibited. > > If you have received this information in error, please notify > the sender immediately by replying to this message and delete the > message from your system. > > > --- > To post a message to this list, send mail to: [email protected] > > You are currently subscribed as: [email protected] > > Unsubscribe in the customer center on our website: > http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx > CONFIDENTIALITY NOTICE: This e-mail message (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, and is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any unauthorized review, use, disclosure, dissemination, copying, forwarding or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are the intended recipient but do not wish to receive communication through this medium, please advise the sender immediately. --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
