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

Similar Messages:

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

Forms Data Controls :: Details View Read - Record Gets Deleted

Feb 27, 2011

I have created a Details View and set some of the fields to read only. I have added the edit command which is allowing me to edit all of the fields that are not set to read only but when I press the update button all the infomation stored in the readomly fields gets deleted and just show up as blank is there a way to stop them from getting deleted.

View 1 Replies

State Management :: Cached Items Automatically Deleted?

Apr 20, 2010

I have an application consisting of two web pages and a web service. All components are part of the same project, i.e. I have a solution with only one project. The web service queries a server and fills the information it retrieves into container objects which are stored in the cache of the application. This done using the Cache.Insert method:

CacheItemPriority.Default, OnRemove);

OnRemove is my handler that writes the reason into the log file in case the item is removed from the cache. Now from what I understand this example item should never be automatically removed from the cache. Basically this is what I want: It shall stay in the cache until I explicitely remove it. Once the cache is populated by the web service one of the web pages visualizes the cache content using html. The other web site contains a button to manually kick on the web service and one button to clear the cache content, i.e. remove everything in the cache. Unfortunately somehow the cache seems to get cleaned up once in a while. In irregular intervals all containers that are created by the web service and are stored in the cache are removed from the cache. I don't understand the reason for this. The only place in the code I remove something from the cache is when I manually press the clean cache button on one of the web pages.

What is strange is that all container objects in the cache are removed, not just a few. But this is not because the button that cleans the cache is pressed. I know this because a log entry is created whenever that button is pressed. To find out what is going on I attached the OnRemove handler which just logs the reason why a cache item is removed. In my case the reason is "Removed". I simply don't get it. How can I ensure that the cache just stays as it is? Items placed in there shall just stay there. Nothing shall be cleaned up automatically.

View 4 Replies

DataSource Controls :: How To Get The Deleted Values In The Dataset

Apr 16, 2010

i am using dataset,i retrived the values from the database and i deleted from the data set .is it possible to get values back?

how can i get those values?

View 3 Replies

DataSource Controls :: How To Retrieve Information From Deleted Row

Apr 7, 2010

How can I retrieve information from delete rows. I delete some rows from table in dataset, then I use method GetChanges(DataRowState.Deleted) to get deleted rows. I try delete rows in original table on server side, but it finished with this errors. I try get value of columns from row, which was deleted

View 6 Replies

DataSource Controls :: Whole Gridview Was Deleted When Trying To Delete Only 1 Row?

Jan 10, 2011

I am trying to delete a row of records in a gridview. The selectMethod works perfectly fine, but the DeleteMethod doesn't. When I delete a row, only 1 row of records should be deleted, but the whole gridview was deleted! (I have about 3 -5 rows of data). I am using ObjectDataSource.

Data Access Layer


Business Logic Layer


Presentation Layer



Presentation Layer

Code Behind:


View 6 Replies

Forms Data Controls :: How To Refresh The Dropdown List In The Details View After The Gridview Item Has Been Deleted

Nov 16, 2010

I have a dropdown list within a details view that allows me to set 1 or many categories to a perticular record(in this case a photo). The select command in this case only displays those catetegories that are not already attached to the selected photo.

all works well and as you select a category and add it to the database the category is removed from the dropdown list and is added to a gridview which shows all categories that photo is stored with.

My Problem is that when i delete the category from the gridview the dropdown list does not delete with said deleted item unless i do a "click in URL bar and press enter" to totally refresh the page.....

how to refresh the dropdown list in the details view after the gridview item has been deleted?


View 5 Replies

DataSource Controls :: Restore Deleted Tables From SQL Database

Apr 3, 2010

i am using sqlserver 2008 express.

i have a problem here, unfortunately i deleted "Manually" some important tables from my database, now i need to retrieve those tables,

i didnot take a backup for those tables,

can i retrive those tables or roll back delete process?

View 1 Replies

DataSource Controls :: Check SqlDataSource Deleted Event If Success?

Jan 6, 2011

I have problem to check "if the file is success deleted".This is the algorithm, if sqldatasource deleted success then ---show message or other action---end if

View 5 Replies

DataSource Controls :: Multiple ItemTemplates - When A User Clicks On Image The Row Gets Deleted?

Nov 5, 2010

I have the following datagrid


Notice that I have multiple ItemTemplates. On the first itemTemplate I have an ASP image control showing some image. I would like that when a user clicks on that image the row gets deleted. How can I do that without using the asp:buttoncolumn?Also the same applies for selecting a row, that instead of deleting the row the row gets selected

View 2 Replies

Visual Studio :: Items That Select In Design View Are Not Being Highlighted In Source View?

Sep 30, 2010

I'm using Visual Studio 2008, and when I select/highlight something in design view and switch to source view it does not highlight and scroll to the selected item. This makes it really hard to change stuff in source view, and it's very inconvenient at worst

View 2 Replies

Forms Data Controls ::want To Get Selected Items On Grid View?

May 16, 2010

how can i get selected checkbox item from grid view if the user click on the buttion , i tryied this but i dont know how to get the values from columns.

my columns are Id,FirstName.the function called from the buttion not from the gridview.

my code is:


the secound one, when i am trying to insert a new values to db and the new values get id automaticly by sqlserves 2005,how can i get this id because i want to save in other table to.

View 3 Replies

Forms Data Controls :: Accessing Items Through Grid View?

Jun 2, 2010

Actually I and doing my college Project and I have some Problem.I have 3 sections in my web page:1. The Search Part, which search a product by its name or Id.2. Result Part, which is a grid view showing Product ID,Product name ,its stock and Price.3. Billing Part, where The bill will be created which contains ,Product Id, Product name, Qty,Price,Total Price as attributes.Now I want that if any one search the product then result is shown in result part and then from the list of the products i click a product and add it in the bill list.But I am not able to understand here how to access a data from the grid view i.e. accessing Product Id,Product name, Price and add it to bill.

View 5 Replies

Forms Data Controls :: Selecting Specified Items In Gdrid View?

May 17, 2010

have trouble with grid view,I want to select specified items and show them in labels or text boxes.I don't want to use check boxes ...E.g:I want to use for or foreach methods and show all the items in column (1) in text boxes respectively.

View 10 Replies

DataSource Controls :: Using A View / To Set A Column As A PK, Or Unique, Within An Already Created View?

Jun 28, 2010

I have a view created that I want to use as my datasource, however to enable to generate insert/update commands it specifies I must have all primary keys selected. Is there a way to set a column as a PK, or unique, within an already created view? And how?

View 2 Replies

Forms Data Controls :: Change The Displaying Items in A Grid View?

Mar 20, 2010

i want to change , the displaying items in a grid view and on the way the text value of a lable at the same click on a link ... ? it means that i need the connectionstring or somthing in the properties to change with the link click

View 5 Replies

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

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

Forms Data Controls :: Delete, Edit, Select Items Is In Grid View I Have To Do In C# Code It Will Reflect To Database Also?

May 20, 2010

I want delete, edit, select items is in grid view i have to do in c# code it will reflect to database also

View 3 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 :: 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

Copyrights 2005-15, All rights reserved