ADO.NET Entity Data Model provides you a better and fast approach for communicating with database objects like Table, Stored Procedure etc. After added it, you have some models (classes ) which is related to tables and context classes. I mean to say that you can access database table directly by using context classes. In the context class, we have some public properties, through these we can retrieve table values. These all such things are related to model first approach , i mean to day that ADO.NET Entity Data model is based on model first approach. Let's start to configure it with the database, you can follow these steps , if you want to configure it:
Step-1 : Right Click on your project name , select add new item from the appearing menu.
Step-2 :
Step-3: Press "OK" to continue.
Step-4: Select "EF designer from Database" option in the Entity Data Model wizard.
Step-5: Now, press Next to continue in model wizard, select Connection string from Dropdown menu if exists. You can create "New Connection" by using Sql Server Database.
Step-6: Also select "Save Connection String into web.config file" CheckBox to save your whole connection parameter in web.config file.
Step-7: Press "Next" to continue. Select either all of them Table, Views, Stored processor and one of them.
In this article, I will show you, How to add default item at index 0 in DropdownList, also select default item, default item will be disabled when drop down the popup. For this task, first of all bind the DropdownList then you can add default item at index first by using following line of code:
DropDownList1.Items.Insert(0, "Select");
After that you can select or disabled default item by the following line of code:
In this Project we have a logical system. By using this system we can store courses and their subjects in the system database. The all things we can do by administrator. First of all, administrator do login in the system. He/ She can change our profile like change password, username and etc. In the Courses tab, we will provide some following things like "Manage Courses", "Add Courses", "Manage subject combination" and "Add subject combination". In the section of Manage courses, i will provide you a GridView control with the following action control like:
By using Edit and Delete button we can make some changes in the course table. By using Subject combination we can configure subjects under defined courses. I will provide you a interface through which you can add new courses in the table like :
After add course details , you can add subjects in particular course also configure it by using some action command like "Edit" and "Delete". Now, by mentioned snap, you can add new subject details in the courses like:
Through this project we are booking a hotel room in a city also reduce lots of paper work. Actually physical process converted into logical process or you can say online process.
In this project we will provide such types of searching functionality:
Pick random city
Search city
You can search hotel directly
Module of the project :
Visitor
Administrator
Working of the project
First of all visitor choose the hotel city by the help of searching facilities. In the search result we will provide some basic information about each hotel which is exist in the city. When visitor select a specific hotel in the given list, we will provide the full details of selected hotel with "book now" button. When visitor press this button, the system will check that visitor is whether authenticated or not. If visitor is not authenticated then visitor moves to the login page. Login page contain a link of register page. If visitor not a website user then she/he will not login by the login panel so first of all visitor should member of the website. After that he /she will booked the selected hotel.
In this article i will show you how to bind TreeView at 2 level, you can say that Bind tree view with country , state and city table. Country table data bind at 0 level , state data bind at 1 level and last city data bind at 2 level. So first of all create three table, Sql Script mentioned below:
Database Table : (Country)
CREATE TABLE [dbo].[Country] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[Name] NVARCHAR (50) NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
Database Table : (State)
CREATE TABLE [dbo].[state] (
[Id] INT NOT NULL,
[Name] NVARCHAR (50) NULL,
[cid] INT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
Database Table : (City)
CREATE TABLE [dbo].[city] (
[Id] INT NOT NULL,
[Name] NVARCHAR (50) NULL,
[sid] INT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
Now, add the tree view in web form. Now, your source page looking like this.
Source Code :
<asp:TreeView ID="TreeView1" runat="server">
</asp:TreeView>
Code Behind Code :
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Default6 : System.Web.UI.Page
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(query))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
sda.SelectCommand = cmd;
sda.Fill(dt);
}
}
return dt;
}
}
}
In this code First to bind DataTable with the Country table, for each country , retrieved State name and for each state name , retrieved city name. Here, we have recursion technique. In the Populate TreeView method parent id define the level of the tree view.
Create User Wizard control is used to store information of the user or visitor into the database table. ASP.net provide the control through this we can store limited information of the client into the database table. But we can change its user interface. You can say customization of Grid View. When we drag it on design window then its look like:
Select Create User Step link by using "show smart tag". After that you can make some changes in fields. Like if You want to remove "Security Answer" and Security Question. Suppose you have to remove it then your interface look like:
Create User Wizard control is used to store information of the user or visitor into the database table. ASP.net provide the control through this we can store limited information of the client into the database table. But we can change its user interface. You can say customization of Grid View. When we drag it on design window then its look like:
Select Create User Step link by using "show smart tag". After that you can make some changes in fields. Like if You want to remove "Security Answer" and Security Question. Suppose you have to remove it then your interface look like:
In this article i will show you, How to use BoundField of GridView in ASP.NET C#. Actually, BoundField is the Default field of GridView Control, used for DataBinding purpose. In my previous article i have already use this field with SQL DataSource control. Check mentioned below link:
Now, Learn, How to create BoundField manually also bind them using ADO.NET Technology with Database table. First to create a database table, insert some data into table. Prepare BoundField like this:
In this article i will show you, How to retrieve record from database table in MVC. This things we have already learned in ASP.NET WEB FORMS, Now the same things we can do in MVC. Before doing this task first to install Entity Framework in the application. Create a Empty MVC project. Add a new database also create table by using this video tutorial. We have a database table with their following fields:
CREATE TABLE [dbo].[Student_Table] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[Name] NVARCHAR (50) NULL,
[City] NVARCHAR (50) NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
Now, Following these steps to retrieve items from table:
Step-1 : Create a "Student" model class in model folder. Like :
using System.ComponentModel.DataAnnotations.Schema;
namespace WebApplication19.Models
{
[Table("Student_Table")]
public class Student
{
public int Id { get; set; }
public string Name { get; set; }
public string City { get; set; }
}
}
By using the Table class we can mapped our class to database table.
Step-2 : Create a "StudentContext" class in model folder. Like
using System.Data.Entity;
namespace WebApplication19.Models
{
public class StudentContext : DbContext
{
public DbSet<Student> students { get; set; }
}
}
By using "students" property we can communicate with the table.
Step-3 : Create ConnectionString in the Web.Config file, in this way :
here we have a connection name is same as Context Class name.
Step-4 : Now, add a controller in the Controller folder, copy this code under controller action method
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using WebApplication19.Models;
namespace WebApplication19.Controllers
{
public class HomeController : Controller
{
// GET: Home
public ActionResult Index()
{
StudentContext sc = new StudentContext();
Student singlestu = sc.students.Single(stu => stu.Id == 2);
return View(singlestu);
}
}
}
By using the LINQ Query we have to retrieving student details from table who's id is 2. Now, Build the project. Add a View By Right click on Index Action method.Now, appear a screen look like this.
Fill all mentioned fields, according to mentioned snaps. Now, last
Step-5 : Design to view for values.
@model WebApplication19.Models.Student
@{
ViewBag.Title = "Student";
}
<h2>Single Student Record</h2>
<div>
Student Id : @Model.Id <br/>
Student Name : @Model.Name <br/>
Student City : @Model.City
By using the Entity Framework you can can communicate with the Sql Server. In which we have two approaches i.e "Code First" and "Model First". But, In this article, I will explain you how to install Entity Framework from console and Solutions: Install From Console:
1. Select "Package Manager Console" by the following path :
Tools -> NuGet Package Manager--> Package Manager Console
Note : Before type the command in command line, must to ensure your internet connection.
Type command in Command Line:
PM> Install-Package EntityFramework
Install From Solution:
1. Select "Manage Nuget Packages for Solutions... " by the following path :
Tools -> NuGet Package Manager--> Manage Nuget Packages for Solutions...
Note : Before type the command in command line, must to ensure your internet connection.
Search Entity Framework in search bar, which reside in right side bar.
In this article, I will show you how to update GridView row. By using edit button we can update GridView row. But the question is, how to design "Edit" button for delete. If you follow me then i am sure you can delete rows from GridView.
Mentioned Following steps are:
Step-1 : Add a GridView Control on source window by using html code. Now, in the source page you have.
<asp:GridView ID="g1" runat="server">
</asp:GridView>
Step-2: Add these mentioned properties in the GridView:
AutoGenerateColumns="false"
OnRowCancelingEdit="g1_RowCancelingEdit"
OnRowEditing="g1_RowEditing"
OnRowUpdating="g1_RowUpdating"
Here, we have AutoGenerateColumns="false" means you design GridView columns manually. OnRowCancelingEdit is a event through this you can cancel the process of editing. OnRowEditing is also a event through this you can edit new Index. By using OnRowUpdating event you can update rows with new Data.
Step-3 : Suppose we have two fields in Database table then you can design GridView for this way. Now, the complete code of GridView is:
<asp:TextBox ID="nametext" runat="server" Text ='<%# Eval("Name") %>' />
</EditItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
In the First Template field we have two templates i.e ItemTemplate and EditItemTemplate. By using ItemTemplate we can show Edit Button with their "Edit" Command Name Property. When you click on it then open EditItemTemplate, in which we have two buttons in same column i.e Update and Cancel. similarly Design two columns for data. Pick the data from the database table using Embedded code block.
Code behind code
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Default3 : System.Web.UI.Page
