Data Controls :: GridView Delete Query Executed Successfully Without Errors But Row Not Deleted

May 7, 2015

In a grid view me bind the data .if i click the update it throw the error like this

Server Error in '/bramandam site' Application.

Object reference not set to an instance of an object.

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.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

Line 81: TextBox tfn = (TextBox)dv.FindControl("tsn");
Line 82: Label lb = ((Label)dv.FindControl("Label4"));
Line 83: string qry = "update section set sectionid='" + tbf.Text;
Line 84: qry += "',sectionname='" + tfn.Text;
Line 85: qry += "' where pk='" + lb.Text;

Source File: d:jquery themesramandam siteSection.aspx.cs Line: 83

Stack Trace:

[NullReferenceException: Object reference not set to an instance of an object.]
Section.GridView1_RowUpdating(Object sender, GridViewUpdateEventArgs e) in d:jquery themesramandam siteSection.aspx.cs:83
System.Web.UI.WebControls.GridView.OnRowUpdating(GridViewUpdateEventArgs e) +133
System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row, Int32 rowIndex, Boolean causesValidation) +720

[Code] .....

Version Information: Microsoft .NET Framework Version:2.0.50727.4984; ASP.NET Version:2.0.50727.4971
if i click the update i need to throw the error edit and update the content 

my gridview is 

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="sectionid" onrowdeleting="GridView1_RowDeleting" onrowcommand="GridView1_RowCommand" onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating" BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Horizontal">
<RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />

[Code] ....

View 1 Replies

Similar Messages:

DataSource Controls :: Whole Gridview Was Deleted When Trying To Delete Only 1 Row?

Jan 10, 2011

I am trying to delete a row of records in a gridview. The selectMethod works perfectly fine, but the DeleteMethod doesn't. When I delete a row, only 1 row of records should be deleted, but the whole gridview was deleted! (I have about 3 -5 rows of data). I am using ObjectDataSource.

Data Access Layer


Business Logic Layer


Presentation Layer



Presentation Layer

Code Behind:


View 6 Replies

Forms Data Controls :: Delete The Third Row - The First Row Is Getting Deleted

Mar 11, 2010

when im deleting rows in a grid view only the first row getting deleted i mean if i want to delete the third row the first row is getting deleted instead of third i dnt know y below is my code


View 3 Replies

DataSource Controls :: Data Not Get Inserted Even Insert Query Execute Successfully?

Mar 31, 2010

i made one window base application in VS2008 ( i made one simple code where i can insert data.and after inserting i can see that data on grid.when i am inserting data insert query runs perfect.after that for debugging purpose i fire select query and get result in dataset and its show data too.but when go
into database my inserted data not showing there.

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim con_str As String = "Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database1.mdf;Integrated Security=True;User Instance=True"
Dim con As SqlConnection = New SqlConnection(con_str)
Dim cmd, cmd2 As SqlCommand
Dim adp As New SqlDataAdapter.....

View 2 Replies

Forms Data Controls :: Enable Delete Column At Gridview When Having Specify Query?

Sep 15, 2010

have trouble to add delete column to gridview when using specific query.I have PK set up at the table, I need add specific query to display dataat gridview:

SELECT [PID], [GID], [TID], [SID], [NEWSID] FROM [TableOne] WHERE ([NAME] = ?)

After builder this query, I click advanced button. However, generate insert, update, and delete Statements is not enabled.

View 19 Replies

.NET MVC With SQL Server Backend Returns Old Data When Query Is Executed?

Jun 12, 2010

My ASP.NET MVC web app has a weird issue. In VS debugging mode it works as expected, but when I publish it to dedicated web server (windows 2003, IIS6) a sql query returns previous data even though underlying data was already updated through the same connection. It looks like as if a query returns cached data. What might be the problem?

View 2 Replies

C# - Sql Inline Query - Parameter Is Not Read When The Query Is Executed

Apr 23, 2010

I am having a problem with my sql query in c#, basically it's inline query with parameters, but when I run it it tells me that parameter 1 or parameter 2 is not there here is my query declared on top of the page as public:

public const string InsertStmtUsersTable = "insert into Users (username, password, email, userTypeID, memberID, CM7Register) " +
"Values(@username, @password, @email, @userTypeID, @memberID,@CM7Register ); select @@identity";

this is my code for assigning the parameters, I know I am having problem so I am assigning the params twice:

Username =(cmd.Parameters["@username"].Value = row["username"].ToString()) as string;
cmd.Parameters["@username"].Value = row["username"].ToString();

In 1 methopd it calls this query and tries to insert to table, here is the code:

Result = Convert.ToInt32(SqlHelper.ExecuteScalar(con, CommandType.Text,InsertStmtUsersTable));

Exact error message is: Must declare the variable '@username'. Could this code be a problem, because all the previous coding is declared with in this using statement, except declaration of query, here the using statement: using (SqlCommand cmd = new SqlCommand(InsertStmtUsersTable, con))

View 1 Replies

Forms Data Controls :: Detecting When The Last Row In A GridView Has Been Deleted?

Dec 6, 2010

I have a GridView. One of its columns contains monetary amounts. Underneath the GridView, I have a SqlDataSource which calculates the sum of this column and displays it in a label which is in a DIV called totalsbox (that I have added runat="server" to).

Obviously, if the GridView is empty, I don't want this label to be visible.

In the Page_Load, I have placed the following code:



This works fine. When the Page first loads, if the GridView is empty, the entire DIV is hidden; if not, the DIV is visible and the label displays the column SUM. imagine now the GridView DOES have rows, the DIV is visible and the total is displayed properly in the DIV ("10.00", say).

I have a RowDeleted event handler in the code behind which contains exactly the same code as I put in the Page_Load. As I delete rows, one by one, the sum is recalculated and displayed properly. But, when I delete the final row, I would expect this code to hide the DIV as the GridView is now empty.

This doesn't happen, however, the DIV remains visible and I have, in the label, something like " ".

Why is it that the code works in the Page_Load but not in the RowDeleted event handler?

View 6 Replies

Forms Data Controls :: How To Refresh The Gridview When Record Is Just Deleted

Jan 23, 2010

I have a gridview and which contain checkbox field too.If the checkbox is clicked and then delete button click, relevent record is deleted.This delete function is working properly.

problem Even though record is deleted,it does not affected in gridview.Deleted record is still remaining in the gridview.What will be the way that should I follow solve this problem?


View 3 Replies

Forms Data Controls :: Determine DataKey For The Row To Be Deleted In GridView?

Jun 14, 2010

I have wired an event to handle delete command for my GridView. But I cannot determine which the record's unique key, in my case stored in DOCIDNO field. All I get is a row index, such as 0, 1, 2 which obviously cannot be used to accurately delete a record from database.



View 2 Replies

Data Controls :: Highlight GridView Row To Be Deleted When Confirmation Box Is Displayed

Dec 30, 2013

I am trying to delete a row in the GridView with an ImageButton Link. By clicking the button, the GridView row is set with a backColor = "Red" and with delete confirmation window. On Cancel, the background color is removed, but When I confirm the deletion, the row is not deleted. I use the following code:

<asp:TemplateField HeaderText="Delete?">
<asp:ImageButton ID="deleteImageLink" runat="Server" ImageUrl="~/images/Delete.gif" CommandName="Delete">


The bellow code deletes the row, but the without setting the background color on the row prior

deletion: ImageButton deleteButton = (ImageButton)e.Row.FindControl("deleteImageLink");
deleteButton.OnClientClick = "if (confirm('Are you sure you want to delete this user account?') == false) return false;";

View 1 Replies

Determine If A Certain Query Had Been Successfully Processed?

Jan 3, 2010

I have a page (i.e. page1.aspx) that a user will select from the record and it will press on the delete button. And it will redirect on another page (i.e. page2.aspx). On page2.aspx, I wrote my query for example

DELETE FROM items WHERE item_id=2 how may I know if the query was successfully processed because I have to redirect again on the first page.

View 4 Replies

Forms Data Controls :: Gridview, All Enter(Chr13) And Whitespace Deleted?

Feb 10, 2010

a)i have an gridview, i need to every record show in every rows, but it's show in both column and rows...., how fix this?i use only itemTemplate in this gridview!

b)how i link a field thats show in gridview and pass to a new page(with query string) for show single record....?

(this is like "read more..." link in many news site!!!)

c)in my db is a 'ntext' field,but when that show in Gridview,all enter(Chr13) and whitespace deleted, how fix this?

View 5 Replies

Data Controls :: How To Save GridView Deleted Rows To Separate Table

Nov 11, 2013

I have made a call logging application in which i have authorised a normal user to edit update and delete from the gridview.But i want to give the admin person rights to see all the complaints deleted updated edited..i have thought a lot but all in vain havent found.

View 1 Replies

Forms Data Controls :: Delete Confirmation Box In Gridview With Edit And Delete Buttons?

Nov 18, 2010

How do I reference the delete button to add the delete confirmation box when I have both the Edit and Delete buttons as the last two columns in the Gridview control. The following code works fine without any issues when I have the delete button only:

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
if (e.Row.RowType != DataControlRowType.DataRow) return;
int lastCellIndex = e.Row.Cells.Count - 1;
Button db = (Button)e.Row.Cells[lastCellIndex].Controls[0];
db.OnClientClick = "if (!window.confirm('Are you sure you want to delete this record?')) return false;";

But, when I have both the Edit and the Delete buttons, I get the following error when I click the edit button while the delete button works fine.

Specified argument was out of the range of valid values. Parameter name: index

How do I reference the delete button so the edit button is not affected in this case?

View 4 Replies

Forms Data Controls :: Delete Images From Folder Using Gridview Delete Link?

Feb 3, 2010

Using "Enable Delete" from Gridview control, I can delete (besides, update, sort, paging, etc) data from the database (this is done automatically). However, how can I delete the actual image that resides in my image folder (i.e. from "pix" folder )? What is the best way to delete image? If using code behind, how? Please write a full code for me. Here is my source code.

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="photoID"

View 12 Replies

Forms Data Controls :: How To Insert Delete Confirmation Dialog To Gridview Delete Button

Apr 6, 2010

I am using Sharepoint Designer and trying to insert a Delete button into a gridview. I added this to the top of my ASPX:

<%@ Register Tagprefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls"
Assembly="Microsoft.SharePoint, Version=, Culture=neutral,
PublicKeyToken=71e9bce111e9429c" %>

and I added this as a Gridview column:


and this is the error I get:

An error occurred during the processing of . System.Web.UI.WebControls.DataControlFieldCollection must have items of type 'System.Web.UI.WebControls.DataControlField'. 'SharePoint:DeleteItemButton' is of type 'Microsoft.SharePoint.WebControls.DeleteItemButton'.

View 4 Replies

Databases :: Query Not Being Executed?

Jan 29, 2010

I need to insert values from the frontend into a mysql table. I am using a 3 layer architecture. the below is the code that is written in my dataaccess layer. the query is not being executed.

public int Insert(List<EmployeeUInfo> objInsert)
DataTable dtInsertRow = new DataTable();


View 1 Replies

Forms Data Controls :: How To Refresh The Dropdown List In The Details View After The Gridview Item Has Been Deleted

Nov 16, 2010

I have a dropdown list within a details view that allows me to set 1 or many categories to a perticular record(in this case a photo). The select command in this case only displays those catetegories that are not already attached to the selected photo.

all works well and as you select a category and add it to the database the category is removed from the dropdown list and is added to a gridview which shows all categories that photo is stored with.

My Problem is that when i delete the category from the gridview the dropdown list does not delete with said deleted item unless i do a "click in URL bar and press enter" to totally refresh the page.....

how to refresh the dropdown list in the details view after the gridview item has been deleted?


View 5 Replies

Delete From Database Without Postback - Animate The Disappearing Deleted Item

Aug 25, 2010

I have a site that show infomation that are contained in div blocks. The info is taken from a database so the user can change the info or delete it. When the user deletes a div block i want to use jQuery to animate that its disappearing and also that its deleted from the database. How can i do this without doing a postback, i dont want the site to reload, i just want the Div block to disappear visually and be gone from the database at the same time. Would i use Ajax update panel to achieve this ?

View 3 Replies

Forms Data Controls :: Sequential Delete Statements In A TableAdapter Ad Hoc Query

Mar 24, 2010

VS 2008 ASP.NET 3.5 app connecting to an MS SQL 2005 backend. The app contains a strongly typed dataset with a number of TableAdapters. I'm trying to add a query to one of the TableAdapters that deletes from table A, then related entries from table B, then related entries in the master table - table C. The query looks like this:


When I try to run that query to test it out, an error dialog box pops up that says "Unable to parse query text" followed by a second error dialog box that says "Must declare scalar variable @ID". Will the TableAdapters not run sequential Delete statements like this or did I do something wrong?

**Side note: A cascading Delete foriegn key relationship would be ideal, and was configured on the development database, but the DBAs messed up when replicating the database on the production server and getting them to fix something like this can be a difficult process.

View 2 Replies

Web Forms :: How To Read That OnClick Is Executed On The Server And OnClientClick Is Executed On The Client

Dec 4, 2010

I've read that OnClick is executed on the server and onClientClick is executed on the client. Is it better to use OnClientClick to do something like close a modal popup?

If my understanding is correct then this would avoid a trip to the server to accomplish the same task. This would be great for something that doesn't need to make a round trip to the server and back.

View 1 Replies

Forms Data Controls :: Creating A 'row-added Successfully' Message?

Apr 27, 2010

My code is below. I can add messages for row deleted and row updated fine, but the e.exception doesn't exist for row-created. My add-row 'success' message doesn't work properly because it doesn't allow the other messages to then overwrite the label.text for some reason.


View 2 Replies

C# - Find Node By Title And Delete It, But Always Is Deleted First Node?

Mar 31, 2011

<?xml version="1.0" encoding="utf-8"?>
<siteMap xmlns="">
<siteMapNode url="~/" title="Úvodní stránka">
<siteMapNode url="Pocitace" title="Počítače" />
<siteMapNode url="Elektronika" title="Elektronika" />

View 2 Replies

Forms Data Controls :: Can't Successfully Apply Microsoft Article ID: 981777 To Project

May 22, 2010

I'm using a file "image.aspx" (with code-behind file "image.aspx.vb") to retrieve an image stored in SQL and display it in my file "main.aspx". But it is not working (I get an image error display/red "x" icon instead of the image). (All other non-binary data is retrieved/displayed fine; no "designer" file is generated/used in this project). Can anyone tell why the image is not displaying? Below is the relevant script ("Avatar" = column in SQL table containing the image file):

1. from "image.aspx" page ("template.master"---not shown here--contains form1 referenced further below):


2. from "image.aspx.vb" page:


3. from inside the script tags in the "main.aspx" page:


View 1 Replies

Copyrights 2005-15, All rights reserved