Tuesday, February 28, 2017

C# create folder on runtime



You can try this code: this will read data from app.config for folder path. if the the path is not found then it it will create folder.


 string curDirectory = ConfigurationManager.AppSettings["AppOutPath"];  
 if (Directory.Exists(curDirectory + @"\Uploads"))  
         {  
           // Do something  
         }  
         else  
         {  
           Directory.CreateDirectory(curDirectory + @"\Uploads");  
           // Do something  
         }  



Monday, February 27, 2017

sql replace coma seperated string


I have a string like this:

000014000608,000014000609,000014000610,000014000611

From this string i want to  remove 00001 with '' because this is a prefix of my every coma separated value.




 REPLACE((SUBSTRING(m_rx_nos,6,LEN(CAST(m_rx_nos AS VARCHAR(500)))-6)),(',0000'+ CONVERT(VARCHAR(100),f.pharminfoid_FK)),',') as m_rx_nos  

 Out Put:

4000608,4000609,4000610,400061

vfpoledeb.1 provider is not registered on the local machine

Have u Install VFP Ole DB Provider in your System ? If No then Please Install it from following link. http://www.microsoft.com/download...