i working on visual studio 2008 with my database in sql server 2005 i have created a chat online apps once the user is online he/she will chat and chat data will go in my message database which has this column
MessageID(pk)
RoomID
UserID
ToUserID
Text
after the chatter finish's chat he log's out and the messages send by the "UserID" or say chat data in message table of that USerID must be deleted so i want to delete muliple row from the database at once.
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.
I am currently Developing application in MVC2 I want to used mutiple form tags(<form>) in My application. In My View I have Created a table which has Delete option which i am doing through Post for Individual Delete so i have Create form tag for each button. as mention By Stephen Walther [URL] i also want user to give option to delete mutiple records so i am providing them with checkboxes.This form should have all the values of checkboxes and all. so form gets render Like this in browser
I am trying to display checkboxes in front of every row in list view. So that after selecting the desired checkboxes user clicks on delete button and we should delete that records.
I have the below code snippet i found, but when running the delete command I get an run-time error of: Index was out of range. Must be non-negative and less than the size of the collection.
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 a Listview which uses a StoredProcedure to display the data. That part works fine. What I'm trying to do is delete multiple lines using a different store procedure. So I did this code:
f i have one item in my dripDown list and i want to select it like to delete from the db. but the function didnt work because,it didnt change is "selected item", or if my drop downlist starts with somethins that i want to delete but i need to change the index first but i dont want to delete other items.
I have a form where users can subscribe and unsubcribe to my email list. so far, i have the subscribe button working fine "add member" function. Now i need help with my "delete member " function (unsubscribe button). it will allows the user to delete their record from the database. When I run the code and click the "unsubscribe" button, i can't get the logic correct so that it will delete the user's record if it exisit. here's the code i'm using for the subscribe and unsubscribe buttons
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class joinmailinglist : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void addMember(object sender, EventArgs e) { // here you are defining the classes for the database and the linq mailinglistClassDataContext Class = new mailinglistClassDataContext(); mailinglistMember member = new mailinglistMember(); // Now we are going to add the data to the member // Here we are going to let the system define a GUID for the unique user ID member.memberID = new Guid(); // here we are going to capture the user inputs and we are going to set these to lower case especially the email so that we can do a proper comparison later. member.fname = txtFirstName.Text; member.lname = txtLastName.Text; member.email = txtEmail.Text; // Here we are going to create the URL so we can later remove the user if they decide to opt out. member.removeurl = "http://removeuser.aspx?code=" + member.memberID.ToString(); // Here we are going to use a LINQ query to search the class of mailinglistmembers for any emails that contain equal values of the text field and select it. var duplicatecheck = from emails in Class.mailinglistMembers where emails.email.Contains(txtEmail.Text) select emails...............................
I am select one mdb database from open dialog box.All records in the database (all table data value)will automatically delete. How to implement this concept.
IDE: MS Visual Studio 2008 / SQL Server 2005 Express / SQL Server Management Studio Express 2005 Skills: BeginnerI was trying to delete a table from my database ASPNETDB.MDF ,that DB was previously used for User login information i made it by using asp.net built in login support by opening ASP.NET configuration ,but now i want to built my own simple login control...so i want to remove all the tables made by ASP.NET configuration.I got this error when deleting one of the table"Could not drop object 'dbo.aspnet_Applications' because it is referenced by a FORIEGN KEY constraint"
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
I have 3 pages, one to add a category, one to edit the category, and one to delete the category. The add and edit work fine. The delete is not working for some reason. I click the link on my site to delete it, and I'm just staring at the green bar in my browser taking a long time. The add and edit don't take long at all to perform their function. I'm thinking this is a connection string issue, but I don't see how it can be the case. It relies on web.config for it just like the other pages. Following is the delete page code behind and also delete cascade from the business logic area. After the page refreshes, I'm not getting any diagnostics or error messages which I have in the code. Doesn't this have to mean a db connection issue?
