Blue Theme Orange Theme Green Theme Red Theme
 
Team Foundation Server Hosting
Home | Forums | ASP.NET 2.0 Tutorials | Web Services | How Do I...? | Class Browser | WPF Quick Starts | Advertise with Us
 | Consulting  
Submit an Article Submit a Blog 
 Jump to
Skip Navigation Links
TechnologyExpand Technology
WebsiteExpand Website
6 Months Free & No Setup Fees ASP.NET Hosting!
Search :       Advanced Search »
Home » ASP.NET 2.0 » Use of Detailview with drop down list in asp.net 2.0

Use of Detailview with drop down list in asp.net 2.0

In this article you will learn how to use of detail view.

Author Rank :
Page Views : 9303
Downloads : 140
Rating :
 Rate it
Level : Beginner
   Print Read/Post comments Post a comment  Similar Articles  
   Email to a friend  Bookmark  Author's other articles  
Download Files:
DetailView.zip
 
 
Team Foundation Server Hosting
Become a Sponsor
 Tag Cloud
 Latest Jobs
More ... 
 Latest Interview Questions
More ... 


In this article you will learn how to use of detail view and how to show the record in detailview.

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!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>Detail view</title>
</
head>
<
body>
<form id="form1" runat="server">
<div>
<table cellpadding="0" cellspacing="0" width="70%" align="center">
<tr>
<td>
<asp:DropDownList ID="ddlStudent" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlStudent_SelectedIndexChanged">
</asp:DropDownList><br />
<br />
<asp:Label ID="lblError" runat="server" ForeColor="red" Font-Bold="true" Font-Size="12pt" Visible="false"></asp:Label>
<asp:DetailsView ID="DetailsViewStudentRecord" runat="server">
</asp:DetailsView>
</td>
</tr>
</table>
</div>
</form>
</
body>
</html>

Image 1: Drop down list on the page.

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public
partial class _Default : System.Web.UI.Page
{
SqlConnection con;
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da;
DataSet ds;

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
rebindStudentRecord();
FillStudentRecord();
}
}

public void rebindStudentRecord()
{
con =
new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
cmd.CommandText =
"Select * from UserRecord";
cmd.Connection = con;
ds =
new DataSet();
da =
new SqlDataAdapter(cmd);
con.Open();
cmd.ExecuteNonQuery();
da.Fill(ds);
con.Close();
ddlStudent.DataValueField =
"UserId";
ddlStudent.DataTextField =
"UserId";
ddlStudent.DataSource = ds;
ddlStudent.DataBind();
ddlStudent.Items.Add(
"Select User ID");
ddlStudent.Items.FindByValue(
"Select User ID").Selected = true;
}

protected void ddlStudent_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlStudent.SelectedValue.ToString() == "Select User ID")
{
lblError.Visible =
true;
lblError.Text =
"Select User ID To See Student record";
DetailsViewStudentRecord.DataSource =
null;
DetailsViewStudentRecord.DataBind();
}
else
{
FillStudentRecord();
}
}

public void FillStudentRecord()
{
if (ddlStudent.SelectedValue.ToString() == "Select User ID")
{
lblError.Visible =
true;
lblError.Text =
"Select User ID To See Student record";
}
else
{
string StudentUserID = ddlStudent.SelectedValue.ToString();
con =
new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
cmd.CommandText =
"Select * from UserRecord Where UserId= '" + StudentUserID + "'";
cmd.Connection = con;
da =
new SqlDataAdapter(cmd);
ds =
new DataSet();
con.Open();
cmd.ExecuteNonQuery();
da.Fill(ds);
con.Close();

if (ds.Tables[0].Rows.Count > 0)
{
DetailsViewStudentRecord.DataSource = ds;
DetailsViewStudentRecord.DataBind();
lblError.Visible =
false;
}
else
{
lblError.Visible =
true;
lblError.Text =
"No Record Exist To This User ID";
DetailsViewStudentRecord.DataSource =
null;
DetailsViewStudentRecord.DataBind();
}
}
}
}

Web.config:

<configuration>
     <
appSettings>
             <
add key="ConnectionString" value="Data Source=PURU-4CE37E9873\SQLSERVER2005;Initial Catalog=StudentRecord;User ID=sa;Password=wintellect;"/>
      </
appSettings>
<
connectionStrings/>

Image 2: Select user id from the drop down list.

Image 3: Show the record in detail view. 

Comment Request!
Thank you for reading this post. Please post your feedback, question, or comments about this post Here.
Login to add your contents and source code to this article
 [Top] Rate this article
 
 About the author
 
Purushottam Rathore

I am working as a Software Developer and has 4 years of experience on Microsoft Technology and having a Master Degree in Computer Application. I really like to work in the .NET platform. and working with ASP.NET 2.0/3.5, Web Services, WPF, WCF, Silverlight, AJAX, JavaScript, JQuery, Ado.net, MsAccess, SQL Server 2005/2008.

Looking for C# Consulting?
C# Consulting is founded in 2002 by the founders of C# Corner. Unlike a traditional consulting company, our consultants are well-known experts in .NET and many of them are MVPs, authors, and trainers. We specialize in Microsoft .NET development and utilize Agile Development and Extreme Programming practices to provide fast pace quick turnaround results. Our software development model is a mix of Agile Development, traditional SDLC, and Waterfall models.
Click here to learn more about C# Consulting.
 
Introducing MaxV - one click. infinite control. Hyper-V Hosting from MaximumASP.
Finally – a virtual platform that delivers next-generation Windows Server 2008 Hyper-V virtualization technology from a managed hosting partner you can truly depend on. Visit www.maximumasp.com/max for a FREE 30 day trial. Hurry offer ends soon. Climb aboard the MaxV platform and take advantage of High Availability, Intelligent Monitoring, Recurrent Backups, and Scalability – with no hassle or hidden fees. As a managed hosting partner focused solely on Microsoft technologies since 2000, MaximumASP is uniquely qualified to provide the superior support that our business is built on. Unparalleled expertise with Microsoft technologies lead to working directly with Microsoft as first to offer IIS 7 and SQL 2008 betas in a hosted environment; partnering in the Go Live Program for Hyper-V; and product co-launches built on WS 2008 with Hyper-V technology.
Dynamic PDF
ceTE software specializes in components for dynamic PDF generation and manipulation. The DynamicPDF™ product line allows you to dynamically generate PDF documents, merge PDF documents and new content to existing PDF documents from within your applications.
Nevron Chart for .NET 2010.1 Now Available
The leading .NET charting control now features PDF, Flash and Silverlight export, visualization of large datasets and more. Deliver true charting functionality to your BI, Scorecard, Presentation or Scientific apps. Download evaluation now.
ASP.NET 4 Hosting
Get 2 Months Free of ASP.NET Hosting for Only $4.95/month! Receive FREE MS SQL and MySQL Databases Including ASP.NET 4/3.5, MVC 3.0, Silverlight 4, Windows 2008/IIS 7.0 Plus FREE IIS 7 Modules. Host UNLIMITED ASP.NET Web Sites – Click Here!
 
 Post a Feedback, Comment, or Question about this article
Subject:
Comment:
Nevron Gauge for SharePoint
Become a Sponsor
 Comments
Good by chandara On February 11, 2009
yeah, it is good. thanks for your file
Reply | Email | Modify 
Re: Good by Purushottam On February 11, 2009
Hi chandara Thanks.. Keep it up...
Reply | Email | Modify 
Detail view by Narendra On February 25, 2009
thank you...
Reply | Email | Modify 
Good Keep It by raj On May 7, 2009

Really nice article. I need how to use richtextbox in asp.net. Please Help me

Reply | Email | Modify 
6 Months Free & No Setup Fees ASP.NET Hosting!
 © 2012  contents copyright of their authors. Rest everything copyright Mindcracker. All rights reserved.