Dot Net Interview Question

C# program Selection Sorting

noreply@blogger.com (Munesh Sharma) — Tue, 02 Oct 2018 08:15:00 +0000

Selection sort is a straightforward sorting algorithm. This algorithm search for the smallest number in the elements array and then swap it with the element at the first position, then it searches for the second smallest number and swaps it with the element in the second position, and it will continue doing this until the point when the whole array is arranged. It is called selection sort since it more than once chooses the following littlest component and swaps it into the ideal place.

Selection sorting algorithm is not appropriate for a large number of datasets as its average and worst case complexities are Ο(n²), where n is the number of items.

How Selection Sort Works?

Following are the steps associated with selection sort (for arranging a given element array in ascending order)

1. Beginning from the primary element, we look through the smallest component in the element array and supplant it with the component in the first position.

2. We at that point proceed onward to the second position, and search for littlest component present in the subarray, beginning from record 1, till the last list.

3. We supplant the component at the 2nd position in the original array.

4. It will continue doing this until the point when the whole array is arranged.

C# Program for selection Sort

using System;

class Program

{

static void Main(string[] args)

{

int ArrayLength = 10;

int[] array = new int[10] { 125, 50, 10, -6, 20, 60, 80,-10, 90, 45 };

Console.WriteLine("The Array elements Before the Selection Sort is: ");

for (int i = 0; i < ArrayLength; i++)

{

Console.WriteLine(array[i]);

}

int tmpIndex, min_key_index;

for (int j = 0; j < ArrayLength - 1; j++)

{

min_key_index = j;

for (int k = j + 1; k < ArrayLength; k++)

{

if (array[k] < array[min_key_index])

{

min_key_index = k;

}

tmpIndex = array[min_key_index];

array[min_key_index] = array[j];

array[j] = tmpIndex;

}

Console.WriteLine("The Array elements After the Selection Sort is: ");

for (int i = 0; i < 10; i++)

{

Console.WriteLine(array[i]);

}

Console.ReadLine();

}

Complexity Analysis of Selection Sort

Selection Sort use two nested for loops to complete sorting

So for n size of the array, the following will be the complexity for the selection sort algorithm:

Best Case Time Complexity [Big-omega]: O(n²)

Worst Case Time Complexity [ Big-O ]: O(n²)

Space Complexity: O(1)

Average Time Complexity [Big-theta]: O(n²)

Paging in html table using javascript

noreply@blogger.com (Munesh Sharma) — Fri, 05 Aug 2016 10:25:00 +0000

I demonstrated how to use HTML tables on the client for a very simple client-side paging solution. I have heard from several people who point out the performance problems with large sets of data. I agree. This solution is best for a fairly fixed amount of data.

Step#1:
Include the following css in your page header;

Step#2

Copy & paste the following script in your page header;

Stet#3

Define an ID on the table you want to paging that is "tablepaging" ; place an empty div in the place you want to display the navigation bar. that is "pageNavPosition"; include an initialization script at the bottom of your page.

<thead>

<tr>
<th>Name </th>
<th>Collage </th>
<th>Gender </th>
<th>percentage </th>
</tr>
<tbody>
<tr class="even">
<td>Munesh </td>
<td>ABC </td>
<td>M </td>
<td>80 </td>
</tr>
<tr class="odd">

<td>Rahul </td>
<td>PQR </td>
<td>M </td>
<td>80 </td>

</tr>
<tr class="odd">

<td>Govind </td>
<td>XYZ </td>
<td>M </td>
<td>40 </td>

</tr>
<tr class="odd">

<td>Anshuman </td>
<td>CollageName1 </td>
<td>M </td>
<td>80 </td>

</tr>
<tr class="odd">

<td>Student1 </td>
<td>CollageName2 </td>
<td>M </td>
<td>50 </td>

</tr>
<tr class="odd">

<td>Student2 </td>
<td>CollageName3 </td>
<td>F </td>
<td>60 </td>

</tr>
<tr class="odd">

<td>Student3 </td>
<td>CollageName4 </td>
<td>F </td>
<td>70 </td>

</tr>
<tr class="odd">

<td>Student4 </td>
<td>CollageName5 </td>
<td>M </td>
<td>80 </td>

</tr>

</tbody>

</table>

</div>

var pager = new Pager('tablepaging', 5);

pager.init();pager.showPageNav('pager', 'pageNavPosition');

pager.showPage(1);

</script>

Output

Name	Collage	Gender	percentage
Munesh	ABC	M	80
Rahul	PQR	M	50
Govind	XYZ	M	70
Anshuman	AAA	M	60

« Prev 1 2 3 4 5 6 7 Next »

Context Menu On Right click on Gridview in Asp.net

noreply@blogger.com (Munesh Sharma) — Wed, 13 Jul 2016 09:22:00 +0000

Here we will learn how to add Context menu on right click on grid view in Asp.net.

For this we need to use

1. Context menu Jquery File. You add jquery file into your project

2. In this page there are Jquery file and css file which we have to use it in this project

Write the following code in the .aspx page

.ASPX Code

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ContextMenu.aspx.cs" Inherits="ContextMenu.ContextMenu" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Grid View Context Menu</title>

<!--[if lt IE 7]>

<![endif]-->

.StudentRow

{

}

.gvhide

{

display: none;

}

</style>

var StudentID = null;

var CollageName = null;

var StudentName = null;

$(document).ready(function () {

$(".StudentRow").contextMenu({ menu: 'myMenu' }, function (action, el, pos) { contextMenuWork(action, el, pos); });

$(".openmenu").contextMenu({ menu: 'myMenu', leftButton: true }, function (action, el, pos) { contextMenuWork(action, el.parent("tr"), pos); });

});

function contextMenuWork(action, el, pos) {

var rowindex = (el[0].rowIndex * 1 - 1);

StudentID = $("#Gridview1_lbl_StudentID_" + rowindex).html();

CollageName = $("#Gridview1_lbl_CollageName_" + rowindex).html();

StudentName = $("#Gridview1_lbl_StudentName_" + rowindex).html();

switch (action) {

case "delete":

{

//you can call code behind function from following method, For this you need to set Script manager property as "EnablePageMethods = "true"

// var success = PageMethods.CallServerFunction(rowindex);

alert("Delete Student Record");

break;

}

case "insert":

{

alert("Insert new student record");

break;

}

case "edit":

{

alert("Edit Student Record");

break;

}

function pageLoad() {

$(".StudentRow").contextMenu({ menu: 'myMenu' }, function (action, el, pos) { contextMenuWork(action, el, pos); });

$(".openmenu").contextMenu({ menu: 'myMenu', leftButton: true }, function (action, el, pos) { contextMenuWork(action, el.parent("tr"), pos); });

}

</script>

</head>

<body>

<asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods = "true">

</asp:ScriptManager>

<asp:UpdatePanel ID="UpdatePanel1" runat="server">

<asp:GridView ID="Gridview1" runat="server" AutoGenerateColumns="false" OnRowDataBound="Gridview1_RowDataBound"

AllowPaging="true" OnPageIndexChanging="Gridview1_PageIndexChanging" PageSize="5">

<asp:TemplateField HeaderText="StudentID">

<asp:Label ID="lbl_StudentID" runat="server" Text='<%# Eval("Studentid") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="CollageName">

<asp:Label ID="lbl_CollageName" runat="server" Text='<%# Eval("CollageName") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="StudentName">

<asp:Label ID="lbl_StudentName" runat="server" Text='<%# Eval("StudentName") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

<br />

</ContentTemplate>

</asp:UpdatePanel>

<li class="insert"><a href="#insert">Add New Record </a></li>

<li class="edit"><a href="#edit">Edit Record</a></li>

<li class="delete"><a href="#delete" >Delete record</a></li>

</ul>

</form>

</body>

</html>

Code behind Page (.CS page)

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Web.Services;

using System.Web.Script.Services;

namespace ContextMenu

{

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

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindGridView();

}

private void BindGridView()

{

DataTable dt = new DataTable();

dt = GetDatasource();

Gridview1.DataSource = dt;

Gridview1.DataBind();

}

private DataTable GetDatasource()

{

DataTable dt = new DataTable();

dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Studentid", typeof(int)),

new DataColumn("CollageName", typeof(string)),

new DataColumn("StudentName",typeof(string)) });

dt.Rows.Add(1, "VIT", "Munesh");

dt.Rows.Add(2, "IIT", "Rahul");

dt.Rows.Add(3, "XYZ", "ABC");

dt.Rows.Add(4, "PQR", "Anshuman");

return dt;

}

protected void Gridview1_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.DataRow)

{

DataTable dt = new DataTable();

dt = (DataTable)Gridview1.DataSource;

int rowindex = e.Row.RowIndex;

e.Row.Attributes.Add("class", "StudentRow");

}

protected void Gridview1_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

Gridview1.PageIndex = e.NewPageIndex;

BindGridView();

}

[WebMethod]

public static bool CallServerFunction(int a)

{

return true;

//You can not call following function because it static method

//Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "Alert();", true);

}

Now run your application and right click on your gridview ,then you perform operations

you can download this project from link Download

File Upload in Gridview ASP.NET

noreply@blogger.com (Munesh Sharma) — Sat, 02 Jul 2016 06:02:00 +0000

In this article we will learn how to use file upload control in grid view in each row for uploading images or files to the database.

Step1 - First create a database table with the name “FileUpload”. And run the following script to create table.

CREATE TABLE [dbo].[FileUpload](

[Studentid] [varchar](10) NULL,

[name] [varchar](100) NULL,

[photo] [varchar](100) NULL

) ON [PRIMARY]

Step2- Go to visual studio and add a webform (.aspx) to your website then write the following code in Designer side

Designer source code:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="GridFileUpload.aspx.cs" Inherits="ContextMenu.GridFileUpload" %>

<!DOCTYPE html>

</head>

<body>

<div>

<asp:GridView ID="grdFileUpload" runat="server" AutoGenerateColumns="false" ShowFooter="true" EmptyDataText="No records found">

<asp:TemplateField HeaderText="Student-ID">

<asp:Label ID="lblStudentID" runat="server" Text='<%#DataBinder.Eval(Container.DataItem, "Studentid") %>'></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtStudentID" runat="server"></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Name">

<asp:Label ID="lblName" runat="server" Text='<%#DataBinder.Eval(Container.DataItem, "name") %>'></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtName" runat="server"></asp:TextBox>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Photo">

<asp:Image ID="imgPhoto" runat="server" Width="100px" Height="120px" ImageUrl='<%#DataBinder.Eval(Container.DataItem, "photo") %>' />

</ItemTemplate>

<asp:FileUpload ID="fUpload" runat="server" />

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField>

<asp:Button ID="btnUpload" runat="server" Text="Upload" OnClick="btnUpload_OnClick" />

</FooterTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

<asp:Label ID="lblMsg" runat="server"></asp:Label>

</div>

</form>

</body>

</html>

C# Code (code behind ) :

using System;

using System.Collections.Generic;

using System.Data;

using System.Data.SqlClient;

using System.IO;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

namespace ContextMenu

{

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

{

SqlConnection conn = new SqlConnection("Data Source=MUNESH;Initial Catalog=GridData;Integrated Security=True");

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindGrid();

}

protected void BindGrid()

{

DataSet ds = new DataSet();

DataTable dtData = new DataTable();

conn.Open();

string cmdstr = "Select * from FileUpload";

SqlCommand cmd = new SqlCommand(cmdstr, conn);

SqlDataAdapter adp = new SqlDataAdapter(cmd);

adp.Fill(ds);

cmd.ExecuteNonQuery();

dtData = ds.Tables[0];

if (dtData.Rows.Count > 0)

{

grdFileUpload.DataSource = dtData;

grdFileUpload.DataBind();

}

else

{

dtData.Rows.Add(dtData.NewRow());

grdFileUpload.DataSource = dtData;

grdFileUpload.DataBind();

int TotalColumns = grdFileUpload.Rows[0].Cells.Count;

grdFileUpload.Rows[0].Cells.Clear();

grdFileUpload.Rows[0].Cells.Add(new TableCell());

grdFileUpload.Rows[0].Cells[0].ColumnSpan = TotalColumns;

grdFileUpload.Rows[0].Cells[0].Text = "No records Found";

}

ds.Dispose();

conn.Close();

}

protected void btnUpload_OnClick(object sender, EventArgs e)

{

TextBox txtStudentID = (TextBox)grdFileUpload.FooterRow.FindControl("txtStudentID");

TextBox txtName = (TextBox)grdFileUpload.FooterRow.FindControl("txtName");

FileUpload fuploadFile = (FileUpload)grdFileUpload.FooterRow.FindControl("fUpload");

Button btnUpload = (Button)grdFileUpload.FooterRow.FindControl("btnUpload");

if (fuploadFile.HasFile)

{

string fileName = fuploadFile.FileName;

string exten = Path.GetExtension(fileName);

//check that the file is of the permitted file type

exten = exten.ToLower();

string[] FileTypes = new string[4];

FileTypes[0] = ".jpg";

FileTypes[1] = ".jpeg";

FileTypes[2] = ".gif";

FileTypes[3] = ".png";

bool IsFileTypeCorrect = false;

for (int i = 0; i <= 3; i++)

{

if (exten == FileTypes[i])

{

IsFileTypeCorrect = true;

}

if (!IsFileTypeCorrect)

{

lblMsg.Text = "File Type is not in a correct formate";

}

else

{

//upload the file onto the server

fuploadFile.SaveAs(Server.MapPath("~/Images/" + fileName));

conn.Open();

string cmdstr = "insert into FileUpload(Studentid,name,photo) values(@Studentid,@name,@photo)";

SqlCommand cmd = new SqlCommand(cmdstr, conn);

cmd.Parameters.AddWithValue("@Studentid", txtStudentID.Text);

cmd.Parameters.AddWithValue("@name", txtName.Text);

cmd.Parameters.AddWithValue("@photo", "Images/" + fileName);

cmd.ExecuteNonQuery();

conn.Close();

BindGrid();

}

Output Will be like following

Twitter authentication for ASP.NET MVC Wb Application

noreply@blogger.com (Munesh Sharma) — Fri, 01 Jul 2016 10:18:00 +0000

Here we will how to use Twitter login for our asp.net mvc application . Now in these days all the commercial website use external login facility means user can login to their website using Twitter , google, twitter etc. Like Flipkart,amazon.

So here will learn how to give login using Twitter .

Go to visual studio and click on new project -> a window will open from here select a 'Asp.net MVC4 web application' and give the name for this project in my case I give it as “TwitterLoginMVCApplication”.

Now click ok and select a template as Internet Application and engine as Razor engine , after sleeting all these click ok. it will click a solution project this will contain .Css file ,script file and MVC application structure.

Step(2) : after creation of application let's create a database for this and give the name for this database i gave it as 'MVCApp' and then add a connection string to the database.

</connectionStrings>

if you are creating new connection string then existinf connection string in ewb config file we have remove with we have remove a following line of code from the "InitializeSimpleMembershipAttribute.cs" which available in filter folder. because it give double connection existing run time error.

// WebSecurity.InitializeDatabaseConnection("DefaultConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true);

After adding the connection string to the project now we need to create membership tables to the database but before this go to the models folder and have a look on AccountModels.cs class. this class automatically create when we select mvc application as Internet application

AccountModel.cs class contain following methods.

now for creating membership tables in database initialize the connection in globel.asax . here we will use code first approach for that we need to add following code in this class

For adding data table in database membership we need to add a line of code in Global.asax

WebSecurity.InitializeDatabaseConnection("DBConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true);

Here namespace for WebSecurity is “using WebMatrix.WebData;”

WebSecurity.InitializeDatabaseConnection

Definition for the InitializeDatabaseConnection is

public static void InitializeDatabaseConnection (string connectionStringName, string userTableName, string userIdColumn, string userNameColumn, bool autoCreateTables);

connectionStringName: It the name of database table where user information stored.

userTableName: It contain user profile information.

userIdColumn: this column name of table contain user ID this should be integer.

userNameColumn: column name of table contain user name. This column is basically used to match profile data of user with membership account data.

autoCreateTables: True to indicate that user profile and membership tables should be created if they do not exist; false to indicate that tables should not be created automatically. Although the membership tables can be created automatically, the database itself must already exist.

Now globel.asax page will look like

Now after all this configuration lets run your application and see the ur hoe page and click on register link which is your page right side.

After running your application you go to database and see the table, it will generate following tables for us

AuthConfig file in Asp.net MVC application

This AuthConfig file is exist under “App_start”s folder. It is automatically created by the asp.net mvc application when we create a project.

This AuthConfig.cs file contains the entire external client as comment by default. So we need to uncomment for auth config for Twitter then the code we like following

At this time if you will run your application it will give error that you can’t be put empty value for “appID,secreted”. For that we need to register in Twitter.

Register MVC application with Twitter

Before run mvc application we have to pass consumerKey and consumerSecret so for that we need to register in Twitter or login if you have account in Twitter ,after login go to the following URL and register there. There will be register button at right click side at top.

For creating your own twitter app on twitter then go to following Url

https://apps.twitter.com/

When you will redirect to this link you will see following screen

Here click on Create new app ,it will redirect to the create application form there you fill information like

1. First you give your app name ,in my case it is “TwitterAppForMvcApplication”.

2. Give the description as “twitter for mvc application”.

3. Now third thing is to pass URL of our application ,in my case url of my application is

http://localTwiiterAuthontcation.com

4. Next is CallBack url which is not a mandatory.

After filling all these information then click on accept agreement and click on “create twiiter app”.

It will redirect to following screen there you will see that your application app is created.

Now click on Keys and Access Tokens tab to get your [ consumerKey: "" and, consumerSecret: "" ]

Copy your “consumerSecret” and “consumerKey” and paste in your application in AutthConfig File , It is under App_start folder.

Now run your application and you will see following screen

Click on Twitter link ,it will redirect to the twitter authentication Login page there you give your twitter credential (if you already login then it will redirect to the authorize page) now click on the Authorize app button

and then you it will redirect to ExternalLoginCallback page there you will see a textbox with the username which is taken from your twitter account, Now click on register button after that you can login your application using the twitter

Now check the database table (UserProfile) for checking that current twitter account user is added

now check that authentication membership in database table ("webpages_OAuthMembership") for new account

all the data added successfully to the database, this is the way to authenticate your mvc website with twitter account.

Facebook authentication for ASP.NET MVC Wb Application

noreply@blogger.com (Munesh Sharma) — Sat, 14 May 2016 05:19:00 +0000

Here we will how to use facebook login for our asp.net mvc application . Now in these days all the commercial website use external login facility means user can login to their website using facebook , , google, twitter etc. Like Flipkart,amazon.

So here will learn how to give login using facebook.

Go to visual studio and click on new project -> a window will open from here select a 'Asp.net MVC4 web application' and give the name for this project in my case I give it as “FacebookLoginMVCApplication”.

Step(2) : after creation of application let's create a database for this and give the name for this database i gave it as 'MVCApp' and then add a connection string to the database.

</connectionStrings>

// WebSecurity.InitializeDatabaseConnection("DefaultConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true);

AccountModel.cs class contain following methods.

now for creating membership tables in database initialize the connection in globel.asax . here we will use code first approach for that we need to add following code in this class

For adding data table in database membership we need to add a line of code in Global.asax

WebSecurity.InitializeDatabaseConnection("DBConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true);

Here namespace for WebSecurity is “using WebMatrix.WebData;”

WebSecurity.InitializeDatabaseConnection

Definition for the InitializeDatabaseConnection is

public static void InitializeDatabaseConnection (string connectionStringName, string userTableName, string userIdColumn, string userNameColumn, bool autoCreateTables);

connectionStringName: It the name of database table where user information stored.

userTableName: It contain user profile information.

userIdColumn: this column name of table contain user ID this should be integer.

userNameColumn: column name of table contain user name. This column is basically used to match profile data of user with membership account data.

Now globel.asax page will look like

Now after all this configuration lets run your application and see the ur hoe page and click on register link which is your page right side.

After running your application you go to database and see the table, it will generate following tables for us

AuthConfig file in Asp.net MVC application

This AuthConfig file is exist under “App_start”s folder. It is automatically created by the asp.net mvc application when we create a project.

This AuthConfig.cs file contains the entire external client as comment by default. So we need to uncomment for auth config for faceBook then the code we like following

At this time if you will run your application it will give error that you can’t be put empty value for “appID,secreted”. For that we need to register in facebook.

Register MVC application with facebook

Before run mvc application we have to pass appID and secret id so for that we need to register in facebook or login if u have account in face,after login go to the following URL and register there. There will be register button at right click side at top.

"http://developers.facebook.com/"

After register you need to create Appid for your website ,it will redirect to that page after register or you can go to following URL and fill the information which it is asking like following snapshot.

https://developers.facebook.com/apps/

From here click on create new App id it will open a window like following

There I gave display name as "dotnetmunesh" and Email and category i select as “Education and after that click on create App ID.

After click on this ,your account will be created and it will redirect to following page where it will ask security answer for selecting image

After selecting click ok then a window will open

Here you can see your app id and Appsecret on Dashboard section. Now go to setting and on basic section enter field , and app domain as empty after that click on add platform and select website.

When you will click on add flat form following window will open

From here you have to select Website.

After selecting add platform a small panel will popup asking Site URL here you will be adding your project URL like http://localhost:63695/.To see where project URL is just right click on Project then select Properties like as shown below.

After selecting Properties a new window will open inside that select Web Menu just below Build at bottom of page you will see Project URL which we highlighted in yellow here project URL like http://localhost:63695/.Just copy that URL.

After copying just paste that URL inside Site URL (http://localhost:63695/)and then click on save changes button.

After that just copy App ID and App Secret and just add in AuthConfig.cs files.

After adding just save your application then Run application. Following is our login page after adding oAuth facebook login in asp.net mvc applicaition.

Here you will see a Facebook button on right part of login page. Now just click on this Facebook button then it will redirect you to Facebook login page ,here you enter Facebook credentials and then login in to Facebook.

After login in to Facebook now new dialog will pop up for allowing App to take your all profile information which you provide in facebook (like name, profile picture, age range, gender etc). Now just click on Okay button to proceed further.

After clicking on okay button it will redirect to "ExternalLoginCallback" view and on that page we will see Username textbox which contains Username (Munesh Sharma) which we have got from Facebook Oauth service.

now just click on Register button and you are login in to your web application.

The user name with facebook is successfully saved in UserProfile table and second table which is webpages_OAuthMembership table.

you can download this project from here Download

Cross-site Request Forgery in Asp.Net MVC

noreply@blogger.com (Munesh Sharma) — Fri, 13 May 2016 04:55:00 +0000

Here will learn what Cross- site Request forgery in Asp.net mvc ,and how to protect our asp.net mvc application from the CSRF.Cross- site Request forgery is abbreviated as “CSRF”.

What is CSRF

CSRF is a attack in which a user login to a website like ABC.Com and after login user open other site called malicious site in other tab, then this malicious site send request to (ABC.com) valid site using existing credential or existing session for attacking the site, Valid site( ABC.com) assume that this coming request is a valid request or coming from a valid user , So it execute that request and site is hacked by the CSRF.

After recognizing this attack ,Microsoft provide a Attribute called “AntiForgeryToken”. It is very simple to use in our site ,just we need to add “@Html.AntiForgeryToken” in view with that we need to add this in controller also as a attribute [ValidateAntiForgeryToken] to validating this. Basically AntiForgeryToken is used in HTTPPost method.

Now we learn this with a example using asp.net mvc

Go to visual studio and create a new project and select a Asp.net MVC4 web application and give the name for project ,in my case it is “CSRFInMVCApplication” after that click ok then a window will open from there select a template as “Besic” and view engine as “Rezor”.

After click ok it will create a project, After that right click on model folder and add a class name is “CollageInfo.cs” ,and write the following code to this class

public class CollageInfo

{

[Key]

public int CollageID { get; set; }

[Required(ErrorMessage = " please Enter Name")]

public string CollageName { get; set; }

[Required(ErrorMessage = "pleaes Enter Address")]

public string CollageAddress { get; set; }

[Required(ErrorMessage = "please Enter Department")]

public string CollageDepartment { get; set; }

}

After completion of model class we need to add a controller to this project so for that right click on the controller folder and a controller and give the name as “CollageController” with Empty MVC Controller template.

After adding controller we need to add action method name is “collageInfo” with [HttpGet] and [HttpPost]. So for that write the following code in controller collageInfo action method.

[HttpGet]

public ActionResult collageInfo()

{

return View();

}

[HttpPost]

public ActionResult collageInfo(CollageInfo _clgInfo)

{

return View(_clgInfo);

}

After adding the action method we need to add the view , for adding the view right click on the collageInfo action method and add the view like following

After click on add it will generate code for the view ,following is the code for the view

@model CSRFInMVCApplication.Models.CollageInfo

ViewBag.Title = "collageInfo";

}

<h2>collageInfo</h2>

@using (Html.BeginForm()) {

@Html.ValidationSummary(true)

<legend>CollageInfo</legend>

@Html.LabelFor(model => model.CollageName)

</div>

@Html.EditorFor(model => model.CollageName)

@Html.ValidationMessageFor(model => model.CollageName)

</div>

@Html.LabelFor(model => model.CollageAddress)

</div>

@Html.EditorFor(model => model.CollageAddress)

@Html.ValidationMessageFor(model => model.CollageAddress)

</div>

@Html.LabelFor(model => model.CollageDepartment)

</div>

@Html.EditorFor(model => model.CollageDepartment)

@Html.ValidationMessageFor(model => model.CollageDepartment)

</div>

<p>

</p>

</fieldset>

}

<div>

@Html.ActionLink("Back to List", "Index")

</div>

@section Scripts {

@Scripts.Render("~/bundles/jqueryval")

}

Now run your application, go to the following URL and see the output

http://localhost:50688/Collage/Collageinfo

Right click on this page and click on View Source ,you will see source code of this page and save this code as .HTML file

After saving this file as .HTML ,Now open this file(.HTML)

Code for HTML file is

<html>

<head>

<title>collageInfo</title>

</head>

<body>

<h2>collageInfo</h2>

<legend>CollageInfo</legend>

<label for="CollageName">CollageName</label>

</div>

</div>

<label for="CollageAddress">CollageAddress</label>

</div>

</div>

<label for="CollageDepartment">CollageDepartment</label>

</div>

</div>

<p>

</p>

</fieldset>

</form>

<div>

</div>

</body>

</html>

Now double click on html file and enter some data then click on “Create” ,this window will be same like view.

now enter some data and click on “create” button .

When you click on create button, you will see that this is redirecting to action method “CollageInfo” this wrong ,its called CSRF attack.

To prevent from this attack Microsoft provide us a keyword name “@Html.AntiForgeryToken() “ For view ,we have to add this keyword as shown below

After this we need to add a attribute to action method attribute is [ValidateAntiForgeryToken]

Now if you will run your HTML file and will click on create button it will give error name is

required anti-forgery form field "__RequestVerificationToken" is not present

Like this we can prevent from this CSRF attack.

you can download this project from here Download

Export data from sqlserver database to excel in asp.net c#

noreply@blogger.com (Munesh Sharma) — Tue, 10 May 2016 16:54:00 +0000

In this article we will learn how to export data directly from sql server database table to excel,

below is the database table which contain some data

I will export this data into excel file to excel by using C#.net coding as below:

1.Add a new file TabletoExcel.aspx in the solution explorer

Copy and paste below code in TabletoExcel.aspx page

<body>

<form id="form1" runat="server">

<div>

<asp:Button ID="btnGenaerateToExcel" runat="server" onclick="btnGenerateToExcel_Click" Text="Button" />

</div>

</form>

</body>

Copy and paste below code in TabletoExcel.cs page:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Configuration;

using System.Data.SqlClient;

using System.Data;

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

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btnGenerateToExcel_Click(object sender, EventArgs e)

{

PopulatExcelEntry();

}

protected void PopulatExcelEntry()

{

SqlConnection Connection = new SqlConnection("Server=Munesh-PC;Database=Griddata;Uid=sa;Pwd=123");

DataSet ds = new DataSet();

SqlDataAdapter adapter = new SqlDataAdapter("select * from Tbl_Mst_Employee", Connection);

try

{

adapter.Fill(ds);

ExportToExcel(ds);

}

catch (Exception ex)

{

Connection.Close();

}

}

public static void ExportToExcel(System.ComponentModel.MarshalByValueComponent DataSource)

{

try

{

System.IO.StringWriter objStringWriter = new System.IO.StringWriter();

System.Web.UI.WebControls.DataGrid tempDataGrid = new System.Web.UI.WebControls.DataGrid();

System.Web.UI.HtmlTextWriter objHtmlTextWriter = new System.Web.UI.HtmlTextWriter(objStringWriter);

HttpContext.Current.Response.ClearContent();

HttpContext.Current.Response.ClearHeaders();

HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";

HttpContext.Current.Response.Charset = "";

HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=TableToExcel.xls");

tempDataGrid.DataSource = DataSource;

tempDataGrid.DataBind();

tempDataGrid.HeaderStyle.Font.Bold = true;

tempDataGrid.RenderControl(objHtmlTextWriter);

DataSource.Dispose();

HttpContext.Current.Response.Write(objStringWriter.ToString());

HttpContext.Current.Response.End();

HttpContext.Current.ApplicationInstance.CompleteRequest();

}

catch (Exception ex)

{

throw ex;

}

}

}

Run you application and click on button

Click on Ok and you will get your required output as:

Remove Assigned Users from Role in Asp.Net MVC

noreply@blogger.com (Munesh Sharma) — Tue, 10 May 2016 10:56:00 +0000

Before proceeding to this tutorial please go to Assigned Role to user in Asp.Net MVC
In previous tutorial we learned how to assign role to user , here we will learn how to remove Role from assigned user.

For this purpose we need to add a action method in account controller class. In previous tutorial we created a model class name is “AllroleWithAllUser” . same class we will use here to pass this class in controller.

Following code is for “RemoveRoleForUser” in controller class.

[HttpGet]

public ActionResult RemoveRoleAddedToUser()

{

AssignRole objvm = new AssignRole();

objvm.UserRolesList = GetAll_UserRoles();

objvm.Userlist = GetAll_Users();

return View(objvm);

}

After creating action method for [HttpGet], now we need to add another action method for the [httpPost] . So the following is code for the “RemoveRoleForUser” action method for[httpPost] method.

[HttpPost]

[ValidateAntiForgeryToken]

public ActionResult RemoveRoleAddedToUser(AssignRole _assignRole)

{

if (_assignRole.UserRoleName == "0")

{

ModelState.AddModelError("RoleName", "select proper RoleName");

}

if (_assignRole.UserID == "0")

{

ModelState.AddModelError("UserName", "select proper Username");

}

if (ModelState.IsValid)

{

int currentUserId = CheckUserWithUserRole(Convert.ToInt32(_assignRole.UserID));

if (currentUserId == Convert.ToInt16(_assignRole.UserRoleName))

{

var UserName = GetUserName_BY_UserID(Convert.ToInt32(_assignRole.UserID));

var UserRoleName = GetRoleNameByRoleID(Convert.ToInt32(_assignRole.UserRoleName));

Roles.RemoveUserFromRole(UserName, UserRoleName);

ViewBag.ResultMessage = "User Role is removed successfully !";

}

else

{

ViewBag.ResultMessage = "This current user doesn't belong to selected user role.";

}

_assignRole.UserRolesList = GetAll_UserRoles();

_assignRole.Userlist = GetAll_Users();

}

else

{

_assignRole.UserRolesList = GetAll_UserRoles();

_assignRole.Userlist = GetAll_Users();

}

return View(_assignRole);

}

Following is the code for the remove the role for the respective user.

Following is the code for checking that selected user is belong to the respective RolId.

public int CheckUserWithUserRole(int UserId)

{

using (UsersRoleContext context = new UsersRoleContext())

{

int RoleId = context.webpages_UsersInRole.Where(c => c.UserId == UserId).Select(c => c.RoleId).SingleOrDefault();

return RoleId;

}

Now right click on the” RemoveRoleAddedToUser” controller and add the view to this controller ,this view contain the scaffold template as “Create” model class and model class as “assignRole”.

After click add write the following code to this view

@model MvcMembershipProvider.Models.AssignRole

ViewBag.Title = "RemoveRoleAddedToUser";

}

<h2>RemoveRoleAddedToUser</h2>

@using (Html.BeginForm()) {

@Html.AntiForgeryToken()

@Html.ValidationSummary(true)

<legend>AssignRole</legend>

@Html.LabelFor(model => model.UserRoleName)

</div>

@*@Html.EditorFor(model => model.UserRoleName)*@

@Html.DropDownListFor(m => m.UserRoleName, new SelectList(Model.UserRolesList, "Value", "Text"),

new { style = "width:200px", @class = "form-control" })

@Html.ValidationMessageFor(model => model.UserRoleName)

</div>

@Html.LabelFor(model => model.UserID)

</div>

@*@Html.EditorFor(model => model.UserID)*@

@Html.DropDownListFor(m => m.UserID, new SelectList(Model.Userlist, "Value", "Text"),

new { style = "width:200px", @class = "form-control" })

@Html.ValidationMessageFor(model => model.UserID)

</div>

<p>

</p>

</fieldset>

}

<div>

@Html.ActionLink("Back to List", "Index")

</div>

@section Scripts {

@Scripts.Render("~/bundles/jqueryval")

}

Now run your application and go to the following URL

http://localhost:50526/Account/RemoveRoleAddedToUser

Now select user and role type from dropdown list and then check this work.

Authorize attribute in controller

We can authorize or we can give permission to the controller using attribute.

There is a attribute [Authorize] to authorize. Following is the code for the give the permission code to the controller.

If you want to give permission to the “admin” to full controller , if user have the permission for admin then it will redirect to this page other wise it will redirect to login page

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Mvc;

namespace MvcMembershipProvider.Controllers

{

[Authorize(Roles="Admin")]

public class Authonticate1Controller : Controller

{

public ActionResult Index()

{

return View();

}

If you want to give permission to particular user then use the following code. Here only admin can access then action method.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Mvc;

namespace MvcMembershipProvider.Controllers

{

public class Authonticate1Controller : Controller

{

[Authorize(Roles="Admin")]

public ActionResult Index()

{

return View();

}

And the following code for the particular action method for the particular user

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Mvc;

namespace MvcMembershipProvider.Controllers

{

public class Authonticate1Controller : Controller

{

[Authorize(Roles = "Admin", Users = "munesh")]

public ActionResult Index()

{

return View();

}

Download this project from this link Downlaod

Assigning Role to User in Asp.Net MVC Membership

noreply@blogger.com (Munesh Sharma) — Tue, 10 May 2016 08:42:00 +0000

Before proceeding to this tutorial please go to Display Roles for the users in Asp.Net MVC Membership
Here we will learn how to How to assign roles to the users in asp.net membership provider. For assigning the roles to the user we need to add a model for member list and roles List.

1^st add a model class in account model.cs class name is “AssignRolesToUsers”.

public class AssignRole

{

[Required(ErrorMessage = " Select proper UserRole Name")]

public string UserRoleName { get; set; }

[Required(ErrorMessage = "Select UserName")]

public string UserID { get; set; }

public List<SelectListItem> Userlist { get; set; }

public List<SelectListItem> UserRolesList { get; set; }

}

After creating the model we need to add a action method in controller class name is “AssignRolesToUsers”.

[HttpGet]

public ActionResult AssignRolesToUsers()

{

}

Now add a DbSet to the UserProfile class

public class UsersRoleContext : DbContext

{

public UsersRoleContext()

: base("DBConnectionForMembership")

{

}

public DbSet<Role> UserRoles { get; set; }

public DbSet< UserProfile > UserProfile { get; set; }

}

Now create two nonAction method got getAllUsers and GetAllUserRoles in Account Controller.

So for that write the following code

[NonAction]

public List<SelectListItem> GetAll_UserRoles()

{

List<SelectListItem> listrole = new List<SelectListItem>();

listrole.Add(new SelectListItem { Text = "select", Value = "0" });

using (UsersRoleContext db = new UsersRoleContext())

{

foreach (var item in db.UserRoles)

{

listrole.Add(new SelectListItem { Text = item.RoleName, Value = Convert.ToString( item.RoleId) });

}

return listrole;

}

[NonAction]

public List<SelectListItem> GetAll_Users()

{

List<SelectListItem> listuser = new List<SelectListItem>();

listuser.Add(new SelectListItem { Text = "Select", Value = "0" });

using (UsersRoleContext db = new UsersRoleContext())

{

foreach (var item in db.UserProfile)

{

listuser.Add(new SelectListItem { Text = item.UserName, Value = Convert.ToString(item.UserId) });

}

return listuser;

}

Now add the following code to the “AssignRolesToUsers” action method

[HttpGet]

public ActionResult AssignRolesToUsers()

{

AssignRole _addignroles = new AssignRole();

_addignroles.UserRolesList = GetAll_UserRoles();

_addignroles.Userlist = GetAll_Users();

return View(_addignroles);

}

Now after assign the object value need to add view for this action method so for that right click on this action method and select strongly typed model as “AssignRoles” and scaffold template as create.

After click on add it will generate some code for us nut we need to make changes in this view

@model MvcMembershipProvider.Models.AssignRole

ViewBag.Title = "AssignRolesToUsers";

}

<h2>AssignRolesToUsers</h2>

@using (Html.BeginForm())

{

@Html.AntiForgeryToken()

@Html.ValidationSummary(true)

<legend>AssignRole</legend>

@Html.LabelFor(model => model.UserRoleName)

</div>

@*@Html.EditorFor(model => model.UserRoleName)*@

@Html.DropDownListFor(m => m.UserRoleName, new SelectList(Model.UserRolesList, "Value", "Text"),

new { style = "width:200px", @class = "form-control" })

@Html.ValidationMessageFor(model => model.UserRoleName)

</div>

@Html.LabelFor(model => model.UserID)

</div>

@*@Html.EditorFor(model => model.UserID)*@

@Html.DropDownListFor(m => m.UserID, new SelectList(Model.Userlist, "Value", "Text"),

new { style = "width:200px", @class = "form-control" })

@Html.ValidationMessageFor(model => model.UserID)

</div>

<p>

</p>

</fieldset>

}

<div>

@Html.ActionLink("Back to List", "Index")

</div>

@section Scripts {

@Scripts.Render("~/bundles/jqueryval")

}

Now run your application and go to following url then o/p will look like this

http://localhost:50526/Account/AssignRolesToUsers

Add role to the user

Now here we will create action method to add the role to the users with the post method.

Write the following code in Post action method for the “AssignRolesToUsers”.

[HttpPost]

[ValidateAntiForgeryToken]

public ActionResult AssignRolesToUsers(AssignRole _assignRole)

{

if (_assignRole.UserRoleName == "0")

{

ModelState.AddModelError("RoleName", " select UserRoleName");

}

if (_assignRole.UserID == "0")

{

ModelState.AddModelError("UserName", " select Username");

}

if (ModelState.IsValid)

{

if (Get_CheckUserRoles(Convert.ToInt32(_assignRole.UserID)) == true)

{

ViewBag.ResultMessage = "Current user is already has the role";

}

else

{

var UserName = GetUserName_BY_UserID(Convert.ToInt32(_assignRole.UserID));

var UserRoleName = GetRoleNameByRoleID(Convert.ToInt32(_assignRole.UserRoleName));

Roles.AddUserToRole(UserName, UserRoleName);

ViewBag.ResultMessage = "Username added to role successfully !";

}

_assignRole.UserRolesList = GetAll_UserRoles();

_assignRole.Userlist = GetAll_Users();

return View(_assignRole);

}

else

{

_assignRole.UserRolesList = GetAll_UserRoles();

_assignRole.Userlist = GetAll_Users();

}

return View(_assignRole);

}

Following code for get UserName by using userid

public string GetUserName_BY_UserID(int UserId)

{

using (UsersRoleContext context = new UsersRoleContext())

{

var UserName = (from UP in context.UserProfile

where UP.UserId == UserId

select UP.UserName).SingleOrDefault();

return UserName;

}

Following code for get UserRoleName by using userRoleId

public string GetRoleNameByRoleID(int RoleId)

{

using (UsersRoleContext context = new UsersRoleContext())

{

var roleName = (from UP in context.UserRoles

where UP.RoleId == RoleId

select UP.RoleName).SingleOrDefault();

return roleName;

}

Following code for checking that current user have role name or not

public bool Get_CheckUserRoles(int UserId)

{

using (UsersRoleContext context = new UsersRoleContext())

{

var data = (from WR in context.webpages_UsersInRole

join R in context.UserRoles on WR.RoleId equals R.RoleId

where WR.UserId == UserId

orderby R.RoleId

select new

{

WR.UserId

}).Count();

if (data > 0)

{

return true;

}

else

{

return false;

}

Now run your application and go to the following URL and check the entries

http://localhost:50526/Account/AssignRolesToUsers

database table is

Create a view with all roles and all the users

First for this add a model in account.cs class under model folder. So code for this is

public class AllroleWithAllUser

{

public string UserRoleName { get; set; }

public string UserName { get; set; }

public IEnumerable<AllroleWithAllUser> AllDetailsUserlist { get; set; }

}

Write a nonAction method in controller to get all user with respective UserRole

[NonAction]

public List<AllroleWithAllUser> GetUserNameResepectiveToRole()

{

using (UsersRoleContext db = new UsersRoleContext())

{

var Alldata = (from User in db.UserProfile

join WU in db.webpages_UsersInRole on User.UserId equals WU.UserId

join WR in db.UserRoles on WU.RoleId equals WR.RoleId

select new AllroleWithAllUser { UserName = User.UserName, UserRoleName = WR.RoleName }).ToList();

return Alldata;

}

Now write a action method for getting this

[HttpGet]

public ActionResult DisplayAllUserroles()

{

AllroleWithAllUser _alluserWithRole = new AllroleWithAllUser();

_alluserWithRole.AllDetailsUserlist = GetUserNameResepectiveToRole();

return View(_alluserWithRole);

}

Now we need to add a view for showing All user with their respective Role. So right click on action method and add a view with scaffold template as empty.

And the write following code in the view

@model MvcMembershipProvider.Models.AllroleWithAllUser

@using GridMvc.Html

ViewBag.Title = "DisplayAllUserroles";

}

<h2>DisplayAllUserroles</h2>

@Html.Grid(Model.AllDetailsUserlist).Columns(columns =>

{

columns.Add(c => c.UserName).Titled("UserName").Filterable(true).SetWidth(300);

columns.Add(c => c.UserRoleName).Titled("RoleName").Filterable(true).SetWidth(300);

}).WithPaging(10).Sortable(true)

Now run your application and go to following URL

http://localhost:50526/Account/DisplayRoleForUsers

Download this project from this link Downlaod

Display Roles for the users in Asp.Net MVC Membership

noreply@blogger.com (Munesh Sharma) — Mon, 09 May 2016 09:00:00 +0000

Before proceeding to this tutorial please go to Asp.Net MVC Membership Provider
In previous tutorial we learned how to use membership provider in asp.net mvc.Here we will learn how to Display Roles for the users in Asp.Net MVC Membership.

First proceeding to this we need to add a class or we need a model name is Role. Add this role model inside the account model.

Add the following code to the account model.cs class

[Table("webpages_Roles")]

public class Role

{

[Required(ErrorMessage = "Enter Role name")]

[StringLength(100, ErrorMessage = "The {0} must be at least {2} characters long.", MinimumLength = 6)]

public string RoleName { get; set; }

[Key]

[DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]

public int RoleId { get; set; }

}

After creating this Role model we need to add a Acton method name RoleCreate for HttpPost and HttpGet , so for that write following code in account controller

[HttpGet]

public ActionResult UserRole()

{

return View(new Role());

}

[HttpPost]

public ActionResult UserRole(Role role)

{

return View(role);

}

After creating action method for Role we need to add a view for this, For adding view right click on the “UserRole” action method a window will open there you select model class as Role model and select scaffold template as Create,And after selecting all these click on Add.

It will add a view for you and you will see this view under the account folder in View.

Now run your application and login to the page which you created account before. After login to account ,navigate to the following URL

http://localhost:50526/Account/UserRole

When you will hit this URL it will go to userRole view and page will look like this

After making this view we need to insert role to database so for that we need to add code to insert data into database , so for that we need to add code in HttpPost method of UserRole action method.

Inside this action method there is a property name is [Roles.RoleExists(role.RoleName) ]to check that this Role is already exist or not in database , it return Boolean value. So write the following code in UserRole Action method.

[HttpPost]

public ActionResult UserRole(Role role)

{

if (ModelState.IsValid)

{

if (Roles.RoleExists(role.RoleName))

{

ModelState.AddModelError("Error", " This Rolename already exists");

return View(role);

}

else

{

Roles.CreateRole(role.RoleName);

return RedirectToAction("RoleIndex", "Account");

}

else

{

ModelState.AddModelError("Error", "Please enter proper Username and Password");

}

return View(role);

}

So far we created Role for the user. Now we will learn how to assign role to the user.

Assign Roles to the user And Display the Role

For displaying all the user role we will use code first approach so for that we have to creaet a class name is “userContext” which will be inherited from the “DbContext” class .If you are internet application then is it already exist in account model at top. Code for this class is like following

public class UsersRoleContext : DbContext

{

public UsersRoleContext()

: base("DBConnectionForMembership")

{

}

public DbSet<Role> UserRoles { get; set; }

}

DBConnectionForMembership is the connection string name which we defined in web config file.

Now we need to add action method for displaying the role of users and add a action methos in account controller class name is “DisplayRoleForUsers”.

[HttpGet]

public ActionResult DisplayRoleForUsers()

{

IEnumerable<Role> ListRoles;

using (UsersRoleContext db = new UsersRoleContext())

{

ListRoles = db.UserRoles.ToList();

}

return View(ListRoles);

}

After adding action method ,now need to add view for displaying the role of user so for that right click on DisplayRoleForUsers action method add a view without creating strongly typed view.

Now this view will create a empty view and for showing role of user we need a grid.

Adding MVC Grid to application

For adding grid to the application right click on the application and select “Nuget package manager”

After click on nugget packet manager a window will open there you search “Grid.Mvc” under online panel. And install this grid to the application.

After adding grid to the application go the “DisplayRoleForUsers” view

Add grid.mvc to this view

Write the following code to this view

@model IEnumerable<MvcMembershipProvider.Models.Role>

@using GridMvc.Html

ViewBag.Title = "Display roles for users";

}

<h2>DisplayAllRoles</h2>

@Html.Grid(Model).Columns(columns =>

{

columns.Add(c => c.RoleId).Titled("Role ID").SetWidth(300);

columns.Add(c => c.RoleName).Titled("RoleName").Filterable(true).SetWidth(300);

}).WithPaging(5).Sortable(true)

Now run you application and go to the followinf URL and see the output

http://localhost:50526/Account/DisplayRoleForUsers

Download this project from this link Downlaod

Asp.Net MVC Membership Provider

noreply@blogger.com (Munesh Sharma) — Sat, 07 May 2016 12:14:00 +0000

Here we will learn how to use membership provider in asp.net mvc, and how to create users, and their roles using asp.net mvc membership, with this we will also learn how to assign roles to users in asp.net mvc membership provider, and how remove users from roles, after getting all roles users from asp.net mvc membership and we will implement security in asp.net mvc applications with examples.

To making security in asp.net mvc application use the following method to create the security in asp.net mvc application

(1) Authentication And Authorization in asp.net mvc

Authentication: It is the process of checking that the user is valid or not

Authorization: it is the process of checking that the user is applicable for the process or not

(2) Membership providers in asp.net mvc

(3) Roles based authentication for user in asp.net mvc

We will learn how to create a database for the membership provider in asp.net mvc and how to assign role to user, we will create a registration page to understand this

Let’s create a application for membership provider asp.net mvc.

Step (1) : Go to visual studio and click on new project -> a window will open from here select a 'Asp.net MVC4 web application' and give the name for this project in my case I give it as “MvcMembershipProvider “.

Step(2) : after creation of application let's create a database for this and give the name for this database i gave it as 'MVCApp' and then add a connection string to the database.

</connectionStrings>

// WebSecurity.InitializeDatabaseConnection("DefaultConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true);

AccountModel.cs class contain following methods.

now for creating membership tables in database initialize the connection in globel.asax . here we will use code first approach for that we need to add following code in this class

For adding data table in database membership we need to add a line of code in Global.asax

WebSecurity.InitializeDatabaseConnection("DBConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true);

Here namespace for WebSecurity is “using WebMatrix.WebData;”

WebSecurity.InitializeDatabaseConnection

Definition for the InitializeDatabaseConnection is

public static void InitializeDatabaseConnection (string connectionStringName, string userTableName, string userIdColumn, string userNameColumn, bool autoCreateTables);

connectionStringName: It the name of database table where user information stored.

userTableName: It contain user profile information.

userIdColumn: this column name of table contain user ID this should be integer.

userNameColumn: column name of table contain user name. This column is basically used to match profile data of user with membership account data.

Now globel.asax page will look like

Now after all this configuration lets run your application and see the ur hoe page and click on register link which is your page right side.

After running your application you go to database and see the table, it will generate following tables for us

When you will click on registration link following screen will open with 3 field .

we can add more field to this view, for making change in registration view 1^st need to add field in database table name is “UserProfile”;

Here we added 3 column as shown above now we need to add these column parameters in registration model ,it is in Account.cs class which is available in Model.

Code for registration model is

public class RegisterModel

{

[Required]

[Display(Name = "User name")]

public string UserName { get; set; }

[Required]

[StringLength(100, ErrorMessage = "The {0} must be at least {2} characters long.", MinimumLength = 6)]

[DataType(DataType.Password)]

[Display(Name = "Password")]

public string Password { get; set; }

[DataType(DataType.Password)]

[Display(Name = "Confirm password")]

[Compare("Password", ErrorMessage = "The password and confirmation password do not match.")]

public string ConfirmPassword { get; set; }

[Required]

[Display(Name = "EmailID")]

public string EmailId { get; set; }

[Required]

[Display(Name = "address")]

public string Address { get; set; }

[Required]

[Display(Name = "Mobile No")]

public string MobileNo { get; set; }

}

Add these field in registration view

<legend>Registration Form</legend>

<ol>

<li>

@Html.LabelFor(m => m.UserName)

@Html.TextBoxFor(m => m.UserName)

</li>

<li>

@Html.LabelFor(m => m.Password)

@Html. PasswordFor (m => m.Password)

</li>

<li>

@Html.LabelFor(m => m.ConfirmPassword)

@Html.PasswordFor(m => m.ConfirmPassword)

</li>

<li>

@Html.LabelFor(m => m.EmailId)

@Html.TextBoxFor(m => m.EmailId)

</li>

<li>

@Html.LabelFor(m => m.Address)

@Html.TextBoxFor(m => m.Address)

</li>

<li>

@Html.LabelFor(m => m.MobileNo)

@Html.TextBoxFor(m => m.MobileNo)

</li>

</ol>

</fieldset>

Now if you will run your application and you will see registration page it will look with new fields.

Now according to this we need to add or handle these field in controller also so for that go to Account Controller and we have to make changes in HTTPPost method of registration Action.

Now the code for this action according to old registration model is

WebSecurity.CreateUserAndAccount(model.UserName, model.Password);

Now will make changes in this according to new model

WebSecurity.CreateUserAndAccount(model.UserName, model.Password,

new

{

EmailID = model.EmailId,

Address = model.Address,

MobileNo = model.MobileNo

}

);

So the code for the Registration action method is

[HttpPost]

[AllowAnonymous]

[ValidateAntiForgeryToken]

public ActionResult Register(RegisterModel model)

{

if (ModelState.IsValid)

{

// Attempt to register the user

try

{

WebSecurity.CreateUserAndAccount(model.UserName, model.Password,

new

{

EmailID = model.EmailId,

Address = model.Address,

MobileNo = model.MobileNo

}

);

WebSecurity.Login(model.UserName, model.Password);

return RedirectToAction("Index", "Home");

}

catch (MembershipCreateUserException e)

{

ModelState.AddModelError("", ErrorCodeToString(e.StatusCode));

}

// If we got this far, something failed, redisplay form

return View(model);

}

Now run your application and go to registration page and enter some data to fields then save it ,data will save in database.

Download this project from this link Downlaod

curd operation in gridView using ajax

noreply@blogger.com (Munesh Sharma) — Tue, 03 May 2016 06:18:00 +0000

Here we will learn how to do crud operations select,insert, edit, update and delete in grid view using AJAX stored procedure

in asp.net , in asp.net gridview curd operation happen without postback using updatepanel .

Here we will learn curd operation in gridview using stored procedure in asp.net .

Before implement this application first we will design the database table name is 'CollageInfo' and then stored Procedure name is CurdOperationInGridView.

Create Database Table and Stored procedure like following if you needed

CREATE TABLE CollageInfo

(

Collageid int identity PRIMARY KEY ,

Collagename nvarchar(50),

CollageRank double

)

CREATE PROCEDURE CrudOperationsInGridView

@Collageid int = 0,

@Collagename varchar(50)=null,

@CollageRank int=0,

@status varchar(50)

BEGIN

SET NOCOUNT ON;

--- Insert New Records For GridView

IF @status='INSERT'

BEGIN

INSERT INTO CollageInfo(Collagename,CollageRank) VALUES(@Collagename,@CollageRank)

END

--- Select Records in Table For GridView

IF @status='SELECT'

BEGIN

SELECT Collageid,Collagename,CollageRank FROM CollageInfo

END

--- Update Records in Table For GridView

IF @status='UPDATE'

BEGIN

UPDATE CollageInfo SET @Collagename=@Collagename,CollageRank=@CollageRank WHERE Collageid=@Collageid

END

--- Delete Records from Table For GridView

IF @status='DELETE'

BEGIN

DELETE FROM CollageInfo where Collageid=@Collageid

END

SET NOCOUNT OFF

END

Once we Create stored procedure in database then add an aspx page and write the following code on .aspx Page.

<title>GridView Crud Operations using Stored Procedure in ASP.Net</title>

.GridviewDesign {

font-size: 100%;

font-family: 'Trebuchet MS', 'Lucida Sans Unicode', 'Lucida Grande', 'Lucida Sans', Arial, sans-serif;

color: #303933;

}

.headerstyleForGrid {

color: #FFFFFF;

border-right-color: #abb079;

border-bottom-color: #abb079;

background-color: #df5015;

padding: 0.5em 0.5em 0.5em 0.5em;

text-align: center;

}

</style>

</head>

<body>

<asp:ScriptManager ID="scriptmanager1" runat="server"></asp:ScriptManager>

<asp:UpdatePanel ID="panel1" runat="server">

<asp:GridView runat="server" ID="gvDetailsForCurdOperation" ShowFooter="true" AllowPaging="true" PageSize="10" AutoGenerateColumns="false" DataKeyNames="Collageid,Collagename" OnPageIndexChanging="gvDetailsForCurdOperation_PageIndexChanging" OnRowCancelingEdit="gvDetailsForCurdOperation_RowCancelingEdit"

OnRowEditing="gvDetailsForCurdOperation_RowEditing" OnRowUpdating="gvDetailsForCurdOperation_RowUpdating" OnRowDeleting="gvDetailsForCurdOperation_RowDeleting" OnRowCommand="gvDetailsForCurdOperation_RowCommand">

<asp:BoundField DataField="Collageid" HeaderText="Collage Id" ReadOnly="true" />

<asp:TemplateField HeaderText="Collage Name">

<asp:Label ID="lblCollagename" runat="server" Text='<%# Eval("Collagename")%>' />

</ItemTemplate>

<asp:TextBox ID="txtCollagename" runat="server" Text='<%# Eval("Collagename")%>' />

</EditItemTemplate>

<asp:TextBox ID="txtpname" runat="server" />

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Collage Rank">

<asp:Label ID="lblCollageRank" runat="server" Text='<%# Eval("CollageRank")%>'></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtCollageRank" runat="server" Text='<%# Eval("CollageRank")%>' />

</EditItemTemplate>

<asp:TextBox ID="txtCollageRank" runat="server" />

<asp:Button ID="btnAddNewItem" CommandName="AddNew" runat="server" Text="Add" />

</FooterTemplate>

</asp:TemplateField>

<asp:CommandField ShowEditButton="True" ShowDeleteButton="true" />

</Columns>

</asp:GridView>

<asp:Label ID="lblresult" runat="server"></asp:Label>

</ContentTemplate>

<asp:AsyncPostBackTrigger ControlID="gvDetailsForCurdOperation" />

</Triggers>

</asp:UpdatePanel>

</div>

</form>

</body>

</html>

After completion code for .aspx page write the following code on .aspx.cs page

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindGridview();

}

protected void BindGridview()

{

DataSet ds = new DataSet();

using (SqlConnection con = new SqlConnection("Data Source=Munesh;Integrated Security=true;Initial Catalog=GridCurdOperation"))

{

con.Open();

SqlCommand cmd = new SqlCommand("CrudOperationsInGridView", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@status", "SELECT");

SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(ds);

con.Close();

if (ds.Tables[0].Rows.Count > 0)

{

gvDetailsForCurdOperation.DataSource = ds;

gvDetailsForCurdOperation.DataBind();

}

else

{

ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());

gvDetailsForCurdOperation.DataSource = ds;

gvDetailsForCurdOperation.DataBind();

int columncount = gvDetailsForCurdOperation.Rows[0].Cells.Count;

gvDetailsForCurdOperation.Rows[0].Cells.Clear();

gvDetailsForCurdOperation.Rows[0].Cells.Add(new TableCell());

gvDetailsForCurdOperation.Rows[0].Cells[0].ColumnSpan = columncount;

gvDetailsForCurdOperation.Rows[0].Cells[0].Text = "No Records Found";

}

protected void gvDetailsForCurdOperation_RowCommand(object sender, GridViewCommandEventArgs e)

{

if (e.CommandName.Equals("AddNew"))

{

TextBox txtname = (TextBox)gvDetailsForCurdOperation.FooterRow.FindControl("txtpname");

TextBox txtprice = (TextBox)gvDetailsForCurdOperation.FooterRow.FindControl("txtprice");

crudoperationsForGrid("INSERT", txtname.Text, txtprice.Text, 0);

}

protected void gvDetailsForCurdOperation_RowEditing(object sender, GridViewEditEventArgs e)

{

gvDetailsForCurdOperation.EditIndex = e.NewEditIndex;

BindGridview();

}

protected void gvDetailsForCurdOperation_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

gvDetailsForCurdOperation.EditIndex = -1;

BindGridview();

}

protected void gvDetailsForCurdOperation_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

gvDetailsForCurdOperation.PageIndex = e.NewPageIndex;

BindGridview();

}

protected void gvDetailsForCurdOperation_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

int Collageid = Convert.ToInt32(gvDetailsForCurdOperation.DataKeys[e.RowIndex].Values["Collageid"].ToString());

TextBox txtname = (TextBox)gvDetailsForCurdOperation.Rows[e.RowIndex].FindControl("txtCollagename");

TextBox txtCollageRank = (TextBox)gvDetailsForCurdOperation.Rows[e.RowIndex].FindControl("txtCollageRank");

crudoperationsForGrid("UPDATE", txtname.Text, txtCollageRank.Text, Collageid);

}

protected void gvDetailsForCurdOperation_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

int Collageid = Convert.ToInt32(gvDetailsForCurdOperation.DataKeys[e.RowIndex].Values["Collageid"].ToString());

string Collagename = gvDetailsForCurdOperation.DataKeys[e.RowIndex].Values["Collagename"].ToString();

crudoperationsForGrid("DELETE", Collagename, "", Collageid);

}

protected void crudoperationsForGrid(string status, string Collagename, string price, int Collageid)

{

using (SqlConnection con = new SqlConnection("Data Source=Munesh;Integrated Security=true;Initial Catalog=GridCurdOperation"))

{

con.Open();

SqlCommand cmd = new SqlCommand("CrudOperationsInGridView", con);

cmd.CommandType = CommandType.StoredProcedure;

if (status == "INSERT")

{

cmd.Parameters.AddWithValue("@status", status);

cmd.Parameters.AddWithValue("@Collagename", Collagename);

cmd.Parameters.AddWithValue("@CollageRank", price);

}

else if (status == "UPDATE")

{

cmd.Parameters.AddWithValue("@status", status);

cmd.Parameters.AddWithValue("@Collagename", Collagename);

cmd.Parameters.AddWithValue("@CollageRank", price);

cmd.Parameters.AddWithValue("@Collageid", Collageid);

}

else if (status == "DELETE")

{

cmd.Parameters.AddWithValue("@status", status);

cmd.Parameters.AddWithValue("@Collageid", Collageid);

}

cmd.ExecuteNonQuery();

lblresult.ForeColor = Color.Green;

lblresult.Text = Collagename + " details " + status.ToLower() + "d successfully";

gvDetailsForCurdOperation.EditIndex = -1;

BindGridview();

}

Now run your application and see the output and perform Curd operation For Gridview.

you can download code semple from here Download

curd operation in gridview using stored procedure

noreply@blogger.com (Munesh Sharma) — Tue, 03 May 2016 05:17:00 +0000

Here we will learn curd operation in gridview using stored procedure in asp.net .

Before implement this application first we will design the database table name is 'CollageInfo' and then stored Procedure name is CurdOperationInGridView.

Create Database Table and Stored procedure like following if you needed

CREATE TABLE CollageInfo

(

Collageid int identity PRIMARY KEY ,

Collagename nvarchar(50),

CollageRank double

)

CREATE PROCEDURE CrudOperationsInGridView

@Collageid int = 0,

@Collagename varchar(50)=null,

@CollageRank int=0,

@status varchar(50)

BEGIN

SET NOCOUNT ON;

--- Insert New Records For GridView

IF @status='INSERT'

BEGIN

INSERT INTO CollageInfo(Collagename,CollageRank) VALUES(@Collagename,@CollageRank)

END

--- Select Records in Table For GridView

IF @status='SELECT'

BEGIN

SELECT Collageid,Collagename,CollageRank FROM CollageInfo

END

--- Update Records in Table For GridView

IF @status='UPDATE'

BEGIN

UPDATE CollageInfo SET @Collagename=@Collagename,CollageRank=@CollageRank WHERE Collageid=@Collageid

END

--- Delete Records from Table For GridView

IF @status='DELETE'

BEGIN

DELETE FROM CollageInfo where Collageid=@Collageid

END

SET NOCOUNT OFF

END

Once we Create stored procedure in database then add an aspx page and write the following code on .aspx Page.

<title>GridView Crud Operations using Stored Procedure in ASP.Net</title>

.GridviewDesign {font-size: 100%; font-family: 'Trebuchet MS', 'Lucida Sans Unicode', 'Lucida Grande', 'Lucida Sans', Arial, sans-serif; color: #303933;}

.headerstyleForGrid

{

color:#FFFFFF;border-right-color:#abb079;border-bottom-color:#abb079;background-color: #df5015;padding:0.5em 0.5em 0.5em 0.5em;text-align:center;

}

</style>

</head>

<body>

<asp:BoundField DataField="Collageid" HeaderText="Collage Id" ReadOnly="true" />

<asp:TemplateField HeaderText="Collage Name">

<asp:Label ID="lblCollagename" runat="server" Text='<%# Eval("Collagename")%>'/>

</ItemTemplate>

<asp:TextBox ID="txtCollagename" runat="server" Text='<%# Eval("Collagename")%>'/>

</EditItemTemplate>

<asp:TextBox ID="txtpname" runat="server" />

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText = "Collage Rank">

<asp:Label ID="lblCollageRank" runat="server" Text='<%# Eval("CollageRank")%>'></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtCollageRank" runat="server" Text='<%# Eval("CollageRank")%>'/>

</EditItemTemplate>

<asp:TextBox ID="txtCollageRank" runat="server" />

<asp:Button ID="btnAddNewItem" CommandName="AddNew" runat="server" Text="Add" />

</FooterTemplate>

</asp:TemplateField>

<asp:CommandField ShowEditButton="True" ShowDeleteButton="true" />

</Columns>

</asp:GridView>

<asp:Label ID="lblresult" runat="server"></asp:Label>

</div>

</form>

</body>

</html>

After completion code for .aspx page write the following code on .aspx.cs page

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindGridview();

}

protected void BindGridview()

{

DataSet ds = new DataSet();

using (SqlConnection con = new SqlConnection("Data Source=Munesh;Integrated Security=true;Initial Catalog=GridCurdOperation"))

{

con.Open();

SqlCommand cmd = new SqlCommand("CrudOperationsInGridView", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@status", "SELECT");

SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(ds);

con.Close();

if (ds.Tables[0].Rows.Count > 0)

{

gvDetailsForCurdOperation.DataSource = ds;

gvDetailsForCurdOperation.DataBind();

}

else

{

ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());

gvDetailsForCurdOperation.DataSource = ds;

gvDetailsForCurdOperation.DataBind();

int columncount = gvDetailsForCurdOperation.Rows[0].Cells.Count;

gvDetailsForCurdOperation.Rows[0].Cells.Clear();

gvDetailsForCurdOperation.Rows[0].Cells.Add(new TableCell());

gvDetailsForCurdOperation.Rows[0].Cells[0].ColumnSpan = columncount;

gvDetailsForCurdOperation.Rows[0].Cells[0].Text = "No Records Found";

}

protected void gvDetailsForCurdOperation_RowCommand(object sender, GridViewCommandEventArgs e)

{

if (e.CommandName.Equals("AddNew"))

{

TextBox txtname = (TextBox)gvDetailsForCurdOperation.FooterRow.FindControl("txtpname");

TextBox txtprice = (TextBox)gvDetailsForCurdOperation.FooterRow.FindControl("txtprice");

crudoperationsForGrid("INSERT", txtname.Text, txtprice.Text, 0);

}

protected void gvDetailsForCurdOperation_RowEditing(object sender, GridViewEditEventArgs e)

{

gvDetailsForCurdOperation.EditIndex = e.NewEditIndex;

BindGridview();

}

protected void gvDetailsForCurdOperation_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

gvDetailsForCurdOperation.EditIndex = -1;

BindGridview();

}

protected void gvDetailsForCurdOperation_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

gvDetailsForCurdOperation.PageIndex = e.NewPageIndex;

BindGridview();

}

protected void gvDetailsForCurdOperation_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

int Collageid = Convert.ToInt32(gvDetailsForCurdOperation.DataKeys[e.RowIndex].Values["Collageid"].ToString());

TextBox txtname = (TextBox)gvDetailsForCurdOperation.Rows[e.RowIndex].FindControl("txtCollagename");

TextBox txtCollageRank = (TextBox)gvDetailsForCurdOperation.Rows[e.RowIndex].FindControl("txtCollageRank");

crudoperationsForGrid("UPDATE", txtname.Text, txtCollageRank.Text, Collageid);

}

protected void gvDetailsForCurdOperation_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

int Collageid = Convert.ToInt32(gvDetailsForCurdOperation.DataKeys[e.RowIndex].Values["Collageid"].ToString());

string Collagename = gvDetailsForCurdOperation.DataKeys[e.RowIndex].Values["Collagename"].ToString();

crudoperationsForGrid("DELETE", Collagename, "", Collageid);

}

protected void crudoperationsForGrid(string status, string Collagename, string price, int Collageid)

{

using (SqlConnection con = new SqlConnection("Data Source=Munesh;Integrated Security=true;Initial Catalog=GridCurdOperation"))

{

con.Open();

SqlCommand cmd = new SqlCommand("CrudOperationsInGridView", con);

cmd.CommandType = CommandType.StoredProcedure;

if (status == "INSERT")

{

cmd.Parameters.AddWithValue("@status", status);

cmd.Parameters.AddWithValue("@Collagename", Collagename);

cmd.Parameters.AddWithValue("@CollageRank", price);

}

else if (status == "UPDATE")

{

cmd.Parameters.AddWithValue("@status", status);

cmd.Parameters.AddWithValue("@Collagename", Collagename);

cmd.Parameters.AddWithValue("@CollageRank", price);

cmd.Parameters.AddWithValue("@Collageid", Collageid);

}

else if (status == "DELETE")

{

cmd.Parameters.AddWithValue("@status", status);

cmd.Parameters.AddWithValue("@Collageid", Collageid);

}

cmd.ExecuteNonQuery();

lblresult.ForeColor = Color.Green;

lblresult.Text = Collagename + " details " + status.ToLower() + "d successfully";

gvDetailsForCurdOperation.EditIndex = -1;

BindGridview();

}

Now run your application and see the output and perform Curd operation For Gridview.

You can download semple code from Here Download

Gridview tutorial in asp.net

noreply@blogger.com (Munesh Sharma) — Tue, 03 May 2016 04:57:00 +0000

curd operation in gridview using stored procedure By: Munesh Sharma In This tutorial we will see curd operation in gridview using stored procedure Continue Reading...
Export grid Data into excel and word By: Munesh Sharma Here we will learn how to Export grid Data into excel and word Continue Reading...
curd operation in gridView using ajax By: Munesh Sharma In This tutorial we will see curd operation in gridView using ajax Continue Reading...
File Upload in Gridview ASP.NET By: Munesh Sharma Here we will learn how to File Upload in Gridview ASP.NET Continue Reading...
Context Menu On Right click on Gridview in Asp.net By: Munesh Sharma In This tutorial we will see Context Menu On Right click on Gridview in Asp.net Continue Reading...

Export grid Data into excel and word

noreply@blogger.com (Munesh Sharma) — Tue, 03 May 2016 04:55:00 +0000

Here we will learn How to export grid data into Excel And Word .

Add an aspx page and write the following code on .aspx Page.

<title>Export Gridview with Images in Asp.net</title>

.GridviewDesign {font-size: 100%; font-family: 'Trebuchet MS', 'Lucida Sans Unicode', 'Lucida Grande', 'Lucida Sans', Arial, sans-serif color: #303933;}

.headerstyleForGrid

{

color:#FFFFFF;border-right-color:#abb079;border-bottom-color:#abb079;background-color: #df5015;padding:0.5em 0.5em 0.5em 0.5em;text-align:center;

}

</style>

</head>

<body>

<asp:GridView ID="gvDetailsForExport" CssClass="Gridview" runat="server" AutoGenerateColumns="False">

<asp:BoundField HeaderText="User Id" DataField="UserId" />

<asp:BoundField HeaderText="User Name" DataField="UserName" />

<asp:BoundField HeaderText="Gender" DataField="Gender" />

<asp:ImageField DataImageUrlField="Imagepath" HeaderText="Image" ItemStyle-Height="25px" ItemStyle-Width="25px" />

</Columns>

</asp:GridView>

<br />

<asp:Button ID="btnExportToExcel" runat="server" Text="Export Data To Excel"

onclick="btnExport_Click" />

<asp:Button ID="btnExportToWord" runat="server" Text="Export Data To Word"

onclick="btnExportToWord_Click" />

</div>

</form>

</body>

</html>

After completion code for .aspx page write the following code on .aspx.cs page

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

gvDetailsForExport.DataSource = BindData();

gvDetailsForExport.DataBind();

}

protected DataTable BindData()

{

DataTable dtGrid = new DataTable();

dtGrid.Columns.Add("UserId", typeof(Int32));

dtGrid.Columns.Add("UserName", typeof(string));

dtGrid.Columns.Add("Gender", typeof(string));

dtGrid.Columns.Add("Imagepath", typeof(string));

dtGrid.Rows.Add(1,"Munesh","Male","Images/uploads/Sign1.jpg");

dtGrid.Rows.Add(2,"Rahul","Male","Images/uploads/Sign2.jpg");

dtGrid.Rows.Add(3,"Reet","Female","Images/uploads/Sign3.jpg");

dtGrid.Rows.Add(4,"Anshuman","Male","Images/uploads/Sign4.jpg");

return dtGrid;

}

protected void btnExport_Click(object sender, EventArgs e)

{

Response.ClearContent();

Response.Buffer = true;

Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Employees.xls"));

Response.ContentType = "application/ms-excel";

StringWriter sw = new StringWriter();

HtmlTextWriter htw = new HtmlTextWriter(sw);

gvDetailsForExport.AllowPaging = false;

gvDetailsForExport.DataSource = BindData();

gvDetailsForExport.DataBind();

gvDetailsForExport.HeaderRow.Style.Add("background-color", "#FFFFFF");

for (int i = 0; i < gvDetailsForExport.HeaderRow.Cells.Count; i++)

{

gvDetailsForExport.HeaderRow.Cells[i].Style.Add("background-color", "#df5015");

}

gvDetailsForExport.RenderControl(htw);

Response.Write(sw.ToString());

Response.End();

}

protected void btnExportToWord_Click(object sender, EventArgs e)

{

Response.ClearContent();

Response.Buffer = true;

Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Employees.doc"));

Response.ContentType = "application/ms-word";

StringWriter sw = new StringWriter();

HtmlTextWriter htw = new HtmlTextWriter(sw);

gvDetailsForExport.AllowPaging = false;

gvDetailsForExport.DataSource = BindData();

gvDetailsForExport.DataBind();

//Change the Header Row back to white color

gvDetailsForExport.HeaderRow.Style.Add("background-color", "#FFFFFF");

//Applying stlye to gridview header cells

for (int i = 0; i < gvDetailsForExport.HeaderRow.Cells.Count; i++)

{

gvDetailsForExport.HeaderRow.Cells[i].Style.Add("background-color", "#df5015");

}

gvDetailsForExport.RenderControl(htw);

Response.Write(sw.ToString());

Response.End();

}

Now run your application and see the output and perform operation On Gridview.

Click Here to Download Semple code Download

Code-Behind for Web Application Projects

noreply@blogger.com (Munesh Sharma) — Mon, 29 Feb 2016 10:52:00 +0000

In this tutorial we will learn the code-behind model and the project structure of pages built For Web Application Projects.

ASP.NET Pages in web project have associated with two files one is a .aspx file that contains the html and declarative server control mark-up, and the other page is a .cs "code-behind" file that contains the UI logic for the page

Control mark-up declarations are defined within the .aspx file itself. For example:

And corresponding protected field declarations are added in the .cs code-behind class that match the name and type of controls defined within the .aspx file. For example:

Here we want to show date in the label when we select date from the calendar,so for that see the following code.

You can then set a breakpoint (press the F9 key on the line to set it on), and then hit F5 to compile, run and debug the page:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

namespace FirstWebApplication

{

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

{

protected void Page_Load(object sender, EventArgs e)

{

if(!Page.IsPostBack)

{

Calendar1.SelectedDate = DateTime.Now;

Label1.Text = "please select a date from calendar";

}

Now if you run your application your result will be

Handling server events from controls in our .aspx page

To handle a server event from a control on your page, you can either manually add an event-handler to the control yourself (by overridng the OnInit method in your code-behind class and adding the event delegate there), or by using the WYSIWYG designer to generate an event handler.

You can double-click on any of the events to automatically add a default named event handler. Alternatively, you can type the name of the event handler you wish to generate.

You can then add whatever code you want within the code-behind file:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

namespace FirstWebApplication

{

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

{

protected void Page_Load(object sender, EventArgs e)

{

if(!Page.IsPostBack)

{

Calendar1.SelectedDate = DateTime.Now;

Label1.Text = "please select a date from calendar";

}

protected void Calendar1_SelectionChanged(object sender, EventArgs e)

{

Label1.Text = "Your selected date from calendar is '" + Calendar1.SelectedDate.ToShortDateString() +"'";

}

Now run your application and select a date from calendar then o/p will be

asp.net first web application

noreply@blogger.com (Munesh Sharma) — Mon, 29 Feb 2016 09:07:00 +0000

In this tutorial we will learn how to create, build and run your first asp.net web app using C# and the ASP.NET.

Creating a New Project

Select File->New Project within the Visual Studio 2013. This will open the New Project dialog screen. Click on the “Visual C#” node in the tree-view on the left hand side of the dialog box and choose the "ASP.NET Web Application" icon:

Choose location where you want this project to be created on system Then give the name of this project and click ok.

Visual Studio will then create and open a new web project within the solution explorer. By default it will create a single page (Default.aspx), an AssemblyInfo.cs file in properties , as well as a web.config file.

Visual stdio 2005 screen-

Visual stdio -2013

In VS-2005 this default.aspx will be empty page but in VS-2013 there will be created page means some text are there by default created by the Microsoft.

So for understanding purpose we will add a new item in this project name will be “FirstWebPage.aspx”.

So for that right click on your application and click on add new item and select a empty web Form give the for this and click Add.

After click on Add new item following screen will open

After click on Add button this “FirstWebPage.aspx” webform will add to the project.

Now click on “FirstWebPage.aspx” webform it will open as HTML format(Source file) we can see it below of that page. We can go in design mode from there.

We can made changes in screen from Source mode and design mode.

Here we are drag and drop a calendar and a label from toolbox .we can change view of calendar using calendar properties.

Html Code will be

<body>

<div>

Hello your first asp.net Application<br />

<br />

<asp:Calendar ID="Calendar1" runat="server" BackColor="White" BorderColor="Black" BorderStyle="Solid" CellSpacing="1" Font-Names="Verdana" Font-Size="9pt" ForeColor="Black" Height="250px" NextPrevFormat="ShortMonth" Width="330px">

</asp:Calendar>

<br />

<asp:Label ID="Label1" runat="server" Height="27px" Text="Label" Width="200px"></asp:Label>

</div>

</form>

</body>

When you will run this application you will see this page on browser ,but before this we have to set “Startup project “ for that right click on “FirstWebPage.aspx” and set it as startup project and run this application or you can see this page using open this browser With.

What is asp.net

noreply@blogger.com (Munesh Sharma) — Thu, 25 Feb 2016 12:08:00 +0000

Asp.net is a web application which is developed by the Microsoft to build the dynamic data driven Web application and Web services.

1. Asp.Net is abbreviated as “Active Server Pages”.

2. Asp.net is the subset of Dot net framework. A framework is a collection of classes.

3. Asp.Net is introduced in 2002 with the 2.0 Dot net framework.

4. Before this technology we was using “Classic Asp” to build web application.

What is Web Application?

A web application is a application which is assessable by the user using the browser.

Example of the web browsers are

1. Internet Explorer

2. Google Chrome

3. Mozilla FireFox

4. Apple Safari

5. Netscape Navigator

Advantages of the web application :>

1. Web application just need to installed on the web server, but for the windows application we have to installed this on every system.

2. Maintains and other things are easier to provide.

3. Only a browser is required for accessing a web application on the client machine.

4. Cross platform.

5. Internet is required for accessing the application.

How Web application work

1. A web application work on the Client/Server architecture .

2. Only a browser needed which can understand HTML for accessing a web application.

3. On the server side , the web application run under the “Internet Information Server(IIS)”.

When a client enter URL or user send a request through the browser then this information is received by the web server , after that this request is proceed by the application. The application converts it to HTML and passes it to IIS Server. The IIS Server send this HTML to the client in user interface format.

This all communication is done on the internet using the HTTP. HTTP is the Hyper Text Transfer protocol.

This HTTP protocols stand how to two or more items communicate.

Generic and Non Generic Collections in C#

noreply@blogger.com (Munesh Sharma) — Thu, 18 Feb 2016 07:24:00 +0000

What is Collections?

Collections are nothing but a grouping of items in to a single unit. Before we starting to office, we are looking at our collection that is “Bag”. Bag is collection of items like laptop (if company provided), Lunch box, Pen, ID card, Zandu balm, Vicks inhaler.

Now the question rises in our mind is Generic and Non Generic collections

The collection of different items in to single unit is called Non Generic collections. So we conclude that our Bag is a good example of Non Generic collection, Since it contain different items as we mentioned above.

The collection of similar items in to a single unit is called Generic

Collections. So we conclude that Footwear rack is the example for Generic collections, since it contains only chapples, shoes and slippers, I hope no one can put lunch box in to Footwear rack.

Now we think in programming view, here generic collections are nothing but the collections of same types (like int,double,long). The generic collections are specific to the type of data we are going to store in it. If we have to clear about type of data, then generic collections is the preferable choice.

C# is loaded with different type of collections, but here I taking a single collection for explaining, that is Stack, the following program shows how our Generic Stack is going to hold the similar type of data.

namespace GenericAndNonGeneric

{

class Program

{

static void Main(string[] args)

{

Stack<int> GenericCollection = new Stack<int>();

GenericCollection.Push(1);

GenericCollection.Push(2);

GenericCollection.Push(3);

GenericCollection.Push(4);

GenericCollection.Push(5);

Console.WriteLine("The Contents of the Generic Collection are:");

foreach(int i in GenericCollection)

{

Console.WriteLine(i);

}

Console.ReadLine();

}

In above code, our collection “GenericCollection” is storing only integer values, if you tries to store something else apart form int type, it result in compilation error.

The generic collections are available in namespace called System.Collections.Generic,need to specify data type in < >.

Example for Generic Collections

Array, Dictionary, List

Non generic collections are the collections of the different types, like storing different type data as a single unit, in the below program we see Stack collection as a non generic collection.

namespace GenericAndNonGeneric

{

class Program

{

static void Main(string[] args)

{

Stack NonGenericCollection = new Stack();

NonGenericCollection.Push(1);

NonGenericCollection.Push("C# coding");

object o = "123Vivek";

NonGenericCollection.Push(o);

NonGenericCollection.Push("#@@@@*&&&");

NonGenericCollection.Push(55.67);

Console.WriteLine("The Contents of the Non Generic Collection are:");

foreach(object obj in NonGenericCollection)

{

Console.WriteLine(obj);

}

Console.ReadLine();

}

In the above code we are putting different type of data(int,string,object,double) in to a “NonGenericCollection”

The Non Generic collections are available in namespace called System.Collections

Example for Non Generic Collections

ArrayList, Hash Table.

Now we have to look at line of code “foreach(object obj in NonGenericCollection)” in above example, in this line we are converting all our entered data into a Object type, since we need a common holding point to hold different type of data, so we using object type.

Performance Issue:

Generic collections are faster than Non Generic collections, since type casting (Boxing) is happens in case of non generic collections.

Conclusion:

Based on the requirement we have to decide the usage of collections either Generic or Non Generic.

Some of the collections like Stack and Queue are used as both Generic and Non Generic collections.

Guys please put comments, it will help me to improve.

What are the different types of results in MVC

noreply@blogger.com (Munesh Sharma) — Tue, 09 Feb 2016 05:14:00 +0000

Action Result Return type

In the following list we can see the action result type

1. ViewResult : This basically render a specific View for the response stream. The View result basically is a class which is inherited by the abstract class of the “ ViewResultBase”, and it is used to render a view. This “ViewResultBase” class contains the methods for finding the specific view for rendering and also for execution the results. It also contain the properties for indentifying the view to rendering for the application.

public ViewResult Index()
{
return View("ViewResult"); // here It is returning a View
}

2. PartialViewResult :- This class also inherited from the abstract base class “ ViewResultBase” class and it is used to rendering a partial view. This class contains the methods from finding the partial view for rendering and also for the execution of the result. This also contains the properties of identify the partial view to rendering the application. This is not like action result. Basically Partial views are not like the primary thing for display the user which is the view.

public PartialViewResult Index()
{
return PartialView("PartialViewData");
}

3. RedirectResult: - It is used to perform the HTTP redirect to a given URL from user side. This class is inherited from the Action result abstract class.

public ActionResult Index()
{
return Redirect("http://www.google.com/");
} public RedirectResult Index1()
{
return Redirect("http://www.google.com/");
}

4. RedirectToRouteResult :- This is used to redirect using specified route data dictionary. This class is inherited from the ActionResult class.

public ActionResult Index(int? Id)
{
return new RedirectToRouteResult(new System.Web.Routing.RouteValueDictionary(new { controller = "Home", action = "List", Id = new int?() }));
}

5. ContentResult : - this is used to return an action plain text this is also inherited from actionResult abstract class.

public ActionResult Index()
{
return Content("Hello");
} public ContentResult ContentResultIndex()
{
return Content("Hello");
}

6. JsonResult : - Action method on controllers basically return the JsonResult means (JavaScript Object Notation result) which can be used in AJAX application. This class inherited from the ActionResult abstract class. Here Json is provided one argument which must be serializable.

public JsonResult Index()
{
return Json("Hello My Friend!");
}

ActionResult	Helper Method	Description
ViewResult	View	Renders a view as a web page
PartialViewResult	PartialView	Section of a view,that can be rendered inside another view
RedirectResult	Redirect	Redirect to another action method
RedirectToRouteResult	RedirectToRoute	Redirect to another action method
ContentResult	Content	Returns a user-defined content type
JsonResult	Json	Retuns a serialized JSON object
JavaScriptResult	JavaScript	Returns a script that can be executed on the client
FileResult	File	Returns a binary output to write to the response
EmptyResult	(None)	returns a null result

Important Validation using jquery

noreply@blogger.com (Munesh Sharma) — Wed, 04 Nov 2015 11:48:00 +0000

1) Phone number validation using jquery

<html>

<head>

//Import jquery.Min.js

$.fn.isPhoneNumber = function (options) {

intRegex = /^[0-9]{1,10}$/;

phoneNumber = this.val();

if ((phoneNumber.length != 10) || (!intRegex.test(phoneNumber))) {

this.val("");

this.attr("placeholder", "Invalid Phone Number");

return false;

}

return true;

};

function validate() {

$("#checkPhoneNumber").isPhoneNumber(this);

return false;

} </script>

</head>

<body>

</body>

</html>

2) Postal code validation

<html>

<head>

//Import jquery.Min.js

$.fn.isPostalCodeNumber = function (options) {

intRegex = /^[0-9]{1,4}$/;

postalcodeNumber = this.val();

if ((postalcodeNumber.length != 10) || (!intRegex.test(postalcodeNumber))) {

this.val("");

this.attr("placeholder", "Invalid Postal Code Number");

return false;

}

return true;

};

function validate() {

$("#checkPostalCodeNumber").isPostalCodeNumber(this);

return false;

}

</script>

</head>

<body>

</body>

</html>

3) English validation

<html>

<head>

//Import jquery.Min.js

var englishAlphabetAndWhiteSpace = /^[a-zA-Z ]*$/;

if(!englishAlphabetAndWhiteSpace.test(this.val()))

{ this.val("");

this.attr("placeholder", "Invalid English Alphabets");

return false;

}

return true;

};

function validate() {

$("#checkEnglishAlphabets").isEnglishAlphabets(this);

return false;

}

</script>

</head>

<body>

</body>

</html>

4) Get the selected value form drop down

<html>

<head>

//Import jquery.Min.js

</head>

<body>

<option value="1">India</option>

<option value="2">China</option>

<option value="3">Russia</option>

<option value="4">Srilanka</option>

<option value="5">Pakistan</option>

</select>

function getSelected() {

alert($("#countries option:selected").text());

alert($("#countries").val());

return false;

}

</script>

</body>

</html>

Display image in asp.net MVC

noreply@blogger.com (Munesh Sharma) — Sat, 26 Sep 2015 18:32:00 +0000

Here we will learn that how to display image in asp.net mvc.

Step(1):- Go to Sql Server management system and execute following script.

create database MVCVariousAttribute

use MVCVariousAttribute

Create table Student

(

Id int primary key identity,

FullName nvarchar(100),

Gender nvarchar(10),

Age int,

AdmissionDate DateTime,

EmailAddress nvarchar(100),

WinningPrize int,

PersonalWebSite nvarchar(100)

)

Insert into Student values

('Munesh Sharma', 'Male', 25, '2005-05-05 16:53:36.975', 'Munesh@gmail.com', 45000,'http://dotnet-munesh.blogspot.in/')

Insert into Student values

('Rahul Sharma', NULL, 30, '2006-06-06 17:42:25.865', 'Rahul@gmail.com', 35000,'http://dotnet-munesh.blogspot.in/')

Alter table Student Add Photo nvarchar(100), AlternateText nvarchar(100)

Update Student set Photo='~/Photos/Munesh.png',

AlternateText = 'munesh Photo' where Id = 1

Step(2):- Go to Visual studio and add a new project -> Select “Asp.Net MVC4 Web Application” and give the name for this ,In my case it is “MVCDemoProject

” -> Select a Project template as Empty and View engine is “Razor”, Then Click OK

Step(3):- Add “EntityFramework dll” to reference folder in your project if you don’t have then install it through nugget package manager for more go this Go here.

Step(4):- Right click on Model folder and add “Ado.net entity Data Model” and give the name it as “StudentDataModel”, Then click on Add

Step(5): . When You will click Add button here you will see another window for “EntityData modal Wizard” from there you select “Generate From DataBase”, And Click Next.

Give the connection name and select your database then click on next

Step(6) . In this screen select your Database Tables and give Modal Name then click FINISH Button.

When you will click on finish button it will create Student Entity.

Step(6) . Right click on your project and add a folder with name is “Photos” and put a image in this folder. Download the following image and paste in "Photos" folder.

Step(7). Add a partial class to this Model folder of this project with the name of student. And put the following code to this class

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel;

using System.Web.Mvc;

namespace MVCDemoProject.Models

{

[MetadataType(typeof(StudentMetaData))]

public partial class Student

{

}

public class StudentMetaData

{

#region dataType attribute

[HiddenInput(DisplayValue = false)]

public int Id { get; set; }

[ReadOnly(true)]

[DataType(DataType.EmailAddress)]

public string EmailAddress { get; set; }

[DataType(DataType.Currency)]

public int? WinningPrize { get; set; }

// Generate a hyperlink

[DataType(DataType.Url)]

[UIHint("OpenInNewWindow")]

public string PersonalWebSite { get; set; }

[DataType(DataType.Date)]

public DateTime? AdmissionDate { get; set; }

#endregion

}

Now right click on controller and a controller with the name is “Home” and put the following code in detail action method.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Mvc;

using MVCDemoProject.Models;

namespace MVCDemoProject.Controllers

{

public class HomeController : Controller

{

// GET: /Home/

public ActionResult Index()

{

return View();

}

// GET: /Home/Details/5

public ActionResult Details(int id)

{

MVCVariousAttributeEntities _context = new MVCVariousAttributeEntities();

Student _studentDetail = _context.Students.Where(c => c.Id == id).SingleOrDefault();

return View(_studentDetail);

}

// GET: /Home/Create

public ActionResult Create()

{

return View();

}

// POST: /Home/Create

[HttpPost]

public ActionResult Create(FormCollection collection)

{

try

{

// TODO: Add insert logic here

return RedirectToAction("Index");

}

catch

{

return View();

}

// GET: /Home/Edit/5

public ActionResult Edit(int id)

{

return View();

}

// POST: /Home/Edit/5

[HttpPost]

public ActionResult Edit(int id, FormCollection collection)

{

try

{

// TODO: Add update logic here

return RedirectToAction("Index");

}

catch

{

return View();

}

// GET: /Home/Delete/5

public ActionResult Delete(int id)

{

return View();

}

// POST: /Home/Delete/5

[HttpPost]

public ActionResult Delete(int id, FormCollection collection)

{

try

{

// TODO: Add delete logic here

return RedirectToAction("Index");

}

catch

{

return View();

}

Step(8):- Next step is that add a view for detail action method so right click on this method -> add view -> Scaffold template as Detail

Step(9) At this position if you go to the following URL then it will not show you the image so for that we need to change in auto generate code in detail view.

http://localhost:3831/Home/Details/1

View Code is

@model MVCDemoProject.Models.Student

ViewBag.Title = "Details";

}

<h2>Details</h2>

<legend>Student</legend>

@Html.DisplayNameFor(model => model.FullName)

</div>

@Html.DisplayFor(model => model.FullName)

</div>

@Html.DisplayNameFor(model => model.Gender)

</div>

@Html.DisplayFor(model => model.Gender)

</div>

@Html.DisplayNameFor(model => model.Age)

</div>

@Html.DisplayFor(model => model.Age)

</div>

@Html.DisplayNameFor(model => model.AdmissionDate)

</div>

@Html.DisplayFor(model => model.AdmissionDate)

</div>

@Html.DisplayNameFor(model => model.EmailAddress)

</div>

@Html.DisplayFor(model => model.EmailAddress)

</div>

@Html.DisplayNameFor(model => model.WinningPrize)

</div>

@Html.DisplayFor(model => model.WinningPrize)

</div>

@Html.DisplayNameFor(model => model.PersonalWebSite)

</div>

@Html.DisplayFor(model => model.PersonalWebSite)

</div>

@Html.DisplayNameFor(model => model.Photo)

</div>

@Html.DisplayFor(model => model.Photo)

</div>

@Html.DisplayNameFor(model => model.AlternateText)

</div>

@Html.DisplayFor(model => model.AlternateText)

</div>

</fieldset>

<p>

@Html.ActionLink("Edit", "Edit", new { id=Model.Id }) |

@Html.ActionLink("Back to List", "Index")

</p>

Replace the above marking code with the following code

<div class="display-label">
@Html.DisplayNameFor(model => model.Photo)
</div>
<div class="display-field">
<img src="@Url.Content(@Model.Photo)" alt="@Model.AlternateText" />
</div>

we are using Url.Content() html helper method. This method resolves a url for a resource when we pass it the relative path.

Now run your application and output will be

http://localhost:3831/Home/Details/1

Customize HTML helper in asp.net mvc

We are making image tag, by passing values of "src" and "alt" attributes. Like following

Here if we want to create own HTML helper through that method we can pass image and alt text only using with that our view will not look complicated.MVC doesn’t have image() html helper so we can create it which accept image and alt text, like following

@Html.Image(Model.Photo, Model.AlternateText)

Basically HTML helper return a string ,like for generating a text box we use following code

@Html.TextBox("TextBox Name")

So, here TextBox() is an extension method defined in HtmlHelper class. In the above code, Html is the property of the View, which returns an instance of the HtmlHelper class.

now add, Image() extension method, to HtmlHelper class.
1. Right click on MVCDemoProject application and add a "CustomHtmlHelpers" folder.
2. Again Right click on "CustomHtmlHelpers" folder and add a with the name "CustomHtmlHelpers.cs".
3. Write the following code. TagBuilder class is available in System.Web.Mvc namespace.

namespace MVCDemoProject.CustomHtmlHelpers
{
public static class CustomHtmlHelpers
{
  public static IHtmlString Image(this HtmlHelper helper, string src, string alt)
{
  // Build <img> tag
  TagBuilder tb = new TagBuilder("img");
  // Add "src" attribute
tb.Attributes.Add("src", VirtualPathUtility.ToAbsolute(src));
  // Add "alt" attribute
tb.Attributes.Add("alt", alt);
  // return MvcHtmlString. This class implements IHtmlString
// interface. IHtmlStrings will not be html encoded.
  return new MvcHtmlString(tb.ToString(TagRenderMode.SelfClosing));
}
}
}

To use the custom Image() html helper in Details.cshtml view, then include the following using statement in “Details.cshtml

@using MVCDemo.CustomHtmlHelpers;

As we intend to use this Image() html helper, in all our views, let's include"MVCDemo.CustomHtmlHelpers" namespace in web.config. This eliminates the need to include the namespace, in every view.

<system.web.webPages.razor>
  <pages pageBaseType="System.Web.Mvc.WebViewPage">
  <namespaces>
  <add namespace="System.Web.Mvc" />
  <add namespace="System.Web.Mvc.Ajax" />
  <add namespace="System.Web.Mvc.Html" />
  <add namespace="System.Web.Routing" />
  <add namespace="MVCDemo.CustomHtmlHelpers" />
  </namespaces>
  </pages>
  <host ....../>
</system.web.webPages.razor>

If you intend to use the Image() custom html helper, only with a set of views, then, include a web.config file in the specific views folder, and then specify the namespace in it.

Jquery calendar in asp.net MVC

noreply@blogger.com (Munesh Sharma) — Sat, 26 Sep 2015 07:55:00 +0000

Here we will learn how to use Jquery in Asp.net MVC and we will create a DateTime picker using Jquery.

Open visual studio and create a new project an select a MVC4 application then you select a “Internet application and click OK

If you want to use Empty instead of internet application then you need to add some Jquery script and css these jquery script is available when we create project using internet application.

You can copy these Content and script folder from this internet application and put it in empty template project.

Step(1):- Go to Sql Server management system and execute following script.

create database MVCVariousAttribute

use MVCVariousAttribute

Create table Student

(

Id int primary key identity,

FullName nvarchar(100),

Gender nvarchar(10),

Age int,

AdmissionDate DateTime,

EmailAddress nvarchar(100),

WinningPrize int,

PersonalWebSite nvarchar(100)

)

Insert into Student values

('Munesh Sharma', 'Male', 25, '2005-05-05 16:53:36.975', 'Munesh@gmail.com', 45000,'http://dotnet-munesh.blogspot.in/')

Insert into Student values

('Rahul Sharma', NULL, 30, '2006-06-06 17:42:25.865', 'Rahul@gmail.com', 35000,'http://dotnet-munesh.blogspot.in/')

Step(2):- Go to Visual studio and add a new project -> Select “Asp.Net MVC4 Web Application” and give the name for this ,In my case it is “JqueryCalendar” -> Select a Project template as Empty and View engine is “Razor”, Then Click OK

Step(3):- Add “EntityFramework dll” to reference folder in your project if you don’t have then install it through nugget package manager for more go this Go here.

Step(4):- Right click on Model folder and add “Ado.net entity Data Model” and give the name it as “StudentDataModel”, Then click on Add

Step(5): . When You will click Add button here you will see another window for “EntityData modal Wizard” from there you select “Generate From DataBase”, And Click Next.

Give the connection name and select your database then click on next

Step(6) . In this screen select your Database Tables and give Modal Name then click FINISH Button.

When you will click on finish button it will create Student Entity.

Step(7):- Now at this position go to controller folder -> right click on this folder and add a controller with the name “CalendarController”, It will create a Calendar controller , write the following code on this page.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Mvc;

using JqueryCalendar.Models;

namespace JqueryCalendar.Controllers

{

public class HomeController : Controller

{

public ActionResult Details(int id)

{

MVCVariousAttributeEntities _context = new MVCVariousAttributeEntities();

Student _studentDetail = _context.Students.Where(c => c.Id == id).SingleOrDefault();

return View(_studentDetail);

}

// GET: /Home/Create

public ActionResult Create()

{

return View();

}

// POST: /Home/Create

[HttpPost]

public ActionResult Create(FormCollection collection)

{

try

{

// TODO: Add insert logic here

return RedirectToAction("Index");

}

catch

{

return View();

}

// GET: /Home/Edit/5

public ActionResult Edit(int id)

{

return View();

}

// POST: /Home/Edit/5

[HttpPost]

public ActionResult Edit(int id, FormCollection collection)

{

try

{

// TODO: Add update logic here

return RedirectToAction("Index");

}

catch

{

return View();

}

// GET: /Home/Delete/5

public ActionResult Delete(int id)

{

return View();

}

// POST: /Home/Delete/5

[HttpPost]

public ActionResult Delete(int id, FormCollection collection)

{

try

{

// TODO: Add delete logic here

return RedirectToAction("Index");

}

catch

{

return View();

}

Step(8):- Next step is that add a view for detail action method so right click on this method -> add view -> Scaffold template as Detail

It will generate a code for Detail view, Now run your application and redirect to the following URL

http://localhost/JqueryCalendar/Calendar/Details/1

It is With Home controller then Detail action method with ID “1”

When we see this output , we see that it is not pretty good means there is no gap in FullName other things so for that we will use attribute.

Step(9):- When we create a application using entityFramework we add a EntityDataModel then we gives connection and select tables that time it create a class in model (Designer class).

Partial this modal.edmx (student.cs class) for making some changes like design is not looking good and for date there is no calander

This auto generated class(modal1.edmx) is a partial class so we can create a another student partial class and we can make changes there.

So in modal folder add a class and give the name as “Student.cs” and write the following code in this class

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel;

namespace JqueryCalendar.Models

{

[MetadataType(typeof(StudentMetaData))]

public partial class Student

{

}

public class StudentMetaData

{

//If you want "FullName" to be displayed as "Full Name",

//use DisplayAttribute or DisplayName attribute.

//[DisplayAttribute(Name="Full Name")]

//[Display(Name = "Full Name")]

[DisplayName("Full Name")]

public string FullName { get; set; }

public DateTime? AdmissionDate { get; set; }

// If gender is NULL, "Gender not specified" text will be displayed.

[DisplayFormat(NullDisplayText = "Gender not specified")]

public string Gender { get; set; }

//If you don't want to display a column use ScaffoldColumn attribute.

//This only works when you use @Html.DisplayForModel() helper

[ScaffoldColumn(false)]

public int? WinningPrize { get; set; }

}

At this point Run your application and go to following URl and output will be

http://localhost:43552/Calendar/Edit/1

Here you will see that Admission Date text box having date and here user have to put date manually which is not a good practice there should be a calendar so that user can enter any date according to particular format.

The following is the convention used by MVC to find the customized templates
1. The customized display templates must be in a sub-folder that is named -DisplayTemplates. Editor templates must be in a sub-folder that is named -EditorTemplates.
2. These sub-folders can live in "Shared" folder, or a specific views folder. If these folders are present in the Shared folder, then the templates are available for all the views. If they are in a specific views folder, then, they are available only for that set of views.
3. The name of the template must match the name of the type. For example, as we are customizing DateTime template, the name of the template in this case has to be DateTime.ascx or DateTime.cshtml.

Adding a Custom DateTime Editor template
Step 1: If "Shared" folder does not already exists in your project(In View Folder), right click on the project in solution explorer and add it. In shared folder file is available to entire project for all the view.

Step 2: Right click on the "Shared" folder, and add a "EditorTemplates" folder.

Step 3: Right click on "EditorTemplates" folder and add a view with name = DateTime

this view name should match with the property type here with have property type name is DateTime

Step 4: Copy and paste the following code in DateTime.cshtml partial view@model DateTime?
@Html.TextBox("", (Model.HasValue ? Model.Value.ToString("dd/MM/yyyy") :string.Empty), new { @class = "date" })

Note: Please refer to the following MSDN articel for all the DateTime format strings
http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx

Step 5: Copy and paste the following code in Edit.cshtml view
@model MVCDemo.Models.Employee
@{
ViewBag.Title = "Edit";
}

<h2>Edit</h2>

<script src="~/Scripts/jquery-1.7.1.min.js" type="text/javascript"></script>
<script src="~/Scripts/jquery-ui-1.8.20.min.js" type="text/javascript"></script>
<link href="~/Content/Site.css" rel="stylesheet" type="text/css" />
<link href="~/Content/themes/base/jquery.ui.all.css" rel="stylesheet" type="text/css" />

<script type="text/javascript">
$(function()
{
$("input:text.date").datepicker(
{
dateFormat: "dd/mm/yy"
});
});
</script>

@using (@Html.BeginForm())
{
  @Html.EditorForModel()
  <br />
  <input type="submit" value="Save" />
}

Note: Please refer to the following jQuery link for DateTime format strings
http://jqueryui.com/resources/demos/datepicker/date-formats.html

The following jQuery scripts and css files are required for jQuery DateTime picker control. However, these files may change depending on the version of jQuery you are working with.
Scripts/jquery-1.7.1.min.js
Scripts/jquery-ui-1.8.20.min.js
Content/Site.css
Content/themes/base/jquery.ui.all.css

Now run your application you will see that datepicker at admission Date text box