DataSource Controls :: Deleting Top 500 Rows With Truncate Statement?

Jun 1, 2010

I have table with 1000 rows. is it possible to delete top 500 rows with truncate statement ??

View 2 Replies

Similar Messages:

DataSource Controls :: Use Transaction To Work With Truncate And Sqlbulkcopy?

Apr 30, 2010

I code to exec a store procedre (sp_truncate) to truncate 10tables and using sqlBulkCopy to download a huge data. Both them are working fine.Now I want to use transaction with application (not in store procedure) torollback truncate tables if download is failed.Is it possible to use transaction to work with these two steps?

View 1 Replies

DataSource Controls :: How To Truncate A String In A Database Table

Jun 14, 2010

I get an error when I try to update a row in an SQL database table with a string of fewer characters than were previously stored. I attempted to correct this problem by using the "PadRight" function in my C# webpage event handler to fill in the remaining characters with spaces, but I don't seem to be able to make that work. So, what do I do when I want to store fewer characters in a table row that has more characters previously stored in it?

View 2 Replies

Forms Data Controls :: Deleting Whole Rows Of Gridview?

Mar 29, 2011

how can i delete the whole rows of gridview using code behind c sharp like

Col1 Col2 Col3

a 1 5

a 2 6

a 3 7

a 4 8

and I want to delete the whole rows in the gridview so that it becomes

Col1 Col2 Col3

a 4 8

only last duplicate row left and all the rest is deleted (rows are deleted from all the columns of gridview)

View 4 Replies

Forms Data Controls :: Datagrid Deleting Random Rows?

Jul 14, 2010

I have an 2.0 web app and one of the pages uses a grid to add/edit items before exporting the contents to excel. The items in the grid are selected based on a dropdown list--after the item in the list is selected, the grid goes and gets the items, populates a dataset and binds the dataset to the gridview. Some of my users are experiencing an issue where after deleting a random number of rows, a row not deleted will disappear or reappear. Though I have witnessed the behavior, I cannot duplicate it on my machine where the developement occurs (Win XP Pro, IIS 5.1, vwd2005 express). The windows 2003 server uses ASP.Net 3.5

Here is the code related to editing and deleting:


If I had to make a guess as to what was occuring, I would say that it appears at times to retain the deleted item's index after the grid is sent back to the user and tries to delete another row. But like I said, I can't duplicate the problem on my dev machine. if this might be caused by .Net 3.5 trying to run a 2.0 site?

View 5 Replies

Forms Data Controls :: Deleting The Rows In Grid View At Runtime?

Mar 17, 2011

I have created a gridview which adds a remove button through item template. I wish to know how do u remove the row from grid view dynamically depending upon the button he clicks ?

protected void RemoveBtn_OnClick(object sender, EventArgs e)
Button clickedButton = sender as Button;
GridViewRow row = (GridViewRow)clickedButton.Parent.Parent;
int rowID = Convert.ToInt16(row.RowIndex);
<asp:GridView ID= "GridView1" runat="server" AutoGenerateColumns="true" OnRowDeleting="RowDeletingEvent">
<asp:TemplateField HeaderText="Remove Items">
<asp:Button id="RemoveBtn" runat="server" Text="Remove" OnClick="RemoveBtn_OnClick"/>

View 5 Replies

DataSource Controls :: How To Select Rows From A DataTable And Create A New ViewList With The Selected Rows Only, While ...

May 31, 2010

I have one big DataTable with X rows. I want to select Y rows from it and bind them to a new ViewList. While doing it, I want to delete these rows from the DataTable (Having X - Y rows).

What is the best and fast way to do it?

I don't know if it is better to create a new DataTable to have the Y and after that bind them to a ViewList or something else?

I'm also looking for example in code how to select/delete rows from DataTable.

View 1 Replies

DataSource Controls :: Top 10 Rows As Well As Count Of All Rows From Linq To Sql Query

Jun 17, 2010


In above query I want to have top 10 rows as well as count of all rows.

View 3 Replies

Adding And Deleting Rows Of A Html Table In C#

Jan 27, 2010

I am trying to achieve the multiple attachments. In order to do this, I am trying to add a new row to a html table. It must have 2 columns

1) The File Name which is a hyperlink

2) a button (html button preferably) on click of which I want to delete that particular row.

View 1 Replies

MVC :: Relation Integrity LINQ To SQL On Deleting Parent Rows?

Nov 9, 2010

I have a MVC project wich uses LINQ to SQL as a data layer.

For example, I have a tables ProductGroups and Products. Product is a child of ProductGroup, so to get name of ProductGroup, in aspx-page I use constuction like Model.ProductGroup.Name.

But when I delete a ProductGroup there is appear a NullReference Exception in presentation page.

While I was using just DataSet and manual SQL-queries, the rows, there was not every joined-element present, simple were not put in query result.

I know that before delete Parent row I have to delete all children rows, it's correct way.

1. Is there a way to ignore rows which has null-elements without manual checking through "IF"?

2. Is there simple way to delete all dependencies without manual enumerating every related tables?

View 7 Replies

DataSource Controls :: Entity Framework Deleting Many To Many Relationship?

Jul 9, 2010

I have 3 tables User, role and UserInRole THe entity frame work made entities for User and Role and I have successfully made a join with the user and role entities using user.add(role); but I can't seem to get it to remove the link (I want to retain the user and role just remove their association).

using (ProviderEntities context = new ProviderEntities())
User u = context.User
.Where(n => n.ApplicationName == application)
.Where(n => n.Username == username).First();
Roles r = context.Roles
.Where(n => n.ApplicationName == application)
.Where(n => n.RoleName == roleName)

The oposite worked when I did r.User.Add(u); but it wont let me now remove it after it been created. Driving me mad as I can't see where I have gone wrong.

View 1 Replies

DataSource Controls :: Deleting Row In Data Access Layer?

Jan 27, 2010

I can use similar code below to select a row in my database when I enter a value (username) in text box and it successfully retrieves.however, I'd also like to delete row from database based on the username i enter in text box. My code runs but no row is code is:


private AdminTableAdapter adminGetUsers;

View 5 Replies

Forms Data Controls :: Deleting In Detailview Without Using Datasource?

Mar 18, 2010

how to delete from detailview without using datasource?

And it also doesnt work using sql datasource .

View 3 Replies

DataSource Controls :: How To Define A Field Value For Deleting A Data Row

Mar 12, 2010

From my Employees table of the Northwind database, how do I delete a row? I have a row with a LastName field = WWWW How to write the string sql?

SqlConnection con = new
string sql =
"DELETE FROM Employees WHERE LastName =" + WWWW;
SqlCommand cmd =
SqlCommand(sql, con);

View 1 Replies

DataSource Controls :: Delete Gridview Records With Enable Deleting

Feb 19, 2010

I have bounded my GridView to an ObjectDataSource. I have set a delete method for this ObjectDataSource. Now how can I delete my GridView's records with enable Deleting?

View 4 Replies

DataSource Controls :: Deleting Data From The Multiple SQL Tables With LINQ (C#)?

Apr 22, 2010

I'm looking for ideas on deleting data from the multiple SQL tables with LINQ (C#).

My existing solution does the following:

1. DeleteAllOnSubmit( Subset of the data from the child table)

2. DeleteAllOnSubmit( Subset of the data from another child table)

3. DeleteAllOnSubmit( Data from the parent table)

4. CommitChanges()

All this resides within a single method, which makes it ugly and not re-usable.

I have considered the following alternatives, but I decided not to use them:

1. Cascade delete on the tables.

2. Do a join on all tables from which I will remove the data, but I'm not sure yet whether I could pass a join query to DeleteAllOnSubmit().

3. Write stored procedure(s) to delete data from each table. I don't have the time to implement this due to a large number of tables and the time constraints.

View 1 Replies

DataSource Controls :: Deleting All Child Record On The Base Of Primary Key And Foreign Key?

Apr 20, 2010

how can i retrieve the all foreign keys against a single primary key. i mean to say that if a table contain a primary key then it becomes as foreign keys in which tables.

i want to take that nam of that tables and on the base of that tables then i am to delete from all the entries. e.g: if a primary key's column entry deleted then all foreing key entries should also be deleted.

there are 988 tables in a single database. it can't be possible to go for each table to setup foreign key to ON DELETE CASCADE.

.can it have any way to delete against foreign key priority wise? mean to say that parent table contain primary key, child table contain foreign key , now there is another child table which dependent previous child table. then how can i delete all record against it?

i want to do it from programatically. i am using sql server 2005

i have completed this till to that , it retrieves all foreign keys but how to delete now on the base of priority.


View 1 Replies

Forms Data Controls :: Deleting From GridView Without Call Datasource's Delete Command

Jan 21, 2010

I'm using the membership on my website. On the User Administration page i've got a GridView to show the details of the users on the site. As a datasource rather than just using the Membership.GetAllUsers function i've got a SQLDataSource as i need to display user information from 3 different tables. I'm trying to add a delete button to the GridView. I'm setting the Membership's UserName as a DataKey and then using the RowDeleting event to call Membership.DeleteUser for the appropriate UserName. This works fine and the user is deleted however i then get an error showing up that "Deleting is not supported by data source 'SqlDataSource1' unless DeleteCommand is specified."

I don't want to use the SqlDataSource for deleting as i've already done it using the Membership. How can i stop it from trying to do this? Here is the cut-down that i have if you're interested. The selectcommand in the sqldatasource was auto-generated by it.


View 5 Replies

ADO.NET :: Add Rows To A Dataset In A Single Statement?

Sep 21, 2010

I got "DataRow[] rows " and I want to insert into "DataTable tb " not using loop.

Is there any single statement to insert/add all rows at a time.

View 1 Replies

DataSource Controls :: Meaning Of N In Statement?

Jan 28, 2010


what does the "N" mean or do in this statement?

View 4 Replies

DataSource Controls :: Foreach Like Statement In T-SQL?

Mar 10, 2010

how to do do some action recurting each row? My data looks like

[Column1] [Column2]
item 1 10
item 2 5

I would like to do something like..

foreach row in Column1 <-- how would I do this part??
While (row.Column2 > 0)
.. do something
row.Column2 = row.Column2-1

View 3 Replies

DataSource Controls :: Select Top Record From Sql Statement

Mar 17, 2010

If I run the following SQL script:


View 3 Replies

DataSource Controls :: SQL UPDATE Statement Not Updating DB?

Feb 24, 2010

I am writing a simple form that will take in data and insert it into a db if it's a new record and update the existing record if it already exists. The insert works fine, but the update isn't working at all, yet the code looks solid to me and everything I've compared it to in my google searches.


View 7 Replies

DataSource Controls :: How To Select Statement For Some Scenario

Apr 24, 2010

I want the select statement for the above scenario.

View 2 Replies

DataSource Controls :: Using A Variable As A Parameter In A SQL Statement

Mar 25, 2010

I've done some SSIS package work in the past, but am by no means an expert.

I want to use an SSIS package to do the following:

1. Get the file name of the newest file in a windows folder (using a filename template like his: filename_ *.txt where the * part is always a date in the format of yyyy-mm-dd.

2. Use that file name in later portions of the SSIS package by reading the file and transferring data from it to a SQL table using a Data Flow task.

and use the result (which should be the name of the newest file) to open that file and pull data out of it and into a 2nd SQL table. I admit, I'm not sure how to use the dynamic result of this SELECT query as the file name in a flat file connection manager.

View 6 Replies

Copyrights 2005-15, All rights reserved