1) Open Visual Studio 2015.
2) Select File –> New –> Project
3) In the “New Project” window, select Templates –> Visual C# –> ASP.NET Web Application. Give valid name and select location then click “OK”.
4) During this post, ASP.Net 5 is in Preview. So in the next screen you can see the “ASP.Net 5 Preview Template” and select “Website”.
5) That’s it! You have created ASP.Net 5 website. It looks like below:
Happy Coding!!!
In my previous articles I have explained various of tips and tricks for Visual studio. In this post i ‘m going to explain various ways that are available to open the Visual Studio IDE.
Way #1:
Click the Start button and type “v” in the “search” box. It will listed the programs (including Visual Studio) and select the Visual Studio.
Way #2:
Click “Start” button and type “devenv” in “Search” box. “Devenv” is the short form for “Development Environment”, which denotes Visual Studio in Windows OS.
Way #3:
Windows 7 offers the concept called “pin and unpin the programs” in task bar. Just pin the Visual Studio in task bar as shown below. This is another shortcut to open VS in a quicker manner.
CREATE TABLE [dbo].[tblEmployee]( [EmpID] [int] NOT NULL, [EmpName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [EmpAge] [int] NOT NULL, CONSTRAINT [PK_tblEmp] PRIMARY KEY CLUSTERED ( [EmpID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY]
insert into tblEmployee values (1,'Francis',30); insert into tblEmployee values (2,'Ram',25); insert into tblEmployee values (3,'Arul',25); insert into tblEmployee values (4,'Prabhu',30);
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="GridviewDemo.aspx.cs" Inherits="DemoWebApp.GridviewDemo" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="gvEmployee" runat="server" EmptyDataText="No Records Found" AutoGenerateColumns="false" >
<Columns>
<asp:BoundField HeaderText="SNo" DataField="EmpID" />
<asp:BoundField HeaderText="Employee Name" DataField="EmpName" />
<asp:BoundField HeaderText="Age" DataField="EmpAge" />
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
// Bind the grid
gvEmployee.DataSource = GetDataFromDB();
gvEmployee.DataBind();
}
}
The below function is used to get data from Database and return a data table.
private DataTable GetDataFromDB()
{
DataTable dt = new DataTable();
// Read Connection String from WebConfig
string strConString = ConfigurationManager.ConnectionStrings["MyConString"].ToString();
// Create connection object
using (SqlConnection con = new SqlConnection(strConString))
{
string strQuery = "Select * from tblEmployee";
// open connection
con.Open();
// create command object
SqlCommand cmd = new SqlCommand(strQuery, con);
// create adapter
SqlDataAdapter da = new SqlDataAdapter(cmd);
// execute query and fill the data into datatable
da.Fill(dt);
}
return dt;
}
We are going to define the following "style" classes in the aspx file itself. These classes are going to be used in JQuery to highlight the row/cell.
<style type="text/css">
.selectedCell {
background-color: lightblue;
}
.unselectedCell {
background-color: white;
}
</style>
// Highlight the row when mouse over on it
$(document).ready(function () {
$('#gvEmployee tr').hover(function () {
$(this).addClass('selectedCell');
}, function () { $(this).removeClass('selectedCell'); });
});
Include the below JQuery code if you want to highlight the cell instead of row: // Highlight the cell when mouse over on it
$(document).ready(function () {
$('#gvEmployee td').hover(function () {
$(this).addClass('selectedCell');
}, function () { $(this).removeClass('selectedCell'); });
});
//Highlight the cell when the row clicked
$(function () {
$(document).on('click', '#gvEmployee tr', function () {
$("#gvEmployee tr").removeClass('selectCell');
$(this).addClass('selectCell');
});
});
Include the below Jquery code if you want to highlight the cell when the particular cell clicked.
//Highlight the cell when the row clicked
$(function () {
$(document).on('click', '#gvEmployee tr', function () {
$("#gvEmployee tr").removeClass('selectCell');
$(this).addClass('selectCell');
});
});
protected void gvEmployee_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
int age = Convert.ToInt32(e.Row.Cells[2].Text.ToString());
if (age >= 25 && age < 30)
{
e.Row.BackColor = Color.GreenYellow;
}
if (age == 30)
{
e.Row.BackColor = Color.LightBlue;
}
}
}
The output is look alike below:
 |
| Highlight Rows on Databound |
protected void gvEmployee_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
int age = Convert.ToInt32(e.Row.Cells[2].Text.ToString());
if (age >= 25 && age < 30)
{
e.Row.Cells[2].BackColor = Color.GreenYellow;
}
if (age == 30)
{
e.Row.Cells[2].BackColor = Color.LightBlue;
}
}
}
The above code output like below: |
| Highlight Column on Databound |
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="lbl" runat="server" Text="Select a file to upload:"></asp:Label>
<asp:FileUpload runat="server" ID="fu" /><br />
<asp:Button runat="server" ID="btnUpload" Text="Upload" OnClick="btnUpload_Click" />
</div>
</form>
</body>
</html>
protected void btnUpload_Click(object sender, EventArgs e)
{
// Check that upload control had file
if(fu.HasFile)
{
// Get the Posted File
HttpPostedFile pf = fu.PostedFile;
Int32 fileLen;
// Get the Posted file Content Length
fileLen = fu.PostedFile.ContentLength;
// Create a byte array with content length
Byte[] Input = new Byte[fileLen];
// Create stream
System.IO.Stream myStream;
// get the stream of uploaded file
myStream = fu.FileContent;
// Read from the stream
myStream.Read(Input, 0, fileLen);
// Create a Document
Document doc = new Document();
// create PDF File and create a writer on it
PdfWriter writer = PdfWriter.GetInstance(doc, new FileStream(string.Concat(Server.MapPath("~/Pdf/PdfSample"), ".pdf"), FileMode.Create));
// open the document
doc.Open();
// Add the text file contents
doc.Add(new Paragraph(System.Text.Encoding.Default.GetString(Input)));
// Close the document
doc.Close();
}
}
