Forms Data Controls :: Moving Rows Up And Down In A Gridview?
Nov 10, 2010
we need to move Gridview rows up or down by selecting the same.
we have two buttons as up and down.
After selecting a row(index(X)) then if we click up the row(index(X-1)) will come down and row we selected will move up.
same case with the down button ,After selecting a row(index(X)) then if we click up the row(index(X+1)) will come up and row we selected will move down.
all these changes has to reflect on database(order of records stored) also.
I came across a situation where a user selects no of rows from dropdown , depending upon the user input, automatically that no of editable rows should appear to input data...(maximum 8 rows only)
I'm binding a gridview from a webservice with 30 columns and 10 rows, I need to print the same in a PORTRAIT, for that i decided to display columns as rows and
I have a set of dataset with different column retrieved from DB. I need to present the datasets in one GridView (or other ListView etc...) without specifying the column_header. It should present automaticly since the GridView is bind to the DataSet.
In additional, I want this GridView to handle multiple rows edit and update the dataset, idealy, show data in textboxs in initially.How could I set the GridView to edit_model without hardcode column_header and textboxs in 'itemtemplate' or filed.
How could I achieve the bulk edit and update, so that I can assign 'mydataview1.table' to the dataset.
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.
Having a bit of difficulty working this gridview update problem out - I have managed to get edit/update function working but instead of only updating the current gridview row it is updating the whole table I believe this is due to a missing where statement on my Update statement - to single out the row index of my grid row.When I configure my sql datasource I am using custom statements Here is my update statement
I have a GridView with edit/delete column, label column and DropDownList column. I have a textbox outside the GridView and I want to choose only those rows from the GridView which have for the second column the same value as the value of the textbox while paging.
I wrote code, but I got 0 rows as a result, which is not true.
I have been tinkering with a adding row to gridview code from [URL] I have been able to adapt it to my needs but I would like to have the user edit the select statement that shows the initial gridview form.
I have a gridview bind to an object datasource Now there is an edit button to edit the entriesUser selects new entries and clicks update Gridview gets updated (all previous entries replaced)Now the new records dont contain the table id of the previously added rowsOn form update, how do I know which entries to drop from database and which entries to insert as the previous rows are all gone?the results are in form of collections of objects returned by object datasource.
i have a gridview with check box in it and I also have a button separately.The gridview contains students name and their school name.User will select rows in gridview with the check box and click the button.Now what I want is, if user select students from two different school, system will display message ("wrong selection").But if user select student with in the same school, system will work as it should be.so, how can I compare the rows??
My users would like to be able to have table headings, then a row with some dropdown lists to discriminate what records are seen in the gird below. Is there a way to do this, or do you have to have the drop down lists floating seperately above the grid?
I have a List box that displays my Vendors, and then I have a Gridview that shows payments made to those vendors. Is there any way of making the gridview always show 12 rows, regardless if 4 payments were made or even 0 payments have been made ?
I am using a Gridview on a webform. Got the editing/updating all working correctly. Problem is, all the data is on one row and it is alot of data. I thought about splitting the data into 2 gridviews but then all of the employee data isn't lumped together like the higher ups want.
I have done research on a DataRepeater as it will give me the formatting I need it but it doesnt support editing.
I have a Gridview which is populated with data based on the selection of dropdowns in a web form. Once the gridview is displayed on the page the user has a "Print" button that will print the gridview. I need to allow the user to remove rows from the gridview prior to printing. I do not want to remove the data from the database, only from the displayed gridview.
I've added a column to the Gridview that has a checkbox which appears next to each row. The header of this column reads "Exlude". If the user checks a box next to a row then this row should be excluded from the printed gridview.Totally new to gridview .. don't know where to go from here.
I bind data to GridView from SqlDataSource. GridView have <19 rows. But i want that all 19 rows are written. If Rows in SqlDataSource are empty it's must be empty in GridView but must be there!
I have developed a gridview that groups rows together based upon a field in the gridview. To separate each group, I have inserted a row that contains the name of the group.
However, I have hit a problem, what I need to do is to have an image button on the row I have inserted between the groups, which when clicked will hide and show the rows in that group in a toggle fashion. I can get the start of the row for a group, but I am unable to work the number of rows in a group and to then show and hide the rows in that group.
I'm developing an ASP webshop website (in VB). I've attached an sql database and put a gridview on the form which pulls up the product details from the database. I can turn on Edit and Delete in the gridview so it is easy to modify the products but how can I add new rows?
