I have a gridview control bound to a sqldatasource in c#. In the rowdatabound event I look at a value in a cell and use a function to evaluate the value and depending on that value I populate an added unbound column in my bound datagrid to show an excalmation point. I now want to sort by the column with the excalmation point.
View 2 RepliesI have a Gridview with a templated column which contains just a label.
I set the Label1.text during GridView1.RowDataBound based on doing a DataBinder.Eval(e.Row.DataItem,"myColumn") and a calculation off that.
When the user clicks the header I want it to sort based on what's in the Label but instead if seems to be sorting on the contents it was bound to, "myColumn", even though that's not what appears in the grid.
I have autogenerated columns some columns come from db and some are virtual columns what i am adding to a dataset that consist of columns from db.i want to disable sorting for the virtual columns which i add to dataset
View 2 RepliesI have a gridview being data bound by an objectdatasource which points to a BLL/DAL. I have paging and sorting enabled within the gridview. I have the fields configured in the look/fell I want from a templatefield. This templatefield has the sort expression (date) I want things to be sorted by. All this works as it should and I have no issues with it.But, the issue is that when I click on the header to sort asc/desc by date, I have to click on it twice for it switch to descending order. E.g. I hit the webpage and it lists all the information in the gridview, sorted by date, ascending order. If I want to sort by descending order, I have to click the date header twice in order for the gridview to sort the information in descending order; the clicks cause a post-back and the whole screen is refreshed.
View 2 Repliesguide how I can sort grid data when header is not shown. Actually In my page I have set visibility of header to false and have placed headings in table above the grid (it was done because requirment was to fix header and make grid with scrollable).how I can give sorting functionality with headings in table above the grid
View 2 RepliesI have a bound column.
<asp:BoundField DataField="WorkPreference" HeaderText="WorkPreference"
HeaderStyle-HorizontalAlign="Left">
<HeaderStyle HorizontalAlign="Left" />
</asp:BoundField>
dr["WorkPreference"] = sa.WorkPreference ( This is how I bind the data to a DataRow)
The example of the data which gets bound to this column is like the following:
Communications and Marketing Officers; Environmental Assessors; Geologists and Geosciences; Geospatial/Spatial Information Officers;
What I want is that the data should be presented to the user like the following:
Communications and Marketing Officers
Environmental Assessors
Geologists and Geosciences
Geospatial/Spatial Information Officers
In short: I basicaly want to put a break where there is a colon and then bind the data to the gridview. It looks like simple but if you can let me know.
I am having trouble with displaying double data in gridview bound coulumn. I want it to display as it is... But it gets rounded off when displayed.
Like my 1.34 displays 1.00
1.57 - 2.00
and so on. But i want it to display as it is i mean with decimal points, without rounding it off.
i want to sort a gridview column which is a template field with a repeater control in it. this column has multiple links and i would like to sort using the first link. how can i achieve this.
here is my code:
<asp:TemplateField HeaderText="Groups">
In gridview columns im displaying date and time, as below.
23/02/2010 11:19:52
Im also doing sorting on these columns.
But the issue is during sorting its only sorting on "day (dd)"....
for example....these 3 values are from column, Date.
23/02/2010 11:19:52
18/02/2010 10:25:10
17/03/2010 09:30:51
when I click for "Ascending" sort....it should get "17/03/2010 09:30:51" on the top (because of month 03) others have 02, but it doesnt, it gets in the above order, its just sort on day (dd).Below is my code for boundfield....
<asp:BoundField
DataField="Date"
HeaderText="Date" [code]...
Dear all; I have the following gridview
Type Cost
BENZ 40,000
TOYOTA 20,000
Now, I would like a situation if either TYPE or Cost is clicked on, it would sort things in ascending order. see example below.
if Cost is clicked on, we will have the following sorting order.
Type Cost
TOYOTA 20,000
BENZ 40,000
I am still new to visual studio.net.
I am trying to change the text in the header column when the GridView is sorted by checking the SortedDirection of the GridView.
problem: The text in the header column gets changed after i have clicked three times to sort the GridView.
i don't understand my problem. it seems really simple to get it work...this is what i done on each databound
[Code]....
Below is the code behind for a simple aspx page. The web form contains one GridView (GridView1) and one label (Label1). I create a Data Table, then add a row to the table. I then DataBind my GridView to the DataTable. (so far so good) When I run the page I do see the GridView and the single row of data. However the checkbox shown is not enabled, meaning the user cannot uncheck or check it. (As if was not enabled)
Imports System.Data.SqlClient
Imports System.Data
PartialClass test
Inherits System.Web.UI.Page
ProtectedSub Page_Load(ByVal senderAsObject,ByVal eAs System.EventArgs)HandlesMe.Load
CreateDT()
EndSub
PrivateSub CreateDT()
Dim dtAsNew DataTable
Dim col1AsNew DataColumn
[code]...
I want to change the width of column in Gridview bound field but it is not changing. Code Is;
<asp:BoundField DataField="Address" HeaderText="Address" SortExpression="Address">
<ItemStyle Width="500px" />
</asp:BoundField>
in a data table contains columns such as id,firstname,lastname.then i will bind into grid view.
now i want to design the gridview like this,
<asp:BoundField HeaderText="Employee Code" DataField="id" />
<asp:BoundField HeaderText="Employee Name" DataField="FirstName"+""++ "MiddleName" />
how can i achieve it?
I have a unbound checkbox column in the GridView control.
When i try to get the value of checkbox in the C# code the checkstate is always false.
I want to check if the Checkbox is selected in a row and get the values of all the cells in that row.
CheckBox chkSelect= (CheckBox)GridView1.Rows[1].FindControl("chkSelect");
<asp:GridView
runat="server"
ID="GridView1"
AutoGenerateColumns="False"
[Code].....
I have a auto column generated GridView in a page, I have a dynamically binded column in that gridview, when page loads then sorting option is available on all other columns except that dynamically created column.
[Code]....
I have a grid that is built as well as populated dynamically through c# code. The grid has 3 columns(3 bound fields). And data is being populated in those bound fields through c# code programatically.
Elaborating my question: I have 3 bound field columns(col1, col2 & col3) . I have to increase the rowspan of col2 and col3 headertext's to 2 i.e I want the col2 and col3 header texts to span across two row cells. But the col1 header text should span across just 1 row. And the extra rowscell that is created under col1 due to the increase in the rowspans (of col2 and col3 boundfield headertexts) should be populated with some random text, i.e something like XXXXX
whn i click edit button on grid before sorting on any column it is working properly...but once i click on any column for sorting n thn click on edit then the rows get sorted again and edit is set on some other row... plz help me...herez my code..
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
gv_photo.EditIndex = e.NewEditIndex;
bindgrid("album_id");
public void bindgrid(string sort)
string str = "select * from tbl_Album";
[code]...
I want to fix the gridview column width using bound field and also template field using vb.net ... How can i ?
View 1 RepliesI have a gridview with 10 columns , i want sort the gridview column and im using bound field and template field
How can i make a sorting in grid in ASP.Net using VB.Net?
Dim Application = From AL In db.AnnualLeave _
Where AL.Approval <> True _
Select LeaveID, EmpID, Name
GridView3.DataSource = Application
GridView3.DataBind()
after calling `GridView3.DataBind(), why do i still get Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index.
at this line of code GridView3.Columns(1).Visible = False yet the grid has rows and more than 2 columns. i found a thread about similar problem here [URL] Note that the Gridview columns have NOT been defined at design time.
Situation: SQL database, Linq to SQL class a ASP.NET page with a LinqDataSource and a gridview. The table has a ID field, a date field and a Serialnr field. In my Grid I like to Page on the datefield but to sort on the serialnr field ( or a selectable other field). Is that possible? Standard the paging is always done on the sort field and when you select a different sort field the page jumps back to the first page., and paging is then done over that sorted column.
View 2 Repliesi want to sort my Gridview rows by a template column that is not bound to any database field. This template coulmn just has a label whose text i set in code depending on a value in a different column that is databound. So am stuck on how to set its sortExpression since its not linked to an column.
View 1 RepliesI am populating a DataTable and binding it to a GridView's source.
I have a dropdown box in an itemtemplate in the gridview.
I want the dropdown to have 3 options and depending on what is in a column from row in datatable a specific value will be selected.
I was able to do this when I was binding gridview source by looping through SQL but now I that I am putting the results in a datatable I am not sure how to go about it.
I am looking to sort a column on my gridview by simply clicking on the column rather than clicking on the column header. In the design I have been given, the column header will not be shown, and I need to be able to give the user to sort this column, by simply just clicking any where on the column.
View 2 Replies