Software Behaviour: April 2014

Sunday, 27 April 2014

How to Remove GridView Columns In ASP.NET.

Objective:-How to Remove GridView Columns In ASP.NET

STEPS :-

STEP:- 1 CREATE NEW PROJECT.

Go to File -> New -> Project -> Select asp.net web forms application -> Entry Application Name -> Click OK.

STEP:-2 Attach "jquery-1.7.1.min" file in Scripts Folder

********HTML Code***************

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Remove Column From GridView Demo</title>
<style type="text/css">
body
{
font-family: Arial;
font-size : 10pt;
}
</style>
<script type="text/javascript" src="Script/jquery-1.7.1.min.js" ></script>
<script type="text/javascript" language="javascript">
$(document).ready(function() {
$("#<%=gdRows.ClientID%> th").click(function() {
var iIndex = $(this).closest("th").prevAll("th").length;
$(this).parents("#<%=gdRows.ClientID%>").find("tr").each(function() {
$(this).find("td:eq(" + iIndex + ")").remove();
$(this).find("th:eq(" + iIndex + ")").remove();
});
});
$("#<%=gdRows.ClientID%> th").mouseover(function() {
$(this).css('cursor','pointer');
});
});
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<b>Click on the column to remove the column.</b>
<br />
<br />
<asp:GridView ID="gdRows" runat="server" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" Font-Names="Arial" Font-Size="Small" GridLines="Vertical">
<RowStyle BackColor="#EEEEEE" ForeColor="Black" />
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="#DCDCDC" />
</asp:GridView>
<br /><br />
<asp:Button ID="btnReset" Text="Reset" runat="server" OnClick="btnReset_Click" />
</div>
</form>
</body>
</html>

********C# Code***************

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
BindGrid();
}
private void BindGrid()
{
DataTable dt = new DataTable();
DataColumn dc;
dc = new DataColumn();
dc.ColumnName = "ID";
dc.DataType = System.Type.GetType("System.Int32");
dt.Columns.Add(dc);
dc = new DataColumn();
dc.ColumnName = "ProductName";
dt.Columns.Add(dc);
dc = new DataColumn();
dc.ColumnName = "Quantity";
dc.DataType = System.Type.GetType("System.Int32");
dt.Columns.Add(dc);
dc = new DataColumn();
dc.ColumnName = "Price";
dc.DataType = System.Type.GetType("System.Int32");
dt.Columns.Add(dc);
DataRow dr;
dr = dt.NewRow();
dr["ID"] = 1;
dr["ProductName"] = "Mouse";
dr["Quantity"] = 10;
dr["Price"] = 100;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = 2;
dr["ProductName"] = "Speaker";
dr["Quantity"] = 15;
dr["Price"] = 990;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = 3;
dr["ProductName"] = "Hard Drive";
dr["Quantity"] = 35;
dr["Price"] = 3990;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = 4;
dr["ProductName"] = "Ram";
dr["Quantity"] = 22;
dr["Price"] = 399;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = 5;
dr["ProductName"] = "Keyboard";
dr["Quantity"] = 20;
dr["Price"] = 350;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = 6;
dr["ProductName"] = "Router";
dr["Quantity"] = 1;
dr["Price"] = 3990;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = 7;
dr["ProductName"] = "LCD";
dr["Quantity"] = 62;
dr["Price"] = 3000;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = 8;
dr["ProductName"] = "Processor";
dr["Quantity"] = 5;
dr["Price"] = 7000;
dt.Rows.Add(dr);
gdRows.DataSource = dt;
gdRows.DataBind();
}
protected void btnReset_Click(object sender, EventArgs e)
{
BindGrid();
}
}

Saturday, 19 April 2014

How to HighLight Rows of GridView In ASP.NET.

Objective:-How to HighLight Rows of GridView In ASP.NET.

STEPS :-

STEP:- 1 CREATE NEW PROJECT.

Go to File -> New -> Project -> Select asp.net web forms application -> Entry Application Name -> Click OK.

STEP:-2 Attach jquery-1.7.1.min file in Scripts Folder

********HTML Code***************

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Highlight GridView Rows on Checkbox Change</title>
<style type="text/css">
body
{
font-family: Arial;
font-size : 10pt;
}
.links
{
font-weight: bold;
}
</style>
<script type="text/javascript" src="Scripts/jquery-1.7.1.min.js"></script>
<script type="text/javascript" language="javascript">
$(document).ready(function()
{
$('#<%=gdRows.ClientID %>').find('input:checkbox[id$="chkDelete"]').click(function() {
var isChecked = $(this).prop("checked");
var $selectedRow = $(this).parent("td").parent("tr");
var selectedIndex = $selectedRow[0].rowIndex;
var sColor = '';
if(selectedIndex%2 == 0)
sColor = 'PaleGoldenrod';
else
sColor = 'LightGoldenrodYellow';
if(isChecked)
$selectedRow.css({
"background-color" : "DarkSlateBlue",
"color" : "GhostWhite"
});
else
$selectedRow.css({
"background-color" : sColor,
"color" : "black"
});
});
});
</script>
</head>
<body>
<form id="form1" runat="server">
<br />
<br />
<asp:GridView ID="gdRows" runat="server" BackColor="LightGoldenrodYellow" BorderColor="Tan"
BorderWidth="1px" CellPadding="6" Font-Names="Arial" Font-Size="Small" GridLines="None"
AutoGenerateColumns="False" ForeColor="Black" Width="36%">
<FooterStyle BackColor="Tan" />
<PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
<HeaderStyle BackColor="Tan" Font-Bold="True" HorizontalAlign="Left" />
<AlternatingRowStyle BackColor="PaleGoldenrod" />
<RowStyle HorizontalAlign="Left" />
<Columns>
<asp:TemplateField HeaderText=" ">
<ItemTemplate>
<asp:CheckBox ID="chkDelete" runat="server" />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField ShowHeader="true" DataField="ID" HeaderText="ID"></asp:BoundField>
<asp:BoundField ShowHeader="true" DataField="ProductName" HeaderText="Product Name">
</asp:BoundField>
<asp:BoundField ShowHeader="true" DataField="Quantity" HeaderText="Quantity"></asp:BoundField>
<asp:BoundField ShowHeader="true" DataField="Price" HeaderText="Price"></asp:BoundField>
</Columns>
</asp:GridView>
</form>
</body>
</html>

********C# Code***************

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
BindGrid();
}
private void BindGrid()
{
DataTable dt = new DataTable();
DataColumn dc;
dc = new DataColumn();
dc.ColumnName = "ID";
dc.DataType = System.Type.GetType("System.Int32");
dt.Columns.Add(dc);
dc = new DataColumn();
dc.ColumnName = "ProductName";
dt.Columns.Add(dc);
dc = new DataColumn();
dc.ColumnName = "Quantity";
dc.DataType = System.Type.GetType("System.Int32");
dt.Columns.Add(dc);
dc = new DataColumn();
dc.ColumnName = "Price";
dc.DataType = System.Type.GetType("System.Int32");
dt.Columns.Add(dc);
DataRow dr;
dr = dt.NewRow();
dr["ID"] = 1;
dr["ProductName"] = "Mouse";
dr["Quantity"] = 10;
dr["Price"] = 100;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = 2;
dr["ProductName"] = "Speaker";
dr["Quantity"] = 15;
dr["Price"] = 990;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = 3;
dr["ProductName"] = "Hard Drive";
dr["Quantity"] = 35;
dr["Price"] = 3990;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = 4;
dr["ProductName"] = "RAM";
dr["Quantity"] = 22;
dr["Price"] = 399;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = 5;
dr["ProductName"] = "Wireless Keyboard";
dr["Quantity"] = 10;
dr["Price"] = 3500;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = 6;
dr["ProductName"] = "Wi-Fi Router";
dr["Quantity"] = 1;
dr["Price"] = 3990;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = 7;
dr["ProductName"] = "LCD";
dr["Quantity"] = 62;
dr["Price"] = 3000;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = 8;
dr["ProductName"] = "Intel Processor";
dr["Quantity"] = 5;
dr["Price"] = 7000;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = 9;
dr["ProductName"] = "Monitor";
dr["Quantity"] = 25;
dr["Price"] = 1990;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = 10;
dr["ProductName"] = "Keyboard";
dr["Quantity"] = 20;
dr["Price"] = 350;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["ID"] = 11;
dr["ProductName"] = "headphones";
dr["Quantity"] = 12;
dr["Price"] = 500;
dt.Rows.Add(dr);
gdRows.DataSource = dt;
gdRows.DataBind();
}
}

Wednesday, 16 April 2014

Show msg. after selecting color In Check Box

Write a program to display message after selecting color as per Check Box list.

********HTML Code***************
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div style="margin-left:30px; height: 236px; color: #008000;">

<br />
Select Your favourite Color:<br />
<br />
<asp:CheckBox ID="CheckBox1" runat="server" text="Blue" ForeColor="Blue"/>
<asp:CheckBox ID="CheckBox2" runat="server" text="red" ForeColor="Red"/>

<br />
<br />
<asp:Button ID="Button1" runat="server" Text="Show" onclick="Button1_Click1" />

   
<asp:Label ID="Label1" runat="server" ForeColor="#003366" Text="Label"></asp:Label>

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

********C# Code***************
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class display_message_after_selecting_color_as_per_Check_Box : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click1(object sender, EventArgs e)
{
Label1.Text = "Ok! your favourite color is/are ";
string color = "";
if (CheckBox1.Checked)
{
// Response.Write("<font color='blue'>Blue</font>");
Label1.Text += "<font color='blue'> Blue </font>";
color += " Blue ";
}

if (CheckBox2.Checked)
{
//Response.Write("<font color='red'>Red</font>");
Label1.Text += "<font color='red'> Red </font>";
color += " Red ";
}
Response.Write("<script>alert('your favourite color is/are" + color + "')</script>");
}
}

Use of Post Back in ASP.NET

Create a Web Site to show the Post Back property of Web pages.

********HTML Code***************

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div style="margin-left:20px;">
<br />
<asp:Label ID="Label1" runat="server" Text="Click Here" ForeColor="#003300"></asp:Label>
<br />
<br />
<asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" />
</div>
</form>
</body>
</html>

********HTML Code***************

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Post_Back : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Label1.Text = "Page is not in Post back";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Label1.Text = "Page is in post back";
}
}

Monday, 14 April 2014

Calculate Total amount of a particular product

Write a program to Calculate Total amount of a particular product purchased by customers.

********HTML***************

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div style="margin-left:40px; height: 235px;">

<br />
Product : -
<asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem>ICE-Cream</asp:ListItem>
</asp:DropDownList>
<br />
<br />
Price : -    
<asp:DropDownList ID="DropDownList2" runat="server">
<asp:ListItem>20</asp:ListItem>
</asp:DropDownList>
<br />
<br />
Quantity : -<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<br />
<br />
<asp:Button ID="Button1" runat="server" Text="Total" onclick="Button1_Click" />
       
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>

</div>
</form>
</body>

</html>

********C# Code***************
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Product_of_Item : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
Label1.Text = "Total is :-"+Convert.ToInt32(TextBox1.Text) * Convert.ToInt32(DropDownList2.SelectedValue);
}
}

Sunday, 13 April 2014

How to Display Date Time And Message in ASP.NET

Create a Web Site to display Message as shown in output to Handling Events and Post backs property Of Web page also display Current date & time in a label.

******HTML Code*****************************

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div style="Margin-left:38px; height: 206px;">
<br />
Enter Your Name :
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<br />
<br />
 <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
<br />
<br />
 <asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>
<br />
<br />
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Show" />
</div>
</form>
</body>
</html>

******C# Code*****************************

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Display_Date_Time_And_Message : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
Label1.Text = TextBox1.Text + " " + "Welcome To Facebook";
Label2.Text = DateTime.Now.ToString();
}
}

Menu

Sunday, 27 April 2014

How to Remove GridView Columns In ASP.NET.

Saturday, 19 April 2014

How to HighLight Rows of GridView In ASP.NET.

Wednesday, 16 April 2014

Show msg. after selecting color In Check Box

Use of Post Back in ASP.NET

Monday, 14 April 2014

Calculate Total amount of a particular product

Sunday, 13 April 2014

How to Display Date Time And Message in ASP.NET