Switin Kotian

Hi, To All Reader. This blog is specially for developer who are comming from VB 6.0 IDE To .net IDE. In VB 6.0 there is a option Goto Last Position. Same is missing in .net IDE. As i known how important that feature is . I recently found the shortcut to key to it. So i thought i would like to share with you people. ShortCut Key :- CTRL And - (Minus Key) . Switin Kotian

Public Sub MailData(ByVal Path As String, ByVal strEmailID As String, _ ByVal strEmailCC As String, ByVal strEmailBCC As String, Optional ByVal Subject As String = "", _ Optional ByVal Message As String = "", _ Optional ByVal KillPath As Boolean = True) Dim msg As New MailMessage Dim arrPath() As String arrPath = Path.Split(";") msg.From = New MailAddress( xyz@abc.com ) msg.To.Add("abc@123.co.in") msg.CC.Add("switinkotian@rediffmail.com") msg. Bcc.Add("switinkotian@gmail.com") msg.Subject = "Attached is a Mulitple PDF file" msg.Body = "Developed by - Switin Kotian" 'Dim attachment As Attachment = New Attachment(Path) ' inCase of Multiple Single Attachment Dim attachment As Attachment ...

Running Totals in SQL Select Base.CustomerID ,Base.DocDt , TotalforCust , SUM(TTotal) RunningTotal from ( Select CustomerID , DocDt ,SUM(Amount) TotalforCust from Transales GROUP By CustomerID , DocDt )Base Inner join ( Select CustomerID , DocDt ,SUM(Amount) TTotal from Transales GROUP By CustomerID , DocDt ) RnT on Base.CustomerID = RnT.CustomerID and RnT.DocDt GROUP BY Base.CustomerID ,Base.DocDt , TotalforCust