DataSource Controls :: How To View Deleted Items In L2S
Feb 4, 2010Iam 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]....
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]....
How do I view my parameters items ?
I tried this but got this error
[code]....
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 RepliesI have an asp.net 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:
Context.Cache.Insert("DemoCacheEntryKey",
"DemoCacheEntryValue",
null,
Cache.NoAbsoluteExpiration,
Cache.NoSlidingExpiration,
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.
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?
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
[Code]....
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
[Code]....
Business Logic Layer
[Code]....
Presentation Layer
Design:
[Code]....
Presentation Layer
Code Behind:
[Code]....
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?
[code]....
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?
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 RepliesI have the following datagrid
[Code]....
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
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 Replieshow 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:
[Code]....
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.
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 Sr.no. ,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 Replieshave 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 RepliesI 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 Repliesi 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 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]....
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 want delete, edit, select items is in grid view i have to do in c# code it will reflect to database also
View 3 RepliesI 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#
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 Replies