Cursor Example in Sql Server 2008

 Declare @name nvarchar(max)  
 Declare cur cursor for  
      select username from userdet  
 open cur  
 fetch next from cur into @name  
 while @@FETCH_STATUS=0  
 begin  
      print @name  
      fetch next from cur into @name  
 end  
 CLOSE CUR;  
 DEALLOCATE CUR;  

Asp.net C# code for download file

  protected void DownloadFile(string Path, string FileName)  
   {  
     try  
     {  
       string strURL = Path;  
       WebClient req = new WebClient();  
       HttpResponse response = HttpContext.Current.Response;  
       response.Clear();  
       response.ClearContent();  
       response.ClearHeaders();  
       response.Buffer = true;  
       response.AddHeader("Content-Disposition", "attachment;filename="+FileName);  
       byte[] data = req.DownloadData(Server.MapPath(strURL));  
       response.BinaryWrite(data);  
       response.End();  
     }  
     catch (Exception ex)  
     {  
     }  
   }  

Check all Check boxes in a check box list ASP.NET + Jquery

Design

 <asp:CheckBox ID="checkAllImport" runat="server" AutoPostBack="false" Text="Select All" />  
         <asp:CheckBoxList ID="chkOptions" runat="server" RepeatColumns="5" RepeatDirection="Horizontal"></asp:CheckBoxList>  

Script

  <script type="text/javascript">  
     $(document).ready(function() {  
     $("#<%=checkAllImport.ClientID %>").change(function() {  
     $("input[id *='chkOptions']").prop("checked", this.checked);  
     })  
     });  
   </script>