Dot net Tutorial|What is Dotnet|Free Dotnet|dot net tutorials|advanced dot net tutorial|advanced dot net tutorial

Tuesday, 12 March 2013

Simple login form example in asp.net Check Username and Password availability in database

Introduction:

In this post I will explain how to implement simple login form

using asp.net and I will explain how to Check Username and

Password Exists in database using asp.net .

mouse over in jquerry

<!DOCTYPE html>
<html>
<head>
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js">
</script>
<script>
$(document).ready(function(){
$("p").mouseover(function(){
$("p").css("background-color","yellow");
});
$("p").mouseout(function(){
$("p").css("background-color","lightgray");
});
});
</script>
</head>
<body>

<p>Move the mouse pointer over this paragraph.</p>

</body>
</html>

What is Constructor and Purpose of Constructor in Class

When a class or struct is created, its constructor is called. Constructors have the same name as the class or struct, and they usually initialize the data members of the new object.

In the following example, a class named Taxi is defined by using a simple constructor. This class is then instantiated with the new operator. The Taxi constructor is invoked by the new operator immediately after memory is allocated for the new object.

Multiple Toggless in same page

Description:

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script src="Scripts/jquery.min.1.3.2.js" type="text/javascript"></script>

Exception Handling in SQL Server Stored Procedure with TRY CATCH

Introduction:

Here I will explain how to handle exceptions in SQL Server or exception handling in SQL Server for stored procedure by using try catch or error handling in SQL Server.

Description:

In previous articles I explained Pass table as parameter to stored procedure in SQL Server, Difference between joins in SQL Server, Convert rows to columns in SQL Server, SQL Query to get duplicate records count and many articles relating to SQL Server, jQuery, JavaScript. Now I will explain how to handle exceptions in SQL Server.

To handle exceptions in SQL Server we can use TRY…… CATCH blocks. To use TRY…… CATCH blocks in stored procedure we need to write the query like as shown below

.NET 4 New GAC Locations/GacUtil

This is what I know, let me know if you know otherwise. There are now 2 distinct GAC locations that you have to manage as of the .NET 4 Framework release.

The GAC was split into two, one for each CLR (2.0, 3.5 AND 4.0). The CLR version used for both .NET Framework 2.0 and .NET Framework 3.5 is CLR 2.0. To avoid issues between CLR 2.0 and CLR 4.0 , the GAC is now split into private GAC’s for each runtime. The main change is that CLR v2.0 applications now cannot see CLR v4.0 assemblies in the GAC.

In previous .NET versions, when I installed a .NET assembly into the GAC (using gacutil.exe or even drag and drop to the c:\windows\assembly directory), I could find it in the ‘C:\Windows\assembly’ path.

With .NET 4.0, GAC is now located in the 'C:\Windows\Microsoft.NET\assembly’ path.

In order to install a dll to the .NET 4 GAC it is necessary to use the gacutil found C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin\GacUtil.exe In addition, you can no longer use the drag n' drop (in reality the drag n' drop really executed the gacutil via a windows explorer extension).

After you use the gacutil.exe -i {path to dll} you can view that it is indeed in the gac via gacutil -l (which will list all dlls in the gac). I used this command and piped the results to a text file via > out.txt which made it easier to find the recently added component.

How to Install MVC4 application in VisualStudio.net 2010

HOW TO Install MVC4:

While you start MVC34Application you Must Install " VS 2010 With Sp1 " by using this Following link You can Directly install the MVC3.

http://www.asp.net/mvc

It consisting of MVC3 And MVC4 Tools Updated

MVC 4 using Entity Framework

This article is a brief introduction to the use of unit testing in MVC 4 using Entity Framework with Repository Pattern.

What is Unit testing: The basic purpose of unit testing is to test the methods of business logic of ASP.NET or MVC projects.

What is Entity Framework

Entity Framework (EF) is an object-relational mapper that enables .NET developers to work with relational data using domain-specific objects. It eliminates the need for most of the data-access code that developers usually need to write. For more see: http://msdn.microsoft.com/en-us/data/ef.aspx

DropDown Cascading in MVC4 Using Entity Framework

Getting Started

Create a new Project. Open Visual Studio 2012.
Go to "File" => "New" => "Project...".
Select "Web" in installed templates.
Select "ASP.NET MVC 4 Web Application".
Enter the Name and choose the location.
Click "OK".
I would recommend reading this article first to learn about Entity Framework: http://aspdotnetbylakshmi.blogspot.in/2013/03/mvc-4-using-entity-framework.html

Once you configure Entity Framework your window will look like this:

SELECT, INSERT, UPDATE and DELETE Using LINQ to SQL

Language-INtegrated Query (LINQ) is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages. In other words LINQ has the power of querying on any source of data (Collection of objects, database tables or XML Files). We can easily retrieve data from any object that implements the IEnumerable<T> interface and any provider that implements the IQueryable<T> interface.

Microsoft basically divides LINQ into the following three areas:

LINQ to Object : Queries performed against in-memory data
LINQ to ADO.Net
LINQ to SQL (formerly DLinq) : Queries performed against the relation database; only Microsoft SQL Server is supported.
LINQ to DataSet : Supports queries by using ADO.NET data sets and data tables.
LINQ to Entities : Microsoft ORM solution
LINQ to XML (formerly XLinq) : Queries performed against the XML source.

How to implement cascading dropdownlist in gridview using asp.net.

How to implement cascading dropdownlist in gridview using asp.net.
Introduction:

In this article I will explain how to implement cascading dropdownlist in gridview using asp.net.

Description:

In Previous posts I explained clearly how to implement ajax cascading dropdownlist using asp.net and lot of articles regarding Gridview. Now I will explain how to implement cascading dropdown list in gridview using asp.net. Here I am using previous implemented article ajax cascading dropdownlist in asp.net to bind data to dropdownlists.

After that I am binding the data to gridview for that first design table in database and give name UserInfomation

ColumnName

ColumnName	DataType
UserId	Int(set identity property=true)
UserName	varchar(50)
LastName	varchar(50)
Location	varchar(50)

After completion table creation add ajax reference to your application because here I am using ajax cascading dropdownlists bind to gridview and design your aspx page like this

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajax" %>
<!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>Cascading Dropdownlist Sample</title>
</head>
<body>
<form id="form1" runat="server">
<ajax:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server"/>
<div>
<asp:GridView runat="server" ID="gvdetails" DataSourceID="dsdetails" AllowPaging="true" PageSize="10" AutoGenerateColumns="false" ShowFooter="true">
<RowStyle BackColor="#EFF3FB" />
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:TemplateField HeaderText="UserId">
<ItemTemplate>
<asp:Label ID="lblUserId" runat="server" Text='<%#Eval("UserId") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="UserName">
<ItemTemplate>
<asp:Label ID="lblUserName" runat="server" Text='<%#Eval("UserName") %>'/>
</ItemTemplate>
<FooterTemplate>
<asp:DropDownList ID="ddlCountry" runat="server"></asp:DropDownList>
<ajax:CascadingDropDown ID="CountryCascading" runat="server" Category="Country" TargetControlID="ddlCountry" LoadingText="Loading Countries..." PromptText="Select Country" ServiceMethod="BindCountrydropdown" ServicePath="DropdownWebService.asmx">
</ajax:CascadingDropDown>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="LastName">
<ItemTemplate>
<asp:Label ID="lblLastName" runat="server" Text='<%#Eval("LastName") %>'/>
</ItemTemplate>
<FooterTemplate>
<asp:DropDownList ID="ddlState" runat="server"></asp:DropDownList>
<ajax:CascadingDropDown ID="StateCascading" runat="server" Category="State" TargetControlID="ddlState" ParentControlID="ddlCountry" LoadingText="Loading States..." PromptText="Select State" ServiceMethod="BindStatedropdown" ServicePath="DropdownWebService.asmx">
</ajax:CascadingDropDown>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Location">
<ItemTemplate>
<asp:Label ID="lblLocation" runat="server" Text='<%#Eval("Location") %>'/>
</ItemTemplate>
<FooterTemplate>
<asp:DropDownList ID="ddlregion" runat="server"></asp:DropDownList>
<ajax:CascadingDropDown ID="RegionCascading" runat="server" Category="Region" TargetControlID="ddlregion" ParentControlID="ddlState" LoadingText="Loading Cities..." PromptText="select" ServiceMethod="BindRegiondropdown" ServicePath="DropdownWebService.asmx">
</ajax:CascadingDropDown>
</FooterTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="dsdetails" runat="server" ConnectionString="<%$ConnectionStrings:dbconnection %>"
SelectCommand="select * from UserInformation"/>
</div>
</form>
</body>
</html>
If you observe above code I used ajax cascading dropdownlist to bind in gridview. To bind data to dropdownlist and data tables design check this post ajax cascading dropdownlist using asp.net .After completion of bind data to dropdownlists use above code to place dropdownlist in gridview and bind data to gridview if you have any doubts just download the attached code to and check the details.

Here don’t forgot to set the connection string in web.config file here I am getting database connection from web.config file for that reason you need to set the connectionstring in web.config file like this

<connectionStrings>
<add name="dbconnection" connectionString="Data Source=SureshDasari;Integrated Security=true;Initial Catalog=MySampleDB"/>
</connectionStrings>
Demo

Populate One Asp.net Dropdown based on Selection in Another Dropdown

Populate One Asp.net Dropdown based on Selection in Another Dropdown

Introduction

Here I will explain how to populate one dropdown based on selection in another dropdown asp.net using c#.

Description

I have three dropdowns Country dropwdown, State dropdown, Region dropdown I need to populate states dropdown based on country dropdown and I need to populate region dropdown based on states dropdown for that what we have to do first design three tables in sql server with data like this

Application and the Session level events using Global.asax

Application and the Session level events using Global.asax

This file exposes the application and session level events in ASP.NET and provides a gateway to all the application and the session level events in ASP.NET. This file can be used to implement the important application and session level events such as Application_Start, Application_End, Session_Start, Session_End, etc.

How To Add Color Picker in Firefox:

How To Add Color Picker in Firefox:

    Step1:Go to Tools menu in menu bar --After Select Add-On and click that Add-on .

    Step2:Go to Search in Add-on--Enter COLORPIX and click enter button.

    Step3:Select ColorZilla -Click Install Now

    Step4:After Installation click Restart FireFox

    Step5:After that in Firefox we will see that collorzilla symbol.

How to Get Color of image using colorpickor

    Step6:Take Whatever image .Select which part color you want click colorpick.

    Step7:It will show html color,RGB color codes using that we get Color.

    Steep8:Using that color in paint or Adobe using we will design or past it where you want.

Tuesday, 12 February 2013

Function for validating the Alphabets using javascript

Function for validating the Alphabets
Description:
Using javascript validating form for accepting only alphanumarics its a function in script tag .call that function name in textbox onkeypress="return Alphabets(event);"

Difference between DebugClass and Trace Class

Difference between DebugClass and Trace Class

Debug Class
Provides a set of methods and properties that help debug your code. This class cannot be inherited.
Namespace: System.Diagnostics
Assembly: System (in system.dll)
Syntax:
public sealed class Debug

Insert Update Edit Delete Rows Record In GridView using sqldatasource

Insert Update Edit Delete Rows Record In GridView

In this example i am explaining how to Insert Update Edit Delete Records Rows In GridView With SqlDataSource Using C# VB.NET Asp.Net using SqlDataSource.

Using MVC3, Razor Helpers, and jCrop to upload and crop images.

Using MVC3, Razor Helpers, and jCrop to upload and crop images.

A common requirement for websites that allow user registration is the uploading of user profile images. In many cases, this can be a bother for both user and developer. The implementation of image cropping functionality has traditionally been somewhat cumbersome for developers, and users are generally pained by having to crop an image offline before uploading it, especially more inexperienced computer users.

We’ll explore how to quickly and easily create a solution using ASP.NET MVC3 and 2 of the new Razor helpers, the FileUpload and WebImage helpers and jCrop, an excellent jQuery plugin for image cropping.
Downloading/Installing Jcrop

Jcrop is available for download from the following link: Jcrop Webpage

Difference between javascript and jquery

What is the difference between JavaScript and Jquery

Single or multiple Image upload on ASP.NET MVC3

I spent a great time searching for an example of Upload Image on ASP.NET MVC3 web site.

These are the two simple steps you need to do. (single image)

Create the view
---------------------

<form action="" method="post" enctype="multipart/form-data">
<input type="text" name="firstName" id="firstName" />
<input type="file" name="file" id="file1" />
<input type="submit" />

*Note - Make sure the name that you give for the input type file is important

or If u are using html helper to create the form

@using (Html.BeginForm("Upload", "Home", FormMethod.Post, new { enctype = "multipart/form-data" }))
{
<input type="text" name="firstName" id="firstName" />
<input type="file" name="file" id="file1" />
<input type="submit" />
}

What is the difference between Parse() and TryParse()?

Parse method is used to parse any value to specified data type.

For example

string test = "42";

int32 Result;

Result = Int32.Parse(test);

This will work fine bt what if when you are aware about the value of string variable test.

if test="abc"....

In that case if u try to use above method, .NET will throw an exception as you are trying to convert string data to integer.

TryParse is a good method if the string you are converting to an interger is not always numeric.

if(!Int32.TryParse(test,out iResult))

{

//do something

}

The TryParse method returns a boolean to denote whether the conversion has been successfull or not, and returns the converted value through an out parameter.

**declare variable iResult of Int32.

*Parse throws an exception if it cannot parse the value, whereas TryParse returns a bool indicating whether it succeeded.

*TryParse does not just try/catch internally - the whole point of it is that it is implemented without exceptions so that it is fast. In fact the way it is most likely implemented is that internally the Parse method will call TryParse and then throw an exception if it returns false.

In a nutshell, use Parse if you are sure the value will be valid; otherwise use TryParse.

DOWNLOAD

Monday, 21 January 2013

C# developer interview questions

A representative of a high-tech company in United Kingdom sent this in today noting that the list was used for interviewing a C# .NET developer. Any corrections and suggestions would be forwarded to the author. I won’t disclose the name of the company, since as far as I know they might still be using this test for prospective employees. Correct answers are in green color.

1) The C# keyword .int. maps to which .NET type?
System.Int16
System.Int32
System.Int64
System.Int128
2) Which of these string definitions will prevent escaping on backslashes in C#?
string s = #.n Test string.;
string s = ..n Test string.;
string s = @.n Test string.;
string s = .n Test string.;

Generatring A Report Based on Employee Name.

step1:Create a new Crystal Report --Go To Vistual Studio - File-New- Website-Name-CrystalReport1.rpt
After that we design like this.

Step2: Creating A new Web Page -- Go To Vistual Studio - File-New- Website-Name-Employee.aspx

step3:Write The Below Code in employee.aspx

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="EmployeeTimesheetEmpRpt.aspx.cs" Inherits="EmployeeTimesheetEmpRpt" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">

<table widht="100%">

        <tr>
            <td colspan="2">
                <table align="center" style="width: 100%">
                    <tr>
                        <td>
                            <asp:Label ID="lblEmployee" Text="Employee" runat="server"></asp:Label>
                        </td>
                        <td>
                            <asp:DropDownList ID="ddlEmployee" runat="server" Width="150px">
                            </asp:DropDownList>
                            <asp:RequiredFieldValidator ID="RfvEmployee" runat="server" ControlToValidate="ddlEmployee"
                                CssClass="failureNotification" InitialValue="-1" ErrorMessage="Please Select Employee"
                                ToolTip="employee is required" ValidationGroup="Timesheet">Please Select Employee</asp:RequiredFieldValidator>
                        </td>
                    </tr>

                    <tr>
                        <td class="style1" colspan="2" align="left">
                            <asp:Button ID="btnView" runat="server" Text="View All Employees" ValidationGroup="Timesheet" onclick="btnView_Click"
                                 />

                        </td>

                        <td class="style1" colspan="2" align="center">
                             </td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>

</asp:Content>

Upload Files to Database in Asp.net Download Files From Database in SQL Server

Upload Files to Database in Asp.net Download Files From Database in SQL Server

Introduction:

Here I will explain how to save or insert or upload word document files into SQL Server database and download files from database in asp.net using C#, VB.NET.
Description:

AutoComplete textbox in Asp.net by using JQuery and Webservice.

Sample Example of JQuery AutoComplete textbox in Asp.net by using WebMethod|| How to Use AutoComplete textbox in Asp.net by using JQuery and Webservice.

In this article I am showing about how to use JQuery AutoComplete textbox in Asp.net .
The following are the step to use AutoComplete textbox in Asp.net by using JQuery.
1.First design the table name Category with two fields Id,Category as follows:

Sending SMS using Asp.net C#

To implement this concept you need to follow the below steps :

Step1 :
Create a new Asp.net website in Visual Studio and write the following html code in the design part of the Default.aspx page.

Default.aspx :

wpf

Tuesday, 12 March 2013

Monday, 11 March 2013

Sunday, 10 March 2013

Tuesday, 5 March 2013

Saturday, 23 February 2013

Monday, 18 February 2013

Thursday, 14 February 2013

Tuesday, 12 February 2013

Wednesday, 6 February 2013

Tuesday, 5 February 2013

Thursday, 31 January 2013

Tuesday, 29 January 2013

Wednesday, 23 January 2013

Monday, 21 January 2013

Thursday, 17 January 2013

Thursday, 3 January 2013