Tutorial

https://msdn.microsoft.com/en-in/data/gg685467.aspx

http://www.codeproject.com/Articles/468777/Code-First-with-Entity-Framework-using-MVC-and

http://www.asp.net/mvc/overview/older-versions/getting-started-with-ef-5-using-mvc-4/creating-an-entity-framework-data-model-for-an-asp-net-mvc-application

Pagging in mvc :

http://www.asp.net/mvc/overview/getting-started/getting-started-with-ef-using-mvc/sorting-filtering-and-paging-with-the-entity-framework-in-an-asp-net-mvc-application

Creating the MVC Application

For this demo, all of the code will live inside of an MVC 3 project so the first step will be to create that project. You’ll use a template that will set up much of the structure for the application.
If you have not installed MVC 3 you can find the download and instructions at http://www.asp.net/mvc/mvc3.
  1. In Visual Studio 2010, add a new project by selecting the File menu, then New and then Project.
  2. In the Search Installed Templates text box (top right), type MVC 3 to filter down the list of project templates.
  3. Select ASP.NET MVC 3 Web Application using your language of choice. This walkthrough will use C# code, but you can find both C# and Visual Basic versions in the sample solutions download.
  4. Name the project MVC3AppCodeFirst and then click OK.
  5. In the New ASP.NET MVC 3 Project wizard, choose Internet Application.
  6. Leave the default values of the other options and click OK.
Figure 1: Creating a new MVC 3 Project

Visual Studio will create a full project structure for you including folders that contain pre-built controller classes, models and views. In fact you can run the application already to see it’s default content which is simply a message welcoming you to MVC.

Creating the Model Classes for the Blogging Application

The M in MVC stands for Model and represents your domain classes.  Each class is thought of as a model. You’ll store your model classes — Blog, Post and Comment — in the Models folder. To keep things simple for your first look at code first, we’ll build all three classes in a single code file.
  1. In Solution Explorer, right click the Models folder.
  2. Select Add from the menu and then from the bottom of its context menu choose Class.
  3. In the Add New Item dialog, change the new class name to BlogClasses.
  4. A new file, BlogClasses will be created.
  5. Remove the BlogClasses class from within the file and replace it with the three classes listed below.
public class Blog 
    public int Id { get; set; } 
    public string Title { get; set; } 
    public string BloggerName { get; set;} 
    public virtual ICollection Posts { get; set; } 
  } 
 
public class Post 
    public int Id { get; set; } 
    public string Title { get; set; } 
    public DateTime DateCreated { get; set; } 
    public string Content { get; set; } 
    public int BlogId { get; set; } 
    public ICollection Comments { get; set; } 
 
public class Comment 
    public int Id { get; set; } 
    public DateTime DateCreated { get; set; } 
    public string Content { get; set; } 
    public int PostId { get; set; } 
    public Post Post { get; set; } 
}

Creating an Entity Framework Context to Manage the Classes and Database Interaction

Now that you have classes, you’ll need to bring in the Entity Framework to manage those classes while it provides data access and change tracking for their object instances. Entity Framework’s DbContext class performs this job. We’ll create a class that inherits from DbContext and knows how to serve up and manage the Blog, Post and Comment objects. The Entity Framework will take care of bridging the classes and a database.
Before you can use the DbContext, you’ll need to create a reference to the Entity Framework 4.1 API. When you installed MVC 3, it added a new feature to Visual Studio 2010 called Nuget. Nuget allows you to easily find and install reference assemblies from the internet.
  1. Select the MVC3AppCodeFirst project in Solution Explorer.
  2. From the Tools Menu, choose Library Package Manager which has a sub-menu.
  3. From the sub-menu choose Package Manager Console.
  4. At the console’s PM prompt type install-package EntityFramework then hit enter.
When the package is installed, you should see the “success message” shown in Figure 2.
Figure 2: Installing the Entity Framework 4.1 package reference

Also there will be a new reference listed in the project references called EntityFramework. This is the assembly that contains the Code First runtime.
  1. Add a new class to the Models folder and name it BlogContext.
  2. Modify the class to match the following code:
using System.Data.Entity; 
namespace MVC3AppCodeFirst.Models 
  public class BlogContext : DbContext 
  { 
    public DbSet Blogs { get; set; } 
    public DbSet Posts { get; set; } 
    public DbSet Comments { get; set; } 
  } 
}
These DbSet properties of the BlogContext are the key Entity Framework’s ability to execute database queries on your behalf. As an example, BlogContext.Blogs will execute a query of the Blogs table in the database and return a set of Blog object instances based on the Blog class you defined earlier.
But where is this database? Code first depends on a default presumption about the location of a database. If you don’t specify otherwise, EF will look for the database in the default location and if it doesn’t exist, it will create it for you. Also by default, this database will be a SQL Express database with the name derived from the strongly typed name of the context and its file will be in the SQL Express default data folder. For example:
C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\
     DATA\MVC3AppCodeFirst.Models.BlogContext.mdf
We’ll rely on this default behavior for this walkthrough.

Creating the Controller Logic for the Blog Class

The “C” in MVC stands for controller. A controller gathers up data and sends it to a view and responds to requests from the view. We’ll create a controller that uses the BlogContext to retrieve data for us. In a more advanced application, you should separate logic further and would not be working with the BlogContext directly from the controller.
For the Blog class, we’ll be creating one view that displays a list of available Blogs and another that lets users create new Blogs. Therefore the controller will need one method to gather up a list of blogs to present in the first view, another method to provide a view to enter information for a new blog and finally a method to handle saving that new blog back to a database.
The project template created a controller called Home with a set of views and another controller called Account with its own set of views. We’ll ignore those and create our own controllers and views, starting with a controller for the Blog class.
  1. Build the project by choosing Build from the Visual Studio menu and then Build MVC3AppCodeFirst from its drop-down menu.
  2. In the Solution Explorer, right click the Controllers folder.
  3. Click Add from its context menu and then Controller.
  4. In the Add Controller window, change the Controller Name to BlogController and check the Add action methods checkbox.
  5. Click the Add button.
The BlogController class will be created with ActionResult methods:  Index, Details, Create, Edit and Delete.
The job of the Index method will be to return a list of Blogs to be displayed in a view. The default code returns an empty View. Change the Index method code to the following:
public ActionResult Index() 
     using (var db = new BlogContext()) 
     { 
            return View(db.Blogs.ToList()); 
     } 
}
The revised method instantiates a new BlogContext and uses that to query for Blogs then return the results in a List. Entity Framework will take care of converting this into a SQL query, executing the query in the database, capturing the database results and transforming them into Blog objects. That single line of code, context.Blogs.ToList(), is responsible for all of those tasks.
Since you don’t yet have a database, code first will create it the first time you run this application and execute the Index method. After that, code first will automatically use the database that is created.  As stated earlier, we’ll rely on the default behavior and won’t need to be concerned any more about the database.

Creating the Index View to Display the Blog List

We’ll add an Index view so that you can see what happens to the results of the Index method.
  1. Right click anywhere in the Index method declaration (public ActionResult Index()).
  2. In the context menu that opens click the Add View option.
Figure 3: Adding a view to a controller ActionResult

  1. The AddView dialog will open with the View name already set to Index.
  2. Check the Create a strongly typed view checkbox.
  3. Drop down the Model class option and select Blog.
  4. From the Scaffold template options select List.
These selections will force Visual Studio to create a new web page with markup to display a list of Blogs. The markup for this web page will use the new MVC Razor syntax. Figure 4 shows the Add View dialog.
  1. Click Add to complete the view creation.
Figure 4: Creating a new view to display a list of Blog types

Visual Studio will create a Blog folder inside of the Views folder and add the new Index view to that folder as shown in Figure 5.
Figure 5: The new Blog Index View is added to the Views/Blog folder

Since the very first call to this method will create a new database, the list of blogs will be empty and you’ll have to begin by creating new blogs.  This is where the two Create methods come into play. Let’s add in the Create logic and View before running the app. Note that you’ll need to make a change to the global.asax file before running the app anyway. You’ll do this shortly.

Adding Controller Logic to Create New Blogs

The first Create method does not need to return anything along with the View. Its View will be used to enter details for a new blog, so those details will start out empty. You don’t need to make any changes to this method.
public ActionResult Create() 
     return View(); 
}
The second Create method is of more interest. This is the one that will be called when the Create view posts back. By default, the template told this Create method to expect a FormCollection to be passed in as a parameter.
[HttpPost] 
public ActionResult Create(FormCollection collection)
Because the Create view was created as a strongly-typed view, it will be able to pass back a strongly typed Blog object. This means you can change that signature so that the method receives a Blog type.  That will simplify the task of adding the new blog to the BlogContext and saving it back to the database using Entity Framework code.
Modify the Create method overload  (the second Create method) to match the following code:
[HttpPost] 
public ActionResult Create(Blog newBlog) 
     try 
     { 
         using (var db = new BlogContext()) 
         { 
              db.Blogs.Add(newBlog); 
              db.SaveChanges(); 
         } 
         return RedirectToAction("Index"); 
      } 
      catch 
      { 
        return View(); 
      } 
}
In this method, you are taking the new blog that is passed in and adding it to the BlogContext’s collection of Blogs, then calling Entity Framework’s SaveChanges method. When .NET executes SaveChanges, it will construct and then execute a SQL INSERT command using the values of the Blog property to create a new row in the Blogs table of the database. If that is successful, then MVC will call the Index method which will return the user to the Index view, listing all of the existing blogs including the newly created blog.

Adding a View for the Create Action

Next, create a view for the Create ActionResult as you did for Index. You can right click either of the Create methods but you only need to build one Create view. Figure 6 shows the settings for the Create view. Notice that the scaffold template is Create. That will result in a very different looking web page than the List you chose for the Index view.
Figure 6: Creating a new view to allow users to add a new Blog.

The new view will be added to the Views/Blog folder along with the Index view you created.

Running the Application

When you first created the MVC application with the template defaults, Visual Studio created a global.asax file that has in it an instruction, called a routing, that tells the application to start with the Index view of the Home controller. You’ll need to change that to start with the Index View of the Blog controller instead.
  • Open the global.asax file from Solution Explorer.
  • Modify the MapRoute call to change the value of controller from “Home” to “Blog”.
routes.MapRoute( 
  "Default"// Route name 
  "{controller}/{action}/{id}"// URL with parameters 
  new { controller = "Blog", action = "Index", id = UrlParameter.Optional }
Now when you run the application the BlogController.Index action will be the first method called. In turn it will execute the code, retrieving a list of Blogs and returning it into the default view (the view of the same name, Index). This is what you will see. Note that I’ve made minor changes to the page’s header in the Shared/ _Layout.cshtml file and the heading of the Index View.
Figure 7: Blog List (empty)

Not much to see here except that when you return a View from the BlogController Index method, MVC will find the Blog Index view and display that along with whatever was passed in, which in this case was an empty list.
Clicking the Create New link will call the Create method which returns the Create view.  After entering some information, such as that shown in Figure 8 and clicking the Create button, control is passed back to the Controller, this time calling the Create post back method.
Figure 8: Creating a new blog

The view pushed a blog instance back to the Create method, which then uses the BlogContext to push that data into the database. The Create method then redirects to the Index method which re-queries the database and returns the Index View along with the list of Blogs. This time the list has a single item in it and is displayed as shown in Figure 9.
Figure 9: Blog list after adding new blog

Implementing Edit and Delete

Thus far you have queried for data and added new data. Now you’ll see how Code First lets you edit and delete data just as easily.
To demonstrate this you’ll use the BlogController’s Edit and Delete methods. This means you’ll need the corresponding Views.
  1. Create an Edit View from the BlogController Edit method. Be sure to select a strongly typed view for the Blog class and the Edit scaffolding type.
  2. Create a Delete View from the Blog Controller Edit method. Again, you must select a strongly typed view for the Blog class and this time, the Delete scaffolding type.
When a user edits a blog you will first need to retrieve that particular blog and then send it back to the Edit view. You can take advangate of Entity Framework 4.1’s Find method which by default searches the entity’s key property using the the value passed in. In this case, we’ll find the Blog with an Id field that matches the value of  id.
  1. Modify the Edit method to match the following code;
public ActionResult Edit(int id) 
     using (var db = new BlogContext()) 
     { 
            return View(db.Blogs.Find(id)); 
     } 
}
The job of the overloaded Edit method used for postbacks is to update the blog in the database with the data that came from the view.  A single line of code that leverages the DbContext.Entry method will make the context aware of the Blog and then tell the context that this Blog has been modified. By setting the State to Modified, you are instructing Entity Framework that it should construct an UPDATE command when you call SaveChanges in the next line of code.
Your project will need a reference to the System.Data.Entity namespace in order to change the State. The first few steps that follow show you how to do that.
  1. Right click the References folder in Solution Explorer.
  2. Choose Add Reference… from the References context menu.
  3. Select the .NET tab in the Add Reference dialog.
  4. Locate the System.Data.Entity component, select it and then click OK.
  5. Modify the Edit HttpPost method to make the context aware of the Blog and then save it back to the database as follows:
[HttpPost] 
public ActionResult Edit(int id, Blog blog) 
          try 
          { 
            context.Entry(blog).State = System.Data.EntityState.Modified; 
            context.SaveChanges(); 
            return RedirectToAction("Index"); 
          } 
          catch 
          { 
            return View(); 
          } 
}
Notice that you just as you did for the Create method, you need to change the method signature to accept a Blog type instead of a FormCollection.
By default, the Edit view presents all of the properties except the key, BlogID.
Figure 10: Editing the blog information

After the changes are saved in the Edit postback method, MVC redirects back to the Index method. A fresh query is executed to retrieve the Blogs, including the newly updated Blog, which are then displayed in the Index view.
Figure 11: After editing blog information

Deleting a Blog will work in much the same way.
Modify the Delete methods to match the following examples:
public ActionResult Delete(int id) 
      using (var context = new BlogContext()) 
      { 
        return View(context.Blogs.Find(b)); 
      } 
    } 
    [HttpPost] 
    public ActionResult Delete(int id, Blog blog) 
    { 
      try 
      { 
        using (var context = new BlogContext()) 
        { 
          context.Entry(blog).State = System.Data.EntityState.Deleted; 
          context.SaveChanges(); 
        } 
        return RedirectToAction("Index"); 
      } 
      catch 
      { 
        return View(); 
      } 
}
The first Delete method is just the same as its Edit counterpart. And the postback is similar to the Edit postback with one exception: you are setting the State to Delete rather than to Modified.
The Delete view presents a confirmation screen to the user.
Figure 12: Delete Confirmation Screen

When the user clicks the Delete button, the Delete postback method will be executed and the user will be returned to the Index view.

Summary

Windows 8 Color code

 #AC193D
 #8C0095
 #D24726
 #008A00
 #094AB2
 #5133AB
 #008299
 #2672EC
 #F3B200
 #77B900
 #632F00
 #B01E00
 #C1004F
 #7200AC
 #006AC1
 #FF76BC
 #2572EB
 #003E00

 query string encrypt and decrypt from the url public static string UrlEncrypt(string querystring)
 {
 string key = querystring.Length.ToString(CultureInfo.InvariantCulture);
 return That(key, querystring, 1);
 }

public static string UrlDecrypt(string querystring)
 {
  string key = querystring.Length.ToString(CultureInfo.InvariantCulture);
 return That(key, querystring, -1);
 }
public static string That(String key, String querystring, int sign)
 {
  return new String(Enumerable.Range(0, querystring.Length).Select((x, i) => (char)(querystring.ToArray()[i] + sign * key.ToArray()[i % key.Length])).ToArray());
 }


http://www.dotnetfunda.com/articles/article1297-how-to-create-a-simple-hello-world-aspnet-mvc-tutorial-no-1.aspx#Video%20demonstration
(For Learn Complate MVC Structure)


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

<!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></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<div>
Name:<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />
Email :<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox><br />
City :<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox><br />
Contact :<asp:TextBox ID="TextBox4" runat="server"></asp:TextBox><br />
<asp:Button ID="btn_submit" runat="server" Text="Submit" OnClick="btn_submit_Click" />
</div>
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" OnDataBinding="GridView1_DataBinding"
OnPageIndexChanging="GridView1_PageIndexChanging" OnRowCommand="GridView1_RowCommand"
PageSize="5" AllowPaging="true" OnSorting="GridView1_Sorting" EnableViewState="true"
AllowSorting="true" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing"
OnRowUpdating="GridView1_RowUpdating">
<Columns>
<asp:BoundField DataField="sName" HeaderText="Name" SortExpression="sName" />
<asp:BoundField DataField="sEmail" HeaderText="Email" SortExpression="sEmail" />
<asp:BoundField DataField="sCity" HeaderText="City" SortExpression="sCity" />
<asp:BoundField DataField="nContact" HeaderText="Contact" />
<asp:TemplateField HeaderText="">
<ItemTemplate>
<asp:HiddenField ID="hrd" runat="server" Value="ID" />
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowEditButton="true" />
<asp:CommandField ShowDeleteButton="true" />
</Columns>
</asp:GridView>
</div>
<asp:Button ID="btnInsertAll" runat="server" OnClick="btnInsertAll_Click" Text="InsertAll" />
</div>
</form>
</body>
</html>


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using BuisnessAccessLayer;
using DataAccessLayer;
using System.Data;
using System.ComponentModel;
using System.Reflection;

namespace ThreeLayer
{
public partial class dynamicgrid : System.Web.UI.Page
{
DataTable dt1;
int en = 0;
protected void Page_Load(object sender, EventArgs e)
{
dt1 = new DataTable("tblTest");
DataColumn dc1 = new DataColumn();
dc1.DataType = typeof(String);
dc1.ColumnName = "sName";
DataColumn dc2 = new DataColumn();
dc2.DataType = typeof(String);
dc2.ColumnName = "sEmail";
DataColumn dc3 = new DataColumn();
dc3.DataType = typeof(String);
dc3.ColumnName = "sCity";
DataColumn dc4 = new DataColumn();
dc4.DataType = typeof(String);
dc4.ColumnName = "nContact";
DataColumn dc5 = new DataColumn();
dc5.DataType = typeof(int);
dc5.ColumnName = "ID";

dt1.Columns.Add(dc1);
dt1.Columns.Add(dc2);
dt1.Columns.Add(dc3);
dt1.Columns.Add(dc4);
dt1.Columns.Add(dc5);
}
public void CreateTable()
{
string[] sa = Session["sName"].ToString().Split('|');
string[] sb = Session["sEmail"].ToString().Split('|');
string[] sc = Session["sCity"].ToString().Split('|');
string[] se = Session["nContact"].ToString().Split('|');



int recordnum = sa.Length;
for (int j = 0; j < recordnum - 1; j++)
{
DataRow dr = dt1.NewRow();
dr["ID"] = dt1.Rows.Count;
dr["sName"] = sa[j].ToString();
dr["sEmail"] = sb[j].ToString();
dr["sCity"] = sc[j].ToString();
dr["nContact"] = se[j].ToString();
dt1.Rows.Add(dr);

}
Session["dt1"] = dt1;
GridView1.DataSource = dt1.DefaultView;
GridView1.DataBind();
Clear(Page.Controls);
}

protected void btn_submit_Click(object sender, EventArgs e)
{
Session["sName"] += TextBox1.Text + "|";
Session["sEmail"] += TextBox2.Text + "|";
Session["sCity"] += TextBox3.Text + "|";
Session["nContact"] += TextBox4.Text + "|";

CreateTable();
}
private void Clear(ControlCollection ctrls)
{
foreach (Control ctrl in ctrls)
{
if (ctrl is TextBox)
((TextBox)ctrl).Text = string.Empty;
Clear(ctrl.Controls);
}
}

protected void GridView1_DataBinding(object sender, EventArgs e)
{

}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("Change"))
{
Int64 MemberID = Convert.ToInt64(e.CommandArgument);
BAL objedit = new BAL();
DataTable ds = objedit.EditData(MemberID);
ViewState["ID"] = MemberID;
TextBox1.Text = ds.Rows[0]["sName"].ToString();
TextBox2.Text = ds.Rows[0]["sEmail"].ToString();
TextBox3.Text = ds.Rows[0]["sCity"].ToString();
TextBox4.Text = ds.Rows[0]["nContact"].ToString();
DataGrid();

}
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
DataGrid();
}
private void DataGrid()
{
BAL objgrid = new BAL();
DataSet dt = objgrid.BindData();
DataView dv = new DataView();
dv.Table = dt.Tables[0];
if (ViewState["SortExpr"] != null)
dv.Sort = (string)ViewState["SortExpr"] + " " + (string)ViewState["SortDir"];
GridView1.DataSource = dv;
GridView1.DataBind();
}
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{
ViewState["SortExpr"] = e.SortExpression;

if (ViewState["SortDir"] != null)

e.SortDirection = (string)ViewState["SortDir"] == "ASC" ? SortDirection.Descending : SortDirection.Ascending;
ViewState["SortDir"] = e.SortDirection == SortDirection.Ascending ? "ASC" : "DESC";
DataGrid();
}

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{

}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int index = GridView1.EditIndex;
GridViewRow row = GridView1.Rows[index];
string sName = ((TextBox)row.Cells[0].Controls[0]).Text.ToString().Trim();
string sEmail = ((TextBox)row.Cells[1].Controls[0]).Text.ToString().Trim();
string sCity = ((TextBox)row.Cells[2].Controls[0]).Text.ToString().Trim();
string nContact = ((TextBox)row.Cells[3].Controls[0]).Text.ToString().Trim();

DataTable dt1 = Session["dt1"] as DataTable;
int recordnum = dt1.Rows.Count;
for (int j = 0; j < recordnum - 1; j++)
{
dt1.Rows[0]["sName"] = sName.ToString();
dt1.Rows[0]["sEmail"] = sEmail.ToString();
dt1.Rows[0]["sCity"] = sCity.ToString();
dt1.Rows[0]["nContact"] = nContact.ToString();
}
dt1.AcceptChanges();
GridView1.EditIndex = -1;
Session["dt1"] = dt1;
GridView1.DataSource = dt1.DefaultView;
GridView1.DataBind();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
GridView1.DataSource = Session["dt1"];
GridView1.DataBind();
GridView1.Visible = true;

}

protected void btnInsertAll_Click(object sender, EventArgs e)
{
BEL objuser = new BEL();

for (int c = 0; c < GridView1.Rows.Count; c++)
{
string sName = GridView1.Rows[c].Cells[0].Text;
string sEmail = GridView1.Rows[c].Cells[1].Text;
string sCity = GridView1.Rows[c].Cells[2].Text;
string nContact = GridView1.Rows[c].Cells[3].Text;
objuser.EName = sName;
objuser.EAddress = sEmail;
objuser.ECity = sCity;
objuser.EContact = nContact;

BAL objInsert = new BAL();
int output = objInsert.InsertDetails(objuser);
if (output != 0)
{
Clear(Page.Controls);
}
}
}
}
}

------------------------------------------------------------------------------------------
<form id="form1" runat="server">
<div>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

<asp:Button ID="btnadd" runat="server" Height="25px" Text="ADD" Width="73px" OnClick="btnadd_Click" />
</div>
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowCommand="GridView1_RowCommand">
<Columns>
<asp:TemplateField HeaderText="Sr.">
<ItemTemplate>
<asp:Label ID="lblSN" runat="server" Text='<%#Container.DataItemIndex+1%>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Name">
<ItemTemplate>
<asp:TextBox ID="txtname" runat="server"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="City">
<ItemTemplate>
<asp:TextBox ID="txtcity" runat="server"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:Button ID="btninsert" runat="server" Height="29px" Text="Insert" Width="71px" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<br />
<asp:Button ID="btnaddmore" runat="server" OnClick="btnaddmore_Click" Text="AddMore" />
  
<asp:Button ID="btnInsertAll" runat="server" OnClick="btnInsertAll_Click" Text="InsertAll" />
<br />
</div>
</form>
using System.Data;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
int rowid = 0;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnadd_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("City", typeof(string));
for (int i = 0; i < Convert.ToInt32(TextBox1.Text); i++)
{
DataRow dr = dt.NewRow();
dt.Rows.Add(dr);
}
GridView1.DataSource = dt;
GridView1.DataBind();
AddRows();
ViewState["temp"] = dt;    }
public string connection()
{
Return         System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Insert")
{
int id = Convert.ToInt32(e.CommandArgument);
TextBox name = (TextBox)(GridView1.Rows[id].Cells[0].FindControl("txtname"));
string nm = name.Text;
TextBox city = (TextBox)(GridView1.Rows[id].Cells[1].FindControl("txtcity"));
string ct = city.Text;
SqlConnection cn = new SqlConnection(connection());
SqlCommand cmd = new SqlCommand("insert into test (name,city) values ('" + nm + "','" + ct + "')", cn);
cn.Open();
cmd.ExecuteNonQuery();
}
}
public void AddRows()
{
for (int k = 1; k <= GridView1.Rows.Count; k++)
{
Button btnadd = (Button)GridView1.Rows[rowid].FindControl("btninsert");
btnadd.CommandArgument = Convert.ToString(rowid);
btnadd.CommandName = "Insert";
rowid++;
}
}
protected void btnaddmore_Click(object sender, EventArgs e)
{
if (ViewState["temp"] != null)
{
DataTable dt1 = new DataTable();
dt1 = (DataTable)ViewState["temp"];
DataRow dr1 = dt1.NewRow();
dt1.Rows.Add(dr1);
GridView1.DataSource = dt1;
GridView1.DataBind();
AddRows();

}
}
protected void btnInsertAll_Click(object sender, EventArgs e)
{
for (int c = 0; c < GridView1.Rows.Count; c++)
{
TextBox name = (TextBox)(GridView1.Rows[c].Cells[0].FindControl("txtname"));
string nm = name.Text;
TextBox city = (TextBox)(GridView1.Rows[c].Cells[1].FindControl("txtcity"));
string ct = city.Text;
SqlConnection cn = new SqlConnection(connection());
SqlCommand cmd = new SqlCommand("insert into test (name,city) values ('" + nm + "','" + ct + "')", cn);
cn.Open();
cmd.ExecuteNonQuery();
}
}
}






Http Handler and http Module
 
(1).. Windows Authentication Provider
(2).. Forms Authentication Provider
(3).. Passport Authentication
------------------------------------------------------------------------------------------------------------------------------------
Page Life Cycle Event :
 PreInit:You can:
    Check for the IsPostBack property to determine whether this is the first time the page is being processed.
    Create or recreate dynamic controls.
    Set master page dynamically.
    Set the Theme property dynamically.
    Read or set profile property values.


If Request is postback:
    The values of the controls have not yet been restored from view state.
    If you set control property at this stage, its value might be overwritten in the next event.


Init:
 
   In the Init event of the individual controls occurs first, later the Init event of the Page takes place.
    This event is used to initialize control properties.


InitComplete:
 
   Tracking of the ViewState is turned on in this event.
    Any changes made to the ViewState in this event are persisted even after the next postback.


PreLoad:
This event processes the postback data that is included with the request.

Load:
    In this event the Page object calls the OnLoad method on the Page object itself, later the OnLoad method of the controls is called.
    Thus Load event of the individual controls occurs after the Load event of the page.

In case of postback:
    If the page contains validator controls, the Page.IsValid property and the validation of the controls takes place before the firing of individual control events.

LoadComplete:
    This event occurs after the event handling stage.
    This event is used for tasks such as loading all other controls on the page.

PreRender:
    In this event the PreRender event of the page is called first and later for the child control.

Usage:
    This method is used to make final changes to the controls on the page like assigning the DataSourceId and calling the DataBind method.

PreRenderComplete:


 This event is raised after each control's PreRender property is completed.
SaveStateComplete:
    This is raised after the control state and view state have been saved for the page and for all controls.

RenderComplete:
    The page object calls this method on each control which is present on the page.
    This method writes the control’s markup to send it to the browser.

Unload:
    This event is raised for each control and then for the Page object.
Usage:
    Use this event in controls for final cleanup work, such as closing open database connections, closing open files, etc.
------------------------------------------------------------------------------------------------------------------------------------



SDLC = Software Development Life Cycle (SDLC) solution provides a complete and total support for all SDLC functions and helps overcome the complexities involved in the entire development process from initiation, analysis, design, implementation and maintenance to disposal.
steps in SDLC

1) Systems analysis, requirements definition: Defines project goals into defined functions and operation of the intended application. Analyzes end-user information needs.

2) Systems design: Describes desired features and operations in detail, including screen layouts, business rules, process diagrams, pseudocode and other documentation.

4) Development: The real code is written here.

5)Integration and testing: Brings all the pieces together into a special testing environment, then checks for errors, bugs and interoperability.

6) Maintenance: What happens during the rest of the software's life: changes, correction, additions, moves to a different computing platform and more. This is often the longest of the stages.


IL= Intermediate Language
            A language used as the output of a number of compilers and as the input to a just-in-time (JIT) compiler. The common language runtime includes a JIT compiler for converting MSIL to native code.

MSIL = Microsoft Intermediate Language
            When compiling to managed code, the compiler translates your source code into Microsoft intermediate language (MSIL).

CIL = Common Intermediate Language
            MSIL includes instructions for loading, storing, initializing, and calling methods on objects, as well as instructions for arithmetic and logical operations, control flow, direct memory access, exception handling, and other operations. Before code can be executed, MSIL must be converted to CPU-specific code, usually by a just-in-time (JIT) compiler

CLR = Common Language Runtime
            The engine at the core of managed code execution. The runtime supplies managed code with      services such as cross-language integration, code access security, object lifetime management, and debugging and profiling support.
CTS: =Common Type System
            The specification that determines how the common language runtime defines, uses,
           and manages types.
JIT =just-in-time compiler



* http://localhost:8301/radcontrols_aspnetajax/grid/examples/programming/binding/defaultcs.aspx
(GridView Demo Ajax Control)

* http://localhost:8301/radcontrols_aspnetajax/grid/examples/dataediting/alleditablecolumns/defaultcs.aspx(GridView Demo)


* http://www.youtube.com/watch?v=aEtSnd_1oY0-- ShoutDown Pc By CMD







http://www.c-sharpcorner.com/uploadfile/john_charles/new-features-of-Asp-Net-4/ (featurs of asp.net 4.0)
http://www.daniweb.com/web-development/aspnet/threads/38004/email-an-aspx-page-or-any-webpage-you-want (send page in mail)
https://github.com/search   (Demo For Jquery , C#)


http://www.jankoatwarpspeed.com/reinventing-a-drop-down-with-css-and-jquery/ (Reinventing a Drop Down with CSS and jQuery With Flag)


http://1000projects.org/projects/net-projects/ (latest Projec With Code)
http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/intro-to-aspnet-mvc-4  (MVC- BEST Tutorial)

http://www.dotnetspark.com/kb/2056-add-windows-media-player-to-wpf-application.aspx (video player)

http://stackoverflow.com/questions/273238/how-to-use-group-by-to-concatenate-strings-in-sql-server (groupby and Concanate string)

http://www.telerik.com/products/reporting.aspx(telerik crystal report)

http://localhost:8301/radcontrols_aspnetajax/controls/examples/integration/gridandwindow/defaultcs.aspx?product=window(RadGrid Update)

http://localhost:8301/radcontrols_aspnetajax/upload/examples/async/multiplefileselection/defaultcs.aspx?product=asyncupload(Multiple File Selection)

http://localhost:8301/radcontrols_aspnetajax/grid/examples/programming/binding/defaultcs.aspx

http://localhost:8301/radcontrols_aspnetajax/grid/examples/dataediting/alleditablecolumns/defaultcs.aspx(Grid Demo)

http://www.codeproject.com/KB/database/TriggersSqlServer.aspx#(TRIGGER IN SQLSERVER)

http://www.telerik.com/help/aspnet-ajax/upload-getting-started.html(RadUpload for ASP.NET AJAX)

http://demos.telerik.com/aspnet-ajax/input/examples/radinputmanager/firstlook/defaultcs.aspx(Telirik RadTextbox)

http://demos.telerik.com/aspnet-ajax/notification/examples/default/defaultcs.aspx(Telerik RadNotification)

http://demo.essentialobjects.com/Demos/Grid/Features/Custom%20Column%20-%20Advanced/Demo.aspx

http://doc.essentialobjects.com/library/1/multipage/using_multipage.aspx(EO.Web Controls)(Latest)

http://demo.essentialobjects.com/(EO.Web Controls)

http://nice-tutorials.blogspot.com/2010/10/3-tier-architecture-in-aspnet-using-c.html(3Tier Architecture)

http://www.codeproject.com/KB/cs/Three_Layer_Architecture.aspx(3Tier Architecture)

http://countrystudies.us/india/

http://www.vkinfotek.com/customvalidator.html

http://msdn.microsoft.com/en-us/library/aa479013.aspx

http://www.codeproject.com/KB/aspnet/Crystal_report_features.aspx(CRYSTAL REPORTS)

http://www.crystalkeen.com/articles/crystalbasics/ChartsGraphs.htm(CRYSTAL REPORTS)

http://www.dotnetheaven.com/UploadFile/SaifiFFC/CrystalReport07122007062723AM/CrystalReport.aspx(CRYSTAL REPORTS)

http://www.c-sharpcorner.com/UploadFile/john_charles/CrystalReportsNET06052008140937PM/CrystalReportsNET.aspx(CRYSTAL REPORTS)

http://www.c-sharpcorner.com/UploadFile/harishps/ReportsInDotNet11082005233222PM/ReportsInDotNet.aspx(CRYSTAL REPORTS)

http://ntssp.blogspot.com/2011/04/creating-chart-step-by-step-in-crystal.html(CRYSTAL REPORTS)

http://www.carlosag.net/tools/codetranslator/(VB TO C# Converter)

\\Sonali\sonali's shared\Income Tax Calculator AY 2011-12.mht(Income Tax Calculator)

http://www.codeproject.com/KB/aspnet/Crystal_report_features.aspx(Crystal Report With Graph)

http://www.highoncoding.com/Articles/201_Creating_Crystal_Reports_Using_Typed_DataSet.aspx(Crystal Report With Graph)

http://sqlservernet.blogspot.com/2011/07/aspnet-interview-questions.html(Asp.Net Interview Questions)

http://www.calorisplanitia.com/e-school-management-system.aspx


http://kuler.adobe.com/#themes/rating?time=30


how to open word document in iframe in asp.net

http://www.vbdotnetheaven.com/UploadFile/mgold/WordDocument04182005081441AM/WordDocument.aspx


how to open docx file in iframe in asp.net

orkut pe ladki patayi,
facebook pe baat chalayi,
twitter pe dad se milayi,
google pe shadi karayi,
yahoo pe divorce ho gaya,
isi bahane computer ka course to ho gaya!

http://www.funonthenet.in/articles/longest-bridges.html

http://www.java-samples.com/showtutorial.php?tutorialid=1083

http://www.csharpfriends.com/articles/getarticle.aspx?articleid=78

http://www.c-sharpcorner.com/UploadFile/gtomar/storedprocedure12052007003126AM/storedprocedure.aspx

http://databases.about.com/

http://www.dotnetfunda.com/tutorials/controls/gridview.aspx

http://www.developerfusion.com/article/4278/using-adonet-with-sql-server/2/

http://www.mckoi.com/database/SQLSyntax.html#14

http://www.mckoi.com/database/SQLSyntax.html

http://www.1keydata.com/sql/sqlupdate.html

http://ramanisandeep.wordpress.com/2008/11/16/gridview-insert-update-delete/(GridView)

http://csharpdotnetfreak.blogspot.com/2009/05/gridview-sqldatasource-insert-edit.html(GridView)

http://www.codeproject.com/KB/aspnet/InsertingWithGridView.aspx(GridView)

http://www.dotnetspark.com/kb/643-how-to-editupdatedelete-gridview.aspx(GridView)

http://demos.telerik.com/aspnet-ajax/grid/examples/dataediting/templateformupdate/defaultcs.aspx(GridView)

http://www.asp.net/ajax/ajaxcontroltoolkit/samples/walkthrough/ccdwithdb.aspx(Cascading DropDownControl)

http://www.dreamincode.net/forums/topic/212748-cascading-dropdownlist/(Cascading DropDownControl)

http://aspdotnetcodebook.blogspot.com/2009/04/how-to-create-cascade-dropdownlist.html(Cascading DropDownControl)

http://aspdotnetcodebook.blogspot.com/2009/04/how-to-create-cascade-dropdownlist.html(Cascading DropDownControl)

http://www.ehow.com/how_7648220_delete-buttons-gridview.html

http://www.dotnetfunda.com/articles/article121.aspx(ListView Insert,Update,Delete)

http://www.asp.net/ajax/ajaxcontroltoolkit/samples/

http://asp-net-example.blogspot.com/2010/10/ajax-accordion-how-to-set-change_1026.html(Best)

http://www.ajaxdaddy.com/demo-interface-accordion.html

http://www.c-sharpcorner.com/UploadFile/MIB426/IntroductionAJAXCollapsiblePanel01032007132314PM/IntroductionAJAXCollapsiblePanel.aspx
(AJAXCollapsiblePanel)

http://www.c-sharpcorner.com/Blogs/BlogDetail.aspx?BlogId=1333(AJAXCollapsiblePanel)

http://www.ajaxtutorials.com/ajax-control-toolkit-tutorials/ajax-control-toolkit-dragpanel-tutorial-asp-net-c/(DragPanel)

http://www.ajaxtutorials.com/ajax-control-toolkit-tutorials/ajax-control-toolkit-listsearch-extender-tutorial-in-asp-net-c/(ListSearch)

http://www.c-sharpcorner.com/blogs/BlogDetail.aspx?BlogId=1373(Masked Edit)

http://www.dotnetheaven.com/UploadFile/prathore/PopupControl05182007072603AM/PopupControl.aspx(PopUp)

http://www.vbdotnetheaven.com/UploadFile/rahul4_saxena/ModalPopupWindowInASPdotNet01282009001458AM/ModalPopupWindowInASPdotNet.aspx(PopUp Image)

http://www.dotnetcurry.com/ShowArticle.aspx?ID=285(Modal Popup)

http://www.codeproject.com/KB/aspnet/QueryString.aspx(Query String)

http://www.dotnetcurry.com/ShowArticle.aspx?ID=147(Query String)

http://www.codeproject.com/KB/grid/JavaScript_Popup.aspx?display=Print

http://msdn.microsoft.com/en-us/library/ms972948.aspx

http://csharpdotnetfreak.blogspot.com/2009/05/edit-multiple-records-gridview-checkbox.html(update,delete multiple records)

how to pass data to next page by use of query string

http://aspdotnet-suresh.blogspot.com/2010/10/how-to-populate-dropdown-based-on-other.html(Country,State,City)

http://forums.asp.net/p/1015437/3223608.aspx(Country,State,City using webservice)

http://aspdotnetcodebook.blogspot.com/2009/04/how-to-create-cascade-dropdownlist.html(Country,State,City using javascript)

how to cascade one dropdownlist with another dropdownlist

how to get data from database in asp.net using datatable(Data Table)

http://www.online-tech-tips.com/computer-tips/create-animated-menu/

http://www.esycode.in/

http://www.krhs.net/computerscience/java/Radio.htm

http://www.4guysfromrolla.com/articles/060706-1.aspx(Login Control)

how to check validity of a textbox value with database

there is no row at position 0. asp.net

http://leedumond.com/blog/how-to-validate-user-input-with-values-from-a-database/(Custom Validator)

http://www.c-sharpcorner.com/UploadFile/anandn_mvp/aspnetvalidationcontrols06202006021425AM/aspnetvalidationcontrols.aspx(Validation Controls)

http://www.dotnetcurry.com/ShowArticle.aspx?ID=197(Custom Validation for checkbox and radiobutton)

http://www.dotnetspider.com/forum/278150-how-maintain-session-asp-net-using-c.aspx(Session Management)

http://www.dotnetfunda.com/forums/thread1415-how-to-maintain-session-in-asp-35-with-csharp.aspx(Login Control)

http://www.dotnetspider.com/forum/161211-What-session-Different-ways-maintain-session.aspx(Session Management)

how to retrieve data using session with use of datatable in asp.net

http://msdn.microsoft.com/en-us/library/75x4ha6s.aspx(Session Management)

http://msforums.ph/forums/p/43800/202655.aspx(session datatable)

http://www.shotdev.com/aspnet/vbnet-ado-net/aspnet-vbnet-session-dataset-datatable/(session datatable)

http://www.vbdotnetheaven.com/Forums//ShowMessages.aspx?ThreadID=100234(session datatable)

http://www.exforsys.com/tutorials/asp.net/managing-data-with-ado.net-datasets-and-csharp.html(session datatable)

http://www.aspnettutorials.com/tutorials/controls/data-table-csharp.aspx(session datatable)

http://asp-net-example.blogspot.com/2009/11/ajax-filteredtextboxextender-filtertype.html(FilteredTextBoxExtender)

http://asp-net-example.blogspot.com/2009/11/ajax-filteredtextboxextender-filtertype_23.html(FilteredTextBoxExtender)

http://r4r.co.in/asp.net/01/tutorial/asp.net_ajax/ajax-toolkit-extender-control/filteredtextbox_control.shtml(FilteredTextBoxExtender)

http://programming4.us/website/1186.aspx(AjaxControlToolKit)

http://codeforasp.wordpress.com/category/ajax/(FilteredTextBoxExtender)

http://csharpdotnetfreak.blogspot.com/2009/07/creating-crystal-reports-in-aspnet.html(CrystalReport)

http://www.beansoftware.com/ASP.NET-Tutorials/Using-Crystal-Reports.aspx(CrystalReport)

http://csharpdotnetfreak.blogspot.com/2009/07/subreports-in-crystal-reports-in-aspnet.html(CrystalReport)

http://csharpdotnetfreak.blogspot.com/2009/07/creating-crystal-reports-in-aspnet.html(CrystalReport)

http://www.highoncoding.com/Articles/563_How_to_Create_Crystal_Report_in_ASP_NET_with_Typed_Dataset_.aspx(CrystalReport)

http://xfgr.com/?u=pz1web1z3hcodeprojectb0iczvMessagesczv2960852czvDynamically-alter-the-page-size-of-crystal-reportz6ax(CrystalReport)

crystal reports using dataset in asp.net

http://www.crystalreportsbook.com/Crystal_Reports_Net_Book_Index.asp(CrystalReport)

http://www.codeproject.com/KB/dotnet/CrystalHelper.aspx?msg=2851443(CrystalReport)

http://aspdotnetcode.source-of-humor.com/Articles/LINQ/InsertRetrieveUpdateDeleteThroughGridViewUsingLINQ.aspx(LINQ)

http://aspdotnetcode.source-of-humor.com/Articles/LINQ/LINQToSelectInsertUpdateDeleteWithStoredProcedures.aspx(LINQ)

http://www.programminghelp.com/web-development/asp-net/using-linq-to-sql-to-add-delete-from-sql-database-in-c/(LINQ)

http://www.c-sharpcorner.com/uploadfile/scottlysle/l2sincs06022008035847am/l2sincs.aspx(LINQ)

http://www.codeproject.com/KB/linq/LINQSQLCS.aspx(LINQ)

http://www.geekpedia.com/PageView2948_Edit-Update-Delete-and-Insert-data-with-DataList-control-using-LINQ.html(LINQ Datalist)

http://www.experts-exchange.com/Programming/Languages/.NET/LINQ/Q_26617819.html(LINQ Delete on joined tables)

http://www.dotnetcurry.com/ShowArticle.aspx?ID=66&AspxAutoDetectCookieSupport=1(Multiple records delete in gridview)

http://www.vbforums.com/showthread.php?t=633275(LINQ Delete on joined tables)

Sum (ToNumber(({StudInfo.Marks1},{StudInfo.Marks2},{StudInfo.Marks3})))

http://www.obviex.com/samples/Encryption.aspx(Encryption/Decryption)

http://www.dotnetspider.com/resources/27716-simple-encryption-decryption.aspx(Encryption/Decryption)

http://www.aspnetajaxtutorials.com/2008/09/encryptdecrypt-data-with-sql-server.html(Encryption/Decryption)

http://www.dotnetcurry.com/ShowArticle.aspx?ID=172(Grid View)

http://codeasp.net/blogs/Vinz/microsoft-net/194/adding-rows-in-gridview-without-using-a-database(Grid View Fill Without Database)

http://codeasp.net/articles/asp-net/45/adding-multiple-columns-and-rows-in-gridview-without-using-a-database(Grid View Fill Without Database)

http://dotnetstories.wordpress.com/2008/12/13/linq-to-sql-and-stored-procedures/(LINQ Using Stored Procedure)

http://programming.top54u.com/post/LINQ-to-SQL-Delete-Operation-by-Stored-Procedure-using-C-sharp.aspx(LINQ Using Stored Procedure)

http://www.dotnetfunda.com/articles/article71.aspx(3 Tier Architecture)

http://www.nehaliamin.com/Implement-3tier-architecture.aspx(3 Tier Architecture)

http://www.c-sharpcorner.com/UploadFile/jayendra/108022009063758AM/1.aspx(3 Tier Architecture in LINQ)

http://aspdotnetcodebook.blogspot.com/2010/09/3-tier-architecture-in-aspnet.html(3 Tier Architecture in LINQ)

http://www.dotnetfunda.com/articles/article18.aspx(4 Tier Architecture)

how to use stored procedure in linq to sql

http://netprogramminghelp.com/aspnet/how-to-encrypt-query-string-using-aspnet/(Query String Encryption)

http://aspdotnetcodebook.blogspot.com/2010/05/how-to-bind-gridview-using-linq-join.html(LINQ)

http://r4r.co.in/asp.net/(Asp.Net Life Cycle)

http://www.mini.pw.edu.pl/~mossakow/materials/presentations/aspnet.3.5/master_pages_site_navigation/index.html(Master Page)

http://www.asp.net/master-pages/tutorials/creating-a-site-wide-layout-using-master-pages-cs(Master Page)

http://www.beansoftware.com/ASP.NET-Tutorials/Save-Read-Image-Database.aspx(Image Uploading)

http://www.dotnetcurry.com/ShowArticle.aspx?ID=191(USE OF HOVER MENU)

http://www.c-sharpcorner.com/uploadfile/mike%20clark/pagei09042007215545pm/pagei.aspx(Repeater Control)

http://sureshsharmaaspdotnet.wordpress.com/2008/05/12/edit-update-delete-in-repeater-in-aspnet/(Repeater Control)

http://www.c-sharpcorner.com/UploadFile/kannagoud/3797/(Repeater Control)

http://howtouseasp.blogspot.com/2010/12/how-to-use-gridview-with-insert-edit.html(GridView IUD)

http://www.daniweb.com/web-development/aspnet/threads/195048(XML IUD)

http://codeasp.net/articles/asp-net/69/adding-rows-in-gridview-with-editupdate-and-delete-functionality(GridView IUD)

http://howinaspnet.blogspot.com/2010/08/saveupdatedelete-in-detailsview-control.html(Display,Save, Update,Delete in DetailsView Control in asp.net)

http://aspdotnetcodebook.blogspot.com/2008/08/insert-update-delete-paging-in-formview.html(Insert, Update, delete, paging in formview)

http://sureshsharmaaspdotnet.wordpress.com/2008/07/08/insert-update-delete-paging-in-formview/(Insert, Update, delete, paging in formview)

http://howinaspnet.blogspot.com/2010/07/insertdisplayeditupdatedelete-data-in.html(Insert,Display,Edit,Update,Delete data in FormView control in Asp.Net)

http://sureshsharmaaspdotnet.wordpress.com/2008/07/04/editupdatedelete-in-gridview-using-xml-file/(Edit,Update,delete in gridview using Xml file)

http://dotnetgems.blogspot.com/2009/05/gridview-details-viewfromviewsrepeaterd.html(Gridview ,Details View,Fromviews,Repeater,Datalist Controles in ASP.Net)

http://howtouseasp.blogspot.com/2011/02/paging-with-repeater-control-in-aspnet.html(Paging in repeater control)

http://www.dotnetfunda.com/articles/article980-paging-with-repeater-control-.aspx(Paging in repeater control)

http://www.dreamincode.net/forums/topic/88658-applying-existing-css-code-to-aspnet-menu-structure/(CSS)

http://howtouseasp.blogspot.com/2010/12/how-to-check-case-sensitive-characters.html(how to check Login case sensitivity)

http://imak47.wordpress.com/2008/10/21/how-to-make-a-case-sensitive-comparision-of-strings-in-sql-server/(how to check Login case sensitivity)

http://www.c-sharpcorner.com/uploadfile/raj1979/aspmultiview09292008002038am/aspmultiview.aspx(Use Of MultiView)

http://www.codeproject.com/KB/webforms/CompleteListView.aspx(List View Example)

http://dotnetgems.blogspot.com/2007/11/how-to-create-dll-file-in-cnet-or-vbnet.html(How to Create DLL File in C#.Net or VB.Net)

http://www.eggheadcafe.com/community/aspnet/17/10213509/create-menu-at-run-time.aspx(Menu)

http://www.codeproject.com/KB/webforms/CompleteListView.aspx(Complete ListView in ASP.NET 3.5)

http://www.geekpedia.com/PageView2948_Edit-Update-Delete-and-Insert-data-with-DataList-control-using-LINQ.html(IUD DataList With LINQ)

http://devarchive.net/(Pie Chart)

http://www.dotnet-tips.com/2008/06/how-to-tooltip-in-aspnet-listbox.html(ToolTip)

http://www.dotnetfunda.com/forums/thread1149-how-to-enable-tooltip-for-a-textbox-while-capslock-on.aspx(ToolTip)

http://my.opera.com/Balu.narani/blog/2009/08/11/display-alert-or-tooltip-text-on-mouseover-in-an-asp-net-gridview(ToolTip)

http://asp-net-example.blogspot.com/2009/03/how-to-use-tool-tip-tooltip-in-label.html(ToolTip)

http://demos.telerik.com/aspnet-ajax/tooltip/examples/default/defaultcs.aspx(ToolTip)

http://chandradev819.wordpress.com/2010/08/10/how-to-show-tool-in-gridview/(ToolTip in GridView)

http://asp-net-example.blogspot.com/2009/12/ajax-listsearchextender-and-listbox-how.html(ListSearchExtender Control Ajax)

http://asp-net-example.blogspot.com/2009/12/ajax-listsearchextender-promptcssclass.html(ListSearchExtender Control Ajax)

http://asp-net-example.blogspot.com/2009/11/ajax-listsearchextender-how-to-use.html(ListSearchExtender Control Ajax)

http://www.dotnetsquare.com/codesnippets/9-Ajax-ListSearchExtender-Control-Sample(Ajax ListSearchExtender Control Sample)

http://www.dotnetsurfers.com/sandcastlehelp/html/85445523-7586-39ec-6798-47b1f46acb36.htm(Ajax)

how to use image tooltip in asp.net

http://asp-net-example.blogspot.com/2009/04/how-to-set-change-image-tool-tip.html(Image ToolTip)

http://asp-net-example.blogspot.com/search/label/ado.net%20example?updated-max=2011-05-02T09%3A38%3A00-07%3A00&max-results=20(DataTable)

http://www.dotnetheaven.com/UploadFile/sundaramkumar/simpletooltipwithimages09172007001529AM/simpletooltipwithimages.aspx(Image ToolTip)

http://www.dotnettwitter.com/2010/12/how-to-show-image-in-tooltip-on.html(Image ToolTip In GridView (Good)

http://www.dotnettwitter.com/2010/11/sometime-back-i-got-assignment-to-show.html(Image ToolTip In GridView (Good))

http://demos.telerik.com/aspnet-ajax/tooltip/examples/loadondemand/defaultcs.aspx(Image ToolTip)

http://asp-net-example.blogspot.com/2008/10/image-control-example.html(Image ToolTip)

http://65.39.148.34/KB/aspnet/NotesTooltip.aspx?msg=1787864(Image ToolTip)

http://www.beansoftware.com/ASP.NET-Tutorials/ImageMap-Control.aspx(ImageMap Control)

http://aspdotnetmatters.blogspot.com/2010/07/css-bubble-tool-tip.html(Bubble ToolTip)

http://www.codegain.com/articles/aspnet/htmlandcss/asp-net-multiple-selection-dropdownlist-with-ajax-hovermenuextender.aspx(Multiple Selection In DropDownList)

http://www.c-sharpcorner.com/UploadFile/mahesh/2345/(ToolTip)

http://asp-net-example.blogspot.com/

http://www.codeproject.com/script/Articles/ViewDownloads.aspx?aid=14293(GridView Inside GridView)

http://davidhayden.com/blog/dave/archive/2006/02/11/2798.aspx(DataView)

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview_properties.aspx(GridView Properties)

http://geekswithblogs.net/TiagoSalgado/archive/2011/03/26/gridview-showheaderwhenempty.aspx(GV Property = showheaderwhenempty)

http://www.w3.org/TR/xslt.html(XSLT)

http://docstore.mik.ua/orelly/xml/pxml/ch04_01.htm(Perl & XML)

how to dynamically generate theme in asp.net(11th page onwards)

http://www.carlj.ca/2007/11/19/dynamically-applying-themes-to-your-aspnet-site-with-a-sitemap/(Dynamic Theme)

http://www.codeproject.com/KB/aspnet/dynamicThemes.aspx(Dynamic Theme)

http://www.codeforasp.net/dynamically-create-asp-net-menu-control-using-c.html(Dynamically create asp.net menu control using C#)

http://www.dotnettutorials.com/tutorials/themes/usingcss-csharp.aspx(Dynamic Theme)

http://weblogs.asp.net/lduveau/archive/2010/05/31/dynamically-apply-and-change-theme-with-the-silverlight-toolkit.aspx(Dynamic Theme)

http://www.opexsolution.com/2010/04/dynamically-applyingthemes-with-master-pages/(Calendar Theme)

http://www.dotnetfunda.com/articles/article14.aspx(Dynamic Theme)

http://www.igregor.net/post/2007/12/24/Adding-Controls-to-an-ASPNET-form-Dynamically.aspx(Adding Controls Dynamically)

http://blog.etavakoli.com/2010/03/08/simple-code-to-use-linq-on-a-generic-list/(Generic List)

http://www.abhisheksur.com/2010/01/how-to-expose-events-from-usercontrol.html(UserControl DropDownList)

http://www.go4answers.com/Example/filling-state-dropdownlist-according-102230.aspx(DropDownList)

http://dotnetspidor.blogspot.com/2009/04/bind-aspnet-dropdownlist-to-xml-file.html(XML County DropDownBind)

http://www.codeguru.com/csharp/sample_chapter/article.php/c12593(FileUpload Contol)

http://www.codeguru.com/csharp/sample_chapter/article.php/c12593__3/ASPNET-20-FileUpload-Server-Control.htm(FileUpload Control)

http://www.dotnetfunda.com/articles/article71.aspx(3Tier Architecture)

http://www.dotnetfunda.com/articles/article18.aspx(4Tier Architecture)

http://javolution.org/target/site/apidocs/javolution/xml/stream/XMLStreamWriter.html(For xmlwriter (good))

http://www.codeproject.com/KB/miscctrl/CheckBoxlist_Value.aspx(Multiple Selection In DropDownList (Good))

http://www.all-freeware.com/results/orkut/theme(Multiple Themes)

http://aspalliance.com/articleViewer.aspx?aId=1886&pId=-1(ASP.NET Multiple Selection DropDownList with AJAX HoverMenuExtender)

http://www.dotnetspider.com/forum/202591-How-get-value-dataset-store-image-grid-very-urgent.aspx(How to get value on dataset and store image on grid)

http://efreedom.com/Question/1-234177/Transfer-Data-One-Database-Another-Using-DataSet(How do I transfer data from one database to another using a DataSet?)

http://www.codeproject.com/KB/database/DataTableToDataBase.aspx(Copy Data from a DataTable to a SQLServer Database using SQLServer Management Objects and SqlBulkCopy)

http://programming.top54u.com/post/ASP-Net-C-sharp-Convert-DataSet-to-ArrayList.aspx(ASP.Net C# Convert DataSet to ArrayList)

http://msdn.microsoft.com/en-us/library/bh8kx08z.aspx(Populating a DataSet from a DataAdapter (ADO.NET))

http://authors.aspalliance.com/stevesmith/articles/convertReadertoSet.asp(Code: Convert DataReader to DataSet)

https://ramanisandeep.wordpress.com/tag/datareader-vs-dataset/(DataReader vs DataSet)

http://www.dotnetspark.com/Forum/937-how-to-get-table-column-name-from-dataset.aspx(How to get table column name from dataset table)

http://www.dotnet247.com/247reference/msgs/3/18833.aspx(Getting column names)

http://www.dotnetspark.com/kb/1710-using-dataset-to-retrieve-data-from-database.aspx(Using DataSet To Retrieve Data From Database)

http://blog.evonet.com.au/post/Creating-a-Stylish-looking-Gridview-with-Filtering.aspx(GV Formatting)

http://csharpdotnetfreak.blogspot.com/2008/11/merging-gridview-headers-to-have.html(GV Formatting)

http://www.codeproject.com/KB/aspnet/Merge_cells_in_GridView.aspx(GV Formatting)

http://weblogs.sqlteam.com/jhermiz/archive/2007/12/10/Cool-Tricks-With-The-ASP.net-Calendar.aspx(Calendar Colors)

http://www.daypilot.org/calendar-tutorial.html(Calendar Control)

http://www.daypilot.org/tutorial-calendar-sqlserver.html(Calendar Control)

http://www.aspfree.com/c/a/ASP.NET-Code/ASPNet-Calendar-Web-Control-by-James-Chen/(Calendar Control (Good One))

http://www.csharpmagic.com/2010/06/how-to-add-google-map-to-your-website.html(3 Step To add Google map ASP.NET with C#)

http://www.indianpublicholidays.com/2010/09/list-of-holidays-in-india-2011/(Holiday List)

http://sgholiday.com/calendar/india-public-holidays-2011-calendar/(Holiday List)

http://sgholiday.com/calendar/india-public-holidays-2012-calendar/(Holiday List)

http://www.sandesh.com/sandesh_special/Gujarati-Panchang/Holidays-Festivals.htm(Holiday List)

http://msdn.microsoft.com/en-us/library/ms228044.aspx(Calendar Showing Holiday in different color)

http://www.codeproject.com/KB/webforms/CalendarHighlighter.aspx(Calendar Showing Holiday in different color)

http://dotnetspeaks.net/post/Multiple-Date-Selection-inc2a0ASPc2a0Calendar.aspx(Calendar Showing Holiday in different color)

http://www.c-sharpcorner.com/UploadFile/gowth/7905/(Calendar Showing Holiday in different color)

http://www.totaldotnet.com/Article/ShowArticle26_Article.aspx(Calendar Showing Holiday in different color)

http://www.c-sharpcorner.com/UploadFile/6897bc/7110/(Calendar Showing Holiday in different color)

http://www.atrickdesign.com/show-time-30-jquery-calendar-date-picker-plugins/(Calendar Showing Holiday in different color)

http://weblogs.sqlteam.com/jhermiz/archive/2007/12/11/Additional-Tip-For-That-Calendar-Control-In-ASP.net.aspx(Calendar Showing Holiday in different color)

http://www.google.co.in/#q=how+to+add+holiday+in+calendar+on+button+click+in+different+color+in+asp.net&hl=en&prmd=ivns&ei=-9wzTsjxOYSnrAeo8aHMCw&start=240&sa=N&bav=on.2,or.r_gc.r_pw.&fp=2839f54c7e4f6857&biw=1024&bih=578

http://www.eduswift.com/gallery_timetable.htm(School Management System)

http://www.eduswift.com/gallery_teacher.htm(School Management System)

http://www.codeproject.com/KB/aspnet/Gridview_Fixed_Header.aspx(GV Footer)

http://negaweblog.wordpress.com/2011/02/22/insert-edit-update-delete-records-data-in-gridview-using-asp-net-c-c-sharp/(GV Footer)

http://codeasp.net/articles/asp-net/200/adding-dynamic-rows-in-gridview-with-textbox-and-dropdownlist(GV Footer)

http://www.codegain.com/articles/aspnet/howto/gridview-insert-update-delete-in-asp-net.aspx(GV Footer)

http://dotnetspeaks.net/post/exm/ExamplesMainPage.aspx(Different Examples)

http://jqueryslideshowtutorial.com/jquery-slideshow-with-asp-net-gridview.html(jquery slideshow)

http://freewebbuttons.net/asp-menu-css-style.html(Menu Control Css)

http://www.eggheadcafe.com/community/aspnet/7/10044292/how-to-add-a-pop-up-calender.aspx(Popup Calendar)

http://shawpnendu.blogspot.com/2009/02/building-aspnetc-database-driven-event.html(Calendar Showing Holiday in different color)

http://njrathod.wordpress.com/2009/05/01/asp-net-dynamically-calendar-dynamic-calendar-in-c-net/((GOOD ONE) Calendar Showing Holiday in different color)

http://www.dotnetspider.com/forum/287005-Open-popup-mouse-over-calender.aspx(Calendar Tooltip)

http://stackoverflow.com/questions/1606477/make-all-sundays-red-on-month-calendar-in-c(Calendar showing sunday in different color)

http://web--templates.org/menus/css-mouseover-popup.html

http://authors.aspalliance.com/aspxtreme/aspnet/syntax/calendarwebcontrol.aspx(Calendar Control Syntax)

http://www.dotnetfunda.com/forums/thread4672-how-to-mark-the-event-in-the-calendar-control.aspx (calender tooltip)

http://forums.asp.net/t/1552240.aspx/1(calender tooltip)

http://www.highoncoding.com/Articles/129_DHTML_ToolTip_with_Calendar_Control.aspx(calender tooltip)

http://forums.asp.net/p/1036174/1800067.aspx(calender tooltip)

http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_3960-Calendar-Control-with-Database-Access-and-Lightbox-popup.html(Calendar showing sunday in different color)

http://www.codeproject.com/KB/sharepoint/wsscalendarlist.aspx(Calendar showing sunday in different color)

http://www.genmaint.com/how-to-display-tooltip-for-textbox-while-entering-the-text-in-that-in-asp-net.html(JQuery)

http://forums.aspfree.com/asp-development-5/onmouseover-event-76269.html?p=241069(onmouseover event)

http://www.dotnetspider.com/forum/162982-Calender-Control-assign-value-each-cell.aspx(assigning each cell values)

http://www.csharpfriends.com/demos/system.datetime.aspx(DATE TIME)

http://codeasp.net/blogs/mohit/microsoft-net/780/how-to-insert-data-using-web-service(How To Insert Data Using Web Service)

http://peterkellner.net/2006/05/24/how-to-set-a-date-format-in-gridview-using-aspnet-20using-htmlencode-property/(How To Set a Date Format In GridView Using ASP.NET 2.0(Using HtmlEncode Property))

http://www.beansoftware.com/ASP.NET-Tutorials/Export-Crystal-Reports-To-PDF.aspx(Export Crystal Reports to PDF file)

http://www.vbdotnetheaven.com/Forums/Thread/122010/how-to-create-crystal-reports-from-xml-file.aspx( How to create Crystal reports from XML File ?)

using CrystalDecisions.CrystalReports.Engine;
public FileStreamResult Report()
{
ReportClass rptH = new ReportClass();
List data = objdb.getdataset();
rptH.FileName = Server.MapPath("[reportName].rpt");
rptH.Load(); rptH.SetDatabaseLogon("un", "pwd", "server", "db");
rptH.SetDataSource(data);
Stream stream = rptH.ExportToStream (CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, System.IO.SeekOrigin.Begin);
return new FileStreamResult(stream, "application/pdf"); }
}

http://devtoolshed.com/content/crystal-reports-and-aspnet(Crystal Reports to PDF file)


http://radcontrols.blogspot.com/(Raid DatePicker)

http://www.toplinestrategies.com/dotneters/tag/telerik-control/?lang=en(Raid DatePicker)









Mvc Architecture
Insert data Demo 

Popular posts from this blog