Posts

Showing posts from August, 2015

running c++ console app in c#

hello, i have c++ console app.exe want run using c# gui. c++ app executes functions on key press ( f1, f2, f3) i tried designing gui c# , using code/ideas found on stackoverflow far not working. want able press ( f1, f2, f3) on c# app , simulate in c++ running in background. thanks help, al hi, based on current description, let me list need do. 1. start console application in c# gui. 2. monitor key events in c# application, when f1 f6 hit, should pass input console application. for first step, can start console application using process class in .net. for second step, think idea christopher provided worth trying. in thread. http://stackoverflow.com/questions/6760341/control-console-application-from-windows-form-application-c-sharp when key press events triggered, can redirect input console application. if did not work, at https://msdn.microsoft.com/en-us/library/ms171548.aspx in the section "to send keystroke different application". anyway

Regarding Exception handling

could 1 let me know m missing. yesterday tried catch the  divide 0 exception in biztalk ... when deployed solution. exception not catched exception block. got suspended. i used system.exception. even today did check wcf service call.. retry 0; but in both cases message got suspended. , not handled exception block. fred could 1 let me know m missing. yesterday tried catch the  divide 0 exception in biztalk ... when deployed solution. exception not catched exception block. got suspended. i used system.exception. even today did check wcf service call.. retry 0; but in both cases message got suspended. , not handled exception block. fred fred, are using request-response port.  if so...just check below.. set port retry count 0. enable delivery notification " transmitted " on logical port in biztalk orchestration. catch exception "  system.web.services.protocols.soapexception " , handle it. have @ below link might help. a d

Provider Hosted App vs SharePoint Hosted App.

Image
hi all, i wondering scenario should use provider hosted app instead of sharepoint hosted app. regards amit k hi, please take @ these articles: sharepoint provider hosted app walkthrough: part 1 preparation is there difference between sharepoint hosted app , cloud hosted app? dmitry lightning tools check out our sharepoint tools , web parts | lightning tools blog | Мой Блог SharePoint  ,  Apps for Office and SharePoint  >  Developing Apps for SharePoint 2013

How to typecast a string parameter to UITestControl object reference?

is there anyway type cast string object reference of uitestcontrol? what trying achieve this:- uitestcontrol utc=(uitestcontrol)(this.parentwindow.subwindow.subchild); "this.parentwindow.subwindow.subchild" passed string.. no. cannot directly assign string uitestcontrol. are trying add title sub-windows of uitestcontrol? if yes, can add string uitestcontrol's windowtitles collection. i hope helps. please mark post answer if solved problem. happy programming! Visual Studio Languages  ,  .NET Framework  >  Visual C#

Calling a WebReference operation name the same as the Web service name

in wsdl below, web service "calcservice" , contains operation called "calcservice". when adding webreference wsdl, proxy generated (calcservice class) contains "callcalcservice" method "calcservice" operation - persumeably because method "calcservice" mistaken constructor. calling "callcalcservice" method tries invoke "callcalcservice" operation on web service, doesn't exist. calling other methods on proxy work fine. looking @ code reflector, method passes "calcservice" method name to soaphttpclientprotocol.invoke(), name translated in soapclienttype.getmethod() via a logical table of method names. table (methods) appears be set via reflection , maps thie "calcservice" name "callcalcservice". <?xml version="1.0" encoding="utf-8" standalone="no" ?> <definitions name="calcservice" targetnamespace=" http://tempuri.org/calcservice &qu

Implementing Form base security in C# desktop Application

Image
help me out please!, how implement form based security in c# desktop application, designing wages management system hi leemadras, welcome msdn forum. it seems want use login form validating. if so, can check threads below. login form using c# , sql http://social.msdn.microsoft.com/forums/en/csharpgeneral/thread/baa85c20-7f6a-4c92-9917-24b6fa39ca67 how create user login application on windows form http://social.msdn.microsoft.com/forums/en-ca/csharpgeneral/thread/b6f7bcd3-6ca7-473e-bf71-c9c5ec8e7511 have nice day. bob shen [msft] msdn community support | feedback us Visual Studio Languages  ,  .NET Framework  >  Visual C#

Support for android below 4.2 versions

i trying add authentication android app through azure mobile services.the tutorial mentions works on android version 4.2. support versions below 4.2? , how support android 5.0?? if works 4.2 work newer versions (such 5.0). , can point out tutorial you're using? far know mobile services sdk android works froyo (api level 8) , above (although froyo may need implement workaround described in blog post ). carlos figueira Microsoft Azure  >  Azure Mobile Apps

Azure PowerShell 4.3.0 - Every cmdlet returning "WARNING: System.ArgumentNullException: Value cannot be null."

hi all, i upgraded azure powershell version 4.3.0. since doing that, every azure powershell cmdlet returns following error message: warning: system.argumentnullexception: value cannot null. parameter name: origininput @ microsoft.windowsazure.commands.common.metrichelper.generatesha256hashstring(string origininput) @ microsoft.windowsazure.commands.common.metrichelper.get_hashmacaddress() @ microsoft.windowsazure.commands.common.metrichelper.populatepropertiesfromqos(azurepsqosevent qos, idictionary`2 eventproperties) @ microsoft.windowsazure.commands.common.metrichelper.logusageevent(azurepsqosevent qos) @ microsoft.windowsazure.commands.common.metrichelper.logqosevent(azurepsqosevent qos, boolean isusagemetricenabled, boolean iserrormetricenabled) @ microsoft.windowsazure.commands.utilities.common.azurepscmdlet.logqosevent() going on? i suggest uninstall powershell, delete contents of c:\program files (x86)\microsoft sdks\azure\powershell , reinst

Chkdsk process is failing when called from code

trying execute following snippet of code when additional disk attached system. *************************************************************************** m_driveletter = driveletter.trim( path .directoryseparatorchar); proc.startinfo.filename = chkdskprocessname; proc.startinfo.arguments = string .format( "{0} /x" , m_driveletter); proc.startinfo.windowstyle = processwindowstyle .hidden; proc.enableraisingevents = true ;                 proc.exited += new eventhandler (chkdskproc_exited); proc.start(); *************************************************************************** 7 out of 10 times chkdsk process returns error code = 3, means "could not check disk, errors not fixed, or errors not fixed because /f or /x not specified." not sure why error occurring. can me how can troubleshoot this? there other alternate process may leverage with/without chkdsk? please suggest. thanks. kausik kayal perhaps device not ready when you&#

Check Disaster Recovery scenario for azure mobile services

we need test disaster recovery scenario mobile services. unfortunately primary mobile service should in "unhealthy" state in order run recovery command. have tried in possible ways make mobile service unhealthy didn't worked out.. suggestion how can simulate scenario? tia!! http://azure.microsoft.com/en-us/documentation/articles/mobile-services-disaster-recovery/ Microsoft Azure  >  Azure Mobile Apps

Http response ack from BizTalk

  hi,   we doing integration customer using biztalk.   when customer posts xml our biztalk recieve biztalk ack : "biztalkhttpreceive correlationtoken tokentype="submit" {f8fe6732-a2e9-4041-af4e-4e3a2f8e9474} correlationtoken biztalkhttpreceive"     but customer doesnot want ack , instead needs http response ack :-   <?xml version="1.0"?> <commack> <transmissionid>ht99999999999991</transmissionid> <requesterid>ht9999999999999</requesterid> <providerid>ht99999999999998</providerid> <acknowledge>1</acknowledge> <transactiontype>2</transactiontype> <comment>success</comment>     </commack>   can achieved thro' biztalk ? if yes how ? hello jay, this forum dedicated biztalk rfid, general biztalk questions please post biztalk general discussions forum -arpit nand

How to Send data from a UDP server to a client and back again

i have basic structure client server message system can't figure out how send messages server client. can please tell me how change can send data in forth between server , client. client: http://pastebin.com/fzgcscbw server: http://pastebin.com/k0n18qs0 - nathan hastings executive of interverse software hi interverse software , thank posting here. as far know. when want send data server client. think have ip address , port. should send data client. like this: udpclient udpserver = new udpclient(udp_listen_port); while (true) { var remoteep = new ipendpoint(ipaddress.any, 11000); var data = udpserver.receive(ref remoteep); udpserver.send(new byte[] { 1 }, 1, remoteep); // if data received reply letting client know got data } here step: server receive client message , echoed client. byte[] bytebuffer = client.receive(ref remoteipendpoint); console.write("handling client @ " + remoteipendpoint + " - ")

Terminology

hello; i new biztalk, , confused meaning of terminology despite reading i've done online. wondering if can me difference between following terms: esb: enterprise service bus api: application integration bus ems: enterprise messaging service soa: service oriented architechture eai: enterprise application integration   i'll know if understood if can draw diagram connecting terms each other somehow.   thanks,   i take shot @ this.   soa approach software design , implementation in enterprise's sofware functions organized services flexibility. typically more of verb - doing soa.   eai description of level of integration within system , used when applications designed esb or other enterprise connectivity. eai exists when connecting applications across enterprise. in order accomplish eai ususally use esb provide pathway connectivity. esb may or may not soa-compliant.   with recent introduction of windows azure , microsoft cloud platform (@ pdc

Learn Biztalk ESB Toolkit

hi, i new esb. can guide me how start working esb toolkit. videos etc... have gone through various links available in google unable understand. regards, vishal hi, esb, following link gives survival guide esb esb survival guide . 1 stop shop articles, blogs, webcasts available online. step step sample using biztalk esb toolkit 2.2, can have @ blog: http://vijaymstech.wordpress.com/2014/01/30/biztalk-2013-esb-toolkit-2-2-messagetype-based-routing-step-by-step-demo/comment-page-1/ webcast on esb refer:  http://www.cloudcasts.net/default.aspx?category=biztalk+esb+toolkit esb use cases:  http://msdn.microsoft.com/en-us/library/ff699819.aspx esb toolkit labs:  http://www.microsoft.com/en-gb/download/details.aspx?id=27151 rachit sikroria (microsoft azure mvp) BizTalk Server  > 

Reason: Could not load type 'Microsoft.BizTalk.Edi.MessageCore.ReceiverRoleX12Settings' from assembly

a message sent adapter "file" on send port "omh.finance.edi.ub92to837_5010.opmcare.snd_edi_file" uri "c:\biztalk\finance\omh.finance.edi.ub92to837_5010.opmcare\ports\output\opmcare.%datetime_bts2000%.edi" suspended.   error details: there failure executing send pipeline: "microsoft.biztalk.edi.defaultpipelines.edisend, microsoft.biztalk.edi.edipipelines, version=3.0.1.0, culture=neutral, publickeytoken=31bf3856ad364e35" source: "edi assembler" send port: "omh.finance.edi.ub92to837_5010.opmcare.snd_edi_file" uri: "c:\biztalk\finance\omh.finance.edi.ub92to837_5010.opmcare\ports\output\opmcare.%datetime_bts2000%.edi" reason: not load type 'microsoft.biztalk.edi.messagecore.receiverrolex12settings' assembly 'microsoft.biztalk.edi.messagecore, version=3.0.1.0, culture=neutral, publickeytoken=31bf3856ad364e35'.    messageid:  {e03d16fe-5d37-4cf3-87e8-1539b7d58a72}  instanceid: {3c8f7687-1438-40bd-

How to publish Azure API App?

hi, i have started learning , experimenting azure api apps. managed create small demo api project in vs 2015 , able run locally using swagger endpoint. in order publish api, select "microsoft azure app service" publish target in "publish web" dialog. takes me "app service" dialog. here click "new". takes me "create app service" dialog, except "app service" plan, other fields pre-populated. however, vs2015 freezes @ point, , have kill app after several minutes. can point me right steps or documentation this? regards, rangarajan i assuming have create api app vs2015, enable swagger first have go swaggerconfig.cs , un comment section                    }) .enableswaggerui(c => {  this enable swagger api app. run locally and  add "/swagger" end of url on browser. should able see api's now publish , follow wizard deployment philip

translate line code C# to VB.NET

hi everybody, does there can me tha traslation of next code c# vb.net? i'm working in wpf application (vb.net). using system; using system.io; using system.collections.generic; using system.linq; using system.text; using system.xml.linq; namespace listviewtest {     public class mydata     {         /// <summary>         /// saves items mydata.xml file in bin folder.         /// </summary>         /// <param name="items"></param>         public void save(system.windows.data.collectionview items)         {             xdocument xdoc = new xdocument();             xelement xeroot = new xelement("data");             xelement xesubroot = new xelement("rows");             foreach (var item in items)             {                 listviewdata lvc = (listviewdata)item;                 xelement xrow = new xelement("row");                 xrow.add(new xelement("col1

Executing commend file while BTDF deployment

hi all, have using below code run cmd file while btdf deployment process did not executing   <target name="customdeploytarget">        <exec command="..\cleancopy.cmd $(environmentname)"></exec>   </target>  <target name="customdeploytarget">        <exec command=" cmd.exe &quot;cleancopy.cmd $(environmentname)&quot;"></exec>   </target> $(environmentname) passing parameter cleancopy.cmd : copy .\direct.xml  c:\biztalk\%1\clenupscript please guide me how resolve  error  hello, try this <target name="customdeploytarget"> <exec command="copygac.bat" workingdirectory="c:\test"/>  </target> thanks BizTalk Server  > 

biztalk stop (running- downloading data)job

hi, i have scheduler job download data running form last 2 days (keep downloading data). dt know when finish. could please suggest me, steps stop job ( abundant running process) ? many thanks. you can suspend instance , let other process complete. later if want resume can else terminate good. there won't side effect of these actions. if job running longer duration not desirable suggest pick , process few records @ time. regards, ajeet kumar mcts biztalk server BizTalk Server  >  BizTalk Server General

JSON.NET - asymmetric serialization

hi, i'm having problems serializing , deserializing objects using json.net. need symmetric serialization, when deserialize object need exact copy of original object. not case. the following code fails, because obj2.value of type long, should of type myenum: public enum myenum { value1, value2 } public class myclass { public string name { get; set; } [jsonproperty(typenamehandling= typenamehandling.objects)] public object value { get; set; } } class program { static void main(string[] args) { var obj1 = new myclass { name = "name", value = myenum.value2 }; jsonserializersettings settings = new jsonserializersettings { typenamehandling = typenamehandling.all, formatting = newtonsoft.json.formatting.indented }; var json = jsonconvert.serializeobject(obj1, settings); var obj2 = jsonconvert.deserializeobject<myclass>(json); debug.as

cannot connect to configuration database

hi friends, i have web method (web service) returns url of sharepoint site. when build (f5) every thing goes well. when browse it, generates following error. microsoft .sharepoint.spexception: cannot connect configuration database . tips .... i have search , worked on many kb articles nothing has helped. here code.     [webmethod]     public string getmycontactsforsmarttag()     {         try         {             guid mysiteguid = new guid("5e9eab1b-f653-43a9-b2f6-751d443e7b5f");                          spsite ignitosite = new spsite(mysiteguid);                          return ignitosite.url;          }          catch(exception ex)          {              return ex.tostring();          }      } check identity running in webservice application pool has sufficient permissions read sharepoint configuration database. Archived Forums A-B  > 

What are some design patterns that are useful to a beginner Application Architect?

what of best design patterns beginner application architect? more recently, have learned 3 - tier, mvc, oo, adapter pattern, , service locater pattern. more specific design patterns a web application, using asp.net besides mvc? hi, you may need learn solid pattern , composotion of important principles. inversion of control important , how use ioc containers. on model layer use repository pattern persisting data database. i highly recommend if read book  microsoft application architecture guide , rich of many guidelines developing applications under microsoft platform. thanks mahmoud Architecture  >  Architecture General

While Converting lineargradient from EMF to PDF I cannot to identify the lineargradient is Horizontal or Vertical?

i can convert lineargradient emf pdf ,but lineargradient type cannot identify,which horizontal or vertical or diagonal can me find lineargradient type. regards, sasi. hi sasi, could please elaborate more? how did convert lineargradient in current project? did use 3rd-libraries? we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make community forums great place. click here participate survey. Visual Studio Languages  ,  .NET Framework  >  Visual C#

Get Data from Calulated DataSet

i have following dataset run following query, select        min(start_date) mindate,  max(exp_date) maxdate from            sales where        (memberid = @memberid) called, getdatabyminmaxdates when run following code; memdata.ezrangedatatable ezdata = memdatatableadapters.ezrangetableadapter ezconnect = new memdatatableadapters.ezrangetableadapter(); memdata.ezrangedatatable sales2data; memdata.ezrangerow sales2row; sales2data= ezconnect.getdatabyminmaxdates(memberid); if (ezdata.count > 0) { sales2row = (memdata.ezrangerow)sales2data.rows[0]; datetime m_min= sales2row.mindate; datetime m_max= sales2row.maxdate; } receive error sales2row.mindate , sales2row.maxdate doesn't exist. how ght mindate , maxdate out of dataset? it's obvious using typed datasets , ezrangedatatable , ezrangerow "cla

Understanding Biztalk Send port retry

hi, i having wcf send port hitting azure end point timeout of 10 min. send port has retries enabled. apparently looks biztalk sending multiple requests before timeout. possible? my understanding send port retries if receives http 404 message. , retries making http connection only.  how timeout on wcf config  work here? if wcf channel timesout, biztalk send port retry? any links detailed understanding of how works biztalk end, helpful. thanks! there multiple timeout values can configured wcf send ports. on general tab of port properties,  click configure button next transport type , @ binding tab. there timeout values open, send, , close. BizTalk Server  >  BizTalk Server General

Create reverse DNS for Azure Cloud VM when using AzureResourceManager (ARM) mode

i have created vm using azureresourcemanager (arm) mode. want configure reverse dns record vm, but, instruction azureservicemanagement (asm) mode, like  ps c : \> set - azureservice – servicename “ contosoapp1 ” – description “ app1 with reverse dns ” – reversednsfqdn “ contosoapp1 . cloudapp . net .” main error command set-azureservice not working, set-azurermservice command not working. so, how can create reverse dns using arm commands? greetings, please check below link contains discussion related same issue. https://azure.microsoft.com/en-in/blog/announcing-reverse-dns-for-azure-cloud-services/ hope helps. regards, Microsoft Azure  >  Azure Scripting and Command Line Tools

BingMaps iOS SDK crash

hi everybody, i've problem iphone app. it's native application , use bingmaps ios sdk. i used sdk demo examples configure le map. the app works fine of time crashes after using while. i found instruments lot of memory leak sdframetimer bmmapviewinternal. here can find crash logs. http://goo.gl/us7yz http://goo.gl/eomiq http://goo.gl/dlwqh i hope can help. thank attention. regards __ valentino for ios development bing maps recommended development path use bing maps v7 ajax control phone gap. access full bing maps api , end better application in end. http://rbrundritt.wordpress.com Bing Maps  >  Bing Maps General

Error: The instance completed without consuming all of its messages.

hi, have following scenario. processing messages in sequential way. have 2 orchestration, orch1 has transformation logic , orch2 has sequential processing logic. orch2 directly binded msgbox , receives messages persisted orch1 based on correlating property. need sort message based on receivedfilename(which date time stamp). in orch2, receiving messages within delay 1min, adding list, sorting messages based on filename , sending destination location 1 one. getting 1 error in orch2 when frequency high. error says " the instance completed without consuming of messages. instance , unconsumed messages have been suspended. " believe cause be, when orch2 sending 1 batch of sorted messages might have received new messages meanwhile. , so, sorted messages sent orch2 instance completes there new messages still attached orch instance , suspending. totally not able figure out how can avoid error. don't want terminate suspended message(loss of message :(). in advance ajeet

Saving Windows Identities

hi   in application i'd create authentication scheme similar 1 of sql server. users can log on automatically using windows account or enter username , password. wonder save in users database table in first case. think storing username only, maybe in form "mydomain\steve" not because might call computer "mydomain" , create local user "steve" , have access program. else must stored in users table. candidates sid or token not know compare logged on windows user's data to.   thank you   christian within scope of single computer or domain, sids unique, yes. in case of domain, dc makes sure sids unique.   in case of workgroup, little different. may happen 2 users on 2 different computers indeed have same sid, not matter sids should never exchanged on network -- sid of local user account worthless different computer anyway. instead, remote user logs on local user account -- local sid used, of course unique (within scope of computer) agai

Biztalk mapping

hi, i'm having trouble mapping generated schema biztalk adapter , more structured xml schema. the trouble that header nodes in destination schema repeated many times there "line" nodes in source schema , seems because i map data "line" nodes in source schema , map header nodes in destination schema. is there way in biztalk specify destination schema should have 1 header node if data source same. functiods? thanks! trond tjp any chance of seeing simple example of input , output schemas?  soungs trying implement grouping pattern. might check out muenchian grouping  http://blogs.msdn.com/chrisromp/archive/2008/07/31/muenchian-grouping-and-sorting-in-biztalk-maps.aspx http://www.richardhallgren.com/efficient-grouping-and-debatching-of-big-files-using-biztalk-2006/ BizTalk Server  > 

New to C#

hi everyone.  this first experience creating mvc type application in c# asp ui , i'm having trouble data access.  the strangest part wasn't having trouble , seems no reason, insert statements have stopped working.  i'm not sure code helpful if more on user controls or controller methods, ask.  i'm not looking criticism or critique, need else blantant syntax errors missing.  i assure file path correct database.  if wants me send them whole visualstudio solution can too.  here's part of code throwing exceptions. t hanks willing attempt solution here. have learned lot these forums , first post. apologize if in wrong forum. public string insertnewemployee(employee vempl) { bool isinserted = false ; oledbconnection curconn = new oledbconnection(); curconn.connectionstring = "provider=microsoft.ace.oledb.12.0;data source=c:\\new\\enrollments.accdb" ; string ssql = "insert employees (e

Read from CSV file and write specific/selected columns to mysql

Image
hello, i have 45 columns , between 50-100 000 lines csv files. i'd parse data these csv files , store database. out of these 45 columns need use 10-14 rows lines. how filter out on reading or writing redundant rows? thank you! have looked @ docs on this? https://dev.mysql.com/doc/refman/5.7/en/load-data.html please remember mark replies answers if , unmark them if provide no help, others looking solutions same or similar problem. contact via twitter (karen payne) or facebook (karen payne) via msdn profile not answer coding question on either. vb forums - moderator Visual Studio Languages  ,  .NET Framework  >  Visual C#

Biztalk Server Integration with MS Dynamics NAV

i continually search far , wide on web new developments being worked on microsoft integrate biztalk dynamics nav. specifically, have implemented dynamics nav , have upgraded nav-2015. however, 2015 going year potentially pursue seamless integration applications , nav...most viewing biztalk as our first choice option.  i have read commerce gateway functionality...that somehow used integrate biztalk nav...is not available anymore. there in works overcome new obstacle? hi yes correct commerce gateway functionality has been old , nav2015 integration .but there web service existence can  make integration more :). navision-2015 framework expose public function inside object. each function parameters determine operation contract , xmlport object used expose complex/customise xml data structure.  , can use wcf adapter framework integrate these endpoints . in integration biztalk data access layer addressing communication between biztalk application , navision web service.the reque

identifying and removing digit from a given string

using system; using system.collections.generic; using system.linq; using system.web; using system.web.ui; using system.web.ui.webcontrols; public partial class _default : system.web.ui.page {     public class test     {         protected void page_load(object sender, eventargs e)         {             string s1 = "palle123 technologies";             specialcharacterzelim se = new specialcharacterzelim();             string res = se.removenumerics(s1);        }     }         public class specialcharacterzelim         {             public string  removenumerics(string   s )             {                      //code             }         }  i getting error at public string  removenumerics(string   s ). please help hi raju4u; did @ solution above , re-posted here , if did have issues it? using system . text . regularexpressions ; public string removenumerics ( string s ) { return regex . replace ( s ,

Using the WMI Event Watcher Task on FTP

Image
i wondering if can use wmi event watcher (ssis in sql server 2008) monitor ftp directory, , if so, sample wql query that? i saw couple of examples wmi used watch files in particular windows folder requirement need monitor ftp site file , when file arrives need email ( use send mail task) concerned users.  please advice how can monitor ftp site using ssis? thanks eva05 you cannot. wmi watcher cannot access ftp sites. to monitor remote ftp site 1 create script remote directory listing using dir command dumping content local file analysis ( parsing ) see if needed file(s) listed , attempt processing. i recall there commercial offerings in form of ssis task can procure otherwise. arthur my blog SQL Server  >  SQL Server Integration Services

sql server xml illegal character error

declare @xmldata xml declare @textdata nvarchar ( max ) set @xmldata =( select convert ( varchar , isnull ( o . datestartorder , '' ), 101 ) as datestartorder , o . datestoporder , o . datedc , orderdescription = rtrim ( rtrim ( ltrim ( isnull ( ph . namepharm , '' ) + ' ' )) + case when isnull ( nd . namegeneric , '' ) = '' then '' when isnull ( nd . namegeneric , '' ) <> isnull ( ph . namepharm , '' ) --then '' then ' (' + isnull ( nd . namegeneric , '' ) + ')' else '' end ), -- + ' ' + isnull ( nd . strength , '' ) + ' ' + isnull ( nd . formdosage , '' ) + ' ' + isnull ( o . instructionsdosing , '' ) as sig from orders o left outer join ordertype ot on