Computer Programming

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

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:         DropDownList1.Items[0].Selected = true;         DropDownList1.Items[0].Attributes["Disabled"] = "Disabled"; Source Code <div>              <asp:DropDownList ID="DropDownList1" runat="server">         </asp:DropDownList>          </div> 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.WebC

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 &q

Introduction 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 th

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.

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: But when you run it then you get error like : Default Membership Provider must be specified. [Solution] Add tags in web. config file. <system.web> <membership>       <providers>                <clear />       <add requiresQuestionAndAnswer="false" name="AspNetSqlmembershipProvider" type="System.Web.Security.Sql

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: But when you run it then you get error like : Default Membership Provider must be specified. [Solution] Add tags in web. config file. <system.web> <membership>       <providers>                <clear />       <add requiresQuestionAndAnswer="false" name="AspNetSqlmembershipProvider" type="System.Web.Security.

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: [Video Contain BoundField + SQLDataSource + ADO.NET] Example :   Example of GridView BoundField with SqlDataSource Control    . 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:   <asp:GridView ID="g1" runat="server" AutoGenerateColumns="false">         <Columns>             <asp:BoundField DataField="Id" HeaderText="Identification No" />             <asp:BoundField DataField="Name" HeaderText="Name of User" />         </Columns>    <

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 { ge

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