I have a GridView bound to an DataSource query with parameters tied to form controls.
What is the standard / best-practices way to handle optional query parameters?
The following is my DB data, how can I sorting it by sid and prev_sid with php/mysql!?
sid prev_sid type
000 197 app_home
197 198 page_teach
198 218 page_teach
199 211 page_step
211 207 link
218 559 page_step
559 199 page_step
Result:
sid prev_sid type
000 197 app_home
197 198 page_teach
198 218 page_teach
218 559 page_step
559 199 page_step
199 211 page_step
211 207 link
000 197 198 218 559 199 199 211 207
I have data from a database loaded into a JTable through a custom table model. I want to have a column (should be the first column) which simply shows the display row number (i.e. it is not tied to any data (or sorting) but is simply the row number on the screen starting at 1). These "column headers" should be grayed out like the row headers.
Any idea how to do this?
Thanks
I have a chechbox in a gridview. i need it disabled for some condition and enabled for other.
Problem is how to fetch check box id out side the grid.
Please help ....
I am working on an ASP.NET MVC application where I need to export data to an excel spreadsheet. Previously, in webforms apps, I used some code I found to render a GridView as an excel-compatible file. This was quite handy. I was wondering what the quickest/most effective method would be to do this in MVC. Thanks.
How can I view and override the full definition for built in classes? I have seen the library docs but am looking for something more.
For e.g. is it possible to override the Array Class such that the base index starts from 1 instead of 0, or to override .sort() of list to a sorting algorithm of my own liking?
i have passportno(varchar) in database.
i am entering values like this 001,002,003. and i want to display like sorting order.
now i wrote query like this "select * from passport_registration where status=1 ORDER BY passportno" then displaying output like this......077,088,099,100,1000,1001,1009,101,1010
i want to diplay sort order. how to do?
Hi Experts,
I am clueless to find out why should we use static method with JSON. Is it possible that I click a button and I load a gridview with JSON ??
Thanks in advance
i have a large database which is updated every now and then.
The application has been developed in asp.net and c#.net.
i need to fetch data from the datbase to griview on a button click event .
i am planning to use data caching , so that i can improve the performance of the application
how can i use DATA caching mechanism so that i could see the updated result of the database in a gridview.
I'm developing a cms for a company that has multiple regional sites (us, uk, china, russia, etc..). Should I use a separate database for each of these sites or use a single database with a 'site' field in each table? My main concern is the table language encoding (ie, can storing strings in different langauges in the same table cause problems, such as sorting issues).
The following is my DB data, how can I sorting it by sid and prev_sid with php/mysql!?
sid prev_sid type
000 197 app_home
197 198 page_teach
198 218 page_teach
199 211 page_step
211 207 link
218 559 page_step
559 199 page_step
Result:
sid prev_sid type
000 197 app_home
197 198 page_teach
198 218 page_teach
218 559 page_step
559 199 page_step
199 211 page_step
211 207 link
000 197 198 218 559 199 199 211 207
Hi All,
I have multiple letters in html format in a folder and im list those letters in the gridview on ASP.NET page if user select couple of letters and click print i should me those letters
Now Question is how to print multiple html files on the event of button click.
I currently have a std::vector which holds std::vector of double. I'd want to sort it by the second element of the double vectore. ex:
instead of sorting by MyVec[0] or myvec[1] I wat it to sort myVec[0] and myvec[1] based on myvec[0][1] myvec[1][1]. Basically sort by a contained value, not the objects in it.
so if myvec[0][1] is less than myvec[1][1] then myvec[0] and myvec[1] will swap.
Thanks
In SharePoint 2010 when you hover over a column heading (i.e. to sort) in a list table, you get a hover effect, how can you supress / change this? I can see it uses OnChildColumn(this), so is there a way to modify this - either preventing the effect (e.g. when sorting can't be done on a column), or using a different background image?
Also want to do the same when you hover over a cell in any of the list table's contents.
Given the following markup for a GridView column, why are my image buttons showing up as left aligned?
<ItemStyle HorizontalAlign="Center" Width="55px" />
<ItemTemplate>
<asp:ImageButton ID="removeButton" runat="server" ImageUrl="~/Images/Icons/x-m.png" CommandArgument='<%# Eval("ResourceId") %>' AlternateText="Remove Button"
onclick="removeButton_Click" />
</ItemTemplate>
Consider a Python list my_list containing ['foo', 'foo', 'bar'].
What is the most Pythonic way to uniqify:ing and sorting and the list (think cat my_list | sort | uniq)?
This is how I currently do it and while it works I'm sure there are better ways to do it.
my_list = []
...
my_list.append("foo")
my_list.append("foo")
my_list.append("bar")
...
my_list = set(my_list)
my_list = list(my_list)
my_list.sort()
Hello,
I've 3 columns that I'd like to sort in the Excel way, i.e. sorting the first column, and for each element sorted in the first column, I'll sort the second column, and so on. Let's say I first sort alphabeticaly Countries, then for each country, I sort alphabeticaly cities. How do I do it using Linq2Sql?
Thanks for helping
Restaurants Menus Products
RestaurantID MenuID ProductID
RestaurantName MenuName ProductName
RestaurantID MenuID
<asp:DropDownList ID="DropDownList8" runat="server" DataSourceID="ObjectDataSource3"
SelectedValue='<%# Bind("MenuID") %>' Field="RestaurantName" DataValueField="RestaurantID">
Gridview has GetAllProducts method
ObjectDataSource3 has method GetAllRestaurants.
I want to edit and update Menus of each Product. But I want to show RestaurantName indtead of MenuID..
Thanks
Hi I want to store data in viewstate from datatable and then want it back from viewstate to datatable.
My problem: I m not able to add two rows in gridview from datatable.
Plese ask for more information if not clear.
I have a large data file that is creatd from a shell script. Next script processes it by sorting and reading several times, that takes more than 14 hours, it is not viable.
I want to replace this long running script with a program, probably in JAVA, C, or COBOl, that can run on windows or on sun solaris. I have to read a group of records everytime, sort and process and write to the output sort file and at the same time insert into db2/sql tables.
Hi,
I have used check box in gridview . Now i want to validate those checkboxes as if no check box is selected a message shud pop up saying please select check box and thn press submit
Thanks
Smartdev
I have an AccessDataSource TestSummaryADS. I can easily view the results in a GridView or DropDownList by setting its DataSourceID property.
How do I bind a value from the results TestSummaryADS to the text of a label?
I'm just trying to populate labels on my page with results from the DB entry.
C# or VB.NET answers okay.
Hello,
R offers max and min, but I do not see a really fast way to find the another value in the order apart from sorting the whole vector and than picking value x from this vector.
Is there a faster way to get the second highest value (e.g.)?
Thanks
What is the difference between normal datagrid and advance datagrid.Sorting,draging columns,resizing columns are supported even in normal datagrid.
I want to add footer details like summery,average etc of each column,does AdvanceDataGrid supports these features?
I'm using asp.net and want to filter a search result everytime the user enter letters in a textbox. For exmaple this website do exactly what I want: http://www.prisjakt.nu/ (try searching in the right top corner). I have tried just putting my textbox and the gridview with the search result in an updatepanel, it's working but it's really slow, can I make it faster and how? Is there any articles or something about this?