Wednesday, 19 June 2013

How to create Default Text (SearchBox) in TextBoxes

In this recipe, let's see how to create a search box in ASP.NET with some default information text. The text is displayed only when the search box is out of focus.
Getting ready 1. Add a new web form Recipe1.aspx to the current project.
2. Add a TextBox field with a Search button to the form as below:
3. The CSS class defaultText attached to the TextBox is defined as below:
.defaultText { font-style:italic;
color:#CCCCCC; }

How to do it… 1. In the document.ready() function, retrieve the TextBox control using its ClientID
and save in a local variable:
var searchBox = $('#<%=TextBox1.ClientID%>') ;
2. On the focus event, check if it contains the default text:
searchBox.focus( function() {
if (searchBox.val() == this.title) {
The ToolTip property of the ASP.NET TextBox control is rendered
as title at runtime. Thus, the ToolTip text Enter your search keyword here is retrieved using this.title.
3. If yes, then remove the defaultText css style:searchBox.removeClass("defaultText");
4. Also clear the search field:
searchBox.val("");
} }); 5. On the blur event, check if the TextBox is empty:
searchBox.blur( function() {
if (searchBox.val() == "") {
6. If yes, then attach the "defaultText" css style:
searchBox.addClass("defaultText");
7. Add the default information text to the search field:
searchBox.val(this.title); } });
8. Call the blur event on page load so that the TextBox is initially out of focus:
searchBox.blur();
[code]

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <script src="Scripts/jquery-1.4.1.js" type="text/javascript"></script>
    <link href="StyleSheet.css" rel="stylesheet" type="text/css"></link>
    <script type="text/javascript">
    $(document).ready(function() {
    var searchBox = $('#<%=TextBox1.ClientID%>');
    searchBox.focus(
    function() {
        if (searchBox.val() == this.title) {
            searchBox.removeClass("defaultText");
            searchBox.val("");
        }
    });
    searchBox.blur(
    function () {
        if (searchBox.val() == "") {
            searchBox.addClass("defaultText");
            searchBox.val(this.title);
        }
    });
searchBox.blur();
});
</script>

</head>
<body>
    <form id="form1" runat="server">
   <div align="center">
    <fieldset style="height: 80px; width: 400px;">
    <asp:textbox cssclass="defaultText" id="TextBox1" runat="server" tooltip="Enter your search keyword here" width="200px"></asp:textbox>
    <asp:button id="btnSubmit" runat="server" text="SEARCH">
    

    </asp:button>
    </fieldset>
</div>
</form>
</body>
</html>

[/code]

What is Team Foundation Server

20:48 TFS No comments

Introduction to TFS

TFS stands for Team Foundation Server which is developed by Microsoft. Integration of TFS with Visual Studio enables a team to work together and organize their efforts to complete a project. Dot Net developers use TFS for source control, bug tracking, requirement gathering and to manage complete life cycle of software development. It has below listed features:-

Communication Enhancement

TFS enhance the communication among team members by ensuring that no information or work is lost when a team member hand over his task to team. Project of the team is stored on the TFS and every team member has its own credentials to connect to TFS for accessing the project. TFS provides a central location to team project and each team member coordinate his work at this location.
Team Explorer

All members of a team work together on the team project by using Team Explorer in Visual Studio. Team Explorer connects to the TFS and displays team projects from the server. By using Team Explorer, every team member can get updated work items, projects documents and task to do.
Roles

Roles can be defined on team project that is on TFS. Each role represents one or more disciplines that are required to successful completion of the team project.
Alerts

TFS also provides alerts that are sent to team members by e-mail when something has changed on the team project. We can customize alerts on TFS according to our need.
Source Control

TFS allow the team to manage all source files for a project. We can also add non-source files such as important project documents, project plans etc. to TFS.
Builds

TFS Build enables the team to create and manage product builds regularly. TFS Build also provides build reports on the status and quality of each build.
Tracking Work Status

Using TFS project head can track the assigned work status to developers to understand the health of the project.
Work Item History

All working items are logged on TFS with all changes. Anyone can review the complete history of activity on a work item at any time. The working item history can be exported into Microsoft Excel.
Reports

Reports related to track status and information (like as work item changes, check-ins and status of product builds etc.) about the project are stored in a database on the TFS.

How to apply css to text box control

21:26 No comments

How to apply css to text box control Create Website:- 1) Open Visual Studio 2) File->New Website->Give Website name and path. 3) Choose C# Paste below code in your aspx file. [code]

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



    How to apply css to text box control

[/code]

How to Edit/Update Gridview Row..

03:41 Grid View No comments

How to Edit/Update Gridview Row..

In This Article I will show you , How Can we Edit/Update Gridview Row.Below I am showing GridView data

If We Want to Edit any Row .Press Edit then We will Get Update and Cancel button .Simply We can Update Row value.

GridWithEditEvent.aspx

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

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

</head>

<body>

<div>

<asp:GridView ID="gridview" runat="server" AutoGenerateColumns="False"

onrowcancelingedit="onRowCancelingEdit" onrowediting="OnRowEdit"

onrowupdating="OnRowUpdate" GridLines="None" Width="67%" Style="text-align: left" BackColor="#99CCFF">

<asp:TemplateField HeaderText="Student Id">

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

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField>

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

</ItemTemplate>

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

</EditItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Student RollNo">

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

</ItemTemplate>

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

</EditItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Student Course">

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

</ItemTemplate>

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

</EditItemTemplate>

</asp:TemplateField>

<asp:TemplateField>

<asp:LinkButton ID="lnkbtn" runat="server" CommandName="Edit">Edit</asp:LinkButton>

</ItemTemplate>

<asp:LinkButton ID="lnkupdate" runat="server" CommandName="Update">Update</asp:LinkButton>

<asp:LinkButton ID="lnkcancel" runat="server" CommandName="Cancel">Cancel</asp:LinkButton>

</EditItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

</div>

</form>

</body>

</html>

GridWithEditEvent.aspx.cs[CodeBehind Page]

using System;

using System.Data;

using System.Data.SqlClient;

using System.Web.UI.WebControls;

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

{

SqlConnection con = new SqlConnection(@"Data Source=RAM-PC\SQLEXPRESS;Initial Catalog=CMC;integrated security=true");

SqlDataAdapter adap = null;

DataSet ds = null;

//int rowNo;

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

GetStudentData();

}

private void GetStudentData()

{

adap = new SqlDataAdapter("select * from Student", con);

ds = new DataSet();

adap.Fill(ds, "Student");

gridview.DataSource = ds.Tables["Student"];

gridview.DataBind();

}

protected void OnRowEdit(object sender, GridViewEditEventArgs e)

{

gridview.EditIndex = e.NewEditIndex;

GetStudentData();

}

protected void OnRowUpdate(object sender, GridViewUpdateEventArgs e)

{

int studentid =Convert.ToInt32( ((Label)gridview.Rows[e.RowIndex].FindControl("id")).Text);

string studentName = ((TextBox)gridview.Rows[e.RowIndex].FindControl("txtname")).Text;

int studentRollNo = Convert.ToInt32(((TextBox)gridview.Rows[e.RowIndex].FindControl("txtrollno")).Text);

string studentCourse = ((TextBox)gridview.Rows[e.RowIndex].FindControl("txtCourse")).Text;

string query = "update Student set Name='"+studentName+"',RollNo='"+studentRollNo+"',Course='"+studentCourse+"' where StudentId="+studentid+"";

con = new SqlConnection(@"Data Source=RAM-PC\SQLEXPRESS;Initial Catalog=CMC;integrated security=true");

con.Open();

SqlCommand cmd = new SqlCommand(query, con);

SqlDataAdapter adap = new SqlDataAdapter(cmd);

int n = adap.SelectCommand.ExecuteNonQuery();

if (n > 0)

{

gridview.EditIndex = -1;

GetStudentData();

Response.Write("Data Updated successfully");

}

protected void onRowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

gridview.EditIndex = -1;

GetStudentData();

}

How to make ImageRotator with JQUERY in ASP.Net

02:39 JQUERY 1 comment

How to make ImageRotator with JQUERY in ASP.Net

Here I am writing a simple Jquery Code that is in Bold lettters.

Code

<%@ Master Language="C#" AutoEventWireup="true" CodeFile="Main.master.cs" Inherits="Main" %>

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

<script src="Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>

<script type="text/javascript">

$(function () {

// create the image rotator

setInterval("rotateImages()", 2000);

});

function rotateImages() {

var oCurPhoto = $('#photoShow div.current');

var oNxtPhoto = oCurPhoto.next();

if (oNxtPhoto.length == 0)

oNxtPhoto = $('#photoShow div:first');

oCurPhoto.removeClass('current').addClass('previous');

oNxtPhoto.css({ opacity: 0.0 }).addClass('current').animate({ opacity: 1.0 }, 1000,

function () {

oCurPhoto.removeClass('previous');

});

}

</script>

#photoShow {

position: absolute;

height: 200%;

width: 800px;

margin: -100px 0 0 -200px;

top: 32%;

left: 32%;

}

#photoShow div {

position:absolute;

z-index: 0;

}

#photoShow div.previous {

z-index: 1;

}

#photoShow div.current {

z-index: 2;

}

</style>

</head>

<body>

<div>

<asp:Image ID="imgrotat1" ImageUrl="~/Images/1.png" runat="server" />

</div>

<div>

<asp:Image ID="imgrotat2" ImageUrl="~/Images/2.png" runat="server" />

</div>

<div>

<asp:Image ID="imgrotat3" ImageUrl="~/Images/3.png" runat="server" />

</div>

<div>

<asp:Image ID="imgrotat4" ImageUrl="~/Images/4.png" runat="server" />

</div>

<div>

<asp:Image ID="imgrotat5" ImageUrl="~/Images/5.png" runat="server" />

</div>

</form>

</body>

</html>

How ASP.NET Web Pages are Processed on the Web Server

00:28 ASP.NET No comments

How ASP.NET Web Pages are Processed on the Web Server

Step 1: The Web Server Receives the HTTP Request

The sole task of a Web server is to accept incoming HTTP requests and to return the requested resource in an HTTP response. The 4Guys Web server runs Microsoft's Internet Information Services (IIS) Web server. The first things IIS does when a request comes in is decide how to handle the request. Its decision is based upon the requested file's extension. For example, if the requested file has the .asp extension, IIS will route the request to be handled by asp.dll.

There are numerous file extensions that map to the ASP.NET engine, some of which include:

.aspx, for ASP.NET Web pages,
.asmx, for ASP.NET Web services,
.config, for ASP.NET configuration files,
.ashx, for custom ASP.NET HTTP handlers,
.rem, for remoting resources,
And others!

In the IIS administration screens, you can configure the extension mappings. The screenshot to the right shows the configuration screen for IIS 5.0. You could, for example, add your own custom extensions here. That is, you could have requests for .scott files routed to the ASP.NET engine.

The diagram below illustrates the steps 0 and 1 of a request for an ASP.NET Web page. When a request comes into the Web server, it is routed to the proper place (perhaps asp.dll for classic ASP page requests, perhaps the ASP.NET engine for ASP.NET requests) based on the requested file's extension.

Step 2: Examining the ASP.NET Engine

An initial request for http://mrjsoftware/home.aspx will reach IIS and then be routed to the ASP.NET engine, but what happens next? The ASP.NET engine is often referred to as the ASP.NET HTTP pipeline, because the incoming request passes through a variable number of HTTP modules on its way to an HTTP handler.

HTTP modules are classes that have access to the incoming request. These modules can inspect the incoming request and make decisions that affect the internal flow of the request. After passing through the specified HTTP modules, the request reaches an HTTP handler, whose job it is to generate the output that will be sent back to the requesting browser. The following diagram illustrates the pipeline an ASP.NET request flows through.

There are a number of pre-built HTTP modules that are included in the HTTP pipeline by default. These modules include:

OutputCache, which handles returning and caching the page's HTML output, if needed
Session, which loads in the session state based on the user's incoming request and the session method specified in the Web.config file
FormsAuthentication, which attempts to authenticate the user based on the forms authentication scheme, if used
And others!

In fact, you can see a precise list of what modules are used by default by going to the machine.config file (located in the$WINDOWS$\Microsoft.NET\Framework\$VERSION$\CONFIG directory) and searching for the <httpModules> element. The following shows the default <httpModules> element:

<httpModules>
  <add name="OutputCache" type="System.Web.Caching.OutputCacheModule" />
  <add name="Session" type="System.Web.SessionState.SessionStateModule" />
  <add name="WindowsAuthentication" type="System.Web.Security.WindowsAuthenticationModule" />
  <add name="FormsAuthentication" type="System.Web.Security.FormsAuthenticationModule" />
  <add name="PassportAuthentication" type="System.Web.Security.PassportAuthenticationModule" />
  <add name="UrlAuthorization" type="System.Web.Security.UrlAuthorizationModule" />
  <add name="FileAuthorization" type="System.Web.Security.FileAuthorizationModule" />
  <add name="ErrorHandlerModule" type="System.Web.Mobile.ErrorHandlerModule, 
                                          System.Web.Mobile, Version=1.0.5000.0, 
                                          Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</httpModules>

HTTP handlers are the endpoints in the ASP.NET HTTP pipeline. The job of the HTTP handler is to generate the output for the requested resource. For ASP.NET Web pages, this means rendering the Web controls into HTML and returning this HTML. For a Web service, it would involve executing the specified method and wrapping its return values into an appropriately formatted SOAP response. Different ASP.NET resources use different HTTP handlers. The handlers used by default are spelled out in the machine.config's <httpHandler> section. Entries in this section refer to classes that are either HTTP handlers themselves or are HTTP handler factories. An HTTP handler factory merely returns a suitable HTTP handler instance when invoked.

The following shows a snippet of the <httpHandler> element in the default machine.config file:

<httpHandlers>
  <add verb="*" path="*.vjsproj" type="System.Web.HttpForbiddenHandler" />
  <add verb="*" path="*.java" type="System.Web.HttpForbiddenHandler" />
  <add verb="*" path="*.jsl" type="System.Web.HttpForbiddenHandler" />
  <add verb="*" path="trace.axd" type="System.Web.Handlers.TraceHandler" />
  <add verb="*" path="*.aspx" type="System.Web.UI.PageHandlerFactory" />
  <add verb="*" path="*.ashx" type="System.Web.UI.SimpleHandlerFactory" />
  ...
</httpHandlers>

Realize that you can create your own HTTP modules and HTTP handlers, and then plug them into the pipeline for all Web sites on the Web server by modifying machine.config, or you can add them to a particular Web application by modifying that application's Web.config file. A thorough discussion on using HTTP modules and handlers is far beyond the scope of this article, but realize that you can accomplish some neat things using modules and handlers. For example, you can use HTTP modules to provide a custom URL rewritter, which can be useful for automatically fixing 404 errors to using shorter and user-friendlier URLs.

Step 3: Generating the Output

The final step is for the suitable HTTP handler to generate the appropriate output. This output, then, is passed back through the HTTP modules and then back to IIS, which then sends it back to the client that initiated the request. (If the client was a Web browser, the Web browser would receive this HTML and display it.)

Since the steps for generating the output differ by HTTP handler, let's focus in on one in particular - the HTTP handler that is used to render ASP.NET Web pages. To retrace the initial steps, when a request comes into IIS for an ASP.NET page (i.e., one with a .aspx extension), the request is handed off to the ASP.NET engine. The request then moves through the modules. The request is then routed to the PageHandlerFactory, since in the machine.config's <httpHandler> section we have the mapping:

<httpHandlers>
  ...
  <add verb="*" path="*.aspx" type="System.Web.UI.PageHandlerFactory" />
  ...
</httpHandlers>

The PageHandlerFactory class is an HTTP handler factory. It's job is to provide an instance of an HTTP handler that can handle the request. What PageHandlerFactory does is find the compiled class that represents the ASP.NET Web page that is being requested.

If you use Visual Studio .NET to create your ASP.NET Web pages you know that the Web pages are composed of two separate files: a .aspx file, which contains just the HTML markup and Web controls, and a .aspx.vb or .aspx.cs file that contains the code-behind class (which contains the server-side code). If you don't use Visual Studio .NET, you likely use a server-side <script> block to hold the server-side code. Regardless of what approach you use, when the ASP.NET Web page is first visited after a change to the HTML or Web control content, the ASP.NET engine creates a class that derives from the System.Web.UI.Page class. This dynamically created class is then compiled.

Not coincidentally, the Page class implements IHttpHandler, thereby indicating that it suffices as an HTTP handler. What the PageHandlerFactory does, then, is check to see if a compiled version of the requested ASP.NET Web page's class exists. If not, it dynamically creates this class and compiles it. This class, then, has a particular method invoked which generates the page's complete HTML markup. It's this HTML markup that is then returned to the client. (Have you noticed that when visiting an ASP.NET Web page after making changes to the HTML or Web control content, there is a bit of a delay? This delay is due to the ASP.NET engine needing to recreate and recompile the ASP.NET page's corresponding class.)

Realize that the 011404-1.aspx class might need to first be generated and compiled by the PageHandlerFactory before it can be invoked to generate the HTML. The process of page rendering - which involves obtaining the HTML markup for the requested ASP.NET Web page - is a bit beyond the scope of this article

How can we compare two columns value in same table in MS Sql Server

23:54 SQLQuery No comments

How can we compare two columns value in same table in MS Sql Server

We have one table ExamScore

StudentId	ExamScoreCT1	ExamScoreCT2	TotalMarks
1	87	75	100
2	68	77	100
3	76	91	100
4	88	56	100

we want to compare two compare two Columns ExamScoreCT1 and ExamScoreCT2 of this table
we want to select greater marks between both of colums ExamScoreCT1 and ExamScoreCT2

query :

Csharp Asp.Net Code Examples

Wednesday, 19 June 2013

How to create Default Text (SearchBox) in TextBoxes

Sunday, 9 June 2013

What is Team Foundation Server

Communication Enhancement

Team Explorer

Roles

Alerts

Source Control

Builds

Tracking Work Status

Work Item History

Reports

Monday, 20 May 2013

How to apply css to text box control

Sunday, 19 May 2013

How to Edit/Update Gridview Row..

How to Edit/Update Gridview Row..

How to make ImageRotator with JQUERY in ASP.Net

How to make ImageRotator with JQUERY in ASP.Net

Thursday, 16 May 2013

How ASP.NET Web Pages are Processed on the Web Server

How ASP.NET Web Pages are Processed on the Web Server

Step 1: The Web Server Receives the HTTP Request

Step 2: Examining the ASP.NET Engine

Step 3: Generating the Output

Monday, 13 May 2013

How can we compare two columns value in same table in MS Sql Server

How can we compare two columns value in same table in MS Sql Server

SELECT CASE WHEN ex.ExamScoreCT1 >= ex.ExamScoreCT2 THEN ex.ExamScoreCT1 ELSE ex.ExamScoreCT2 END
FROM ExamScore as ex

Labels

Blog Archive

Wednesday, 19 June 2013

Sunday, 9 June 2013

Communication Enhancement

Team Explorer

Roles

Alerts

Source Control

Builds

Tracking Work Status

Work Item History

Reports

Monday, 20 May 2013

Sunday, 19 May 2013

How to Edit/Update Gridview Row..

How to make ImageRotator with JQUERY in ASP.Net

Thursday, 16 May 2013

How ASP.NET Web Pages are Processed on the Web Server

Step 1: The Web Server Receives the HTTP Request

Step 2: Examining the ASP.NET Engine

Step 3: Generating the Output

Monday, 13 May 2013

How can we compare two columns value in same table in MS Sql Server

SELECT CASE WHEN ex.ExamScoreCT1 >= ex.ExamScoreCT2 THEN ex.ExamScoreCT1 ELSE ex.ExamScoreCT2 ENDFROM ExamScore as ex

Social Profiles

Labels

Blog Archive

SELECT CASE WHEN ex.ExamScoreCT1 >= ex.ExamScoreCT2 THEN ex.ExamScoreCT1 ELSE ex.ExamScoreCT2 END
FROM ExamScore as ex