Thursday, February 19, 2015

Encrypt and Decrypt the connection String in Web.Config file in asp.net

Thursday, February 12, 2015

Get Facebook logged in User details like Username, Email, Birthday, Profile picture, DOB and Gender

Introduction: In this article today I am going to explain how to get the Facebook logged in User details like Username, DOB and Gender etc.
Facebook
Click to Enlarge

Description:

HTML Markup of Web Page:
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
     <div id="fb-root"></div>

Sunday, February 8, 2015

Create dynamic menu in asp.net

Introduction: In this article I am going to explain how to create a dynamic menu in asp.net
Description:

Create a table (“Main_menu”).
Id
int
Menu_Name
varchar(50)
Menu_Url
varchar(100)
Menu_Order
int

Store Procedure:
To Insert data:
Create PROCEDURE Insert_Menu
(
@menuname varchar(50),
@menuurl varchar(100),
@menuorder int
)

Friday, February 6, 2015

Getting the ID of last inserted record in asp.net using output parameter

Introduction: In this article today I am going to explain the how we can get the ID of last inserted record using SQl Server database in asp.net using output parameter
Description:

In this example i getting the ID of last record with SCOPE_IDENTITY() using output parameter. In below given store procedure I am using output parameter @id.
Store procedure:

Monday, February 2, 2015

Getting the ID of last inserted record using SQL Server database in asp.net

Introduction: In this article today I am going to explain the how we can get the ID of last inserted record using SQL Server database in asp.net

Description:

In this example we getting the ID of last record with SCOPE_IDENTITY()without using output parameter.

Store procedure:
CREATE PROCEDURE Insert_Album
(
@albumname varchar(50),
@albumdescription varchar(100)
)
AS
BEGIN     
      SET NOCOUNT ON;
Insert into dbo.ALBUM values(@albumname,@albumdescription)
select SCOPE_IDENTITY()   
END
GO