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:

Finding Dynamically Created Table With Rows ID In Javascript

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

Web Forms :: Dynamically Created Table / The Table Subsequently Disappears?

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

Forms Data Controls :: Dynamically Created Rows And Columns Of Grid View?

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

Data Controls :: Dynamically Created Rows With Dropdownlists Selected Index Changed Not Firing

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

To Find Controls From Dynamically Created Table?

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

Paging By Using Dynamically Created HTML Table

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

Web Forms :: Dynamically Created Table Will Not Appear After Postback?

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

Web Forms :: Buttons Which Are Created Dynamically With Events Not Working?

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

Restoring Dynamically Created Javascript Table Structure

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

AJAX :: Creating HoverMenuExtender On Dynamically Created Table

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

SQL Server :: Inserting Records Into Table Which Is Dynamically Created?

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

DataSource Controls :: For Loop To Dynamically Name The Created Table Name?

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

Web Forms :: Get The Backcolor Of Dynamically Created Table Cell?

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

C# - Find Dynamically Created Table On Button Click?

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

C# - Dynamically Add Rows To A Table?

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

Web Forms :: Dynamically Created Checkboxlist Validation Is Not Working In Firefox?

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

Web Forms :: Dynamically Created Table - Empty On First Page Load

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

C# - Retaining Viewstate In Textboxes Found In A Dynamically Created Table?

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

Forms Data Controls :: Append Row In Dynamically Created Table?

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

C# - Dynamically Add / Remove Table Rows?

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

Dynamically Add Multiple Rows To A Table?

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

Forms Data Controls :: How To Bind Text Box From Dynamically Created Table

Feb 17, 2011

i want to bind text box that is located in dynamically created table.

[Code].....

View 1 Replies

C# - Count Dynamically Added Table Rows?

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

Web Forms :: Adding Rows Dynamically To A Table Using Masterpages

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







Copyrights 2005-15 www.BigResource.com, All rights reserved