• Home
  • SQL Server
    • Articles
    • T-SQL Puzzles
    • Output Puzzles
    • Interview Questions
    • Performance Tuning
    • SQL SERVER On Linux
    • Resources
  • SSRS
    • SSRS Articles
    • Interview Questions
  • SSAS
    • SSAS Articles
    • DAX
  • SQL Puzzles
  • Interview Questions
    • SQL Interview Questions
    • Data Interview Questions
  • Python Interview Puzzles
  • New Features(SQL SERVER)
    • SQL SERVER 2017
    • SQL SERVER 2016
    • SQL SERVER On Linux
  • Social
    • Expert Exchange
      • Top Expert in SQL
      • Yearly Award
      • Certifications
      • Achievement List
      • Top Expert of the Week
    • HackerRank (SQL)
    • StackOverflow
    • About Me
      • Contact Me
      • Blog Rules

Improving my SQL BI Skills

Improving my SQL BI Skills

Category Archives: ASP.NET

ASP.NET related stuff

Email Alerts in Asp.net applications in different format

12 Thursday Aug 2010

Posted by Pawan Kumar Khowal in ASP.NET

≈ Leave a comment


Below class and its methods will help you in sending email alerts to the end users.

public class clsEmail
    {
        StringBuilder Strbuilder = new StringBuilder();
        StringBuilder obj1 = new StringBuilder();
        static string strMailFrom = System.Configuration.ConfigurationManager.AppSettings["mailFrom"];
        static string strMailTo = System.Configuration.ConfigurationManager.AppSettings["mailTo"];
        static string strMailCC = System.Configuration.ConfigurationManager.AppSettings["MailCC"];
        static string strMailBcc = System.Configuration.ConfigurationManager.AppSettings["MailBcc"];
        static string strSmtpServer = System.Configuration.ConfigurationManager.AppSettings["MailServer"];
        static string strUserName = System.Configuration.ConfigurationManager.AppSettings["mailUserName"];

        /// <summary>
        /// procedure used to send the mail notification to the end user.
        /// </summary>
        /// <param name="message"></param>
        /// <param name="subject"></param>
        public static void SendNewCustomerEmail(string message, string subject)
        {
            string Style1 = "style=’font-family: Verdana;font-weight: normal;font-size: 11px;color: black’";
            StringBuilder Strbuilder = new StringBuilder();
            try
            {
                if (message != string.Empty)
                {
                    // Create the Objects
                    System.Net.Mail.MailMessage objMsg = new System.Net.Mail.MailMessage();
                    System.Net.Mail.SmtpClient SmtpMail = new SmtpClient(strSmtpServer,25);
                    SmtpMail.Credentials = new NetworkCredential("EMailAddress", "Password");         
                    MailAddress fromAddress = new MailAddress(strMailFrom, "Testing");
                    objMsg.To.Add(strMailTo);
                    objMsg.CC.Add(strMailCC);
                    objMsg.Bcc.Add(strMailBcc);
                    objMsg.From = fromAddress;
                    objMsg.Subject = subject;
                    Strbuilder.Append("<form><div " + Style1 + "> Hi,<Br><br> " + message + "</Div></form>");
                    Strbuilder.Append("<form><div " + Style1 + "> Regards,<Br> Dev Team </Div></form>");
                    objMsg.Body = Strbuilder.ToString();
                    objMsg.IsBodyHtml = true;
                    objMsg.Priority = MailPriority.High;
                    objMsg.BodyEncoding = System.Text.Encoding.UTF8;    
                    SmtpMail.Send(objMsg);
                }
                else
                {
                }
            }
            catch (SmtpException E)
            {
                AeSharedLibrary.clsMessage.Show("Error :" + E.Message.ToString() + " : " + E.InnerException.Message.ToString());
            }
            finally
            {

            }

        }

        /// <summary>
        /// procedure used to send the mail notification to the end user.
        /// </summary>
        /// <param name="message"></param>
        /// <param name="subject"></param>
        public static void SendNewCustomerEmail(string EmailId, string message, string subject)
        {
            string Style1 = "style=’font-family: Verdana;font-weight: normal;font-size: 11px;color: black’";
            StringBuilder Strbuilder = new StringBuilder();
            string strSmtpServer = System.Configuration.ConfigurationManager.AppSettings["MailServer"];
            try
            {
                if (message != string.Empty)
                {
                    // Create the Objects
                    System.Net.Mail.MailMessage objMsg = new System.Net.Mail.MailMessage();
                    System.Net.Mail.SmtpClient SmtpMail = new SmtpClient(strSmtpServer, 25);
                    SmtpMail.Credentials = new NetworkCredential("EmailId", "Password");
                    MailAddress fromAddress = new MailAddress(EmailId, "Testing");
                    objMsg.To.Add(EmailId);
                    //objMsg.CC.Add(strMailCC);
                    //objMsg.Bcc.Add(strMailBcc);
                    objMsg.From = fromAddress;
                    objMsg.Subject = subject;
                    Strbuilder.Append("<form><div " + Style1 + "> Hi,<Br><br> " + message + "</Div></form>");
                    Strbuilder.Append("<form><div " + Style1 + "> Thnx,<Br> Dev Team </Div></form>");
                    objMsg.Body = Strbuilder.ToString();
                    objMsg.IsBodyHtml = true;
                    objMsg.Priority = MailPriority.High;
                    objMsg.BodyEncoding = System.Text.Encoding.UTF8;
                    SmtpMail.Send(objMsg);
                }
                else
                {
                }
            }
            catch (SmtpException E)
            {
                AeSharedLibrary.clsMessage.Show("Error :" + E.Message.ToString() + " : " + E.InnerException.Message.ToString());
            }
            finally
            {

            }
        }

        /// <summary>
        /// procedure used to send the mail notification to the end user.
        /// </summary>
        /// <param name="message"></param>
        /// <param name="subject"></param>
        public static void SendNewCustomerEmail(string EmailId, string message, string subject, DataSet _dsLoginDetails)
        {
            string Style1 = "style=’font-family: Verdana;font-weight: normal;font-size: 11px;color: black’";
            StringBuilder Strbuilder = new StringBuilder();
            string strSmtpServer = System.Configuration.ConfigurationManager.AppSettings["MailServer"];
            try
            {
                if (message != string.Empty)
                {
                    // Create the Objects
                    System.Net.Mail.MailMessage objMsg = new System.Net.Mail.MailMessage();
                    System.Net.Mail.SmtpClient SmtpMail = new SmtpClient(strSmtpServer,25);
                    SmtpMail.Credentials = new NetworkCredential("EmailID", "Password");
                    MailAddress fromAddress = new MailAddress(EmailId, "Testing");
                    objMsg.To.Add(EmailId);
                    //objMsg.CC.Add(strMailCC);
                    //objMsg.Bcc.Add(strMailBcc);
                    objMsg.From = fromAddress;
                    objMsg.Subject = subject;
                    Strbuilder.Append("<form><div " + Style1 + "> Hi,<Br><br> " + message + "</Div></form>");
                    Strbuilder.Append("<form><div " + Style1 + "> Regards,<Br> Dev Team </Div></form>");
                    objMsg.Body = Strbuilder.ToString();
                    objMsg.IsBodyHtml = true;
                    objMsg.Priority = MailPriority.High;
                    objMsg.BodyEncoding = System.Text.Encoding.UTF8;
                    SmtpMail.Send(objMsg);
                }
                else
                {
                }
            }
            catch (SmtpException E)
            {
                AeSharedLibrary.clsMessage.Show("Error :" + E.Message.ToString() + " : " + E.InnerException.Message.ToString());
            }
            finally
            {

            }
        }

        /// <summary>
        /// procedure used to send the mail Notification to the end user.
        /// </summary>
        /// <param name="obj_h">Hashtable</param>
        /// <param name="subject">string</param>
        public static void SendNewCustomerEmail(Hashtable obj_h, string subject, string EmailId, string message)
        {
            StringBuilder Strbuilder = new StringBuilder(5000);
            StringBuilder obj1 = new StringBuilder();
            string Strvalue = "";

            string Style1 = "style=’font-family: Verdana;font-weight: normal;font-size: 11px;color:black’";

            string Style2 = "style=’text-align: left;font-family: Verdana;font-weight: normal;font-size: 11px;width: 150px;border: 1px #EFEFEF solid;border-collapse: collapse;border-spacing: 0px’";
            try
            {

                System.Net.Mail.MailMessage objMsg = new System.Net.Mail.MailMessage();
                System.Net.Mail.SmtpClient SmtpMail = new SmtpClient(strSmtpServer,25);
                SmtpMail.Credentials = new NetworkCredential("EmailID", "Password");
                MailAddress fromAddress = new MailAddress(EmailId, "Testing");
                objMsg.To.Add("EmailAddress");
                objMsg.From = fromAddress;
                objMsg.Subject = subject;
                IDictionaryEnumerator En = obj_h.GetEnumerator();
                Strbuilder.Append("<form><div " + Style1 + "> Hello,<Br><Br></Div></form>");
                Strbuilder.Append("<table border=1 width=60%" + Style2 + ">");
                while (En.MoveNext())
                {
                    if (En.Value.ToString().Trim() != "")
                    {
                        Strvalue = En.Value.ToString();
                    }
                    else
                    {
                        Strvalue = "-";
                    }
                    Strbuilder.Append("<tr><td " + Style2 + ">" + En.Key + "</td><td " + Style2 + ">" + Strvalue + "</td> </tr>");
                }
                Strbuilder.Append("</table>");
                Strbuilder.Append("<form><div " + Style1 + "> Regards,<Br> Dev Team </Div></form>");

                objMsg.Body = Strbuilder.ToString();
                obj_h.Clear();
                objMsg.IsBodyHtml = true;
                objMsg.Priority = MailPriority.High;
                objMsg.BodyEncoding = System.Text.Encoding.UTF8;               
                SmtpMail.Send(objMsg);

            }
            catch (SmtpException E)
            {
                AeSharedLibrary.clsMessage.Show("Error :" + E.Message.ToString() + " : " + E.InnerException.Message.ToString());
            }
            finally
            {

            }

        }

        /// <summary>
        /// procedure used to send the mail Notification to the end user.
        /// </summary>
        /// <param name="obj_h">Hashtable</param>
        /// <param name="subject">string</param>
        public static void SendNewCustomerEmail(DataTable dt)
        {
            StringBuilder Strbuilder = new StringBuilder(5000);
            StringBuilder obj1 = new StringBuilder();
            string Strvalue = "";
            string Style1 = "style=’font-family: Verdana;font-weight: normal;font-size: 11px;color:black’";          
            string Style2 = "style=’text-align: left;font-family: Verdana;font-weight: normal;font-size: 11px;width: 150px;border: 1px #EFEFEF solid;border-collapse: collapse;border-spacing: 0px’";
            try
            {

                System.Net.Mail.MailMessage objMsg = new System.Net.Mail.MailMessage();
                System.Net.Mail.SmtpClient SmtpMail = new SmtpClient(strSmtpServer,25);
                SmtpMail.Credentials = new NetworkCredential("EmailID", "Password");
                MailAddress fromAddress = new MailAddress(dt.Rows[0]["EmailFrom"].ToString(), "Testing");

                objMsg.To.Add(dt.Rows[0]["EmailAddTo"].ToString());
                objMsg.CC.Add(dt.Rows[0]["EmailAddCC"].ToString());
                objMsg.Bcc.Add(dt.Rows[0]["EmailAddBCC"].ToString());
                objMsg.From = fromAddress;
                Hashtable obj_h = new Hashtable();
                IDictionaryEnumerator En = obj_h.GetEnumerator();
                objMsg.Subject = dt.Rows[0]["EmailSubject"].ToString();              
                Strbuilder.Append("<form><div " + Style1 + "> Hello,<Br><Br></Div></form>");
                Strbuilder.Append("<table border=1 width=60%" + Style2 + ">");
                while (En.MoveNext())
                {
                    if (En.Value.ToString().Trim() != "")
                    {
                        Strvalue = En.Value.ToString();
                    }
                    else
                    {
                        Strvalue = "-";
                    }
                    Strbuilder.Append("<tr><td " + Style2 + ">" + En.Key + "</td><td " + Style2 + ">" + Strvalue + "</td> </tr>");
                }
                Strbuilder.Append("</table>");
                Strbuilder.Append("<form><div " + Style1 + "> Regards,<Br> Billing Team </Div></form>");

                objMsg.Body = dt.Rows[0]["EmailBody"].ToString();
                Attachment attach = new Attachment(dt.Rows[0]["EmailAttachments"].ToString());
                objMsg.Attachments.Add(attach);
                objMsg.IsBodyHtml = true;
                objMsg.Priority = MailPriority.High;
                objMsg.BodyEncoding = System.Text.Encoding.UTF8;
               
               
               
                SmtpMail.Send(objMsg);

            }
            catch (SmtpException E)
            {
                AeSharedLibrary.clsMessage.Show("Error :" + E.Message.ToString() + " : " + E.InnerException.Message.ToString());
            }
            finally
            {

            }

        }
    }

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

Exporting GridView data to Excel file in asp.net applications

12 Thursday Aug 2010

Posted by Pawan Kumar Khowal in ASP.NET

≈ Leave a comment


Below class will help us in exporting the gridView data to the excel file.

  public class clsExportToExcel
    {

        public static void ExportDataSetToExcel(DataTable dTable, string filename)
        {
            HttpResponse response = HttpContext.Current.Response;
            response.Clear();
            response.Charset = "";
            response.ContentType = "application/vnd.ms-excel";
            response.AddHeader("Content-Disposition", "attachment;filename=\"" + filename + "\"");
            response.Cache.SetCacheability(HttpCacheability.NoCache);
            using (StringWriter sw = new StringWriter())
            {
                using (HtmlTextWriter htw = new HtmlTextWriter(sw))
                {
                    DataGrid dg = new DataGrid();
                    dg.DataSource = dTable;
                    dg.DataBind();
                    dg.RenderControl(htw);
                    response.Write(sw.ToString());
                    response.End();
                }
            }
        }
    }

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

Error logging in asp.net application using a text file.

12 Thursday Aug 2010

Posted by Pawan Kumar Khowal in ASP.NET

≈ Leave a comment


Error logging in asp.net application using text file.Following class can help us in doing the same.

public class clsErrLogging
    {
        #region Function
        /// <summary>
        /// This function is used to open the file and write the error messages in that same file.
        /// </summary>
        /// <param name="msg"></param>
        public void LoggingErrors(string strMsg)
        {
            try
            {            
                string strPath = System.Configuration.ConfigurationManager.AppSettings["LogFilePath"];
                StreamWriter StrWriter = new StreamWriter(strPath, true);
                StrWriter.AutoFlush = true;
                StrWriter.WriteLine("———————" + DateTime.Now + "————————");
                StrWriter.WriteLine(DateTime.Now + " :: " + strMsg);
                StrWriter.WriteLine("———————" + DateTime.Now + "————————");
                StrWriter.Close();
              
              
            }
            catch (Exception ex)
            {
                string strErr = ex.Message;
            }          
        }
        #endregion Function
    }

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

Message Box Creation in ASP.net

12 Thursday Aug 2010

Posted by Pawan Kumar Khowal in ASP.NET

≈ Leave a comment


Below Class can be used to display messages to the end user.(In Web applications).

public class clsMessage
    {
        protected static Hashtable handlerPages = new Hashtable();
        private clsMessage()
        {
        }

        public static void Show(string Message)
        {
            if (!(handlerPages.Contains(HttpContext.Current.Handler)))
            {
                Page currentPage = (Page)HttpContext.Current.Handler;
                if (!((currentPage == null)))
                {
                    Queue messageQueue = new Queue();
                    messageQueue.Enqueue(Message);
                    handlerPages.Add(HttpContext.Current.Handler, messageQueue);
                    currentPage.Unload += new EventHandler(CurrentPageUnload);
                }
            }
            else
            {
                Queue queue = ((Queue)(handlerPages[HttpContext.Current.Handler]));
                queue.Enqueue(Message);
            }
        }

        private static void CurrentPageUnload(object sender, EventArgs e)
        {

            Queue queue = ((Queue)(handlerPages[HttpContext.Current.Handler]));
            if (queue != null)
            {
                StringBuilder builder = new StringBuilder();
                int iMsgCount = queue.Count;
                builder.Append("<script language=’javascript’>");
                string sMsg;
                while ((iMsgCount > 0))
                {

                    iMsgCount = iMsgCount – 1;
                    sMsg = System.Convert.ToString(queue.Dequeue());
                    sMsg = sMsg.Replace("\"", "’");
                    builder.Append("alert( \"" + sMsg + "\" );");
                }
                builder.Append("</script>");
                handlerPages.Remove(HttpContext.Current.Handler);
                HttpContext.Current.Response.Write(builder.ToString());
            }
        }
    }

Pawan Kumar
Pawankkmr@hotmail.com

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

Breadcrumbs implementation in ASP.NET

05 Thursday Aug 2010

Posted by Pawan Kumar Khowal in ASP.NET

≈ Leave a comment


Following is the code to implement the breadcrumbs in asp.net

/* Add Web.sitemap.  To add this file, right click on Project Folder, select option "Add New Item".
Select Site Map and add file.  Your file should contain nodes like below :

<siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0&quot; >
<siteMapNode url="~/default.aspx" title="Home"  description="Home">
<siteMapNode url="~/OrderDetails/OrderList.aspx" title="OrderList" description="" />
<siteMapNode url="" title="Search" description="" >
<siteMapNode url="~/GallerySearch/NewGallarySearch.aspx" title="Gallary Search"  description=""/>
<siteMapNode url="~/Search/Search.aspx" title="Advance Search"  description=""/>
</siteMapNode>
<siteMapNode url="" title="Administration"  description="">
<siteMapNode url="~/Partner/PartnerList.aspx" title="Partner List"  description="" >
<siteMapNode url="~/Partner/PartnerSummary.aspx" title="Partner Summary"  description="">
<siteMapNode url="~/Partner/EditPartner.aspx" title="Partner Edit"  description="" />
<siteMapNode url="~/Partner/PartnerProduct.aspx" title="Partner Product" description="" />
</siteMapNode>
</siteMapNode>
</siteMapNode>
<siteMapNode url="~/User/ViewaccountInfo.aspx" title="My Profile" description="" />
<siteMapNode url="" title="Help"  description="" />
</siteMapNode>
</siteMap>

/* To implement Breadcrumb upto first level of Querystring, add following code in your Global.aspx */

<%@ Application Language="C#" %>
<%@ Import Namespace="System.Diagnostics" %>

<script runat="server">
void Application_Start(object sender, EventArgs e)
{
// Code that runs on application startup
SiteMap.SiteMapResolve += new SiteMapResolveEventHandler(AppendQueryString);
}

void Application_End(object sender, EventArgs e)
{
//  Code that runs on application shutdown
}

void Application_Error(object sender, EventArgs e)
{
//Exception objErr = Server.GetLastError().GetBaseException();
//string err = "Error in: " + Request.Url.ToString() +
//                  ". Error Message:" + objErr.Message.ToString();
//if (Session["SessionInformation"] == null)
//{
//    Server.Transfer("../Logout.aspx");
//}
}

void Session_Start(object sender, EventArgs e)
{
// Code that runs when a new session is started
//HttpContext context = HttpContext.Current;
//HttpCookieCollection cookies = context.Request.Cookies;
}

void Session_End(object sender, EventArgs e)
{
// Code that runs when a session ends.
// Note: The Session_End event is raised only when the sessionstate mode
// is set to InProc in the Web.config file. If session mode is set to StateServer
// or SQLServer, the event is not raised.
Application_Error(sender, e);
}

//Function to add breadcrumb with Querystring.
SiteMapNode AppendQueryString(object o, SiteMapResolveEventArgs e)
{
if (SiteMap.CurrentNode != null)
{
SiteMapNode temp;
temp = SiteMap.CurrentNode.Clone(true);
Uri u = new Uri(e.Context.Request.Url.ToString());
temp.Url += u.Query;
if (temp.ParentNode != null)
{
temp.ParentNode.Url += u.Query;
}
return temp;
}
else
{
return null;
}
}

</script>

/* Add following tag in Master Page, where you want to implement site map.

<asp:SiteMapPath ID="SiteMapPath1" runat="server" Font-Names="Verdana" ParentLevelsDisplayed="8"
Font-Size="0.8em" PathSeparator=" ->">
<PathSeparatorStyle Font-Bold="True" ForeColor="#507CD1" />
<CurrentNodeStyle ForeColor="#333333" />
<NodeStyle Font-Bold="True" ForeColor="#284E98" />
<RootNodeStyle Font-Bold="True" ForeColor="#507CD1" />
</asp:SiteMapPath>

Gauri Deshpande / Pawan Kumar

Pawankkmr@hotmail.com

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

Blog Stats

  • 1,074,800 hits

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,131 other subscribers

Pawan Khowal

502 SQL Puzzles with answers

Achievement - 500 PuzzlesJuly 18, 2018
The big day is here. Finally presented 500+ puzzles for SQL community.

200 SQL Server Puzzle with Answers

The Big DayAugust 19, 2016
The big day is here. Completed 200 SQL Puzzles today

Archives

February 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728  
« Oct    

Top Articles

  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…

Archives

  • October 2020 (29)
  • September 2018 (2)
  • August 2018 (6)
  • July 2018 (25)
  • June 2018 (22)
  • May 2018 (24)
  • April 2018 (33)
  • March 2018 (35)
  • February 2018 (53)
  • January 2018 (48)
  • December 2017 (32)
  • November 2017 (2)
  • October 2017 (20)
  • August 2017 (8)
  • June 2017 (2)
  • March 2017 (1)
  • February 2017 (18)
  • January 2017 (2)
  • December 2016 (5)
  • November 2016 (23)
  • October 2016 (2)
  • September 2016 (14)
  • August 2016 (6)
  • July 2016 (22)
  • June 2016 (27)
  • May 2016 (15)
  • April 2016 (7)
  • March 2016 (5)
  • February 2016 (7)
  • December 2015 (4)
  • October 2015 (23)
  • September 2015 (31)
  • August 2015 (14)
  • July 2015 (16)
  • June 2015 (29)
  • May 2015 (25)
  • April 2015 (44)
  • March 2015 (47)
  • November 2012 (1)
  • July 2012 (8)
  • September 2010 (26)
  • August 2010 (125)
  • July 2010 (2)

Article Categories

  • Analysis Services (6)
    • DAX (6)
  • Data (2)
    • Data warehousing (2)
  • Integration Services (2)
  • Magazines (3)
  • Python (29)
  • Reporting Services (4)
  • SQL SERVER (820)
    • Download SQL Interview Q's (212)
    • SQL Concepts (323)
    • SQL Performance Tuning (155)
    • SQL Puzzles (331)
    • SQL SERVER 2017 Linux (6)
    • SQL Server Interview Questions (308)
    • SQL SERVER Puzzles (332)
    • T SQL Puzzles (547)
    • Tricky SQL Queries (439)
  • UI (30)
    • ASP.NET (5)
    • C# (13)
    • CSS (9)
    • OOPS (3)
  • Uncategorized (5)

Recent Posts

  • Python | The Print and Divide Puzzle October 30, 2020
  • Python | Count consecutive 1’s from a list of 0’s and 1’s October 30, 2020
  • Python | How to convert a number into a list of its digits October 26, 2020
  • Python | Validate an IP Address-IPV6(Internet Protocol version 6) October 26, 2020
  • Python | Print the first non-recurring element in a list October 26, 2020
  • Python | Print the most recurring element in a list October 26, 2020
  • Python | Find the cumulative sum of elements in a list October 26, 2020
  • Python | Check a character is present in a string or not October 26, 2020
  • Python | Check whether a string is palindrome or not October 26, 2020
  • Python | Find the missing number in the array of Ints October 26, 2020
  • Python | How would you delete duplicates in a list October 26, 2020
  • Python | Check whether an array is Monotonic or not October 26, 2020
  • Python | Check whether a number is prime or not October 26, 2020
  • Python | Print list of prime numbers up to a number October 26, 2020
  • Python | Print elements from odd positions in a list October 26, 2020
  • Python | Print positions of a string present in another string October 26, 2020
  • Python | How to sort an array in ascending order October 26, 2020
  • Python | How to reverse an array October 26, 2020
  • Python | Find un-common words from two strings October 26, 2020
  • Python | How to convert a string to a list October 26, 2020
  • Python | Find unique words from a string October 26, 2020
  • Python | Calculate average word length from a string October 26, 2020
  • Python | Find common words from two strings October 26, 2020
  • Python | Find the number of times a substring present in a string October 26, 2020
  • Python | Find maximum value from a list October 26, 2020
  • Python | How to find GCF of two numbers October 26, 2020
  • Python | How to find LCM of two numbers October 26, 2020
  • Python | How to convert a list to a string October 26, 2020
  • Python | Replace NONE by its previous NON None value October 26, 2020
  • Microsoft SQL Server 2019 | Features added to SQL Server on Linux September 26, 2018

Create a website or blog at WordPress.com

  • Follow Following
    • Improving my SQL BI Skills
    • Join 231 other followers
    • Already have a WordPress.com account? Log in now.
    • Improving my SQL BI Skills
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar