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 would like to select a distinct query based on three fields and display the rest of the fields. For example,
I have firstname, lastname, address, city, state and zip, but I only want to use the distinct on these fields first and last name. However when i use the distinct function I get a distinct on all the selected rows. I just want to distinct firstname and lastname and display the other fields. for example,
Mary Smith New York
Mary Smithy New York
Mary Smith Maine
I would like the result to be:
Mary Smith New York
Mary Smithy New York
I don't care about Mary Smith Maine, because i am only using the distinct for "Mary Smith" firstname and last name and showing the city.
how to write a select distinct column1 from another select ?
i mean SELECT distinct column1 from (SELECT column1,column2,column3 where column1 =1)
Having some troubles selecting distinct rows.
[Code]....
This is not giving me the wanted results.
Two models:
[code]....
Each ContentVersion is linked to Content through the ContentID.
I want to select all "Content" where UserID = X, then for each selected "Content" I want the latest "ContentVersion".
The return type should be of type <IQueryable>ContentVersion.
This is something I can easily do in SQL, but I'm pretty new to LINQ and haven't been able to find an answer online.
I need a LINQ query that returns two values; the first a distinct value and the second the count of the first value. This is filtered by a parameter. Here is my table:
[code]....
how can i use Distinct in my sql statement like that
SELECT
Distinct * from my_table ?? ? ? ?? ? ? ?
I have an already created DataTable object which i am using for my girdview (asp.net) i also need to bind a column of that object to a DropDownList. The datatable has the correct details in the column but the column contains more that 1 of the same name in the column - hence I would love to just do some kind of SELECT DISTINCT on the datatable and copy it to a new datatable for use with binding the dropdown.
This would allow me to save resources by making another trip to the database.
Here is an example, the current datatable has a column called items and in this column has the following entries
1
1
1
1
5
5
6
And of course i need only unique items for binding to my dropdown, hence i need the following data
1
5
6
Of course i don't want to change the original datatable object but rather make a copy of it will the new details.
How can i select all columns of table but to distinct by one column? i am tryin to figure it out without success, i know how to make distinct (select distinct column from table, but i need all the values from the table and to distinct by Delcompany.
my line is:
[Code]....
I'm using asp.net login on a SQL Database.
I have 12 users in my User tabel - one of the user I don't want to have in my select (the user is an admin).
I tried this:
[Code]....
I also tried:
WHERE (dbo.aspnet_Roles.RoleName <> 'Administrators')
Both time it took the user into the table....
If I instead try this
WHERE (dbo.aspnet_Roles.RoleName = 'Administrators')
I get only one row (as expected).
What is wrong with the above sql statement - why can't I get 11 users and not them all (12 users)?
<
asp:LinqDataSource
ID="LinqDataSourceSM"
runat="server"
ContextTypeName="SalesIntranetSolution.DataClasses.salesIntranetDataClassesDataContext"
OrderBy="reportTo"
Select="new (reportTo)"
TableName="cubeSalesRepRollups">
</asp:LinqDataSource>
Does somebody know how I can modify this LinqDataSource to select distinct records only?
there are multiple rows with same SubContact_No and with same value of some columns. for a single column I am firing query like
Select distinct (Financial_Status) from mtblSub_Contract where SubContract_No=@SubContract_No";
it's working fine.... (it's ok with a Single column)
But Now I need multiple columns value so how to query for this.
Select distinct (Financial_Status, colums2, column3) from mtblSub_Contract where SubContract_No=@SubContract_No"; is not working
So how to do that.
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]....
I have the following table structure:
[code]....
The following query returns the default recordset:
[code]....
I have a page where I'm displaying all the different brand that I company stocks
For each distinct brand I need to display a count of the number of items with that particular brand
e.g.
brand name
number of products with that brand
brand name 2
number of products with that brand
brand name 3
number of products with that brand
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!
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 one table(tableName is getDetails and having three column ID, Name, City)
View 6 RepliesI 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 Replies