Add a subtotal Row in a asp dot net Repeater control?

home / software / tips and tricks / Add a subtotal Row in a asp dot net Repeater control?

Add a subtotal Row in a asp dot net Repeater control?

Category: ASP.Net
view more software Tips and Tricks

Updated: 03/01/2011 16:03 PM
Author: Shiju Mathews

Status: Resolved.

Create a data table and crete a stored procedure that will pull data order by DepartmentId.

Create a sub total Row in a asp dot net Repeater

On a Repeater control we are trying to create sub total by 'DepartmentId'.

CREATE TABLE [dbo].[Employees]( [EmployeeId] [INT] Identity(1,1) NOT NULL , [DepartmentId] [int] NULL, [FirstName] [nvarchar](50) NOT NULL, [LastName] [nvarchar](50) NOT NULL, [FullName] [nvarchar](100) NOT NULL, [Salary] [int] Not NULL default 0) ON [PRIMARY] ALTER TABLE [Employees] ADD PRIMARY KEY (EmployeeId); GO
INSERT INTO [CICdb].[dbo].[Employees]
values (1
,'mike'
,'Mike'
,'Mike Mike'
,'99000')
GO
INSERT INTO [CICdb].[dbo].[Employees]
values (1
,'Scott'
,'Scott'
,'Scott Scott'
,'63000')
GO
INSERT INTO [CICdb].[dbo].[Employees]
values (2
,'bill'
,'bill'
,'bill bill'
,'66000')
GO
INSERT INTO [CICdb].[dbo].[Employees]
values (2
,'dan'
,'dan'
,'dan dan'
,'13500')
GO
INSERT INTO [CICdb].[dbo].[Employees]
values (2
,'nancy'
,'nancy'
,'nancy nancy'
,'68500')
GO
INSERT INTO [CICdb].[dbo].[Employees]
values (1
,'Eric'
,'Eric'
,'Eric Eric'
,'168500')
GO
INSERT INTO [CICdb].[dbo].[Employees]
values (3
,'Tomas'
,'Tomas'
,'Tomas Tomas'
,'125500')
GO
CREATE PROCEDURE [dbo].[EmployeeList]
AS
SET NOCOUNT ON
select * from [CICdb].[dbo].[Employees] Order By [DepartmentId]
SET NOCOUNT OFF
RETURN (0)
GO

Create an asp Repeater control named 'rptEmployelist'.

_InsertData is a string variable that hold the Value for the Sub Total Row. Now add the following section on the code Behind.

Please copy the code and reformat it.

#region Member Variables
public string _InsertData = string.Empty;
StringBuilder stringBuilder;
private int _SalarySubTotal = 0;
private int _TotalDataRowCount = 0;
private int _HoldSDepartmentNo = 0;
private int WorkingDeptNo = 0;
#endregion
protected void Page_Load(object sender, EventArgs e)
{
// Connect to the database and access the Datatable named tblSalary.
_TotalDataRowCount = tblSalary.Rows.Count;
rptEmployeeList.DataSource = tblSalary;
rptEmployeeList.DataBind();
}
protected void Repeater_OnItemDataBound(object sender, RepeaterItemEventArgs e)
{ if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{ if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType ==
ListItemType.AlternatingItem)
{
_InsertData = string.Empty;
int CurrentDataRowNo = e.Item.ItemIndex + 1;
DataRowView drv = (DataRowView)e.Item.DataItem;
WorkingDeptNo = Convert.ToInt32(drv["DepartmentId"]);
stringBuilder = new StringBuilder();
if (_HoldSDepartmentNo != 0 && (_HoldSDepartmentNo !=
WorkingDeptNo))
{
stringBuilder.Append("<tr><td colspan='4' style=' text-align:right;'> SalarySubTotal: <b>" + _SalarySubTotal
+ "</b></td></tr>");
_SalarySubTotal = 0;
}
_SalarySubTotal += Convert.ToInt32(drv["Salary"]);
_HoldSDepartmentNo = WorkingDeptNo;
stringBuilder.Append(string.Concat("<tr><td>", drv["EmployeeId"], "</td>"));
stringBuilder.Append(string.Concat("<td>", drv["DepartmentId"], "</td>"));
stringBuilder.Append(string.Concat("<td>", drv["FullName"], "</td>"));
stringBuilder.Append(string.Concat("<td>", drv["Salary"], "</td></tr>"));
if (CurrentDataRowNo == _TotalDataRowCount)
{
stringBuilder.Append("<tr><td colspan='4' style=' text-align:right;'>Salary SubTotal:<b> " +
_SalarySubTotal + "</b></td></tr>");
}
_InsertData = stringBuilder.ToString();
} }
}

Indian Resources by Category

Indian Grocery Stores

Indian Jewelry Stores

Indian Hindu Temple

alt="Add your business to our listing Free"

Software Resources

Tips and Tricks

Interview Questions for C#

Interview Questions for ASP.Net

Interview Questions for SQL Server