Forms Data Controls :: Deleting / Updating Record From SQL Database Via GridView
May 11, 2010
I've been googling for 2 days for the solution, but I couldn't find something useful. The problem is that I have GridView that is connected to the SQL database and that is how it is being populated. I added EDIT and DELETE buttons in the columns, but as far as I can see the event which handles them is empty.
I have a gridview in which update and delete is enabled.
I have the following fields in database table, which is binded to the grid view through sql datasource.
ID,Firstname,Lastname,Add,City,modifieddate. Here ID is primary key.
1. When edit and delete is enabled in the grid. The ID column is showing in the grid,which i don't want to show. But without that ID column the grid is not able to update and delete. Plz tel me how to update and delete without ID column in grid.
2. When ever any update is happen in the grid, the modifieddate should get updated. Here the date is not datetime.now , i need to use my own system date and time. Coz my server and system time has some difference.
I have use the following javascript to get system date and time, which is working fine. This date should be get and update in the modified column.
function displayTime() { var m_names = new Array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"); var localTime = new Date(); var year = localTime.getYear(); var month = localTime.getMonth() + 1; var date = localTime.getDate(); var hours = localTime.getHours(); var minutes = localTime.getMinutes(); var seconds = localTime.getSeconds(); var div = document.getElementById("TextBox1"); div.innerText = date + "-" + m_names[month] + "-" + year; }
I have a gridview and a SQLDataSource control. In my gridview I have 2 commandfields "Edit" and "Delete"
The "Edit" command field works as expected. Using the "Delete" command field I get the error below.
Server Error in '/DataControls' Application.
The DELETE statement conflicted with the REFERENCE constraint "FK__titleauth__au_id__0CBAE877". The conflict occurred in database "pubs", table "dbo.titleauthor", column 'au_id'. The statement has been terminated.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK__titleauth__au_id__0CBAE877". The conflict occurred in database "pubs", table "dbo.titleauthor", column 'au_id'. The statement has been terminated.
I am using a Gridview inside an UpdatePanel. I am using the RowCommand method to call my code to delete the record. The gridview is bound to a <list> collection. I am unable to get the Gridview to postback / refresh after the users deletes a record; however, if I refresh the page in the browser and the page loads, it obviously is gone. I have searched quite a bit on this where others are having problems but nothing they did work for me, so I was hoping someone could review my code and let me know what I am doing wrong.
Here is my ASPX:
[Code]....
Here is my C#
[Code]....
When I step through the code, the postback happens and then my delete code is called, so once the delete code happens, the page is already finished loading, which seems to be my problem.
Using vb.net/asp.net 2005.I have an inner gridview.The outer gridview is "Authors" and in the inner gridview (GridView1 below) I have to set it up so that the user cannot delete the last book from the inner grid, if they try to delete the last book from that inner grid then I want to show the exception message below.
So I am checking the GridViewRows1.Rows.Count which works great when I have one record (one book) to start with. The problem is when I have 2 books (for example). I am writing out the test statement below and the RowCount is always 2 each time, never decremented, even after I rebind.Editing this now: i realize that my initial logic is faulty because when I rebind my inner gridview I am not specifying which inner gridview so the result is that only the last inner gridview is being re-bound, so I think that I need to get the selected inner gridview and then refresh that...
I am having trouble changing page numbers on my gridview after deleting a record if the deletion of the record causes there to be no more records on that page. Currently I have a form below the gridview that adds a record to the datasource of the gridview.
[Code]....
Code behind stuff:
[Code]....
Now with this code above, if I insert a new record using the form below the gridview, it will reload and go to the new page if the insertion causes the record to appear on a new page, however when I delete that record, thus causing nothing to be on that page, the gridview visually just dissappears. I've got the gridview bound by a linqdatasource control, and on the page_load function I only databind if the page is not a postback.
Protected Sub movebtn_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles movebtn.Click Dim con As New SqlConnection con.ConnectionString = ConfigurationManager.ConnectionStrings("26ConnectionString").ConnectionString con.Open() If persno.Text = "" Then Page.ClientScript.RegisterStartupScript(Me.GetType, "Forms", "<script> alert('Enter Pers No of Offr ..........') </script>")
[Code] ....
I want to add a confirmation before deleting the data and popup message box...
when i checked the checkboxes(not all) ,corresponding rows data has to be updating when i click save button which is outside of gridview,Its just same like our gmail delete button.
I have an app where i have a GridView connected to a DropdownList....The selectedIndexChange determines what the gridview shows. Then have coded in the row editing event the ability to change the information in the row. MY ISSUE- cant take the new information changed in the row and update it in the database. I have a row updating event that im trying to figure out how to attach it to my stored proc and the newly edited row
I have seen a project where my friend has used a sqlhelper.dll which make it easy to write code for inserting,Deleting and updating data.
ex:
ds=sqlhelper.ExecuteDataset(con,[StoredProcedure],parameter1,parameter2,...,parametern) Or sqlhelper.ExecuteNonQuery(con,[StoredProcedure],parameter1,parameter2,...,parametern)
I want to insert a new record into the database through gridview.New butoon in not inside the gridview it a diifrebt button.when we click new then it show a new row which is blank. another button is save when we click save it will save the data into database
I'm just wondering if anyone has come across a good, easy method for updating a SQL Server 2000 DB table using the edit feature in GridView. The catch here is that I need it to encrypt, send to database, then decrypt when the page calls it to be displayed. I have successfully implemented an insert method using FormView with encryption. For some reason, I just can't seem to figure out the edit/update.
I have created a simple application to edit data in an access database using gridview but its not working , the results are shown correctly , but when i click update nothing happens..
I am trying to update record via stored procedure, but i got error at very start point. Problem is when i click on Edit link button within the Gridview it produce error.
I can populate values from database fine but its produce error when i click on edit link button. see the code below.
I had another post about this issue, but decided to modify it to drill down and find the issue. I was doing a master/details, and that was not working, so I have changed it to just a single data source with a single details view created entirely via wizards. The issue is, when I click on the auto generated edit link, and change values in the fields, after clicking update the page refreshes without error but does not update the record. Here is the code:
I have another problem is that I have Placed a file upload control in Empty template of Gridview to have multiple record insert. I have used viewstate to save multiple record into database. But problem is that I am able to find the control but it not giving any value.I have following code.
I've got a gridview with three fields, the last of which is a template field with an imagebutton in.
The first field is a Date, and the second is a time field (it is however just varchar field as it may differ and will not be programmatically used).
I want the following to happen if I click on the imagebutton (reserve):
Four other fields must be inserted into the record.
Is the best way to launch a detailsview where the row.imagebutton@=ID and just edit the fields like that or should I pass the two fields (and RecordID) along with the query string to a new page where the passed information can be in invisble textbowes and just have the user enter (UPDATE) the four outstanding fields? I feel like doing it this way?
can read on 1. setting up the onrowcommand code for the templatefield 2.
This should be simple as it is only one table with records that has to be partially inserted by an admin person (2 Fields) and then completed by a web user (4 fields).
I'm new to asp.net 3.5 and I have been working through the tutorials using a real access database to learn how to use the new controls. I have an extremely simplistic page setup with a master-details view, the master using the gridview, and the detail using the detailsview controls. Everything seemingly functions correctly, except when I try to update the data in the details view. I make changes to the record, click update and the page posts back but nothing is updated in the database. No errors are given either.
I am making a message module in asp.net with database of sql. i have made a gridview and enabled selecting. and a form view is synchorised with grid view on selecting. i am writing update sql but could not get a way to take data on Gridview or Formview to compare the record in sql database.