DataSource Controls :: Get Last Record Of Each Group?

Apr 22, 2010

This is my table.

I want ms sql query to get result

ID ProcessID Processname Date
105 123
Sammying 2010-04-22 12:09:02.827

View 8 Replies


Similar Messages:

Forms Data Controls :: How To Make The Repeater Like Group By Col Instead Of Dispaly All Record

Feb 28, 2010

after i select data from datatabe and store to datatable finally bind to the repeater to display. but grid is always display what the datatable store there is many duplicate data appear in the repeater. i would like to show specifc col once and hidden other name which appears more than 1.

for example in repeater:

section desc seq no
A NT 1
A BT 2
A KK 3
B PP 1

then A appear more than 1. i would like to hidden A except the first record as belows:

section desc seq no
A NT 1
BT 2
KK 3
B PP 1

View 1 Replies

DataSource Controls :: Row Count Shows 1 Record But There Is No Record In Database Table

Jun 24, 2010

I am counting from a table for that i have written code as below

protected void get_Id_Afterpoint()
{
int counter = 0;
string strSql = "select count(*) as ID from tblEnergy where ID=?";
OdbcCommand com = new OdbcCommand(strSql, con);
com.Parameters.AddWithValue("ID", DropDownList1.SelectedValue);
OdbcDataAdapter oda = new OdbcDataAdapter(com);
DataTable dt = new DataTable();
oda.Fill(dt);
if (dt.Rows.Count == 0)
{
lblID2.Text = "1";
}
else
{
counter = dt.Rows.Count;
counter = counter + 1;
lblID2.Text = Convert.ToString(counter);
}
}

there is no record related to DropDownList1.SelectedValue. but as i am counting if(dt.rows.count) and i put break point on the bolded part it shows 1 record. how it can be possible?

View 5 Replies

DataSource Controls :: Getting The PK ID Of The Newly Created Record After Inserting A New Record?

Dec 20, 2010

I am creating an album using the following stored procedure, which returns the primary key for the newly created record:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[fpa_sp_albums_update_insert]
@album_id int,
@album_name nvarchar (50),
@album_descr nvarchar(250),
@album_img_cover_id_FK int,
@album_creation_date date
AS
If @album_id > 0
UPDATE [fpa_albums]
SET
album_name=@album_name,
album_descr= @album_descr,
album_img_cover_id_FK = @album_img_cover_id_FK,
album_creation_date = @album_creation_date
Where ((album_id = @album_id))
Else
INSERT INTO [fpa_albums] (
album_name,
album_descr,
album_img_cover_id_FK,
album_creation_date)
VALUES (
@album_name,
@album_descr,
@album_img_cover_id_FK,
@album_creation_date)
Return SCOPE_IDENTITY();

I execute the above stored procedure using the SQLHELPER. The VB.NET code for the page is as follows:

[Code]....

However, the createdAlbumID always shows -1 instead of the id for the newly created album.

View 1 Replies

SQL Server :: Arrange Record By Position In Group?

Jan 7, 2011

I want to develop rotation logic for my company's software by using SQL Query. I will explain you what exactly I want.

As mentioned in above figure (LEFT SIDE) I have 8 grades in alphabetical order A, B, C, D, E, F, G and Z. There are different companies belong with different grades respectively. This is my database table situation. And I want an output like (RIGHT SIDE) figure in my grid view using SQL Query.

The grade position is skipped if there is no any raw or company name exists. And newly entered Company is automatically placed in that respective skipped grade position.

I have attached an sql script for your kind help to make such useful query.

View 13 Replies

DataSource Controls :: How To Select Top X Records From Each Group

Apr 7, 2010

i have two tables (Users, Roles) and each user belongs to one role. Can I make a sql query that returns 10 newest users from each role in one query?

View 5 Replies

DataSource Controls :: Grant Execute On Sp To Group

Jun 11, 2010

i have create a local Group (on server2003) name: Group_Test

SQL-Server:
i want to grant execute on usp_test. i have to specify the group with hostname

i tried

[Code]....

but it doesn`t work

View 3 Replies

DataSource Controls :: Group By Month - Format Like MM YY

Feb 13, 2010

i have to Count Data Month wise and Date format would be like this Feb-10 and iam using the below query but no luck .

SELECT REPLACE(CONVERT(CHAR(9), ADate, 6), ' ', '-') As 'MonthYear', COUNT(AID) AS 'Planned' FROM Employee where Status =1 and YEAR(Adate) = '2009' GROUP BY YEAR(Adate), MONTH(Adate) ORDER BY YEAR(Adate),MONTH(Adate)

View 8 Replies

DataSource Controls :: Assign Sequence No To Each Group In Sql

Feb 27, 2010

I have many record in the datatable and these record is grouped by section col. How can i assign seq no to record for each group in sql

section seq
A 1
B 1
A 2
C 3

View 5 Replies

DataSource Controls :: Displaying Group By Data?

Apr 29, 2010

I'm trying to display using this query:

SELECT documentcategoryname, documentname, documentid FROM documents
INNER JOIN documentcategory
ON documents.documentcat = documentcategory.documentcategoryid
WHERE documentsiteid = @siteid
GROUP BY documentcategoryname, documentname, documentid

Which gives the following results:

documentcategoryname | documentname | documentid
About Us doccy3 3
About Us doccy4 4
Map Of Medicine doccy5 5

Is there a way using vb.net I can just display the category name once, and the documents underneath it like below:

About Us
doccy3
doccy4
Map Of MEdicine
doccy5

My code so far is:

If pagesreader.Read() Then
' output documentcategoryname
mydata &= "<h2>" & reader.Item("documentcategoryname") & "</h2>"
'display document list here using while loop?
End if

View 5 Replies

DataSource Controls :: Use Group By / Giving Error?

Apr 5, 2010

i want to use group by

var origina = (from m in _db.MeSetgroup by m.Categoryselect m)

but it have error in. how can i use group by in mvc?

View 6 Replies

DataSource Controls :: How To Display A Group Of Events When The Value Is 12/19/2010

Dec 19, 2010

I've written this code to display a group of events when the value is 12/19/2010. This means each day I need to change the "default value" to the current date to display the events of the day. I would like to make this such that the change occurs automatically, that is, on 12/20/2010, I'd like to see just the events for 12/20/2010.

<asp:SqlDataSource ID="testeventdate" runat="server" ConnectionString="<%$ ConnectionStrings:testdateConnectionString %>" SelectCommand="SELECT [eventDate], [eventDesc] FROM [programEvents] WHERE ([eventDate] = @eventDate)">
<SelectParameters>
<asp:querystringparameter DefaultValue="12/19/2010" Name="eventDate" QueryStringField="eventDate" Type="DateTime" />
</SelectParameters>
</asp:SqlDataSource>

View 4 Replies

DataSource Controls :: Use SQL GROUP BY Statement To Create Menu?

Jan 27, 2010

I'm trying to create a menu structure, subpages within pages, for use with my cms. I have 3 tables in sql server, I would like to query all three tables and list those pages with a certain siteid, and subpages where the subid is the pageid. how to use the GROUP BY Statement to create the menu below? Or could I use vb.net to display it for me? Something like this:

sitename
page
page
page
page
subpage
subpage
subpage
page
page

Here is my query so far:

SELECT * FROM sites
LEFT JOIN pages ON sites.siteid=pages.siteid
LEFT JOIN subpages ON pages.pageid=subpages.pageid
WHERE sites.siteID = 1ORDER BY sites.siteid, pages.pagesub ASC

These are my tables:

sites
siteID int Unchecked PK
siteName nvarchar(MAX) Checked
siteAdmin nvarchar(MAX) Checked
siteLive bit Checked
Pages

pageID int Unchecked PK
siteID int Checked FK linked to siteid in sites table
pageLink nvarchar(MAX) Checked
pageBody ntext Checked
pageSummary ntext Checked
pageTitle ntext Checked
pageOrder int Checked
pageHome bit Checked

subpages

subID int Unchecked PK
PageID int Checked FK linked to pageid in pages table
subBody ntext Checked
subSummary ntext Checked
subTitle nvarchar(MAX) Checked
subOrder nvarchar(MAX) Checked

View 2 Replies

DataSource Controls :: Linq Group Cannot Get The Data Returned

Feb 8, 2010

I'm attempting to further reduce a dataset/table by various user input. Part of this process is grouping the data by a timestamp prior to a summation. I'm trying to use LINQ and cannot get the data returned that I need.

[Code]....

View 7 Replies

DataSource Controls :: Order By Count And Group By In LINQ?

Mar 14, 2010

How do I translate the following query into LINQ to SQL?

[Code]....

View 1 Replies

Crystal Reports :: Count Total Number Of Record In Group Section?

Jun 2, 2010

how to count total no of record in different group section in seagate crystal report

View 2 Replies

DataSource Controls :: List Duplicate Records And Group By Clause?

May 27, 2010

I have some duplication that I need to clean up. I wrote a SQL query that is supposed to return duplicate customers who are located in the same city and zipcode.

I have 2 questions regarding it:

1. Is the query syntax correct to find duplicate records by same city and zipcode, data is being returned but it just returns the same customer a few times?

2. I only need to do the GROUP BY clause for Fullname and City however it gives an error when the other columns are left out. The error is Address, State and Zip not being in the aggregate function or in the group by clause.

Adding all the remaining columns to the GROUP BY clause works.

Query is as below:

[code].....

View 3 Replies

DataSource Controls :: LINQ Query To Grab The Last 5 Rows From A Group?

Jan 8, 2010

i have the following objects:

Event:

- EventID (PK)
- GroupID (FK)
- StartDate

Group:

- GroupID (PK)
- GroupName

What i need to do is select the last 5 events for each group using LINQ to Objects. I tried starting with:

[Code]....

But i'm not sure how i only take the last 5 per group.

The simple way of doing this is to get the groups and then have a property on that which returns the last 5 events but if i databind this i will have to use a nested Repeater/ListView. Ideally i would like to have a row foreach event.

View 3 Replies

DataSource Controls :: Equivalent Of Group Join In Lambda Expression?

Jun 29, 2010

What will be the equivalent GroupJoin lambda expression in LINQ when I do this.

Dim fruit_salad = (From fruits In _DataContext_Fruits _
Group Join fruitRipe In _DataContext_FruitRipe On fruitRipe.fID Equals fruits.fID Into Group
From fruitty_lecious In Group.DefaultIfEmpty() _

[code]...

View 5 Replies

DataSource Controls :: Group By With No Repeated Data In Sqlserver 2005?

Jan 28, 2010

The below query produce the below output.

[code]...

select r.Name,c.Name,s.Name,(select count(p1.id)from profiles p1 where r.id=p1.religion and c.id=p1.caste and s.id=p1.subcaste and p1.Gender=1)as Male,(select count(p1.id)from profiles p1 where r.id=p1.religion and c.id=p1.caste and s.id=p1.subcaste and p1.Gender=2)as Female from religion r,profiles p,caste c,subcaste s where r.id=p.religion and c.id=p.caste and s.id=p.subcaste group by r.Name,c.Name,s.Name,r.id,c.id,s.id

View 3 Replies

DataSource Controls :: Change File Group Using Alter Table Query?

May 6, 2010

I have a table that contains image data type and has more than 20,000 records.I want to change its file group to the new file group. I tried to change it using table designer, but everytime I wanted to save it, it occured an error with this message:

[Code]....

Does anyone know how to change file group using Alter Table query? I'm using SQL Server 2005.

View 2 Replies

DataSource Controls :: Error 18 Cannot Convert Method Group 'ToList' To Non-delegate Type

Feb 17, 2010

I am getting an error on the return saying

Error 18 Cannot convert method group 'ToList' to non-delegate type System.Collections.Generic.List<string>'. Did you intend to invoke the method?

View 2 Replies

DataSource Controls :: Sql Query - Group By - Display Total No Of Contacts And Companies With Respect To Countries

May 4, 2010

i have 2 tables company(companyId,companyName,City,state,country) and people(peopleId,peopleName,City,state,country) i want to display the total no of contacts and Total no of companies with respect to countries

i tried with group by: select country,count(*)companyId from company group by country is displaying the total number of companies with respect to country select country,count(*)peopleId from people group by country is displaying the total number of peoplewith respect to country

but i want to combine these two quries i want the output as :

Country Companies Contacts
India 10 5
USA 0 10 (usa is having only contacts ,i doesn' have the companies)
UK 8 0 (ukis having only companies ,i doesn' have the contacts)

View 2 Replies

DataSource Controls :: SQL Insert A Record Using VB?

Mar 31, 2010

I'm very new to this area and am using ASP.NET 3.5 with WMD 2008 Express Edition and VB code.

How do I write records to the SQL database using VB? I want to use the connection string, etc used in the ASP.NET controls if possible.

My website is a Rugby Club site and I've an SQL database of match fixtures which include TeamId(1XV, 2XV, etc.), Season(2008, 2009, etc) and match date.

I allow some users to update the fixture details but want to insert a series of new fixture records for the neext season which contain just TeamId Season and Match Dates. I therefore want to take the season and Team Id from label fields and then create match dates by adding seven days to a start date.

View 4 Replies

DataSource Controls :: How To Get And Use Record ID In Same TableAdapter

Feb 5, 2010

There are several articles and blogs that are sort of about this subject but I haven't found one on point. Wondering if anyone has done this? Using VS2008 creating an ASP.NET 3.5 app with a strongly-typed dataset connecting to an MS SQL backend. In one TableAdapter, I have a custom Insert statement that inserts the record into the primary table. There are two other tables the also need records inserted into them and those records contain the record ID from the primary table. Here's an example of what I'm trying to accomplish:

[Code]....

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved