I have a page that is used to delete multiple records....i tried attaching a confirm extender
to the delete button....but it the problem is when i click Ok on the confirm button UI...it deletes
only one record even if i have selected multiple records for deletion
I am using gridview,in that gridview i provide a link button as delete,if the user click the delete button,it will deleted properly no problem in my code,before delete i want to show an dialog box like, are you want to delete the employee details,,how can i do this in my code..
Protected Sub GridView1_RowCommand(ByVal sender As Object, ByVal e As GridViewCommandEventArgs) Handles GridView1.RowCommand
If (e.CommandName = "DELETE_Employeeid") Then
'Delete button is clicked
Dim empid = e.CommandArgument.ToString()
[Code] ....
I have button, which fires an event, that deletes a record from the database. This is the source of the button:
<asp:Button ID="btnDelete" runat="server" Text="Delete" onclick="btnDelete_Click" />
But how can I make a confirm box appear before the deletion?
I have a gridview that shows all data from a table. DataNames includes KeyId, which is a Primary Key.Yet when I try to delete a record, nothing happens, the page appears to performa refresh but the record is still there.Edit does not work either. I used the wizard to build all of the queries, they look okay. But I cannot figure out why they are not working.
[Code]....
m using gridview to display records from sql server2005. In gridview, I have a field containing checkboxes. Now what i want that the fields against which a user checked in checkboxes that will be deleted by clicking on delete button just like the emails yahoo, gmail etc How can i do so?
View 2 RepliesI have created a ListView with a SQL DataSource. It has Item Template, Alternate Item Template, Insert Item Template, Layout Template, Edit Item Template & Select Item Template. There are delete buttons in the Item Template, Alternate Item Template and Select Item Template. The Delete command is
DeleteCommand="DELETE FROM [ClientNoteType_Lookup] WHERE [ClientNoteTypeCode] = @ClientNoteTypeCode"
which seems correct. I have not selected Use Optimistic Consurrency when I configured the data source. When I click on the Delete button, it deletes the selected record and the record after. THe ClienNoteTypeCode is a varchar(4) field and all codes are unique. It deletes both records in SQL Server when the button is clicked, but one one is deleted on the web page until I refresh the page and then both are deleted.
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 RepliesI have an inventory page with a gridview that shows 1 item per record, each item starts with a checkbox in the gridview. Currently users can select multiple records and hit the order button and everything has worked well. Now I have multiple pages in my gridview, and if a user selects a few records from the first page, and then goes to the second page, all the records (checked checkboxes) disappear from the first page.
[Code]....
I am trying to design my logic to do this but I want to create a dataSet which will have records from several databases, The records all have the same layout.
I am reagin the connection string paths from a table in a database.
I am asking for your help in trying figure out my logic.
Should I use the connectionString builder in conjunction with a loop to Connect, read a record into a dataset Until therer are no more records to be read from my databse table with the database name/paths tables ?
Here is my beginning code which deals with one database:
[Code]....
I have two tables with a foreign key constraint how can I delete rows from both of them in one transaction? linq to SQL seems to call my deletes in the wrong order. Is there somewhere I can check and make sure the constraint is recognized properly by linq to SQL??
DataContext.OtherImages.DeleteOnSubmit(myOtherImage);
DataContext.Images.DeleteOnSubmit(myImage);
DataContext.SubmitChanges();
The Foreign key constraint is on OtherImages.
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.
I have a repeater which binds a set of data. Within this repeater is a column with various controls for updating, deleting, etc. These are image buttons which fire an onclick event such as "DeleteRecord". All this does is fire a stored procedure, passing in the ID of the record to delete from the CommandArgument of the object.
This works wonderfully... except for one rather huge problem. Once you delete a record, if you refresh the page, the record where the first deleted record used to be gets deleted. For instance... if I have 4 records
1 Record1
2 Record2
3 Record3
4 Record4
and I delete record 2... The page reloads with (which is fine):
1 Record1
3 Record3
4 Record4
...if I then hit refresh...
1 Record1
4 Record4
I assume this is because the erroneously deleted object (record3) is now in the same hierarchical place as the old object used to be and .net therefore doesn't know the difference, the page refreshes and fires the onlick event, grabbing out the command argument of the new object and deletes based on the ID as obtained from the commandargument of the new object. This is obviously a huge problem, if a client did this it would destroy data erroneously and I'm at a loss here. Is there any way to stop this from happening? I'm not sure if there is a better way to go about doing things or not. If there isn't, I need some sort of way to tell the page not to execute the event or to cross reference the ID of the object that is intended for deletion against the object itself...
Code below for convenience...
EDIT Wrapped a LinkButton around it because I have some jquery code in here as well which stops the page execution to wait for user confirmation. Pressing "ok" continues page execution.
<asp:LinkButton ID="oDeleteLink" CssClass="oDeleteIcon" CommandName="Delete" CommandArgument='<%# Eval("iAccountID") %>' runat="server">
<asp:ImageButton ImageUrl="/files/system/icons/trash-steel-16.png" ToolTip="Delete This Account" AlternateText="Delete" ID="oDeleteIcon" runat="server" />
</asp:LinkButton>
protected void oAccounts_ItemCommand(Object Sender, RepeaterCommandEventArgs e) {
if (e.CommandName == "Delete") {
int ID = e.CommandArgument.ToString().Numeric();
db.SPs.SpDeleteAccount(ID).Execute();
UI.Confirm(uiBroadcast, "Account has been deleted", "300px");
BindAccounts();
}
}
I have a DataGrid that I need to be able to use to delete records form a file
[Code]....
[Code]....
I use
((TextBox)GridMenuOptions.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
To access the data in the Grid for updating, but it doesn't work for deleting
I can use
string id = GridMenuOptions.DataKeys[e.RowIndex].Value.ToString();
but that only returns the first key.
How do I access the rest of the keys?
I have a table with 5 columns: ID, Session1, Session2, Session3, Session4. What I want to do is to display the number of same items from each column. Same item can't appear in more than one column.
ID Session1 Session2 Session3 Session4
-- -------- -------- -------- --------
1 Music Web Tech Future
2 Art Articles Search Introduction
3 Music Books Camera Phone
4 Music Glass Cup Future
5 Art Books Tech Future
6 Music Glass Cup Phone
I want to display it like this on an asp.net page.
Music: 4
Art: 2
Web: 1
Articles: 1
Books: 2
Glass: 2
Tech: 2
Search: 1
Camera: 1
Cup: 2
Future: 3
introduction: 1
Phone: 2
how would I construct a sql query and display them on asp.net?
Here is my situation: I use the SqlCommond to update some records in the SQL Server in a ASP.NET web site. Users can choose which records they want to update. Sometimes they may choose 40 or 60 records to update at a time.Is there any good way to do it? I do not want to do like it
foreach(string ID in List)
{
Update here
}
I am trying to insert about 100,000 in my SQL Server database. It is really slow when I create 100,000 separate queries, so I tried to insert all these records in one query, it worked for the first few thousands records but then it threw me a timeout error.
What would be the fastest way to insert multiple records into database?
i use mvc 1.0 since my host supports that.i have a piece of code in my view like this and i want to change it in order to be able to show records in 4 columns.
What should i do?
<table>
<% foreach (var item in Model) { %>
<tr>
<td>
<%=Html.ActionLink(item.CategoryName + "(" + item.NumberOfWebsitesInCategory + ")", "SubCategory", new { CatID = item.CategoryID }, new {style="text-decoration:none;" })%>
</td>
</tr>
<% } %>
</table>
Im getting multiple records displayed and they arent descending in order correctly when I insert on button click.
The text is added to the database and it is displayed but I get two sets of records displayed on the page and the text from the insert is pushed down to the bottom of the first multiple record.
How can I correct this so I only get one return on the page and the comment(text from db) is set to desc.
Code:
protected void Page_Load(object sender, EventArgs e)
{
string theUserId = Session["UserID"].ToString();
PopulateWallPosts(theUserId);
}
[Code]....
I am having 3 textboxes where I am inserting 3 employee names.I want to insert these details into database as 3 different records.Pls respond me ASAP
View 7 RepliesI have the following a Master Table that has some Id and a child table with multiple records for that Id, i created a Main rdlc report in asp.net and a sub report, i am having trouble on displaying the sub report as multiple times (i.e. for reach record in the child table for a particular Main Id there should be a sub report with the information related to the child tabke), i was able to display it repeated but it repeated the first record of the child table.
View 1 RepliesI am trying to delete multiple records from an access databse with ASP.NET VB but I'm doing something very wrong .....
Here is my code ...
[Code]....
I would also like to know once I get this working how I would delete, additional tables linked to this table by another field not ID ??
I have to get the multiple records from the gridview and store it in the session. Can any one send the coding for this?
View 5 RepliesI am in the way to make an SQL server saving transactions. How to make MultipleSaveNewReadings function to perform the best performance for an SQL server saving call without closing/opening connection for each record saving? I don't need to merge the for-next loop into the saving function code but it's ok to get out some of the saving code to be in the for-next calling function.
[Code]....
We have to select a record based on which we have to open a new page which will display the details of the selected record.
Now issue lies in the second part, which is:
User can select multiple records and new page open should display details for both the selected reocrds one after other.
That is, first details of first selcted record will be displayed and right after that details of second selected record should be displayed.
I m working on one page. It has three table for select, Insert and Update.
I wrote the join query for select statement. also i wrote the three Insert and Update statement.
i have some fields on one page which fields suppose to insert in one table. How can i Insert the multiple records into one table from one page using only one save button.