print code

<asp:ImageButton OnClientClick="javascript:ClickPrint();" ImageUrl="images/btn_print.gif"
                    ID="btnPrint" runat="server"/>

 <script language="javascript" type="text/javascript">
          function ClickPrint() {

              //ISP-CheckRequest
            window.print();
            document.form1.btnPrint.style.visibility = 'hidden';
            document.form1.btnClose.style.visibility = 'hidden';
            document.form1.btnPrevious.style.visibility = 'hidden';
            document.form1.btnNext.style.visibility = 'hidden';
       
            document.form1.submit();
            }
           
            function ClickClose()
            {
            window.close();
            }
        </script>

Anil

datalist wrap column field

 <td>
    <div style="word-wrap: break-word; width: 100px" >
                        <%# Eval("MName")%>
     </div>
 </td>


also set datalist width=100%

SSIS reading multiple xml files from folder

http://stackoverflow.com/questions/6956409/ssis-reading-multiple-xml-files-from-folder

How to create ssis package which copies all files into new folder

http://stackoverflow.com/questions/7139172/how-to-create-ssis-package-which-copies-all-files-into-new-folder

how to substring one comma saperated column values

Select            
  @FirstName=Substring(@RecipientName,1,charindex(',',@RecipientName,1)-1),           
  @LastName=Substring(@RecipientName,charindex(',',@RecipientName,1)+1,len(@RecipientName)) 

how to chek comma in values

DECLARE @Pos int           
           
    SET @RecipientName = LTRIM(RTRIM(@RecipientName))           
    SET @Pos = CHARINDEX(',', @RecipientName, 1)           
 IF( @Pos > 0) 

how to replace spaces and compare where condition

Declare @Credential varchar(500)
SET @Credential = 'MediCAl  Doctor'
 select Credentials_Id from PMP_Credentials where REPLACE(Description,' ','')= REPLACE(@Credential,' ','')