TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
mary jean ligas
NA
420
196.7k
Dynamically GridView code behind
Oct 30 2012 10:52 PM
Hello Everyone,
Please help me how to create a gridview dynamically..I have ab HTML TABLE code here:
how can i revert this in a gridview
protected void DisplayUser()
{
try
{
CLMSDataContext context = new CLMSDataContext();
string query = "select User_Idx, LastName, FirstName, MiddleInitial, NickName, PosLoc_Abbreviation, DateTimeRegistered from Dim_User " + Environment.NewLine +
"where PosLoc_Abbreviation is not null" + Environment.NewLine +
"order by DateTimeRegistered desc";
List<tmp_Users> TmpUser = context.ExecuteQuery<tmp_Users>(query).ToList();
foreach (tmp_Users u in TmpUser)
{
var created = context.DateInterval(u.DateTimeRegistered);
foreach (var di in created)
{
var post = (from p in context.Fact_Contract_Threads
where p.User_PIdx == u.User_Idx
select new { p.Message }).Count();
string s = di.Assigned.ToString();
tbl_DisplayUser("Content", u.LastName + ",  " + u.FirstName + " " + u.MiddleInitial + ". ", "tblDisplayUser", "TimeAssigned", "also known as ",
"tblDisplayUser", "Content", u.NickName + ", " + u.PosLoc_Abbreviation, "tblDisplayUser",
"View", "<a href=EditUser.aspx?id=" + u.User_Idx + " + class=View>   [edit]</a> [deactivate]" + "<br />", "tblDisplayUser",
"TimeAssigned", "Created " + di.Assigned + " ago | " + "Active |" + " Posts"+ "("+post +")" , "tblDisplayUser");
//string role = "SELECT usr.SMTPAddress, roles.Plant_Name, roles.Dept_Name, roles.Role_Name" + Environment.NewLine +
// " FROM Dim_User usr " + Environment.NewLine +
// " join ( " + Environment.NewLine +
// " SELECT distinct User_PIdx, Role_Name, dept.Dept_Name, loc.Plant_Name, rol.Role_Idx FROM Dim_User_Role usrol " + Environment.NewLine +
// " join Dim_Role rol on (rol.Role_Idx = usrol.Role_PIdx) " + Environment.NewLine +
// " join Dim_Department dept on (dept.Dept_Idx = usrol.Dept_PIdx) " + Environment.NewLine +
// " join Dim_Location_Plant loc on (loc.Plant_Idx = usrol.Plant_PIdx) " + Environment.NewLine +
// " ) [roles] " + Environment.NewLine +
// " on roles.User_PIdx = usr.User_Idx " + Environment.NewLine +
// " where usr.User_Idx='"+ u.User_Idx +"' ";
//List<tmp_Roles> TmpRole = context.ExecuteQuery<tmp_Roles>(role).ToList();
//foreach (tmp_Roles r in TmpRole)
//{
// tbl_DisplayRole("SubFont", r.Role_Name + " |" + r.Plant_Name + " |" + r.Dept_Name + " |" + r.SMTPAddress + " |" , "tblDisplayUser");
//}
}
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected void tbl_DisplayUser(string clmsClass, string clmsValue, string tableName,
string clmsClass2, string clmsValue2, string tableName2,
string clmsClass3, string clmsValue3, string tableName3,
string clmsClass4, string clmsValue4, string tableName4,
string clmsClass5, string clmsValue5, string tableName5)
{
try
{
HtmlTableRow htRow = new HtmlTableRow();
HtmlTableCell htCell = new HtmlTableCell();
Label lbContent = new Label();
lbContent.CssClass = clmsClass;
lbContent.Text = clmsValue;
htCell.Controls.Add(lbContent);
htRow.Cells.Add(htCell);
Label lbContent2 = new Label();
lbContent2.CssClass = clmsClass2;
lbContent2.Text = clmsValue2;
htCell.Controls.Add(lbContent2);
htRow.Cells.Add(htCell);
Label lbContent3 = new Label();
lbContent3.CssClass = clmsClass3;
lbContent3.Text = clmsValue3;
htCell.Controls.Add(lbContent3);
htRow.Cells.Add(htCell);
Label lbContent4 = new Label();
lbContent4.CssClass = clmsClass4;
lbContent4.Text = clmsValue4;
htCell.Controls.Add(lbContent4);
htRow.Cells.Add(htCell);
Label lbContent5 = new Label();
lbContent5.CssClass = clmsClass5;
lbContent5.Text = clmsValue5;
htCell.Controls.Add(lbContent5);
htRow.Cells.Add(htCell);
if (tableName == "tblDisplayUser")
{
tblDisplayUser.Rows.Add(htRow);
}
else
{
tblDisplayUser.Rows.Add(htRow);
}
}
catch (Exception e)
{
Response.Write(e.Message);
}
}
protected void tbl_DisplayRole(string clmsClass, string clmsValue, string tableName)
{
try
{
HtmlTableRow htRow = new HtmlTableRow();
HtmlTableCell htCell = new HtmlTableCell();
Label lbContent = new Label();
lbContent.CssClass = clmsClass;
lbContent.Text = clmsValue;
htCell.Controls.Add(lbContent);
htCell.Style.Add("padding-left", "10px");
htRow.Cells.Add(htCell);
if (tableName == "tblDisplayUser")
{
tblDisplayUser.Rows.Add(htRow);
}
else
{
tblDisplayUser.Rows.Add(htRow);
}
}
catch (Exception e)
{
Response.Write(e.Message);
}
}
Reply
Answers (
0
)
obtain file for C# 2008
Countdown timer all button textbox not visible