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.
View 1 Replies
Similar Messages:
Jul 2, 2010
I'm trying to build a small back-end page for adding business references to 'portfolio' front-end page.
I chose the GridView control for displaying current items, and am currently working on positioning code(display order) with button fields up/down.
The up/down button code works fine until the GridView is sorted by clicking the header field, then it breaks.
Here is the relevant code:
[Code]....
View 3 Replies
May 7, 2015
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)
View 1 Replies
Mar 4, 2011
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
rows as columns like below:
EMP1 1 2 3 4
EMP2 1 2 3 4
View 3 Replies
Dec 10, 2010
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.
View 1 Replies
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
May 11, 2010
I have 2gridview. And I want to Every rows sum to another gridview like this.
1.Gridview
ID Ad KM M
1 a 12 5
1 a 13 4
2 b 11 1
2 b 10 2
2.Gridview
Id Ad TotalKm TotalMeter
1 A 25 6
2 B 21 3
View 5 Replies
Mar 29, 2011
how can i delete the whole rows of gridview using code behind c sharp like
Col1 Col2 Col3
a 1 5
a 2 6
a 3 7
a 4 8
and I want to delete the whole rows in the gridview so that it becomes
Col1 Col2 Col3
a 4 8
only last duplicate row left and all the rest is deleted (rows are deleted from all the columns of gridview)
View 4 Replies
Nov 23, 2010
I have 2 tables. Table1 and Table2 are related with Column Uid.
Table1 Table2
UId Name
Id Car Uid
10 Stalin 1 Audi 10
20 Antony 2 BMW 10
Here Stalin has 2 cars, one is Audi and other is BMW. I have to display output in a webpage like below.
Name Car__
| Stalin | Audi |
| | BMW |
In which control can we get the output like above. No problem whether it in Listview or Gridview controls.
View 12 Replies
Jul 30, 2010
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
UPDATE SimpData SET store_nbr = @store_nbr, date = @date, data_type = @data_type, acct_1 = @acct_1, amt_1 = @amt_1, acct_2 = @acct_2, amt_2 = @amt_2, acct_3 = @acct_3, amt_3 = @amt_3, cheque_nbr = @cheque_nbr, cheque_amt = @cheque_amt, gst_hst = @gst_hst, qst = @qst, comments = @comments, uploaded = @uploaded
Here is my gridview
<asp:GridView
ID="GridView1"
runat="server"
CellPadding="4"
Font-Names="Arial"
ForeColor="#333333"
GridLines="None"
Font-Size="Smaller"
Width="100%"
AllowPaging="True"
OnSelectedIndexChanged="GridView1_SelectedIndexChanged"
OnRowCommand="GridView1_RowCommand"
OnRowEditing="GridView1_RowEditing"
OnRowUpdating="GridView1_RowUpdating"
AutoGenerateColumns="False"
DataSourceID="SqlDataSource1"
OnRowDataBound="GridView1_RowDataBound">
<RowStyle
BackColor="#EFF3FB"
/>
<FooterStyle
BackColor="#507CD1"
Font-Bold="True"
ForeColor="White"
/>
<PagerStyle
BackColor="#2461BF"
ForeColor="White"
HorizontalAlign="Center"
/>
<SelectedRowStyle
BackColor="#D1DDF1"
Font-Bold="True"
ForeColor="#333333"
/>
<HeaderStyle
BackColor="#507CD1"
Font-Bold="True"
ForeColor="White"
Font-Size="Smaller"
/>
<EditRowStyle
BackColor="#2461BF"
/>
<AlternatingRowStyle
BackColor="White"
/>
<Columns>
<asp:ButtonField
ButtonType="Button"
CommandName="Select"
HeaderText="Select item to delete"
ShowHeader="True"
Text="Delete">
<ControlStyle
Font-Size="Smaller"
/>
</asp:ButtonField>
<asp:CommandField
ShowEditButton="True"
/>
<asp:ButtonField
ButtonType="Button"
CommandName="Select"
HeaderText="Select item to upload"
ShowHeader="True"
Text="Upload">
<ControlStyle
Font-Size="Smaller"
/>
</asp:ButtonField>
<asp:BoundField
DataField="store_nbr"
HeaderText="Store Number"
SortExpression="store_nbr"
/>...............
View 2 Replies
Jan 13, 2011
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.
View 1 Replies
May 11, 2010
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.
.ASPX
[Code]....
C#
[Code]....
View 3 Replies
Jun 24, 2010
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.
View 6 Replies
Oct 6, 2010
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??
View 3 Replies
Jul 19, 2010
I want to remove rows (which contains text) of a gridview on a button click..
View 5 Replies
Jul 2, 2010
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?
View 3 Replies
Jan 11, 2010
is there a way to swap rows in a gridview up and down. if so, what would be the easiest way to do this?
View 5 Replies
Nov 27, 2010
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 ?
View 2 Replies
Jun 24, 2010
how to Grouping rows in a gridview?
View 1 Replies
Jan 14, 2010
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.
View 12 Replies
Feb 18, 2010
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.
View 4 Replies
Oct 6, 2010
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!
View 2 Replies
Jan 21, 2010
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.
View 10 Replies
Jun 15, 2010
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?
View 1 Replies
Apr 28, 2010
]I have a problem with grid,Now my grid is like this...
Company Name
Issued Date
Quotation
Quotation2
Validity1
I want to be like this...
Company Name
Issued Date
Quotation1
Validity1
Here is my code... .aspx
[Code]....
.cs
[Code]....
View 8 Replies
