is it possible to have a dynamic order in a stored procedure? I have a report that I am generating, I want the report headers to be clickable...so when a user clicks, that column is ordered ASC, and when the user clicks again, it is ordered DESC. I tried something like this, but it won't let me use ASC or DESC...
[Code]....
I've added the Dynamic.cs file to my project and have set it's Build Action = Compile in order to get the System.Linq.Dynamic namespace.
However, when I try to use any of the new code I am getting an ambiguous call error; see below.
[Code]....
How to make a sort (asc / desc) in my ListView through a dropdownlist?
View 2 RepliesI am created dynamic Usercontrol in the placeholder, it works fine(top to bottom) but i need to add controls in reverse order mean(bottom to top). I don know how to handle this one. how to display dynamic control in Bottom to top?
View 4 RepliesI m getting Problem in Tab Index Setting of Dynamic Created Controls. There are 6 Drop down dynamic created and also Two user controls which contains text boxes. There are also Static Controls on a Page. How i set tab index for all controls. I have try to give from code behind using TabIndex property But it's not working and Tab order get destory.
View 1 RepliesHow do I sort a data table based on a particular column which has integer values in ascending order?
I wrote this:
leadtable.DefaultView.Sort = "Id"
But it doesnt seem to work, it displays fine but when i get try to get the values of the sorted datatable in an array they dont come in an sorted ordere Datatble is defined as:view plaincopy to clipboardprint?
I have a stored proc which returns months year in nice words, but having problem ordering them:
SELECT count(id) as counter, datename(MONTH, PublishDate) + ' ' + datename(YEAR, PublishDate) as date
from BLG_BlogPost where active=1 group by datename(MONTH, PublishDate) + ' ' + datename(YEAR, PublishDate)
And that returns:
April 2009 (8)
August 2009 (3)
February 2009 (2)
How can i order them?
My query was SELECT ID FROM TBLCARS WHERE (ID IN (1, 5, 3, 6))
this will usualy produces the result 1,3,5,6 order.But i want the result in the specefied order of ids.ie:1,5,3,6;ie;first get the row with id 1,then with id 5,then id 3,and last 6.
after i merged two tables i want to order the entries by a column named "time" and i don't know the syntax for it.
View 2 Repliesi get this data from history table for a paricular ConsignmentNo.
................
i want the sql statement. 1st condition is sql statement should be order by CurrentStatusDate.
.......................
I was wondering in which order MSSQL executes a command. Say if I have this statement:
select top 1 * from table1 t1
inner join table2 t2 on t2.productid = t1.id
order by t1.buydate desc
what is done first:
- find if there's a matching record in t2 through the join
OR
- sort the results in t1 based on the buydate?
And when I have a large database with many records in both t1 and t2, what are possible performance issues I might hit?
How do I translate the following query into LINQ to SQL?
[Code]....
I have a column of type varchar that lists the values in this format:
SEP-09
SEP-08
OCT-09
OCT-08
NOV-09
NOV-08
MAY-09
MAR-09
JUN-09
JUL-09
JAN-10
JAN-09
I need to sort this list by descending order treated as actual date. I tried converting it to date and then tried to extract the year and month out but I keep receiving conversion errors. Does anyone know how to get this in the descending order to it shows up like this:
JAN-10
NOV-09
OCT-09
SEP-09
JUL-09
NOV-08
OCT-08
SEP-08
JUN-09
MAY-09
MAR-09
JAN-09
This is the closest I got but it keeps sorting the list alphabetically:
select distinct periodname, Convert(varchar,periodname,112) from periodtableorder by Convert(varchar,periodname,112) desc
I am a bit confused how to say this but here goes.I have a sql server 2008 database tablewhere I want to select rows by descending order of a [column name] and then select first 10 rows from that output.I was trying something like select top 5 * from (select * from movie_data order by hits DESC);this does not work and I'm quite new to query-writing.
View 2 RepliesI have built a "portal" that displays "widgets" (server side usercontrols). The page contains two columns, each containing an updatepanel. Each widget contains an updatepanel and multiview with the default view showing a "loading" message and the second view contains the actual content.
When a user logs in, I query the database to get a list of widgets the user has access to, along with their column and order number. During page init, I add all of the widgets to the page's columns in the order indicated. Once the page loads, a timer on each widget gets fired and the widget's multiview switches from the "loading" view to the content view and sets the content's visibility to true. This forces the content to load.
Setting up the load this way makes the page load appear faster because it doesn't process any of the widget data until after the initial page load. This all works fine but I have an issue with the order in which the widgets get loaded.
Currently, the page loads and the widgets will start loading from the top of the left column down to the bottom, then it will start loading the top of the right column. The page could potentially have many widgets so I end up staring at a bunch of loading messages on the right side while I wait for the full left column to load. I would really like to be able to load top down across both columns instead of the whole left column and then the right column. For example, load the first widget in the left column, then the first in the right, and so on. This way, the user would have something to look at the top instead of staring at a bunch of loading messages and having to scroll down the page while it loads.
I have two table Order and Order Detail.
What i need is i need to bind last 10 Order in Gridview/details view with paging, and the same order detail also fetch from database and shown in another gridview.. if user click any oderNo in first Gridview/DetailView then i need to show Respective order detail in anther gridview..
without postback coz we already fetch 10 order with orderdetails from the database..and if user click next 10 orderNo using paging then again we need to load 10 orderNo with respective orderdeatils from database like this going on....as well as let me know how to take print of particular oder and order detail....?
I have two tables:
GalleryAlbums and GalleryPhotos.
I would like to Select all entries in the GalleryAlbums table, but Order them (DESC) by date values in a column (upload_date) on the GalleryPhotos table. Both tables have a column "album_id"
A little confused how I might write this statement.
I wrote a select statement such as:
[Code]....
I need to implement a stored procedure for search with 1 fileldkeywords(jobtitle,skills,company name....etc) everything is in different tables?how i will query this?any samples using dynamic query or temporary tables
View 3 RepliesI have one sproc with Dynamic Temp Table. Sproc returns dynamic temp table rows and when I drag and drop the sporc on to Linq to Sql Designer I am not getting Return Type as "(Auto-generated Type).
how can I get Return Type as Auto-generated Type.
I have several dropdownlists which are databound to a SQL DB but I am also needing to add 2 items to them. I am using the code below.
With the code in the Calendar1_SelectionChanged sub (Which is when I want it to fire) It loads the data from the sql but not the static content
If I move the code to the Page_Load sub and add "If Page.IsPostBack Then" then it loads the static content but not the SQL.
[Code]....
I want to write dynamic store procedure means 1 select_sp, 1 update_sp, 1 insert_sp, 1_delete_sp for all tables.
How it is used in secured manner.
i have a query like this and its running correctly
SELECT CAST(REPLACE(LTRIM(RTRIM(SUBSTRING(P.Telephone, 2, LEN(P.Telephone)))), ' ', '') AS BIGINT)
FROM P INNER JOIN PCommunication ON P.ID = PCommunication.ID
WHERE P.Telephone IS NOT NULL AND CAST(REPLACE(LTRIM(RTRIM(SUBSTRING(P.Telephone, 2, LEN(P.Telephone)))), ' ', '') AS BIGINT) > 5000000000
AND PCommunication.TypesID = '7667d187-5fe1-4aaf-9e31-79761561da58'
i am trying to use it with dynamic query like this but its not working
@query = 'SELECT CAST(REPLACE(LTRIM(RTRIM(SUBSTRING(P.Telephone, 2, LEN(P.Telephone)))), ''' ''', '''''') AS BIGINT)
I try to import Excel files to sqlserver problem is that the number and the titles of columns are dynamic.How can i do that by code?
View 5 RepliesI have a requirement where I need to declare a Sql Statement dynamically in a cusror. When I declare dynamic Sql Statement and execute the SP, it throws an error message. The Cursor is not recognizing the dynamic Sql command.
As per the requirement, the sql statement will change according to the input parameter and it can't be declared as a static sql as shown below. Can anyone tell me, how this can be achieved any other alternative to do?
