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 the columns pre-set and I set the Allow Sorting = True,
Now I don't know what code to put in my VB file under "GridView1_Sorting" event.
I want to sort my gridview binded to an object datasource fetching business objects. I have already implemented custom paging & now want to implement sorting. Just read this article but there is lot of concatenation going on there with the SQL Query.
[URL]
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]....
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 Replieswhn 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 got this code which bind a datatable to a grid view. After the binding, i wanted to add additional column to the right of the grid, how can I do that? My codes below failed to do it.
[Code]....
The Header value of "ID1" is shown, but the cells only shows a '-' instead of 'New Column' sign.
After a little hard work I was finally able to bind jqgrid in asp.net, but now I am facing another problem that is I am not able to sort the data or use pagination in jqgrid. And it seems There is a post back every time I click on the grid headers or select the page drop down. My code is as follows:
[Code]....
And web method is as follows:
[Code]....
I 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?
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 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 RepliesModerators Note: THIS ISSUE IS BIG FOR ME AND EVEN IF POSSIBLE, GET THE REPLY FROM THE DESIGNER OF GRIDVIEW. I have been looking for him for long. I am really fed up with reviewing a good lot of web pages on how we can possibly customize the gridview to enable sorting and paging. So many sites have listed out a lot of information and so many guidances. But the problem is that one works out fine and the other is a burden. I really feel bad about being given the job of customizing this kind of a gridview which has no user friendly approach to it. Also, this control is rendered without the pager links inside the <tfoot> tag. I have tried the Pear Pager in php. It is that good and easy to use and compared to that, the gridview in asp.net is the worst ever control i have ever tried so far.
1. i can use the images to indicate the sorting direction
2. I can have the custom pager like
[code]
<<Previous 1 2 3 .. 7 Next >>.
[/code]
When i click the next when i am viewing the page at 3 , the pager links should change as
[code]
<<Previous 2 3 4 .. 7 Next >>
[/code]
Kindly look into this type of requirement and firstly tell me whether this is possible with the gridview control. I would like this request even to be escalated to the designers of the gridview control also, so that Microsoft comes out with a reply THAT WORKS and not the kind of stuff like surfing through a lot of links and pages and finally wasting a lot of days precious time and still breaking the head with this useless control. I have spent a lot of time in searching for a perfect way. Not writing a code that is non-standard. I am really serious b'cos I have spent weeks in customizing this control. If I dont get a solid reply atleast now, I am going to generate all the output by HTML content by custom coding.
So I take all my current query and through it into my gridview and it works great. What I need to do is grab some data from antoher query and add on columns if anything exists in the data. How can i create columns dynamically and add them onto my existing gridview if data exists.
Sql = Select intMetricId, strBenchmarkName, intBenchmark from tblbenchmark.
myDataTable = New DataTable
myDatatable = GetData(sql)
mygridview.Datasource = mydatatable
mygridview.databind
So strBenchmarkName would be the new column heading name and then all the 12 rows of data would be the inbenchmark if any exists.
How can i new columns on an existing gridview if anything exists in the datasource.
I populate a gridview dynamically which has differen column numbers depend on requirements. My goal is to adjust column width dynamically. I have tried several methods and events, then RowCreated event of GridView looks best one to do. My code is as below. When
i check result at the ViewSource on the browser, i can see that width of <td> successfully adjusted. BUT nothing changes on the browser, column width always as wide as text?
My Code [Code]....
HTML RESULT SUCCESSFUl [Code]....
My issue is that , need to change the column name(following some format) of the gridview (which is binded with XMLTextReader). Without changing directly XML file, Required to change the column name dynamically at runtime .
Performance.xml
<Performance>
<Departments>
<Heading>FS</Heading>
<S0015>1</S0015>
<S0020>2</S0020>
<S0025>5</S0025>
<S0030>5</S0030>
<S0035>6</S0035>
</Departments>
<Departments>
<Heading>BS</Heading>
<S0015>0</S0015>
<S0020>3</S0020>
<S0025>5</S0025>
<S0030>1</S0030>
<S0035>3</S0035>
</Departments>
</Performance>
Heading S0015 S0020 S0025 S0030 S0035
FS 1 2 4 5 6
BS 0 3 5 1 3
Required Format:
Heading 00:15 00:20 00:25 00:30 00:35
FS 1 2 4 5 6
BS 0 3 5 1 3
I have a auto binded grid view, in one of the column, I would like to create a hyperlink for it.
View 2 Repliesam binding a gridview to datatable ...and now i want to add a linkbutton/hyperlink as one of the columns in gridview (similar to checkbox field) ...am adding the Lbtn inside a template field ,but i want that column to come as last column ..but its coming as first column,,,how to acheive that??
moreover ,whn i clk on eack linkbutton a pop-up window has to come with submit and save and close buttons and functionality(is it better to use linkbutton or hyperlink??)...am using vs 2005
I am dynamically creating my grid view as:
HyperLinkColum hlc = new HyperLinkColum();
hlc.Datatext.DataTextField = "PK";
myGridView.Colums.Add(hlc);
I wanted to call a page say "test.aspx" and to send the primary key of the relevant row to the "test.aspx" page and then how to retrieve this values in the "test.aspx" page
I have a Gridview, which I bind to a Dataview programtically. My Gridview has 11 columns. Sorting works fine as long as I do not remove any columns programtically.
In certain cases I remove 2 of the columns from the Gridview. Still not a problem. All the data is properly displayed however the problem occurs when I sort one of the columns. I sort the Dataview and bind to the Gridview again. Data from two of my columns just vanishes. Both of these columns are based on ItemTemplates. The columns are still displayed but just empty cells.
I am binding the gridview with the list like this
<ev_event> objev_event = new List<ev_event>();
GridView1.DataSource = objev_event.ToList();
GridView1.DataBind();
I want to enable paging for the Gridview. when I enable True for Enable paging property, The error throws.how to enable the paging for list binded GridView?
I've already searched to no avail for an answer to this question:is it possible to dynamically alter the page size in a paged gridview based on data in a particular column?In other words,let's say I get data from a table that lists students enrolled in a particular course.If there are 10 students in Course "A," then I want page 1 in my gridview to show 10 records.
If there are 15 students in Course "B," then I want page 2 in my gridview to show those 15 records,and so on.I imagine that this could probably be done with a master-detail kind of set up,but let's say for the sake of argument that I don't want to go that route.
Split off from http://forums.asp.net/t/1595139.aspx:
I have an additional column called 'KPI %' in my gridview that calculates the percentage of two template fields and thus I cannot use the sortexpression on it. How can I sort the contents of the 'KPI %' column in ASC or DESC format?