binding data using a repeater control
List<T> ss = new List<T>();
string connectionString = @"Server=arun;Database=us;User ID=sa;Password=server;";
using (SqlConnection conn = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand("dbo.arun"))
{
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
cmd.Connection = conn;
using (SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
while (rdr.Read())
{
arun n = new arun { suppid = rdr.GetString(0), suppname = rdr.GetString(1), dispname = rdr.GetString(2) };
ss.Add(n);
}
rdr.Close();
}
}
}
Repeater1.DataSource = ss;
Repeater1.DataBind();
in html page add
<asp:Repeater ID="Repeater1" runat="server" OnItemDataBound="Repeater1_ItemDataBound">
<ItemTemplate>
<div id="dvRowData" runat="server" class="itemRows">
<div id="dvEmpId" class="w30" style="display:none ">
<%# Eval("suppid") %>
</div>
<div id="dvEmpName" class="w200s">
<%# Eval("suppname")%></div>
<div id="dvEmpAge" class="w60" style="display:none ">
<%# Eval("dispname") %></div>
<div class="w40s">
<input type="Button" id="basic" class="basic" value="Edit" runat="server" />
</div>
</div>
</ItemTemplate>
</asp:Repeater>
in behind code in Repeater_ItemDataBound event
RepeaterItem rowItem = e.Item;
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
HtmlControl btn = e.Item.FindControl("basic") as HtmlControl;
HtmlControl rowContainer = e.Item.FindControl("dvRowData") as HtmlControl;
if (btn != null)
{
btn.Attributes.Add("onClick", string.Format("showDataRow('{0}');", rowContainer.ClientID));
}
}
java function for poup
function showDataRow(rowContainerId) {
var childControlsArray = document.getElementById(rowContainerId).childNodes;
var empId, empName, empAge, empBasicPay;
for (var i = 0; i < childControlsArray.length; i++) {
if (childControlsArray.item(i).id == 'dvEmpId') {
empId = childControlsArray[i].innerHTML;
}
else if (childControlsArray.item(i).id == 'dvEmpName') {
empName = childControlsArray.item(i).innerHTML;
}
else if (childControlsArray.item(i).id == 'dvEmpAge') {
empAge = childControlsArray.item(i).innerHTML;
}
}
//document.getElementById('dvEmployPopup').innerHTML = empId + ' ' + empName + ' ' + empAge + ' ' + empBasicPay;
document.getElementById('txtEmpId').value = empId.trim();
document.getElementById('SupplierNameTxt').value = empName.trim();
document.getElementById('SupplierDisplayTxt').value = empAge.trim();
$('.mask').css({ 'width': 1500, 'height': 1437 });
$('.mask').fadeIn(100);
$('.mask').fadeTo("fast", 0.8);
$('.window').css('top', 287.5);
$('.window').css('left', 409.5);
$('.window').css('display', 'inline');
$('.window').fadeIn('slow');
return false;
}
[B]style sheet for repeater[/B]
body
{
}
.headerRow
{
width: 461px;
height: 25px;
border-top: solid 1px;
border-bottom: solid 1px;
background-color: #DEEAFA;
}
.itemRow
{
width: 461px;
border-bottom: solid 1px;
height: 25px;
}
.itemRows
{
width: 461px;
height: 25px;
}
.w30
{
float: left;
width: 30px;
height: 25px;
border-left: solid 1px;
padding-left: 5px;
}
.w40
{
float: left;
width: 40px;
height: 25px;
border-left: solid 1px;
padding-left: 5px;
}
.w40s
{
float: left;
width: 40px;
height: 25px;
padding-left: 5px;
}
.w100
{
float: left;
width: 100px;
height: 25px;
border-left: solid 1px;
padding-left: 5px;
}
.w200
{
float: left;
width: 200px;
height: 25px;
border-left: solid 1px;
padding-left: 5px;
}
.w200s
{
float: left;
width: 200px;
height: 25px;
padding-left: 5px;
}
.w60
{
float: left;
width: 60px;
height: 25px;
border-left: solid 1px;
padding-left: 5px;
}
.w40
{
float: left;
width: 40px;
height: 25px;
border-left: solid 1px;
padding-left: 5px;
}
.input
{
padding: 5px 5px 5px 25px;
width: 340px;
}
.label
{
float: left;
width: 100px;
}
.input text
{
float: left;
width: 200px;
}
h2
{
padding-left: 25px;
}