I'm somewhat new to aps.net and am not sure how to come up with a technique for acheiving the following results.I think a GridView might do the trick, but am unsure how to manage the sorting/grouping aspect. Here's what I need to do:
[code]...
In ASP.NET Can we achieve both grouping and sorting in a repeater control.If possible please suggest me the way of doing it or links ..I have to implement that in my application
View 2 RepliesThis is probably an easy one, but can I use SQL Server Management Studio Express to work on a regular SQL Server database?
View 2 RepliesI have a mdf database in my computer. And I have sql management studio 2005 installed. I would like to mange the mdf database with this program and I do not know how.
View 3 RepliesI am facing grouping the agent wise in stored procedure, here i showned the table columns,views and stored procedures i used.
User Table columns
User_Id,pwd,Created_Dttm,Role,Status
Table1 columns[code]....
Problem is when i am group by A.Name i am getting error "Column 'V1.Target' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."
Iam developing a custom server control of radiobuttton. it is working fine with the all the properties i wrapped except the grouping . somehow the grouping is not working .
[Code]....
For the below query (sdate is column name and table name is storedata)
View 2 RepliesI need to know how to configure the .config to manage Session state in SQL Server
View 2 RepliesIn Visual Studio 2010 there is a handy tool for managing users for my Silverlight Business Application. How do I do this with my deployed application?
View 1 RepliesWe are working on a web application that is distributed across 3 load-balanced web servers. A lot of the data we retreive via NHibernate is stored in System.Web.Caching.Cache.
System.Web.Caching.Cache does a lot to increase the responsiveness of an application, but there are a few issues that we don't exactly know how to resolve, such as
when a user requests data on server1 that data is cached on server1, but for their next request, the load balancer might direct them to server2. That data they requested on server1 is no longer available, and server2 will have to request it from the database again. If the user does something on server1 to invalidate the cached data, the cache is flushed on server1. However the original cache is still available on server2 & server3, so when the user submits a subsequent request and they're directed to either of the other servers, they are going to be presented with invalid data.We have applications that update data (such as performance data) on a regular basis. When the performance data is updated we want to flush this from the cache so when a user requests the data again, they're presented with the latest data. How can we get these applications to flush the cache on 3 web servers?
What are the best ways to resolve these issues?
Should we have cache stored on a separate server such as we could to for HttpContext.Session with a SessionState server?
Is there a way for us to set a Cache Dependency on the Cache in the other 2 servers?
Is it possible for us to implement a Cache Dependency on the actual database tables or rows? When these change the cache is flushed? -- or could we set up a database trigger to flush the cache somehow?
I am using fileuplaod control for uplaoding images. I want to change the aspect ratio of my image. Say 4:3 for horizontal pictures and 3:4 for the vertical images. How to do that in Asp.net
View 2 Repliesi want to convert image pixel . For example my image is 1024x768 , i want to convert it to 225x225 and i want to store the image in a folder with name. i don wan the code based on bitmap.
View 1 RepliesHow can I resize image through web.config file?while using generic handlers to resize image to upload?
View 1 RepliesI use image control in my page and i set Height=100px and width=100px for it
When I set imageurl fo this control it convert my image size to Height=100px width=100px
But I want it small my image Proportional my image scale i mean that if my image is vertical it small it with out change it's scale .
I have images of big size. I want to resize them according to their width and height. If width is bigger than height then maximum width will be 650px and height will in proportion of width. If height is bigger than width then maximum height will be 650px and width will be in proportion of height. How I will resize images proportionally using handler in ASP.Net,C#.
View 1 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.
I have a column TimePeriod with values in mmm-yyyy format. ex. Jan-2010, Apr-2010,Nov-2010, Dec-2010, Jan-2011
How can I wirte query so result will be in order by Jan-2010, Feb-2010,..... Jan-2011.
I tried to cast, convert but i couldnt figured it out. I did googling... can't find solution.
I'm using Sqlreader to get some information from a database table. Right now I have it looping through a while loop, and adding in the appropriate information in to an asp table contol. I'm not haveing any difficulty with that, what I am having problems with is sorting the data. I just want it to sort it by a field called title. I tried putting an ORDER BY statement into my SQL command, but it throws an error saying it cannot sort a text field. So the only thing I can think of is instead of adding the data right from the sqlreader to the table control is that I first put it into an array, sort the array, and then add it to the table control. It seems like an ineffieint way of doing it. Is there a better way of sorting this stuff or is there a way to get the database to do it for me like with the ORDER BY command?
View 5 RepliesWhen it comes to sort some data, we have two option to sort the data: first one is sort on SQL server with ORDER BY clause, and another is Client side sorting ,how i can choose one option over the other and why? which option is more efficient? with sorting? is there any sorting function with client side sorting? what is the adventage on client side sorting?
View 1 Replieswhen I use 'RowNumber' = ROW_NUMBER() OVER(ORDER BY ColumnName) then due to orderby Column name consume 76% usage in execution plan . in such case what I have to do? I can see sorting taking much time in execution plan.
View 9 RepliesI want to use a gridview with sorting and paging to display data from an SQL server, the query uses 3 joins and the full text search containstable. The from part of the query uses all 3 tables in the join.What is the best way to do this? I can think of a stored procedure, SQL directly in the SQLDataSource and creating a view in the database.I want good performance and would like to leverage the automatic sorting and paging features of the gridview as much as possible.
Edit:About size, I suspect very few records, total about 1000 and a query would typical result in no more than 100 records and most times much less.
I can explain my problem pretty straightforeward. I am using Visual Web Developers reporting GUI but the question should remain the same. I have that consists of a month, year, employee, and Hours. Sample data would look like this:Month, Year, Employee, Hours
1, 2010, Jim, 20
2, 2010, Jim, 50
1, 2010, Jen, 95
3, 2010, Jen, 65
I've got a project I'm working on where I need to put a RadioButton inside a ListView, and have them all have the same GroupName. (can't use RadioButtonList, long story).[URL]This works perfectly, but with one small bug which undoubtedly will come back to bite me. If I click one radio button, and then click another while the javascript function is still running and has not completed; I can get 2 radiobuttons in the same group selected.
View 2 RepliesIs it possible to have multiple grouping in SPGridview? Grouping is working fine for a single column? Is there any way to have multiple grouping in SPGridView programmatically
View 4 RepliesTHE REPORT The report (itself) must display a table of data above a related set of calculations for each a grouping (of data). I'm hoping to keep one group per page...but that may not be possible as each table may become quite long (but that is another question for another day).
...There can be 1 to N GROUPS
Example
(GROUP 1)
TABLE
FORM CALCULATIONS
PAGE BREAK
(GROUP 2)
TABLE
FORM CALCULATIONS
...and so on.
IS THIS THE BEST WAY TO DO THIS?
Place each group into a SUBREPORT. The sub report would then contain the table & form calculations.