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.

View 6 Replies


Similar Messages:

DataSource Controls :: How To Delete The Duplicate Rows From Data Table

Mar 4, 2010

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.

View 8 Replies

DataSource Controls :: How To Delete Multiple Records In A Table Using Linq

May 14, 2010

i am new to this linq concept,

i have used the following code to delete multiple records in my table,

but when i hit the button insteading deleting multiple records only one record is getting deleted

below is the code

protected void Button1_Click(object sender, EventArgs e)

View 10 Replies

DataSource Controls :: Update Multiple Rows In Directory Table?

Sep 22, 2010

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:

[Code]....

View 2 Replies

DataSource Controls :: Using Dataadapter For Custom Add / Delete Of Database Table

Feb 12, 2010

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?

public DataTable UpdateEmailList(int listId, string connectionString, DataTable EmailList)
{
//DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(null, conn);
SqlCommand cmd = null;
//add
cmd = new SqlCommand("dbo.fp_ServiceAwards_AddEmailToList", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@emailList_id", SqlDbType.Int)).Value = listId;
cmd.Parameters.Add(new SqlParameter("@email_address", SqlDbType.NVarChar, 255, "email_address"));
cmd.Connection = conn;
da.InsertCommand = cmd;
//delete
cmd = new SqlCommand("dbo.fp_ServiceAwards_DeleteEmailFromList", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@emailList_id", SqlDbType.Int)).Value = listId;
cmd.Parameters.Add(new SqlParameter("@email_address", SqlDbType.NVarChar, 255, "email_address"));
cmd.Connection = conn;
da.DeleteCommand = cmd;
try
{
da.Update(EmailList);
}
catch (Exception ex)
{
string msg = ex.Message;
}
conn.Close();
conn.Dispose();
return EmailList;
}

View 3 Replies

DataSource Controls :: Insert Multiple Rows In One Database Call

May 19, 2010

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?.

View 1 Replies

SQL Server :: XML With PrimaryKey Values To Delete Rows In Database Table At A Time?

Oct 25, 2010

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?

My XML will be like this

<root>
<Customer>
<CustomerID>GUID1</CustomerID>
<CustomerID>GUID2</CustomerID>
<CustomerID>GUID3</CustomerID>.....

View 4 Replies

Forms Data Controls :: Delete Multiple Rows In Grid?

Jun 16, 2010

ihave grid in which i want to delete selected rows (checkbox selected)

i have written code as follow but on click on delete button it delete all.

[Code]....

View 8 Replies

Forms Data Controls :: Delete Multiple Rows In A Gridview Using Checkbox?

Jul 18, 2010

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

View 5 Replies

SQL Server :: Delete Objects From Table Using Another Table To Select Rows?

Sep 14, 2010

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

View 4 Replies

JQuery :: Delete Or Add Rows In A Table But Since The Table Is In An Update Panel?

Sep 18, 2010

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 am using the following code:

$(document).ready(function () {
$(.table).click (function ()}
(this).parent().remove();

[code]...

Basically I need a way to disable the postback.

View 5 Replies

DataSource Controls :: How To Delete Related Data / Rows

May 5, 2010

How to delete related data.

Ex:

Tables:

1) Account: ID,UserName,Pass

2) Campaign: ID,AccountID,Date,Balance

3) CampaignSpec: ID,CampaignID,Spec,Color

Note: Account.ID = Campaign.AccountID and Campaign.ID = CampaignSpec.CampaignID

View 1 Replies

DataSource Controls :: Delete The Rows Present In The DataTable From IEnumerable DataRow

Jul 22, 2010

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"

View 1 Replies

Data Controls :: Delete Multiple Selected GridView Rows Using CheckBoxes On Button Click Using JQuery / AJAX?

May 7, 2015

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 

Following the my jqury code for delete

<script type="text/javascript">
$(function () {
$("[id*=GridView1] td").hover(function () {
$("td", $(this).closest("tr")).addClass("hover_row");
}, function () {
$("td", $(this).closest("tr")).removeClass("hover_row");

[code]....

i am working without using data base only delete from gridview.

View 1 Replies

Forms Data Controls :: DetialsView Where Each Row Has Multiple Detail Rows From Another Table?

Sep 22, 2010

I have a <asp:DetailsView> based on a table that has a details table, like so:

DB1 --> TABLE1 --> Customers: ID, name, street, mail

DB1 --> TABLE2 --> SitesToCustomers: CustomerID, SiteID

Problem One: I need my details view to show / edit both values from customer table and SitesToCustomers table, How do i do that?

Problem two: The site name (oppesed to its code that is saved at SitesToCustomers) is found on another DataBase in this table:

DB2 --> TABLE1 --> Sites: ID, SiteName

How can make the data source show site names according to their id's from SitesToCustomers table?

all of the code behind is c#.

View 1 Replies

Forms Data Controls :: How To Store Multiple Rows In A Table From Gridview

Apr 9, 2010

iam using asp.net2.0 with c#

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

View 7 Replies

Forms Data Controls :: How To Store Multiple Rows In A Table From Gridview

Apr 9, 2010

iam using asp.net2.0 with c#

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

View 3 Replies

DataSource Controls :: Unable To Delete Data In The Third Table.

Mar 18, 2010

I have three tables:

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?

View 13 Replies

Forms Data Controls :: Delete Multiple Files From Disk Based On Path In Sql Table?

Sep 15, 2010

I have two tables:

Table1
IDTable1
CustomerName
Table2
IDTable2
IDTable1
FIlePath

There is a one to many relationship with key field = IDTable1

I have created one client and uploaded 20 files

Now I would like to:

Delete the client record from Table1

Delete all associated records in Table2

Delete all files from the disk based on the paths in Table2

I am able to delete all the records in both tables but I cannot delete the disk files. Here is what I ahve so far:

[Code]....

View 1 Replies

DataSource Controls :: Select Rows From Table?

Mar 16, 2010

I need to select the rows between 20 to 30 from a table without using where condition. How is it possible?

View 2 Replies

DataSource Controls :: Resetting A Table Rows?

May 1, 2010

I want to delete all rows from my table and then Sequence no of the primary key will start at 1.

View 1 Replies

AJAX :: Multiple Delete GridView Rows With Confirmation Using ConfirmButtonExtender

Sep 19, 2013

I have a grid in which multiple delete is to be implemented but before deletion it should show confrmation box which will ask to delete or not.

But this confirmation bo must be an ajax modal popup extender confirmation box not javascript.

My code for multiple delete:

protected void annDelete_Click(object sender, EventArgs e) {
foreach (GridViewRow row in GridView1.Rows) {
CheckBox cb = (CheckBox)row.FindControl("chk_delete");
if (cb.Checked && cb != null) {
{
modalconfirmbox.show();
int ID_No = Convert.ToInt32(GridView1.DataKeys[row.RowIndex].Value);
//code to delete where id =ID_No and bindgrid
} }
} }

This delete code is working and confirmation is appering. but you click yes or no or click none in modalconfirm  rows will be deleted.

View 1 Replies

DataSource Controls :: Summing A Column From Multiple Rows?

Jul 1, 2010

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.

for example

row 1 activityTotal = 4
row 2 activityTotal = 3
row 3 activityTotal = 1
totalValue = 8

How can I incorporate this into the code?

View 7 Replies

DataSource Controls :: Read Sequential Rows From A Table?

Mar 23, 2010

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.

View 3 Replies

Web Forms :: Delete Multiple Rows In Nested Gridview Control Using CheckBoxes

Jun 25, 2012

I have trying your solution [URL] .... in nested grid view. But it is not working with nested grid view. How to solve it.

Error "object reference not set to an instance of an object" ....

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved