This is my HTML Code.
[code=c#]
<%@ Page Language="C#" MasterPageFile= "~/TopMasterPageWi thMenu.master" AutoEventWireup ="true" CodeFile="Listo fCoursesOffer.a spx.cs" Inherits="Listo fCoursesOffer" Title="List of Courses Offer" %>
<asp:Content ID="Content1" ContentPlaceHol derID="ContentP laceHolder1" Runat="Server">
<br />
<br />
<asp:Literal id="ltrProgramC ode" runat="server"> </asp:Literal>
<table width="100%" style="margin-left:auto;margi n-right:auto;font-family:Verdana; font-size:11px;font-weight:bold;bor der-color:Black;bor der:1px" >
<tr style="backgrou nd-color:#62a0c4" >
<td align="center"> List of Courses Offer</td>
</tr>
<tr>
<td>
<asp:Repeater ID="repListofCo urse" runat="server" OnItemDataBound ="repListofCour se_ItemDataBoun d">
<HeaderTemplate >
<table width="100%" border="1px solid" style="font-family:Verdana; font-size:11px">
<tr >
<td style="width:30 %">Program</td>
<td style="width:10 %">Semester</td>
<td style="width:20 %">Stream</td>
<td style="width:35 %">Course</td>
</tr>
</HeaderTemplate>
<ItemTemplate >
<tr style="font-weight:normal">
<td style="width:30 %">Program:- '<%=strProgramN ame%>'</td> <td style="width:10 %"><%#DataBinde r.Eval(Containe r.DataItem, "SemesterName") %></td>
<td style="width:20 %"><%#DataBinde r.Eval(Containe r.DataItem, "StreamElective Name")%></td>
<td style="width:35 %"><%#DataBinde r.Eval(Containe r.DataItem, "CourseName")%> </td>
</tr>
</ItemTemplate>
<FooterTemplate >
</table>
</FooterTemplate>
</asp:Repeater>
</td>
</tr>
</table>
</asp:Content>
Server Side Code is below
using System;
using System.Data;
using System.Configur ation;
using System.Collecti ons;
using System.Web;
using System.Web.Secu rity;
using System.Web.UI;
using System.Web.UI.W ebControls;
using System.Web.UI.W ebControls.WebP arts;
using System.Web.UI.H tmlControls;
public partial class ListofCoursesOf fer : System.Web.UI.P age
{
long lngProgramCode;
protected String strProgramName;
protected void Page_Load(objec t sender, EventArgs e)
{
BlackBox blc = new BlackBox();
String strSQL;
DataSet DS = new DataSet();
strSQL = " SELECT DISTINCT " +
" mstBatchDefinit ionDetail.Progr amGroupCode, " +
" mstBatchDefinit ionDetail.Progr amCode, " +
" mstBatchDefinit ionDetail.Semes terCode, " +
" mstBatchDefinit ionDetail.Strea mCode, " +
" mstProgram.Name As [ProgramName], " +
" Isnull(mstSemes ter.Name,'') As [SemesterName], " +
" Case When mstBatchDefinit ionDetail.Elect iveCourseGroupC ode > 0 " +
" Then Isnull(mstElect iveCourseGroup. Name,'') " +
" Else Isnull(mstStrea m.Name,'') " +
" END As [StreamElectiveN ame], " +
" mstBatchDefinit ionDetail.Cours eCode As [CourseDBCode], " +
" mstCourse.Cours eCode + ' - ' + mstCourse.Name as [CourseName] " +
" FROM tranTermDefinat ionHeader " +
" JOIN tranTermBatchDe fination On tranTermbatchDe fination.Header Code = tranTermDefinat ionHeader.Code " +
" JOIN mstBatchDefinit ionDetail On mstBatchDefinit ionDetail.Heade rCode = tranTermBatchDe fination.BatchC ode " +
" AND mstBatchDefinit ionDetail.Progr amCode = tranTermBatchDe fination.Progra mCode " +
" AND mstBatchDefinit ionDetail.Semes terCode IN (0,tranTermBatc hDefination.Sem esterCode) " +
" AND mstBatchDefinit ionDetail.Strea mCode IN (0,tranTermBatc hDefination.Str eamCode) " +
" Join mstProgram On mstProgram.Code = mstBatchDefinit ionDetail.Progr amCode " +
" Left Outer Join mstSemester On mstSemester.Cod e = mstBatchDefinit ionDetail.Semes terCode " +
" Left Outer Join mstStream On mstStream.Code = mstBatchDefinit ionDetail.Strea mCode " +
" Left Outer Join mstElectiveCour seGroup On mstElectiveCour seGroup.Code = mstBatchDefinit ionDetail.Elect iveCourseGroupC ode " +
" Left Outer Join mstCourse On mstCourse.Code = mstBatchDefinit ionDetail.Cours eCode " +
" WHERE tranTermDefinat ionHeader.Acade micYearCode = " + Session["AcademicYearCo de"].ToString() +
" AND tranTermDefinat ionHeader.Locat ionCode = " + Session["LocationCo de"].ToString() +
" AND tranTermDefinat ionHeader.TermC ode = " + Session["TermCode"].ToString() +
" ORDER BY mstBatchDefinit ionDetail.Progr amGroupCode, mstProgram.Name , mstBatchDefinit ionDetail.Semes terCode, mstBatchDefinit ionDetail.Strea mCode, " +
" mstCourse.Cours eCode + ' - ' + mstCourse.Name " ;
DS = blc.ExecuteQuer y(strSQL);
repListofCourse .DataSource = DS;
repListofCourse .DataBind();
}
protected void repListofCourse _ItemDataBound( object sender, System.Web.UI.W ebControls.Repe aterItemEventAr gs e)
{
long lngTempProgramC ode;
if (e.Item.DataIte m != null)
{
lngTempProgramC ode = long.Parse(Data Binder.Eval(e.I tem.DataItem, "ProgramCode"). ToString());
if (lngTempProgram Code == lngProgramCode)
{
strProgramName= (((System.Data. DataRowView)(e. Item.DataItem))["ProgramNam e"]).ToString (); strProgramName = "";
}
else
{
lngProgramCode = lngTempProgramC ode;
strProgramName = (((System.Data. DataRowView)(e. Item.DataItem))["ProgramNam e"]).ToString();
}
}
}
}[/code]I m setting strProgramName Value from serverside to client. But result is empty string for strProgramName.
why it happning i don't know. because while debugging it setting value for strProgramName but while displaying it is empty string.
can anybody help me?
[code=c#]
<%@ Page Language="C#" MasterPageFile= "~/TopMasterPageWi thMenu.master" AutoEventWireup ="true" CodeFile="Listo fCoursesOffer.a spx.cs" Inherits="Listo fCoursesOffer" Title="List of Courses Offer" %>
<asp:Content ID="Content1" ContentPlaceHol derID="ContentP laceHolder1" Runat="Server">
<br />
<br />
<asp:Literal id="ltrProgramC ode" runat="server"> </asp:Literal>
<table width="100%" style="margin-left:auto;margi n-right:auto;font-family:Verdana; font-size:11px;font-weight:bold;bor der-color:Black;bor der:1px" >
<tr style="backgrou nd-color:#62a0c4" >
<td align="center"> List of Courses Offer</td>
</tr>
<tr>
<td>
<asp:Repeater ID="repListofCo urse" runat="server" OnItemDataBound ="repListofCour se_ItemDataBoun d">
<HeaderTemplate >
<table width="100%" border="1px solid" style="font-family:Verdana; font-size:11px">
<tr >
<td style="width:30 %">Program</td>
<td style="width:10 %">Semester</td>
<td style="width:20 %">Stream</td>
<td style="width:35 %">Course</td>
</tr>
</HeaderTemplate>
<ItemTemplate >
<tr style="font-weight:normal">
<td style="width:30 %">Program:- '<%=strProgramN ame%>'</td> <td style="width:10 %"><%#DataBinde r.Eval(Containe r.DataItem, "SemesterName") %></td>
<td style="width:20 %"><%#DataBinde r.Eval(Containe r.DataItem, "StreamElective Name")%></td>
<td style="width:35 %"><%#DataBinde r.Eval(Containe r.DataItem, "CourseName")%> </td>
</tr>
</ItemTemplate>
<FooterTemplate >
</table>
</FooterTemplate>
</asp:Repeater>
</td>
</tr>
</table>
</asp:Content>
Server Side Code is below
using System;
using System.Data;
using System.Configur ation;
using System.Collecti ons;
using System.Web;
using System.Web.Secu rity;
using System.Web.UI;
using System.Web.UI.W ebControls;
using System.Web.UI.W ebControls.WebP arts;
using System.Web.UI.H tmlControls;
public partial class ListofCoursesOf fer : System.Web.UI.P age
{
long lngProgramCode;
protected String strProgramName;
protected void Page_Load(objec t sender, EventArgs e)
{
BlackBox blc = new BlackBox();
String strSQL;
DataSet DS = new DataSet();
strSQL = " SELECT DISTINCT " +
" mstBatchDefinit ionDetail.Progr amGroupCode, " +
" mstBatchDefinit ionDetail.Progr amCode, " +
" mstBatchDefinit ionDetail.Semes terCode, " +
" mstBatchDefinit ionDetail.Strea mCode, " +
" mstProgram.Name As [ProgramName], " +
" Isnull(mstSemes ter.Name,'') As [SemesterName], " +
" Case When mstBatchDefinit ionDetail.Elect iveCourseGroupC ode > 0 " +
" Then Isnull(mstElect iveCourseGroup. Name,'') " +
" Else Isnull(mstStrea m.Name,'') " +
" END As [StreamElectiveN ame], " +
" mstBatchDefinit ionDetail.Cours eCode As [CourseDBCode], " +
" mstCourse.Cours eCode + ' - ' + mstCourse.Name as [CourseName] " +
" FROM tranTermDefinat ionHeader " +
" JOIN tranTermBatchDe fination On tranTermbatchDe fination.Header Code = tranTermDefinat ionHeader.Code " +
" JOIN mstBatchDefinit ionDetail On mstBatchDefinit ionDetail.Heade rCode = tranTermBatchDe fination.BatchC ode " +
" AND mstBatchDefinit ionDetail.Progr amCode = tranTermBatchDe fination.Progra mCode " +
" AND mstBatchDefinit ionDetail.Semes terCode IN (0,tranTermBatc hDefination.Sem esterCode) " +
" AND mstBatchDefinit ionDetail.Strea mCode IN (0,tranTermBatc hDefination.Str eamCode) " +
" Join mstProgram On mstProgram.Code = mstBatchDefinit ionDetail.Progr amCode " +
" Left Outer Join mstSemester On mstSemester.Cod e = mstBatchDefinit ionDetail.Semes terCode " +
" Left Outer Join mstStream On mstStream.Code = mstBatchDefinit ionDetail.Strea mCode " +
" Left Outer Join mstElectiveCour seGroup On mstElectiveCour seGroup.Code = mstBatchDefinit ionDetail.Elect iveCourseGroupC ode " +
" Left Outer Join mstCourse On mstCourse.Code = mstBatchDefinit ionDetail.Cours eCode " +
" WHERE tranTermDefinat ionHeader.Acade micYearCode = " + Session["AcademicYearCo de"].ToString() +
" AND tranTermDefinat ionHeader.Locat ionCode = " + Session["LocationCo de"].ToString() +
" AND tranTermDefinat ionHeader.TermC ode = " + Session["TermCode"].ToString() +
" ORDER BY mstBatchDefinit ionDetail.Progr amGroupCode, mstProgram.Name , mstBatchDefinit ionDetail.Semes terCode, mstBatchDefinit ionDetail.Strea mCode, " +
" mstCourse.Cours eCode + ' - ' + mstCourse.Name " ;
DS = blc.ExecuteQuer y(strSQL);
repListofCourse .DataSource = DS;
repListofCourse .DataBind();
}
protected void repListofCourse _ItemDataBound( object sender, System.Web.UI.W ebControls.Repe aterItemEventAr gs e)
{
long lngTempProgramC ode;
if (e.Item.DataIte m != null)
{
lngTempProgramC ode = long.Parse(Data Binder.Eval(e.I tem.DataItem, "ProgramCode"). ToString());
if (lngTempProgram Code == lngProgramCode)
{
strProgramName= (((System.Data. DataRowView)(e. Item.DataItem))["ProgramNam e"]).ToString (); strProgramName = "";
}
else
{
lngProgramCode = lngTempProgramC ode;
strProgramName = (((System.Data. DataRowView)(e. Item.DataItem))["ProgramNam e"]).ToString();
}
}
}
}[/code]I m setting strProgramName Value from serverside to client. But result is empty string for strProgramName.
why it happning i don't know. because while debugging it setting value for strProgramName but while displaying it is empty string.
can anybody help me?
Comment