.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Display Employee Record

Posted By:      Posted Date: August 24, 2010    Points: 0   Category :ASP.Net

I have employee table and qualification table

Each employee has multiple qualifications

Now what i want to display is employees basic information like name, identity card, designation etc..

With all the qualification he/she has

please let me know how can i do that

Following is situation which i dnt want


Identity card :123


Qualification one


Identity card :123


Qualification two

View Complete Post

More Related Resource Links

GridView inline Master/Detail record display

This code drop is part of a smash and grab series. If you're in a rush, you can just grab this code and insert it into your application, no understanding is required. When you have some time (ya, right) you may want to review the source code.

Passing Primary Key to User Control to Display Record Detail


I'm building a user control to display detail information on a parent record. The user control will be displayed via an Ajax Modal Popup. The user control works and is displayed when expected. The problem that I'm having is that I'm not able to pass in the primary key for the parent. The control is displayed via the _ItemCommand event of a Repeater. In the markup for the user control, I explicity set the ContactId to 0 to avoid an error when the control loads (its still underdevelopment, eventually that I'll check if the value is valid).

I was assuming that I could change the property in the _ItemCommand event, but obviously its not working.

In the Page_Load event this code successfully sets the ContactId property of the control. The _ItemCommand event appears to set the value. However when I set a test label on the user control to the Me.ContactId, its showing '0' as if it was never passed in.

        UserControlContactDetail.ContactId = "1462"
        test.Text = UserControlContactDetail.ContactId

    Protected Sub RepeaterDirectory_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.RepeaterCommandEventArgs) Handles RepeaterDirectory.ItemCommand

Protected Sub RepeaterDirectory_ItemCommand(By

Display Inserted Record After Insert Using A FormView

How do I display a record in a FormView once the record has been inserted? I'm able to get the Identity of the new record without anyproblems, but I can't figure out how I should code the _ItemCreated event. Protected Sub FormViewMessageDetail_ItemInserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewInsertedEventArgs) 'Refresh the list to show the new record RepeaterMessages.DataBind() 'Set the .SelectCommand to Select the New Record SqlDataSourceMessageDetail.SelectCommand = "SELECT * FROM Messages WHERE [Id] = " & NewId FormViewMessage.DataBind() FormViewMessage.ChangeMode(FormViewMode.Edit) test.Text = NewId.ToString End Sub Protected Sub SQLDataSourceMessageDetail_Inserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceStatusEventArgs) NewId = e.Command.Parameters("@NewId").Value End Sub

how do I search record from database and display that in Datagridview.

hi,I am working in windows application.I wanted to search record while entering into textbox and respective data should be displayed in datagridview..

I Need Help to display Present & Absent when Employee present or Absent


Hi all

hear is my query

SELECT t.EmployeeCode, t.FullName

, COUNT(CASE WHEN t.LogInDate = '2010-07-05' THEN 'p' ELSE 'A' END ) AS [day1]

, COUNT(CASE WHEN t.LogInDate = '2010-07-06' THEN 'P' ELSE 'A' END ) AS [day2]

, COUNT(CASE WHEN t.LogInDate = '2010-07-07' THEN 'P' ELSE 'A' END ) AS [day3]

, COUNT(CASE WHEN t.LogInDate = '2010-07-08' THEN 'P' ELSE 'A' END ) AS [day4]

, COUNT(CASE WHEN t.LogInDate = '2010-07-08' THEN 'P' ELSE 'A' END ) AS [day5]

, COUNT(CASE WHEN t.LogInDate = '2010-07-10' THEN 'P' ELSE 'A' END ) AS [day6]

, COUNT(CASE WHEN t.LogInDate = '2010-07-11' THEN 'P' ELSE 'A' END ) AS [day7]

FROM dbo.PermenantAttadenceView t

WHERE t.LogInDate  between '2010-07-05' and '2010-07-11'

GROUP BY t.EmployeeCode, t.FullName




Need Help in a query... How to Display Last Record For a Given Month


Hi All,

I have a table DBGROWTHTABLE with below structure and data.

USE [ibmdba]


/****** Object: Table [dbo].[DBGROWTHTABLE] Script Date: 10/22/2010 11:54:02 ******/








	[TableEntryID] [int] IDENTITY(1,1) NOT NULL,

	[EntryDate] [smalldatetime] NOT NULL,

	[MachineName] [varchar](100) NULL,

	[InstanceName] [varchar](100) NULL,

	[DBNAME] [varchar](100) NULL,

	[DBsizeMB] [bigint] NULL,

	[unallocMB] [bigint] NULL,

	[reservedMB] [bigint] NULL,

	[dataMB] [bigint] NULL,

	[indexMB] [bigint] 

Display last record while loading another page in asp.net


how can i display the last record of the table in asp.net. i have button(Cparts) on status webform when you click this two events takes place

1.A pop-up window will appearon on the screen which has 4 textfield,pop-up window comming with blank fields i want to fill all the 4 fields with current/last record of the corresponding table.

2.Also tranfering the primary key value (WONumber in status) of status webform into textbox of the pop-up window(CParts.aspx) which is a hidden field.here i am inserting values into different table(Cparts table) based on WONumber which is not an unique column in this table

I want when this pop-up window opened last record of the CParts table should be populated into CParts.aspx fields. WONumber is not an unique number in CParts table

display a record count from sql database connection


sometimes learning asp.net feels so heavy handed compared to some of the general purpose scripting languages like php.  for examples, all i want to do is create a sql connection that pulls a row count and displays that number.  I don't need a grid, list, detail page, etc., nothing this heavy... a simply query that will display a simple bit of text.  for the life of me I can't figure out how to do it.  Using these controls, I'm not in the code behind with the query, so I wouldn't attach this to a label (or would i), and there's nothing i see in the toolbox that does what i want.  Perhaps i'm too accustomed to php but it feels like with asp.net, major things are simple, and simple things are hard.  any help would be appreciated.  i'm trying to convert my career to c#.net

how to display employee name in dropdownlist depend on departments name in the other dropdownlist


i use  2 dropdownlist with 2 object data source

first dropdownlist to display departments name using object datasource (field to display DeptName , value of field DeptID) 

second dropdownlist to display Employee name but depend on departments (field to display EmpName , value of field EmpID)


how to display employee name in dropdownlist  depend on departments name in the other dropdownlist


2 tables

1 table deprtments with column  (DeptID , DeptName , DeptDescription)

2 table Employee with column (EmpID , DeptID , EmpName)

HELP: Creating an ActionResult method to display a particular database record using Entity Framework


Hi All,

I have an ActionResult method that displays records from a database table (below):

namespace STD.Controllers
    public class StudentController: Controller
        StudentEntities stud;
        public StudentController()
        stud= new StudentEntities ();


        public ActionResult Index()
            ViewData.Model = stud.StudentTable.ToList();
            return View();


I want to design a method "ActionResult Student()" that accepts "Student ID" as a parameter and displays record for that particular student only.

What do I need to do to make this happen? Could anyone please help me with this?

Thanks in advance


Display data in gridview dynamicallay

I have AD domain which has 100000 users, I want to display all the users in gridview controls.Actually it is displaying users in gridview after parsing entire domain which takes around 30 min. I want to display the users while loading itself.It is continously getting user information from AD domain and getting each user details, I want to display the users information which already queried instead of waiting till getting all users information

asp.net display data in gridview

i want to display data in gridview binded to a sql datasource
but the problem part is i want to bind a field of that datasource to a dropdownlist and when a item is selected in that dropdownlist then correcposnding to that data will be displayed in gridview...

display data into GridView from excel sheet

I have to display data from excel sheet into my gridview and also I need to figure out a way to store data into excel files from my web page. I am using C# 3.5, VS 2008.

Display Related Data in an ASP.NET GridView

Typically when you display a datagrid you will want to show data from a related table. There are 3 different ways to accomplish this with NetTiers. You can use a custom stored procedure, deepload functionality from the code behind, or a strongly typed datasource control. We'll provide an example of each

Get Top 1 Record from Dataset

Many of them in need of getting the Top 1 or Top 10 records from a Dataset without going to SQL query. It is possible to do from Code Behind. I have given the code below,
The below code is to get single record from a Dataset. Also I have given for getting 8 records at Green Color.

Store and Display Images from MS Access Database Using C#

There is only the difference of coding syntax to stream the binary data of image content type to upload it into MS Access Database using C#/VB in ASP.Net 2.0

Namespaces required:-
using System.Data.OleDb;

OleDb is used to connect the web site forms with MS Access Database using Microsoft.Jet.OLEDB.4.0

Enterprize library 4.1 getting output parameter after adding record in db, plz guide



I need to get output parameter (flag) from db after saving record in database. I am using Microsoft Enterprise Library 4.1 for DB. I am inserting record using I Data reader.

Please guide


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend