DataSource Controls :: GridView Sum / Want To Sum All Items That Are Equal?

Jun 4, 2010

Im creating a Report to see all I have sold to a Client, my SQL query looks like this


What I dont want is to get a list of repeted items, I want to sum all items that are equal. for exemple:

Current Situation:

What I want to acomplish

View 3 Replies

Similar Messages:

DataSource Controls :: Retrieve All The Records Where The Datetime Is Greater Than Or Equal To 30 Days Ago?

Apr 10, 2010

I want to retrieve all the records where the datetime is greater than or equal to 30 days ago. What is the correct formatting for this line: WHERE Property.dateadded >= NOW -30 days .. Dateadded field is in datetime format.

SELECT TOP (1) Property.Name, Property.Price, Department.DepartmentTitle, Images.ImageId, Property.DateAdded
Department ON Property.DepartmentId = Department.DepartmentId LEFT OUTER JOIN
Images ON Property.PropertyId = Images.PropertyId
WHERE Property.dateadded >= NOW -30 days

View 6 Replies

DataSource Controls :: Data Types Text And Varchar Are Incompatible In The Equal To Operator?

Jul 4, 2010

I get the following error: The data types text and varchar are incompatible in the equal to's my code (PageName is a string Parameter) :

SqlConnection sql = SQLconnection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select title, text, postdate, sticky from articles where pagename = @pagename;";

View 2 Replies

Forms Data Controls :: Why Select Index Equal -1 In Gridview

Apr 3, 2010


why when I selected button select then it show index equal -1 in gridview ?

View 5 Replies

DataSource Controls :: Cannot Resolve The Collation Conflict Between "SQL_Latin1_General_CP1_CI_AS" And "SQL_Latin1_ General_CP1_CS_AS" In The Equal To Operation

Mar 27, 2010

I seem to be getting the following error when trying to do an inner join on a new table I have recently created. The only way I have got around this so far is to put "COLLATE SQL_Latin1_General_CP1_CI_AS" into my join. Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP1_CS_AS" in the equal to operation.

I have not seen this error previously when doing joins, and it is a real pain. My only thoughts are that I have recently added the ASP.NET Security tables to my database - could this be causing the issue? Is there a conflict with collation going on? Although all my tables seem to be using the same Collation as the "aspnet" tables when I look at the extended properties of each table.

View 9 Replies

DataSource Controls :: How To View Deleted Items In L2S

Feb 4, 2010

Iam a newbie in Linq to Sql. I have some problems with my deleting items function. assemble the code together:I must have the following code accumulated.


View 12 Replies

DataSource Controls :: Delete Items From Two Tables?

Jun 28, 2010

im doing an album page just like facebook album

Now im trying to allow deleting album function in which, when i click a button or linkbutton,

the entire album will be deleted including all the photos within that particular album

Album and photo is in two different table in my sql

im using the sqldatasource to set the delete parameter

DeleteCommand="DELETE FROM [Album] WHERE [AlbumID] = @AlbumID"

is there any way i can insert another delete command in the same sqldatasource or other way to do it?

i duno how to do with store procedure.

View 5 Replies

DataSource Controls :: Count Items Returned From ObjectDataSource?

May 27, 2010

I am viewing items returned from a dataset in an Infragistics chart control. My problem is that due to a weak point in the control, I am left looking for a way to manipulate the height of the chart based on the count/number of items returned by the ObjectDataSource(DataSet).

Does anyone one have an existing C# sample they could let me view of accessing the count of records returned within the code-behind of a page that I could then use within a case statement to set the hight of the control?

View 7 Replies

DataSource Controls :: GroupID Relates The Various Items To The 1st Record?

Mar 14, 2010

I have a table like the following

ID Part# Serial# GroupID
1 aa 111 NULL
2 bb 222 1
3 cc 333 1
4 dd 444 1

The groupID relates the various items to the 1st recordI would like a select that will result with the followingID Part# Serial# Partbb_serial# Partcc_Serial# Partdd_Serial#

View 3 Replies

DataSource Controls :: How To View The Command.parameters.items

Feb 3, 2010

How do I view my parameters items ?

I tried this but got this error


View 5 Replies

DataSource Controls :: Store Multiple Items In Array?

Jan 11, 2010

i want fetch multiple values from the database and store in one local array and once again i will send it that multiple values to the database

View 4 Replies

DataSource Controls :: How To Support Lists Of Items In A SQL Database

Jun 26, 2010

Using the products database analogy, i have an application using SQL Database tables, that needs to maintain list's of- applicable products for numerous different scenarios.

I reaslise a database is effectively a list itself, but ideally need some kind of list support as a table field, eg list of type "products" where I can list the primary key id's for each product - how to handle this situation using SQL databases?

View 3 Replies

DataSource Controls :: CheckBoxList Items Save To Database?

Jan 4, 2010

I've this checkboxlist with different sports items inside (Example Swimming, Floorball, Basketball and etc). Users are able to check/tick more than one item as they may be interested in lots of different sports. However, I realised that I'm not able to save all the items that the user has checked into the database; only an item will be saved. How can I save all the items that the user has checked into the database?The codes I'm implementing now:cblSportsInterest.SelectedValue (to save the value into the database)

View 4 Replies

DataSource Controls :: Checkbox List Items Stored In Database?

Apr 6, 2010

In the user form, the user has a chekboxList, and he can select more than one item.

how can I store those selected items in database, and how then I can retrieve them.
Is it true to make a separate column for each item, and then if selected, then that cloumn will have "1" and "0" for non selected.
Only that idea occurred to my mind, and I think that I can find better it.

View 7 Replies

Forms Data Controls :: Repeater DataBind Not Updating Items In Datasource

Jan 28, 2010

Here is the situation I have, I have a repeater inside a Usercontrol. The datasource is a IEnumerable<Investor> Exposed through a UserControl's Property. I have overridden the UserControl's databind event to set the Repeater Datasource before databinding the repeater. When it's not a postback, it databinds find and the events on the repeater item's controls fires up fine. But there is one event on repeater items (Delete Investor) which call back the DataBind of the UserControl after removing the Investor from de datasource. When this Event is called, it does all the work (deleting the investor and so on...) calls back the usercontrol's databind but when (within the usercontrol databind) the repeater is databinded again, the repeater items doesn't update (repeater items for investor not on the DataSource anymore still appears). My ItemDataBind doesn't even fire by then.


and code bedind


I Tried with both the Repeater Item Command and each LinkButton Event to see if it would make any difference, but none worked

View 7 Replies

Forms Data Controls :: Items Collection Cannot Be Modified When The DataSource Property Is Set

Dec 14, 2010


Above is my select query result. "Select Groupname from table". Now i want to add dynamit row in table which display like follows.


so that i can display the combobox with default value '-Select-'. I tried combobox.item.insert(0.'"Select") but it gives error.

"Items collection cannot be modified when the DataSource property is set."

so I am trying to add dynamically into table.

View 5 Replies

Forms Data Controls :: ListView With Datasource And Later Adding Items Dynamically?

Dec 11, 2010

I have a listview which has a complicated Item template that contains a repeater, an objectdatasource and some other controls. On the first run I am only showing 10 Items of the listview. The user has an option to show 10 more ListView Items. If user clicks on show older items; the listview shall add another 10 items. how to go around this since my list view already has a datasource and I don't want to rebind the whole listview all over again. Instead; I just want to add another 10 items.

View 7 Replies

Forms Data Controls :: Items Collection Cannot Be Modified When The DataSource Property Is Set?

Feb 17, 2010

I got 2 listboxes in a window form, one on left and one on right. The 1st listbox have some items while the 2nd listbox is empty. Also there are 2 buttons between the 2 listboxes which used to move item from/to the 1st and 2nd listbox.My problem here is that after I bind the data to the 1st listbox (from a dataTable, using DisplayMember and ValueMember) , and I try to move 1 of the item from this 1st listbox to the 2nd listbox and I want that the selected item is also removed from the 1st listbox by:

lbMembers2.Items. Add(lbMembers1. Text);
lbMembers1.Items. Remove(lbMembers 1.Text);

But the selected item is not removed from the 1st listbox.Also on deselect button when i move item from 2nd listbox to 1st listbox,it displays error message "Items collection cannot be modified when the DataSource property is set."

View 2 Replies

Data Controls :: How To Check If XML Element Name Is Equal To Database Field Name

Nov 25, 2013

I have to check if XML Element name is equal to db table column name in

Iam using data access layer for sql commands.


 if XML Element name is Userid the same name must be exist in the db table column name(Uerid)

if the column does not exist in the table the value should not be stored.

View 1 Replies

DataSource Controls :: Looping Through Checkbox List And Adding Selected Items To MS SQL Database

Jan 14, 2010

Looping Through Checkbox List and adding selected items to MS SQL DatabaseI don't want to store it using comma deliminator.I will need to do a search on analyze which users have what music in common.The image above is from a tbl_lookup_music table I created. MusicID, MusicNow how should I build the logicIF we have a user that has a tbl_profile table. And listens to many different types of music. How should We store the data.------------------------------------------------------------------------------------------CREATE TABLE [dbo].[tbl_lookup_music]( [MusicID] [int] IDENTITY(1,1) NOT NULL, [Music] [nvarchar](64) NOT NULL, ---- Type of music. CONSTRAINT [PK_tbl_lookup_music] PRIMARY KEY CLUSTERED ( [MusicID] ASC )WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY----------------------------------------------------------------------------------------------CREATE TABLE [dbo].[tbl_Profile_Music]( [ProfileMusicID] [int] IDENTITY(1,1) NOT NULL, [ProfileID] [int] NOT NULL, [MusicID] [int] NOT NULL,PRIMARY KEY CLUSTERED ( [ProfileMusicID] ASC)WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOHow should I setup this table.

View 4 Replies

Forms Data Controls :: How To Calculate Gridview Row Items

Dec 22, 2010

see the table below in which I calculated Grand Total of column in the Footer, but how to calculate GrandTotal at the end of each Row.


View 8 Replies

Forms Data Controls :: How To Get Filtered Items In A GridView

Apr 22, 2010

I use a GridView control in my web part to display data from sql server. I use the filter in this GridView. Can I only get those rows that are filtered. If I use GridView.Rows, it returns all data it got, Not only the filtered data.

View 2 Replies

Forms Data Controls :: Sum Of Selected Items In Gridview?

May 4, 2010

Im using Visual Web Developer 2008 and I have set up a gridview showing data from a sql database, it shows 3 columns, these are: item name, item cost and a check box column to allow the user to select certain items. I would like to have a text box that shows the sum of all the selected item costs.

Im coding in VB.

View 4 Replies

Data Controls :: ListBox Items Already Sorted To GridView?

May 7, 2015

Is it possible to have 2 ListBox then when a Button is Click the Items is Sorted already to GridView accordingly. btw I have done a sort button but for LB1 only. and LB2 only.

LB1       LB2          GridView

1           A                1 A

3           B                2 C

2           C                3 B

4           D                4 D

View 1 Replies

Data Controls :: Populate GridView From ListBox Items

May 7, 2015

Lets say I have ListBox1 (1,2,3,4,5,6) and a ListBox2 (A,B,C,D,E,F)..

and a Button and a GridView. Now when I click the Button. I want a GridView Column 0 to be populated by ListBox1 and Column 1 to be populated by ListBox2. .  C# /

View 1 Replies

Copyrights 2005-15, All rights reserved