Last night I started working on an NHibernate provider. I'm creating a criteria that several records will match, however I only want to return the most recent record (the record with the largest Id). I thought UniqueResult() would do this it cannot be used if a list would be returned otherwise.
I could theoretically select the full list and then return the desired record, but I believe there is a better way.
Can any one let me know about the below issue. I have a page which has three labels, say startdate,enddate and username. My issue is if the user doesnot select any of the above three then a message gets displayed as "Please select one search criteria" or if the user doesnot enter the date in correct format then i dispaly "Please enter date in mm/dd/yy" format. But what is happening is first time if the user doesnot select any then "Please select one search criteria" is getting displayed and after this message gets displayed if the user enters wrong format of date then both the messages are displayed.
View 5 RepliesIn the stord procedure below. I am retreiving all the records for that 1 deal. What I want is to retrieve the most recent record hence the one with the most recent in the AddedDate field.
How can I accomplish this?
(
@DealID int)
AS
SET NOCOUNT ON
SELECT deals_Comments.CommentID, deals_Comments.AddedDate, deals_Comments.UserID, deals_Comments.AddedByEmail, deals_Comments.AddedByIP, deals_Comments.DealID, deals_Comments.Body, deals_Comments.SBody,
ROW_NUMBER() OVER (ORDER BY deals_Comments.AddedDate DESC) AS RowNum
FROM deals_Comments
WHERE deals_Comments.DealID = @DealID
I am working on a project for a market research company that needs to select and have it displayed to my gridview. I need a select statement that will randomly put on my gridview the following:
Recruitment Goal 21 people and out of those people 10 people have to be male, 11 people female, 9 of them white, 9 of them black, 2 of them hispanic. Is there a way I could do that? I was thinking of doing a stored procedure and doing something like
Select TOP 10 * from Canidates where sex = 'Male' order by newid() Into #tmp
Select TOP 11 * from Canidates where sex = 'Female' order by newid() Into #tmp
Etc... and then just selecting from the Temp Table.
I have a form that searches for images in a database. I have several DropDownLists with various search criteria e.g. Genus, Photographer, State, Project.I'd like the user to be able to filter using any combination of these. For example they might pick a specific photographer and a specific genus but choose not filter by project or state.I'd like to find a good, clean, elegent way to do this.Here is an example of the code I have now, it has only two possible criteria. It works but I have a feeling there are better ways to do this....
[Code]....
I have a drop down which gets data from database.I want to show not all entries but the very last one entered by employee. What do I have to add to the sql script to get me very last entry and hide the rest.this is my Sql data source:
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:CompanyInfoEventsConnectionString %>"
SelectCommand="SELECT [ID], [NameOne] FROM [Gpi_DayOff] ORDER BY [ID] DESC">
</asp:SqlDataSource>
No records where inserted in my SQL Table after committing the transaction or after the .Flush() method. I checked the code and it follows the correct sequence of codes. I can't seem to find any other way where the error fails.
View 3 RepliesI am new to Nhibernate, I am trying to get record by ID and I am getting exceptionUnknown entity class: DAL.Producthere is my line of code where I am getting exception..
Repository.Get<Product>(id);
I am new to NHibernate and have just started right now.I have very simple table contain Id(Int primary key and auto incremented), Name(varchar(100)), Description(varchar(100))
Here is my XML
<class name="DevelopmentStep" table="DevelopmentSteps" lazy="true">
<id name="Id" type="Int32" column="Id">
</id> [code].....
I have a delete button bellow my gridview and I want a pop up to show when no record is selected and tell the user to first select a record. The button click event would show the pop up, but my gridview data blanks out.
Here is my code:
[Code]....
I want users to select a record in the GridView and then have that record open up in the Detailsview. How would I go about getting these two tools to communicate?
View 4 RepliesI was Make code to select top 3 record from db and I wont to enter every record in label or textbox
[Code]....
How to Retrive records within last 24 hrs using Nhibernate.I want to retrieve the 10 records within last 24 hours.
How can i achieve this using Nhibernate.
I'm a junior programmer, i do not get the concept of MVC! My method of coding is seperating my application design into 3 layers:
Presentation Layer
Business Layer
Data Access Layer
I find it very practical to a junior developer or at least to me, so i do not really get the point of MVC since i believe MVC just tries to separate logic from UI. Right?
I decided to have this book to help me have a better idea on code design:
http://www.amazon.com/Professional-ASP-NET-Design-Patterns-Millett/dp/0470292784/ref=sr_1_1?ie=UTF8&qid=1292836936&sr=8-1
Note: i also decided to start learning about TDD.
QUESTION:
Is breaking my code design into 3 layers (presentation, dal and business) meets MVC concept?
I have the following query which gets the top record SELECT TOP 1 username from users GROUP BY username ORDER BY COUNT(*) DESC. now i have a second field which gets the numbers of views of each user i need to return just ONE single field and that is the same username field but based on views field i can do this:
SELECT TOP 1 username,views from users GROUP BY username,views ORDER BY COUNT(*) DESC but i just need that username field based on views not both!
1.Category:
CatID(Pkey),
CatName,
ParentCatId(Fkey)=> CatID is used as a ParentCatId
2.Comp_Cat:
CCID(Pkey),
CatID,(fkey),
CompID
In my stored Procedure I am passing PageNo,CompID.. My requirement is that One parent CatName is displayed Per page but only one time.
I have a gridview which is bound to a sqldtatasource. The gridview has 3 columns and a select button. The data in the gridview pulls up just fine when I run the application and the first record is selected.
However when I select one of the other records, the gridview will not select it. The postback occurs and it remains on the first record. Here is code for my gridview and the sqldatasource:
Code:
[code]....
I'm having a problem trying to get the last record from my database.. I'm doing this: myCommand.Connection.Open()
View 2 RepliesIf I run the following SQL script:
[Code]....
I have a SQL data source control defined to filter data from a SQL database, sorted according to the date time in descending order. When i try and update a field of the latest record, the entire column, related to the field of the filtered search gets modified. I want to only update a field of the last record i.e. the last entry of the filtered data. How can i achieve it?
View 5 RepliesI've got Gridview returning a list of records in response to query... NOW, from that list of records, I need to be able to select ONE of the records, show it online in another form (some kind of data "Tool") AND also write the record to another table in an Access database...
View 23 Repliesi want to select three records order by Date .This is my News table.
NewID NewTitle NewContent NewDate
1 Example ExampleContent 01.12.2010
2 Example2 ExampleContent2 02.12.2010
3 Example3 ExampleContent3 03.12.2010
4 Example4 ExampleContent4 04.12.2010
So,query selects example4,example3 and example2.
I have to retreive all records from a table except 1 record. For example: I give example from default database in SQL ie "master" In "master" DB we have "spt_values" table. Now if I want to retreive all records from spt_values table except 1-1 record of type = A and type = B. To retreive all records its a simple query "Select * from spt_values where type in ('A','B')" -- this will returns 16 records. Now I want to retreive all record except 1-1 record left in each type, so it will return 14 records in result.
View 6 RepliesI'd like to use sql to select top (#) random row into another table, but it inserts the same record a few times sometimes. I want to avoid duplicates to be inserted, what shall I do?
what I've got for now is
INSERT INTO CompWin (PrizeID, EntryID, UserID) SELECT TOP (50) PrizeID, EntryID, UserID FROM CompEntry ORDER BY NEWID()
If I have records in a table in this order:
Id - Date - Type
1 - 2011-03-01 - 1
2 - 2011-03-02 - 0
3 - 2011-03-03 - 0
4 - 2011-03-04 - (-1)
5 - 2011-03-04 - 0
Can I somehow select the records between a record having type 1 and type -1 without using a cursor,for example the records with ids 1-4 in this example?
