Im creating a Report to see all I have sold to a Client, my SQL query looks like this
[Code]....
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:
[Code]....
What I want to acomplish
[Code]....
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
FROM Property LEFT OUTER JOIN
Department ON Property.DepartmentId = Department.DepartmentId LEFT OUTER JOIN
Images ON Property.PropertyId = Images.PropertyId
WHERE Property.dateadded >= NOW -30 days
I get the following error: The data types text and varchar are incompatible in the equal to operator.here's my code (PageName is a string Parameter) :
SqlConnection sql = SQLconnection();
en();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select title, text, postdate, sticky from articles where pagename = @pagename;";
[code]...
[code].....
why when I selected button select then it show index equal -1 in gridview ?
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.
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.
[Code]....
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.
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?
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#
How do I view my parameters items ?
I tried this but got this error
[code]....
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 RepliesUsing 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?
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 RepliesIn 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.
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.
[Code]....
and code bedind
[Code]....
I Tried with both the Repeater Item Command and each LinkButton Event to see if it would make any difference, but none worked
[code]....
Above is my select query result. "Select Groupname from table". Now i want to add dynamit row in table which display like follows.
[code]....
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.
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 RepliesI 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."
I have to check if XML Element name is equal to db table column name in c#.net
Iam using data access layer for sql commands.
Ex,
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.
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 Repliessee 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.
[code]....
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 RepliesIm 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.
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
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# / Asp.net.