String has first charcter only upper case another lower case in sql Server

select  CONCAT(UPPER(LEFT(c.Name,1)),LOWER(RIGHT(c.Name,Len(c.Name)-1))) from c

Read More

remove unwanted characters from the string

 using System; using System.Linq; using System.Collections.Generic; using System.Text.RegularExpressions; public class Program { public st...

Read More

set up mali body countent in c# .net

  mail.Body = "Your Incomplete Grade Application has been Result[] <br /> Here is another line of text!" ;

Read More

email body content with hatml tags

  string html = "<p>hey</p><p></p><p>hey 2</p><p>hey 3</p>" ; AlternateV...

Read More

ClosedXML worksheet styles and create excel

     using (var workbook = new XLWorkbook())    {  var worksheet2 = workbook.Worksheets.Add("Sheet -2");    worksheet2.Row(1).Heig...

Read More

Worsheet Cell style using closedXML

  ws . Cell ( "A1" ). Style . Font . SetFontSize ( 20 ) . Font . SetFontName ( "Arial" );

Read More