Answer Posted / d

/* Default.aspx */

<div>
<asp:DropDownList ID="ddlProject" runat="server"
AutoPostBack="true"></asp:DropDownList>
<asp:DropDownList ID="ddlDivision" runat="server"
AutoPostBack="true"></asp:DropDownList>
<asp:GridView ID="gvMember" runat="server"
AutoGenerateColumns="false"
OnRowDataBound="gvMember_RowDataBound">
<Columns>
<asp:BoundField DataField="ProjDesc"
HeaderText="Project Name" />
<asp:BoundField DataField="DivisionName"
HeaderText="Division Name" />
<asp:BoundField DataField="MemberID" HeaderText="Member
ID" />
<asp:BoundField DataField="MemberName"
HeaderText="Member Name" />
</Columns>
</asp:GridView>
</div>

/* Default.aspx.cs */

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
{
public string projDesc = string.Empty;
public string divisionName = string.Empty;


protected void Page_Load(object sender, EventArgs e) {
string projCode = string.Empty;
string divisionID = string.Empty;

if (!IsPostBack) {
PopulateData.LoadProject(ddlProject);
}

projCode = ddlProject.SelectedValue.ToString();

if (Session["projCode"] == null || !projCode.Equals
(Session["projCode"].ToString())) {
PopulateData.LoadDivision(ddlDivision,
projCode);
Session["projCode"] = projCode;
}

divisionID = ddlDivision.SelectedValue.ToString();

if (!divisionID.Equals(string.Empty)) {
gvMember.DataSource =
PopulateData.LoadMemberDetails(projCode, divisionID);
gvMember.DataBind();
}
}


protected void gvMember_RowDataBound(object sender,
GridViewRowEventArgs e) {
if (e.Row.RowIndex == 0) {
projDesc = e.Row.Cells[0].Text;
divisionName = e.Row.Cells[1].Text;
}

if (e.Row.RowIndex > 0) {
if (projDesc.Equals(e.Row.Cells[0].Text)) {
e.Row.Cells[0].Text = "";
}

if (divisionName.Equals(e.Row.Cells[1].Text)) {
e.Row.Cells[1].Text = "";
}
}
}
}

/* Populate.cs */

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;

/// <summary>
/// Summary description for PopulateData
/// </summary>
public class PopulateData
{
public PopulateData()
{
//
// TODO: Add constructor logic here
//
}

public static DataSet LoadProject() {
string query = string.Empty;
query = "select * from Project";
DataSet dst = Data.getDataSet(query);
return dst;
}

public static void LoadProject(DropDownList ddlProject)
{
string query = string.Empty;
query = "select * from Project";
DataSet dst = Data.getDataSet(query);
ddlProject.DataSource = dst;
ddlProject.DataValueField = dst.Tables[0].Columns
["ProjCode"].ToString();
ddlProject.DataTextField = dst.Tables[0].Columns
["ProjDesc"].ToString();
ddlProject.DataBind();
dst.Dispose();
}

public static DataSet LoadDivision(string projCode) {
string query = string.Empty;
query = "select * from Division where ProjCode = "
+ Convert.ToInt32(projCode);
DataSet dst = Data.getDataSet(query);
return dst;
}

public static void LoadDivision(DropDownList
ddlDivision, string projCode) {
string query = string.Empty;
query = "select * from Division where ProjCode = "
+ Convert.ToInt32(projCode);
DataSet dst = Data.getDataSet(query);
ddlDivision.DataSource = dst;
ddlDivision.DataValueField = dst.Tables[0].Columns
["DivisionID"].ToString();
ddlDivision.DataTextField = dst.Tables[0].Columns
["DivisionName"].ToString();
ddlDivision.DataBind();
dst.Dispose();
}

public static DataSet LoadMemberDetails(string
projCode, string divisionID) {
string query = string.Empty;
query = "select c.ProjDesc, b.DivisionName,
a.MemberID, a.MemberName from Member a";
query += " inner join Division b on a.DivisionID =
b.DivisionID";
query += " inner join Project c on b.ProjCode=
c.ProjCode";
query += " where a.ProjCode = " + Convert.ToInt32
(projCode) + " and a.DivisionID = " + Convert.ToInt32
(divisionID);
DataSet dst = Data.getDataSet(query);
return dst;
}
}

/* Connection.cs */

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;

/// <summary>
/// Summary description for Connection
/// </summary>
public class Connection
{
public Connection()
{
//
// TODO: Add constructor logic here
//
}

public static SqlConnection OpenConnection
(SqlConnection con) {
con.ConnectionString =
ConfigurationManager.ConnectionStrings["conString"].ToString
();
con.Open();
return con;
}

public static void CloseConnection(SqlConnection con){
if (con.State == ConnectionState.Open) {
con.Close();
}
}
}

/* Data.cs */

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;

/// <summary>
/// Summary description for Data
/// </summary>
public class Data
{
public Data()
{
//
// TODO: Add constructor logic here
//
}

public static DataSet getDataSet(string query) {
SqlConnection con = new SqlConnection();
DataSet dst = new DataSet();
SqlDataAdapter dap = new SqlDataAdapter(query,
Connection.OpenConnection(con));
dap.Fill(dst);
Connection.CloseConnection(con);
return dst;
}
}

What does asp stand for in asp.net?

1021

---

How can you register a custom server control to a web page?

1023

---

Can I tap into other windows livetm services?

1033

---

what is DLL Hell and how it is solved in .NET? please explain clearly??

2413

---

Define the steps to set up validation control.

1094

---

How can we communicate with each server in N-tier Architecture? and what are the methods?

2292

---

What is the viewstate in asp.net?

1098

---

A Web Service Can Only Be Written In .net. Is it True??

1113

---

What is the most appropriate lifetime for a database connection/orm context in an asp.net mvc application? : Asp.Net MVC

1092

---

What kind of data we can store in viewstate?

1093

---

Any one can tell how we store tiff format images in database and retrive from the database(need for tiff format only)

2088

---

How ASP.NET page works?

1138

---

Explain the Session state management options available with ASP.NET?

1081

---

Which object encapsulates state or data of a user?

1106

---

what is meant by sitemapnode ?

2047

---