.NET Snippets

How to capitalize the first letter in sql ?

2014-04-02T20:24:00.001-07:00

Recently I got the requirement of capitalizing the first letter of a string in a drop down list which holds some product related information.

The drop down list looks like the below screen:

From the above screen, I also got the requirement of replacing the letter ';' with the letter ':'. This string is coming from a SQL table and I got some business reasons for why I can't change this value during the insertion into the Database. As I couldn't control it during the insertion neither by writing a query for one time update, I had to follow a different approach. Then I only left with a choice of modifying the value during the selection. Then I wrote the below SQL function and used it in the SELECT statement.

Writing a SQL function:

CREATE FUNCTION [dbo].[CapitalizeFirstLetter] 
(
        -- Add the parameters for the function here
 @InputStr VARCHAR(200)
)
RETURNS VARCHAR(200)
AS
BEGIN
 --Declare a variable
 DECLARE @Index INT,
  @ResultStr VARCHAR(200)
 --Intialize the variables
 SET @Index = 1
 SET @ResultStr = ''
 
 --Loop through the string for each letter
 WHILE (@Index < LEN(@InputStr) + 1)
 BEGIN
  IF (@Index = 1) --First letter of the string
  BEGIN
   --Make the first letter capital
   SET @ResultStr = @ResultStr + upper(substring(@InputStr, @Index, 1))
   SET @Index = @Index + 1--increase the index
  END
  -- If the previous character is space or ';'
  ELSE IF ((SUBSTRING(@InputStr, @Index-1, 1) = ' ' OR SUBSTRING(@InputStr, @Index-1, 1) = ';') AND @Index+1 <> LEN(@InputStr))
  BEGIN
   --make the letter capital
   SET @ResultStr = @ResultStr + UPPER(SUBSTRING(@InputStr,@Index, 1))
   SET @Index = @Index + 1--increase the index
  END
  -- If the current character is ';'
  ELSE IF ((SUBSTRING(@InputStr, @Index, 1) = ';') AND @Index+1 <> LEN(@InputStr))
  BEGIN
   --replace the character ';' with character ':'
   SET @ResultStr = @ResultStr + replace(SUBSTRING(@InputStr,@Index, 1),';', ':')
   SET @Index = @Index + 1--increase the index
  END
  ELSE --all others
  BEGIN
   --make the letter capital
   SET @ResultStr = @ResultStr + LOWER(SUBSTRING(@InputStr,@Index, 1))
   SET @Index = @Index + 1--increase the index
  END
  
  IF (@@ERROR <> 0)-- If any error occurs, assign input string to the result string
  BEGIN
   SET @ResultStr = @InputStr
  END
 END
 RETURN @ResultStr
END
GO

Using the above function in a SELECT statement:

SELECT dbo.CapitalizeFirstLetter(Name) FROM tblProduct

Result:

CSS3 Features - Borders

2014-03-20T23:11:00.000-07:00

Please click the below link to view my article on the above topic:
CSS3 Features - Borders

How to detect IE (Internet Explorer) by using JavaScript ?

2014-03-19T15:06:00.000-07:00

In this blog, I will demonstrate how to detect the browser IE including latest version IE 11 by using JavaScript.

Why do we need to detect a specific browser?

As every browser is backed up by its own rendering engine to draw the HTML/CSS web page, you might find some things that do not work perfectly across all the browsers.

Ex: I have recently developed a MVC web application and my requirement was to show loading animation when the form submits.

After I deployed my website to the web server and upgraded my IE to IE 11, I realized that the loading animation is not working in IE 11 browser. It was perfectly working in the other browsers like Chrome and Firefox.

Solution

I had to do some other stuff to make it work on IE by detecting the browser. I thought I could detect the browser IE 11 just by checking a ‘navigator.appName == “Microsoft Internet Explorer”’ property in the JavaScript. But, later I found out IE11 preview has changed the value of navigator.appName. Before IE11, this value is: “Microsoft Internet Explorer”.

Now with IE11 preview, Microsoft changed this value to “Netscape”.

Not only the IE11, for other browsers like Chrome and Firefox also ‘navigator.appName’ property returning ‘Netscape’.

Try the below link in different browsers to find ‘navigator.appName’ value:

http://www.w3schools.com/jsref/prop_nav_appname.asp

To fix the above problem, I had to write a piece of code to detect the browser IE11 by using JavaScript. After a little bit of research on the internet I found this code.

$(document).ready(function () {

if (IsRequestFromIE())

alert(‘This is IE’);

else

alert(‘Some other browser’);

});

function IsRequestFromIE(){

var rv = -1;

var result = false;

if (navigator.appName == 'Microsoft Internet Explorer')

{

var ua = navigator.userAgent;

var re = new RegExp("MSIE ([0-9]{1,}[\.0-9]{0,})");

if (re.exec(ua) != null)

rv = parseFloat( RegExp.$1 );

}

else if (navigator.appName == 'Netscape')

{

var ua = navigator.userAgent;

var re = new RegExp("Trident/.*rv:([0-9]{1,}[\.0-9]{0,})");

if (re.exec(ua) != null)

rv = parseFloat( RegExp.$1 );

}

if(rv != -1)

result = true;

return result;

}

As I found the solution, I thought to blog it in my blogspot. So that it might help to someone who is struggling to resolve this issue.

How to create and install a windows service in C# ?

2014-03-11T20:32:00.001-07:00

Please click the below link to read my article about this topic:
Create and install a windows service in C#

Difference between DELETE and TRUNCATE command

2012-07-29T00:12:00.001-07:00

DELETE and TRUNCATE in SQL:

DELETE:

Delete is a DML(Data manipulation language) command.
DELETE statement only locks a row in table while performing DELETE operation.
We can use WHERE clause. So that it deletes specified data by filtering with WHERE clause.
DELETE activates a trigger. Because operation logs individually.
Slower than TRUNCATE. because it keeps logs.
Since DELETE keeps logs, Rollback is possible.

TRUNCATE:

TRUNCATE is a DDL(Data Definition Language) command.
TRUNCATE statement locks table and page, but not each row.
Cannot use WHERE clause.
No trigger activates. Since it doesn't log individually.
Faster than DELETE in performance wise. Because, it doesn't keeps logs.
Since it doesn't keeps logs, Rollback is not possible.

Binding Datatable to a Gridview in ASP.NET

2012-04-19T02:22:00.003-07:00

How to Bind Datatable to Gridview in ASP.NET

This article will explain you about binding a data table to gridview in ASP.NET.......

Lets us assume we have got a Default.aspx web form and a Gridview called gvProducts in that web form.

Here is a sample code in code behind:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindProducts();

}

private void BindProducts()

{

DataTable tblProducts = new DataTable();

tblProducts.Columns.Add("Id", System.Type.GetType("System.Int32"));

tblProducts.Columns.Add("Name", System.Type.GetType("System.String"));

tblProducts.Columns.Add("Price", System.Type.GetType("System.Decimal"));

tblProducts.Columns.Add("Published", System.Type.GetType("System.Boolean"));

DataRow dr = tblProducts.NewRow();

dr["Id"] = "100";

dr["Name"] = "Apple";

dr["Price"] = "12.36";

dr["Published"] = "true";

tblProducts.Rows.Add(dr);

DataRow dr = tblProducts.NewRow();

dr["Id"] = "101";

dr["Name"] = "Orange";

dr["Price"] = "10.00";

dr["Published"] = "false";

tblProducts.Rows.Add(dr);

DataRow dr = tblProducts.NewRow();

dr["Id"] = "102";

dr["Name"] = "Banana";

dr["Price"] = "15.34";

dr["Published"] = "true";

tblProducts.Rows.Add(dr);

gvProducts.DataSource = tblProducts;

gvProducts.DataBind();

}

ICC World Cup 2011 & 1983 Calendars

2011-04-03T18:12:00.000-07:00

It is true...If you cross verify the 1983 calendar and 2011 calendar...same to same..

1983: When Kapil Dev lifted the world cup up.....

2011: When Dhoni lifted the world cup up.....

How to get a free domain name

2010-11-27T21:53:00.000-08:00

1. Microsoft, of all people, will give you a website and domain name absolutely free. Though aimed at small businesses, anyone can register and set up a website.

Read more: How to get a Free Website and Domain Name | eHow.com http://www.ehow.com/how_2254591_website-domain-name.html#ixzz16dVPQsFt

2. Head to office.live.com and click on the button that says: "Office Live Small Business -- Sign Up for Free."

3. Fill in the simple registration information...it's basically name, city/state/zip, and email.

You'll be asked some business questions like "Number of employees". Just answer as best you can, even if the answer is zero, or one (yourself!).

4. Use the simple form that pops up to register a domain name, and build a website. You can have the whole thing in operation in 15 minutes.

Removing HTML tags from a string in C#

2010-10-08T17:00:00.000-07:00

This following code can be useful to remove html tags from a string using C# language...

Code:

private string StripHTML(string strContent)
{
//strContent = Regex.Replace(strContent, @"[^\u0000-\u007F-\u0x0B]", "");
string asAscii = Encoding.ASCII.GetString(
Encoding.Convert(
Encoding.UTF8,
Encoding.GetEncoding(
Encoding.ASCII.EncodingName,
new EncoderReplacementFallback(string.Empty),
new DecoderExceptionFallback()
),
Encoding.UTF8.GetBytes(strContent)
)
);
return Regex.Replace(asAscii, "<.*?>", string.Empty);
}

How to send an email

2010-09-28T14:16:00.000-07:00

How to send mail from Gmail without login your Gmail account

In this article I am going to discuss how to send mail from Gmail using Asp.net 3.5 without login your Gmail account.

Write the small line of code as follows:

Sample:

html body> form id="form1" runat="server"> fieldset style="width: 500px; padding: 10px;"> <legend>Sending email from GMaillegend> <div align="left" style="padding: 5px;"> Your Gmail EmailID <asp:TextBox ID="TextBoxSenderEmailId" runat="server"Width="250px">asp:TextBox>Please enter your GMailId (e.g yourId@gmail.com)font> Friend's EmailId <asp:TextBox ID="TextBoxReceiverEmailId" runat="server"Width="250px">asp:TextBox>Please enter your friend's emailId (e.g abc@xyz.com)font> Subject <asp:TextBox ID="TextBoxSubject" runat="server"Width="350px">asp:TextBox> Body <asp:TextBox ID="TextBoxBody" Width="350px" TextMode="MultiLine" Rows="5"runat="server">asp:TextBox> <asp:Button ID="btnSendEmail" runat="server" OnClick="btnSendEmail_Click"Text="Send" />

</div> </fieldset> </form> </body> </html>

using System;

using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class SendingMailByGMail : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { }
protected void btnSendEmail_Click(object sender, EventArgs e) { System.Net.Mail.MailMessage MyMailMessage = new System.Net.Mail.MailMessage(TextBoxSenderEmailId.Text, TextBoxReceiverEmailId.Text, TextBoxSubject.Text, ""); MyMailMessage.IsBodyHtml = false; MyMailMessage.Body = TextBoxBody.Text; //provide Authentication Details need to be passed when sending email from gmail System.Net.NetworkCredential mailAuthentication = new System.Net.NetworkCredential(TextBoxSenderEmailId.Text,"password");//Sender password

//Smtp Mail server of Gmail is "smpt.gmail.com" and it uses port no. 587 System.Net.Mail.SmtpClient mailClient = new System.Net.Mail.SmtpClient("smtp.gmail.com", 587);

//Enable SSL

mailClient.EnableSsl = true;
mailClient.UseDefaultCredentials = false;
mailClient.Credentials = mailAuthentication;
mailClient.Send(MyMailMessage);
}
}