DataSource Controls :: Delete Multiple Rows From Database In A Table?
May 1, 2010
I've have to delete multiple rows from database in a table . Which is the best way to delete data to optimize performance of sql server as well as asp.net.
How do I remove duplicate rows from a data table based upon a two column values;I want to pass in a Data Table and a column names and get the data table back with data rows where that columns value are unique.
I have a Data Table with Duplicate Rows i want to delete the duplicates rows based upon two column values if both columns values are there then Delete the row.
I'm trying to figure out how to update multiple rows in my Directory table, when a user changes their Street Number or Street Name in their profile. They can add multiple users to a directory and each user they add to the directory has this primary users UserId in it. So if the primary user changes their address, I want it to update the address for all the users they listed in the directory as well. I'm adding this to the On_Click in the Code Behind, so when they click to update their profile, it fires this function as well. This code may be way off, but here's what I have right now:
My code is not updating the sql database. I am definately passing the correct information in to this function, and it runs without errors. If I exec the procedure with the passed in data, it works great. Can someone tell me what is missing?
I want to insert almost 400 rows in one database call in asp.net. I am using .net 3.5 and sql server 2005. What should be the best possible way for doing that?.
I'm having a gridview in my aspx page with checkbox, User can select one or more than one record(s) at a time and clicks on delete button, Then i'm constructing an object of my DTO and adding all the checked row's Primary Key (DataKeyNames - GUID's in case) to a serializable class and generating an XML and sending it as parameter to the Stored Procedure.
My Doubt is, can i bulk delete all the rows from database table those are present in my XML document??
If it works, I can do bulk update with XML only, i already did bulk insertion by generating an XML..
My Another Question is, Will it affect the performance? Each time when i construct an DTO object and adding it to the Generic List??
WHich one is better, I mean ObjectDataSource or SQLDataSource or my XML method?
I am trying to delete multiple rows using a checkbox in a Gridview. When someone checks the checkbox and then click on button Delete that the rows is chosen will be deleting.
GUI:
[Code]....
when i click on button Delete : Error: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
I have one table named 'dbo.ac_Products' Within this table there is a column named 'ProductId' There is also another table named 'dbo.ac_CatalogNodes' Within this table there is a column named 'CatalogNodeId' and a column named 'CatalogNodeType'
I need to delete all the rows from 'dbo.ac_Products' and 'dbo.ac_CatalogNodes' where 'ProductId' = 'CatalogNodeId' and 'CatalogNodeType' = 1
I am trying to delete or add rows in a table but since the table is in an update panel,upon deletion the row goes away and then comes back.I have tried using return false but it does not seem to work in IE or FF.
I want to delete the rows present in the DataTable by using LINQ (with out looping)
The deleted rows will be come from a LINQ as below
IEnumerable<DataRow> MobileQuery = (from d in dtBillDetail.AsEnumerable() where (String.Compare(d.Field<string>("Destination"), "MOBILE", StringComparison.InvariantCultureIgnoreCase) == 0) select d );
The DataRows present in the "MobileQuery" should be deleted in the DataTable "dtBillDetail"
I want to delete grid view row on button click .when I select a row and click on delete button the selected row should be delete using jquery,with out using database . I want to do this work on button click using jquery
in my gridview iam at page load event iam displaying data from view.my 1st column in the gridview is checkbox, when user selects the checkbox and iam using paging in gridview, when user selects the checkbox and selects the rows from first page or from any page, that have to be stored in database.
in my database the table contains
orderid int primary key autoincrement productname nvarchar price nvarchar quantity nvarchar total nvarchar
when user selects the rows then in database how to store multiple rows in that table field
in my gridview iam at page load event iam displaying data from view.my 1st column in the gridview is checkbox, when user selects the checkbox and iam using paging in gridview, when user selects the checkbox and selects the rows from first page or from any page, that have to be stored in database.
in my database the table contains
orderid int primary key autoincrement productname nvarchar price nvarchar quantity nvarchar total nvarchar
when user selects the rows then in database how to store multiple rows in that table field
Colour(Colour ID, Colour) DogColours(ColourID, Dog ID) Dog(Dog ID, Breed)
Colour ID and Dog are primary keys.
I have three web forms, one for each table. Dog colours consists of data that is already in the system from the other two tables. It basically joins a breed to a colour. My problem is this:
When i try delete a dog which is being used in dog colours the program crashes. How can i prevent this crash?
The second problem, the data source in the dog colours web form has the insert, update and delete tick boxes greyed out in the 'configure the select statement' so i am unable to delete a colour and dog joined together. how can i delete something in the dog colours?
I currently have a datasource that displays several rows on an editable gridview where the user can update several rows at once. Each row contains an ActivityTotal column per row. I'd like to sum all the ActivityTotal rows displayed and have one totalValue.
I would like to be able to read the first row of a table and then each successive row sequentially individually. So, is there a way to read the first row of a table, whatever the primary key may be, and then read the next sequential row in the table until the last row has been read? I need to be able to do this in order to create a list of column entries in each row for a listbox control that a user can select from.