Moving Rows In Dynamically Created Table Not Working
Nov 12, 2010
I'm maintaining a dynamically generated table in ASP.NET, which allows users to move items up and down in the table. What this essentially does behind the scenes is just swaps around the 'sortorder' which the table is sorted by. I have checks to see if a row is the first/last column, and if so only display up/down (whatever's relevant). An issue has crept up now and I have no idea why. For some reason, most of the time (not all of the time strangely) the up and down buttons don't work. Using 'Up' as an example, the current record does get set to the 'above' rows sortorder, but the 'above' row doesn't take the below rows sort order. Now I've set my breakpoints throughout my code, and strangely everything gets set fine. It's just when I call SubmitChanges() to the LINQ data context, that it seems to put the wrong value into the database. Also what's strange is that I think that if you click it again, it actually works. But it doesn't work properly as the number is still out by a bit.
Here's my code:
if (Request.QueryString["dir"] != null) {
if (Request.QueryString["dir"] == "up") {
var currentrecordup = (from s in dc.InvoiceItems
where Request.QueryString["val"] == s.id.ToString()
select s).Single();
int valsortidup = (int)currentrecordup.sortorder;
var prevrecordup = (from s in dc.InvoiceItems
where s.sortorder < valsortidup
orderby s.sortorder descending select s).First();
int prevsortidup = (int)prevrecordup.sortorder; int tempval = valsortidup;
currentrecordup.sortorder = prevsortidup; prevrecordup.sortorder = tempval; }
else if (Request.QueryString["dir"] == "down") {
var currentrecorddown = (from s in dc.InvoiceItems
where Request.QueryString["val"] == s.id.ToString()
select s).Single(); int valsortiddown = (int)currentrecorddown.sortorder;
var nextrecorddown = (from s in dc.InvoiceItems where s.sortorder > valsortiddown
orderby s.sortorder ascending select s).First();
int nextsortiddown = (int)nextrecorddown.sortorder; int tempvaldown = valsortiddown;
currentrecorddown.sortorder = nextsortiddown; nextrecorddown.sortorder = tempvaldown;}
dc.SubmitChanges(); Response.Redirect("EditInvoice.aspx?id=" + Request.QueryString["id"]);
}
The sortorder column in my table is an int field that allows nulls.
View 1 Replies
Similar Messages:
Jun 22, 2010
I created dynamically a table with 3 rows not by using table tag. I need to find these rows in scripting, in button click, if any of these rows is empty then need to generate an alert message like enter current row.
View 1 Replies
Mar 9, 2011
Im creating a table dynamically in my codebehind to display some statistics. The table is in a usercontrol. When the page first loads, its created and displayed correctly. If I do something that generates a postback, the table subsequently disappears, this is because its created inside a !IsPostback. How can i ensure that the table, once its been generated, stays visble on the page ? I dont want to generate it each time the page loads as it involves a lot of calculations on the database which will slow the pageload down.
View 4 Replies
Jun 2, 2010
Need row editing on page_load for all the cells and need to validate each cell entry. Means cell1 one entery isvalid it fills thrid cell and insert or update to a table in the database. How do i handle on tab clicking to update in databse.
View 1 Replies
Jan 8, 2013
i've dynamically created new rows on button click in gridview with 3 dropdownlist.for the first default row the selectindexchanged is firing and on pageload 1st ddl is loading with values and basing on selection the second ddl is showing values and third ddl is showing basing on second ddl. Now, when i click add new row, a new row is created with 3 ddl's ...1st one is showing properly but when i select from that ddl ,it should show data accordingly but its not showing particular data but showing all realted data from DB.same for 3rd ddl.
Also when new row is added and the first ddl is selected on postback the second ddl data is refreshing..
View 1 Replies
Jan 6, 2011
i wrote a function to create dynamic table in code behind on selectedindexchanged of checkbox,that is when user will check 2 checkboxex 2 tables will be generated with textboxes,Then on button click i want insert values of these textboxes in database,for that i want to find textbox using findcontrol,but i could not find it,
So i called same function of table creation on page load,but then it shows error that textbox is having duplicate id
View 2 Replies
Jan 24, 2011
I am coding online sales a website but I've a problem on main page I have to show products I made it as 4 columns table but there is over than 100 product and i need paging for that. How can I fix it like 20 products per page.
View 2 Replies
Jun 7, 2010
In my code I create a table dynamically and I try to restore the table after a postback. But although I recreate the table during the Page_Load event with the same id's before,the table doesn't appear with the same state and values as before.
I think it will be a typically beginner error, but I wasn't be able to locate the error whereas reading different posts and tutorials related to this topic.
//Code behind
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack & _hfsubmittedURL.Value == "tbCreated")
{
TableRow row1 = new TableRow();
[Code].....
View 6 Replies
Jan 25, 2011
m new to .NET. I'm trying to create a button dynamically with event by original button. The original button's click event response creates a button. The new button has a click event attached with a test message.What I have to do is onclick change background color of dynamically created button and grab id value to delete when button delete is clicked. Unfortunately, when I click the dynamically attached button,
<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
[code]...
View 7 Replies
Feb 9, 2011
On runtime I am creating table structure using javascript and appending it to the div which is placed in an update panel. Problem here is, when I use asp.net button control, onClick of the button it posts the page to server and whatever javascript tables I have created it goes off. When I use html input button (input type="button") I don't face this problem and tables also stay there. But I have to use asp.net button to take necessary actions on the server side. Is there any way that I can restore the structure or use asp.net button control alongwith dynamic javascript.
View 1 Replies
Jan 6, 2011
I created a table dynamically with its row cell contain textbox. Now I need to show a hovermenuextender popup window on each rows textbox. I spend more time for this. But not getting till now.
This is my code for dynamically created table
private void GenerateTable(int colsCount, int rowsCount) {
string qry2 = "select lchannelname,ltransformdata from latestchannel where lenable=1";
DataTable dt = ob.getDetails(qry2);
dt.Columns.Add(new DataColumn("combined", System.Type.GetType("System.String"),
"lchannelname+ ' '+ltransformdata"));
//Create the Table and Add it to the Page
Table table = new Table(); table.ID = "Table1";
Page.Form.Controls.Add(table); int flag=0;
foreach (DataRow dr in dt.Rows) { TableRow row = new TableRow(); row.Width = 200;
TableCell cell = new TableCell(); TextBox tb = new TextBox();
tb.BorderColor = System.Drawing.Color.OliveDrab;
cell.BorderColor = System.Drawing.Color.OliveDrab;
cell.BorderWidth = 1; cell.Width = 200; tb.Width = 200;
// tb.ReadOnly = true; tb.Text = dr["combined"].ToString();
tb.ID =flag.ToString(); cell.Controls.Add(tb);
row.Cells.Add(cell); table.Rows.Add(row);
AjaxControlToolkit.HoverMenuExtender hrv = new AjaxControlToolkit.HoverMenuExtender(); hrv.TargetControlID = tb.ID;
Here I am confusing for which way is using for popup panel1
hrv.PopupControlID = Panel1.ID;
hrv.PopupPosition = AjaxControlToolkit.HoverMenuPopupPosition.Right;
Panel1.Controls.Add(hrv); flag++; } }
protected void Page_Load(object sender, EventArgs e) {
int numOfColumns = 1;
int numOfRows = ob.selectLatestEnableCount();
GenerateTable(numOfColumns, numOfRows); }
I want to popup this Panel1 on textbox through hovermenuextender
<asp:Panel ID="Panel1" runat="server" Height="50px" Width="125px">
<div style="border:1px outset white;padding:2px;">
<div><asp:ImageButton ID="ImageButton1" ImageUrl="~/images/close.png" runat="server" /> <asp:LinkButton ID="lnkButtonHide" runat="server" CommandName="Edit" Text="Hide Channel" ForeColor="olivedrab" OnClick="lnkButtonHide_Click1" /> </div>
<div> <asp:ImageButton ID="ImageButton2" runat="server" ImageUrl="~/images/element_up.png" /> <asp:LinkButton ID="LinkButtonUp" runat="server" CommandName="Cancel" Text="Go Up One Pos" ForeColor="olivedrab" OnClick="LinkButtonUp_Click2"/> </div>
<div> <asp:ImageButton ID="ImageButton3" runat="server" ImageUrl="~/images/element_down.png" /><asp:LinkButton ID="lnkButtonDown" runat="server" CommandName="Delete" Text="Go Down One Pos" ForeColor="olivedrab" OnClick="lnkButtonDown_Click1"/> </div> </div> </asp:Panel>
View 1 Replies
Sep 16, 2010
I have created table into database dynamicaly,while inserting records into that dynamic table i faced problem.
The name "STD000001" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted. this error occured.
I created dynamic table by ,
declare @STUDENT_Table varchar(50)
set @STUDENT_Table = [dbo].[GetStudentTable](@SchoolID)
exec (@cmd)
[code]....
this stored procedure.....
Should i give any permission while creating dynamic table.
View 7 Replies
May 18, 2010
Say for example, I have script like below whereby everything is same except the table name and each table name will append an incremental number, is it possible for me to have a for loop to dynamically add the incremental number?
CREATE TABLE Persons1
(
P_Id int,
[code]...
View 5 Replies
Oct 19, 2010
I am unable to reterive dynamically created table cells back color which has been changed by the click event of the cell.I am adding table cells dynamically on asp.net page and also setting cells back color. So when the page is loaded, table has number of cells with different colors.Table cells back color can be changed by clicking on it through java script. On page post back event, i am jutst getting those colors which were set before the click event.For example:When the page is loaded, cell1= red and cell2=red.If i click on cell2 then it will change to blue so now cell1= red and cell2 = bluebut on post back i am getting cell1= red and cell2 = red.Table is recreated on post back event.
View 3 Replies
Jul 21, 2010
i created dynamically a table with in a function... this table is added to a panel. and this panel is in ajax updatepanel... statically i have given no of rows as 3, for that table... in page_load my table with 3 rows is created.... but i cannot identify this table in another button click event...
i wrote the code like this...
System.Web.UI.WebControls.Table table = (System.Web.UI.WebControls.Table)addrowpnl.FindControl("Table1");
here Table1 is my dynamic table id.....
View 2 Replies
Sep 24, 2010
So today I started learning ASP.NET. Unfortunately I haven't found any good tutorials online, and I can't afford to buy books at the moment, so I've had to create a ASP.NET web application in Visual Studio 2010 and just play around with the default project setup. So far here's what I have in my Default.aspx:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication1._Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Project Management</title>
</head>
<body>
<div style="padding-bottom:10px;"> Project Management System</div>
<div> <table style="width:100%;">
<tr>
<td>Name</td>
<td>Task</td>
<td>Hours</td>
</tr>
</table></div>
</body>
</html>
I created a simple table with the header row already in there. Through a C# script, I want to be able to dynamically add rows to this HTML table. Is this the right way of thinking in ASP.NET? If so, how can I do this? I'm sure I'll need an "Add" button, which adds a new row to the table, with editable fields, and a "submit" button which adds some stuff to a database. Basically just a rundown of how this is done would be ever so helpful. Also if anyone knows any good tutorials or websites
View 5 Replies
Aug 5, 2010
I added dynamic checkboxlist.The javascript validation for checkboxlist(dynamic) in firefox + asp.net is not working,but in IE its working fine.why the javascript validation is not firing for dynamical checkboxlist.
View 1 Replies
Mar 10, 2011
I have a table thats created dynamically, the table gets its contents from a custom class I've created that gets statistical data from a database. As the table is generated dynamically, I've put the contents class (the table data) into a session object and I populate the table initially inside a !IsPostback then on the page init I get the data from the session (its empty on the firts page load). I am now getting this error: Multiple controls with the same ID 'controlnamehere' were found. FindControl requires that controls have unique IDs. How can I avoid this?
View 4 Replies
Feb 3, 2010
My problem is that I have an ASPX page which contains an ASP:Table. The rows for the table is added dynamically on Page_Load. One column in the table contains TextBoxes, BUT when I type something on a TextBox and cause a postback, I am unable to find the value just entered. And above that the table is not displayed after the postback.Can anyone help me please? I want to keep the table viewstate with the modified textbox values, so that when i post back to server, I can intercept these new values.
View 3 Replies
Jan 10, 2011
i am working on Accounting software.in this software i am to implement voucher entries form.In this form on page load a table (two rows and four columns) should be created after that one row should be appended to that table dynamically on button click event.
View 3 Replies
Jan 20, 2011
Does anyone know how to dynamically add and remove rows in a table triggered by a button click from the backend (in c#) using asp.net?
Here's how it might be done in javascript, is there any way to do this in the asp.net framework?
[URL]
View 2 Replies
Jul 29, 2010
Protected Sub btnAddRow7_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnAddRow7.Click
Dim tableRow As New System.Web.UI.WebControls.TableRow
Dim tableCell As New System.Web.UI.WebControls.TableCell
Dim textBox As New System.Web.UI.WebControls.TextBox
tableCell.Controls.Add(textBox)
tableRow.Cells.Add(tableCell)
tbl7.Rows.Add(tableRow)
End Sub
but it only adds one row dynamically. After the first addition, more clicks to the button will not add more rows.
View 3 Replies
Feb 17, 2011
i want to bind text box that is located in dynamically created table.
[Code].....
View 1 Replies
Jul 9, 2010
my table has already 5 rows...after pressing addow, rows are added dynamically to another table... i need to save the data of all the rows(5+newly added) in the database...
View 2 Replies
Dec 1, 2010
I am using ASP.NET3.5, I want to Add rows dynamically to a table.I have written this code.This code is working fine if the Page is not having masterPage file. If I use masterpagefile in my ASPX age,controls(textboxes) are displaying at bottom of the page,and the data in textboxes is not retaining after click on Add button.Disaapering the text box values. My .Aspx:
[Code]....
View 2 Replies
