Forms Data Controls :: GridView1.RowDeleting Event Occurring For All Command Fields (Edit & Select)

May 11, 2010

I'm creating a confirm delete like popup with an iframe to use along with a gridview. When you click delete on a gridview row, the iframe shows up and asks if you would like to delete the associated image as well from the server. It works perfectly the first time I delete a row. After that whenever I click select or edit on a new row, it calls the rowdeleting event from the last deleted entry every time. I'm stumped.Here's the Sub:

'// Event that Occurs when the Delete Button is Clicked //'
Protected Sub Confirm_Delete(ByVal sender As Object, ByVal e As GridViewDeleteEventArgs) Handles GridView1.RowDeleting
Dim file_name As Array = Split(GridView1.Rows.Item(e.rowIndex).Cells.Item(10).Text, "/")
If file_name.getLength(0) = 1 Then
file_name = Split(GridView1.Rows.Item(e.rowIndex).Cells.Item(10).Text, "")
End If
Dim fn As String = file_name(file_name.getLength(0) -1)
fn = replace(fn, ",", "%2C")
fn = replace(fn, " ", "%20")
Dim url As String = Me.Master.get_root_url & "CrimeBulletinProject/ConfirmDelete.asp?img_list=" & fn & "~!"
confirm_delete_frame.Attributes.Add("src", url)
confirm_delete_frame.Attributes.Add("style", "display: block; left: 50%")
End Sub

Here's the GridView:

<!-- // Main Data Table Section // -->
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" BackColor="Black" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataKeyNames="ID" DataSourceID="ArrestsDB" CellSpacing
= "1" GridLines="None" CssClass = "GV_Row" >
<PagerSettings Mode="NumericFirstLast" Position="TopAndBottom" />
<RowStyle CssClass = "GV_RowStyle" />
<Columns>
<asp:CommandField ButtonType="Button" ShowDeleteButton="True" CausesValidation = "True"
ShowEditButton="True" ShowSelectButton="True" HeaderText="Options" />
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False"
ReadOnly="True" SortExpression="ID" />
<asp:TemplateField HeaderText="Photo">
<ItemTemplate>
<img class = "GridViewImg" onclick = "popup_EnlargePhoto_EditForms(this.id)" id = "<%# DataBinder.Eval(Container.DataItem, "FileNumber") %>, <%# DataBinder.Eval(Container.DataItem, "LastName") %>, <%# DataBinder.Eval(Container.DataItem, "FirstName") %>"
alt = "<%# DataBinder.Eval(Container.DataItem, "LastName") %>, <%# DataBinder.Eval(Container.DataItem, "FirstName") %>" src = "<%# DataBinder.Eval(Container.DataItem, "PhotoLink") %>"></img>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="FileNumber" HeaderText="File #"
SortExpression="FileNumber" />
<asp:BoundField DataField="LastName" HeaderText="Last Name"
SortExpression="LastName" />
<asp:BoundField DataField="FirstName" HeaderText="First Name"
SortExpression="FirstName" />
<asp:BoundField DataField="MiddleName" HeaderText="Middle Name"
SortExpression="MiddleName" />
<asp:BoundField HeaderText="DOB (mm/dd/yyyy)" SortExpression = "DOB" DataField = "DOB" DataFormatString = "{0:MM/dd/yyyy}" />
<asp:BoundField DataField="Charge" HeaderText="Charge"
SortExpression="Charge" />
<asp:BoundField DataField="OfficerInCharge" HeaderText="Officer"
SortExpression="OfficerInCharge" />
<asp:BoundField DataField="PhotoLink" HeaderText="Photo Link"
SortExpression="PhotoLink" />
<asp:BoundField DataField="LocationOfArrest" HeaderText="Location Of Arrest"
SortExpression="LocationOfArrest" />
<asp:BoundField DataField="AdditionalInfo" HeaderText="Additional Info"
SortExpression="AdditionalInfo" />
<asp:BoundField DataField="Zone" HeaderText="Zone" SortExpression="Zone" />
<asp:BoundField DataField="DateOfArrest" HeaderText="Date Of Arrest (mm/dd/yyyy)"
SortExpression="DateOfArrest" DataFormatString="{0:MM/dd/yyyy}" />
<asp:BoundField DataField="DateAdded" HeaderText="Date Added (mm/dd/yyyy)"
SortExpression="DateAdded" DataFormatString="{0:MM/dd/yyyy}" />
</Columns>
<FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
<PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Center" />
<SelectedRowStyle CssClass = "GV_SelectedRow" />
<HeaderStyle CssClass = "GV_Header" />
<AlternatingRowStyle CssClass = "GV_AltRowStyle" />
</asp:GridView>

View 4 Replies


Similar Messages:

Forms Data Controls :: Select - Edit Field Command - Display Table In Label

Dec 12, 2010

i have gridview i added it select command field i want when it is clicked,the id of the table displayed in label and i have update command field but the problem the update can't update the primary key i want when it is clicked update all the record

View 7 Replies

Forms Data Controls :: GridView1 And Run The SQL Command

Mar 7, 2011

I started a C# web project in Visual Web Developer. I dropped a grid view in with designer and connected to my remote SQL database with the designer dialog based wizard. All is well there. I have in my program also a textbox where a user enters a zip code and clicks a button 'search'. When the user clicks search I want to run the SQL command "select * from flat_list where zipcode='userszipcode'". In other words the userszipcode is dynamic and different every time. It is my understanding I should use a SQLDataSource object but I do not know how.

View 1 Replies

Forms Data Controls :: RowDeleting Event Is Not Fired?

May 24, 2010

I have a rowDeleting even on my gridView. When I click Delete link, the Rowdeleting is not fired. I checked my aspx...and I have it there...I dont see any problems there..bu still when I click delete, my page is refreshed without calling RowDeleing event.

View 20 Replies

Forms Data Controls :: ListBox_SelectedIndexChanged Event Not Occurring?

Mar 29, 2010

I have a requirement where I want to change the text of the text fields when ever a new I tem is selected from the list

my code at Interface Layer is as follows

[Code]....

Code at BLL is as follows

[Code]....

At ASP is as follows

[Code]....

I Debugged to check but on selecting a different value from list the event handler is not being called..

View 2 Replies

Forms Data Controls :: Access New Textbox In The RowDeleting Event?

Mar 17, 2011

I manually added a textbox to a cell in my gridview in the RowDataBound event as seen here:

[Code]....

View 7 Replies

Forms Data Controls :: To Find Out The Rowstate Of A Gridview In RowDeleting Event?

Aug 30, 2010

I want to find out the rowstate of a gridview in RowDeleting event. Also I want to disable my delete linkbutton in the gridview when in edit mode.

View 10 Replies

Forms Data Controls :: Select Command In App So Could Execute The Command And Retrive The Data Into A String Variable?

Apr 9, 2010

i'm trying to issue a select command in my app soi could execute the command and retrive the data into a string variable.the problem is that this command is overloaded with DataSourceSelectArgument and i can't figure out what it is.i'm using sql server express and when issue a n insert command for example sq.Insert(); i have no problems.this the command that's holding me:

SqlDataSource sq = new SqlDataSource();
sq.ConnectionString = ConfigurationManager.ConnectionStrings["CustomerDatabaseConnectionString1"].ToString();
sq.SelectCommandType = SqlDataSourceCommandType.Text;
sq.SelectCommand = "SELECT * FROM CustomerTable where customerID = 1";
string result = sq.Select(some overload that's stopping me);

View 5 Replies

Forms Data Controls :: 2008 - How To Retrieve Data From GRIDVIEW1 Using Column SELECT Button

Jul 29, 2010

I am using ASPNET2008 with VB Scripting and not C# Scripting I am encountering new problem.

On the WebFrm1, I just don't know how to write the coding to retrieve the CUSTOMERID data in order to retrieve the details from SQL SERVER table to fill the textbox controls.Here is the decription of the GRIDVIEW column

In the GRIDVIEW1 on the left edge one of the column is SELECT button which let the userclick on it to select the specific CUSTOMERID on the column next to it on the right.

Here are the coding from SOURCE

<asp:ButtonField ButtonType="Button" Text="Select" CommandName="SelectClick" DataTextField="CustomerID" >
</asp:ButtonField>

View 10 Replies

Forms Data Controls :: How To Select A Row In Gridview Without Select Command

Jan 25, 2011

I have gridview. some columns are data, and some are link buttons. now, I need move these link buttons to a hovermenu. this is done. but I got a javascript exception, and it is because if there is no row was selected in gridview, it will pop this.

so, the question is: how can I select a row in gridview without select command? simply by code?

View 3 Replies

Forms Data Controls :: GridView1 Fired Event PageIndexChanging Which Wasn't Handled

Feb 8, 2011

GridView1 fired event PageIndexChanging which wasn't handled

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class View_Project : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["USERNAME"] == null)
{
Response.Redirect("Home.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
fillgrid();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
fillgrid();
}
private void fillgrid()
{
if (TextBox1.Text == "*")
{
SqlCommand cmd;
SqlConnection con = new SqlConnection("Data Source=SUNTECH-812ECD7\SQLEXPRESS;Initial Catalog=suntech;Integrated Security=True;");
cmd = new SqlCommand("Select * from " + DropDownList3.SelectedItem + " where project_name like '" + TextBox1.Text + "'");
con.Open();
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
}
else
{
SqlCommand cmd;
SqlConnection con = new SqlConnection("Data Source=SUNTECH-812ECD7\SQLEXPRESS;Initial Catalog=suntech;Integrated Security=True;");
cmd = new SqlCommand("Select * from " + DropDownList3.SelectedItem + " where project_name like '" + TextBox1.Text + "'");
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
}
}
}

View 4 Replies

Forms Data Controls :: GridView1 On First Page Fired Event PageIndexChanging Which Wasn't Handled

Feb 8, 2011

I am getting this error when click on page no 2 of grid view on first page it is working correctly My source code of grid view is

<asp:GridView ID="GridView1" runat="server" Width="738px" CellPadding="4" ForeColor="#333333" AllowPaging="True" >
<RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
And c# code is
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class Time_keeping_system : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
private void Page_PreInit(object sender, EventArgs e)
{
if (Session["USERNAME"] == null)
{
this.MasterPageFile = "MasterPage.master";
}
else
{
this.MasterPageFile = "MasterPage2.master";
}
}
protected void Calendar1_SelectionChanged(object sender, EventArgs e)
{
//TextBox1.Text = Calendar1.SelectedDate.ToShortDateString();
TextBox1.Text = Calendar1.SelectedDate.ToString("dd/MM/yyyy");
}
protected void Button1_Click(object sender, EventArgs e)
{
if (TextBox1.Text == "*")
{
SqlCommand cmd;
SqlConnection con = new SqlConnection("Data Source=SUNTECH-812ECD7\SQLEXPRESS;Initial Catalog=suntech;Integrated Security=True;");
cmd = new SqlCommand("select ld.username, ld.login_date,ld.login_time,wp.Project_Id,wp.Project_Of,wp.Project_Name,wp.Start_time,wp.end_time, bd.break_for,bd.break_time,bd.break_over_time,l.logout_time from login_details ld inner join working_projects
wp on ld.login_date= wp.Date join break_details bd on ld.login_date = bd.login_date join logout l on bd.login_date= l.logout_date where ld.username ='" + DropDownList1.SelectedValue + "'");
//cmd = new SqlCommand("Select * from " + DropDownList3.SelectedItem + " where project_name like ''" + TextBox1.Text + "''");
//cmd.ExecuteNonQuery();
con.Open();
cmd.Connection = con;
//SqlDataReader reader = cmd.ExecuteReader();
//GridView1.DataSource = reader;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
// reader.Close();
}
else
{
SqlCommand cmd;
SqlConnection con = new SqlConnection("Data Source=SUNTECH-812ECD7\SQLEXPRESS;Initial Catalog=suntech;Integrated Security=True;");
cmd = new SqlCommand("select ld.username, ld.login_date,ld.login_time,wp.Project_Id,wp.Project_Of,wp.Project_Name,wp.Start_time,wp.end_time, bd.break_for,bd.break_time,bd.break_over_time,l.logout_time from login_details ld inner join working_projects
wp on ld.login_date= wp.Date join break_details bd on ld.login_date = bd.login_date join logout l on bd.login_date= l.logout_date where ld.username = '" + DropDownList1.SelectedValue + "' AND ld.login_date = '" + TextBox1.Text + "'");
//cmd = new SqlCommand("Select * from " + DropDownList3.SelectedItem + " where project_name like ''" + TextBox1.Text + "''");
//cmd.ExecuteNonQuery();
con.Open();
cmd.Connection = con;
//SqlDataReader reader = cmd.ExecuteReader();
//GridView1.DataSource = reader;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
// reader.Close();
}
}
protected void TextBox1_TextChanged(object sender, EventArgs e)
{
}
}

View 10 Replies

Forms Data Controls :: Gridview RowDataBound Event Fires On Every Command Event?

Jul 19, 2010

why the gridview RowDataBound event fires during a select command. I only expect it to run when the gridview is being populated with data. Is there some way to stop it from running when the select command is triggered?

View 3 Replies

Forms Data Controls :: How To Edit Command In Datalist

Jun 11, 2010

I have started practicing a little on asp.net c# and I have a very simple problem which i cannot figure out. I have th following datalist code and below the code I have attached a screenshot of how does it look like.

task.aspx code:

[Code]....

task.aspx.cs

[Code]....

[Code]....

View 1 Replies

Forms Data Controls :: Edit Command Is Not Working?

Nov 9, 2010

I have a gridview. Every time i click on the Edit command, it caused the Delete command fired. This gridview works fine on the test site, but it does not work on the live site.

Do you know what causes this issue?

View 5 Replies

Forms Data Controls :: GridView And Html Select - Find The GV Object (getElementByID("GridView1") Returns Null)?

Jul 10, 2010

I have a webpage with a select object and a GridView object. For testing my problem i've created asp button and html button.On pageLoad the GV is empty and select is being filled with names. (GV is not appearing)After choosing a name from the select options, the user should click a button and then the GV need to be filled with relevant info.I am having 2 "related" problems:

1. When clicking on the asp button and getting into the click function on the aspx.cs file, i can't find the select object and retrieve the selected option. How can i get this?

2. When clicking on the html button and getting into the button_click function on the aspx file (javascript), i can't find the GV object (getElementByID("GridView1") returns null). I guess that it's because the GV is not loaded initialy since it's empty.I've tried also using callback methods, but the although it seems like i am reaching the GV and performing DataBind(), the GV table won't show on the page.

View 4 Replies

Forms Data Controls :: GridView Delete Command Fires Error When Using Template Fields Inside

Mar 6, 2011

I have visual 2010 with net 3.5 web app. I was implementing EntityFramework in my project and added a gridview to a entity source control. It worked ok, with select, update, and delete buttons enabled on the grid. But then, i needed to add a template field bound to a Foreign table, so my users select value from a list instead of writing the code. After that, my app fires error when i delete. I tried everything, inclue dakeyNames, write code on my RowDeleting, RowDeleted, RowCommand, but error persists.

Now, i can delete the row, but it then i get the error Object reference not set to an instance of an object If i implemente delete code on RowCommand i get the error: Store update, insert, or delete statement affected an unexpected number of rows (0). Entities may have been modified or deleted since entities were loaded. Refresh ObjectStateManager entries.

View 1 Replies

Forms Data Controls :: How To Get Value From The Edit Mode Form The Gridview Row Command

Mar 3, 2010

to get value from the edit mode form the gridview row command

protected void grdcalib_RowCommand(object sender, GridViewCommandEventArgs e)
{
string prd;
GridViewRow rw= (GridViewRow)(((Button)e.CommandSource).NamingContainer) ;
if (e.CommandName == "Edit")
{
}
else if (e.CommandName == "Update")
{
Label12.Text = (TextBox)rw.FindControl("txteditgoupp").ToString() ;//i got the error

View 2 Replies

Forms Data Controls :: Edit Command Is Not Working In A Nested Listview?

Jan 26, 2011

in the nested ListView (or the child ListView), the edit command does not work.

It seems that the <EditItemTemplate> is not properly excecuted by the edit button in the <ItemTemplate>.

Interestingly, the edit command in the parent ListView works well.

The insert and delete commands in the nested ListView also run without any problem.

But I get no change by pushing the edit button which is located for each reply (the item of the nested listview)

Here is my code.

[code]...

View 6 Replies

Forms Data Controls :: Using Edit Command In Listview And Updating Database

Mar 4, 2010

i am updating data using editcommand by listview.. i got data max 50 depends on customers sometimes it has a few in the database. i am using listview and sqldatasource. when i update using editcommand in listview. it doesnt update relevant rows. it update to all data in database. why.. i have provided datasoure and list view.

<asp:ListView runat="server" ID="photosListView" DataSourceID="SqlDataSource1"
DataKeyNames="PhotoAlbumID" onitemediting="photosListView_ItemEditing" >
<LayoutTemplate>
<asp:PlaceHolder ID="itemPlaceHolder" runat="server"></asp:PlaceHolder>
</LayoutTemplate>
<ItemTemplate>
<div>
<div>
<div>
<asp:Image runat="server" ID="capImage"
ImageUrl="~/AsianaPortals/StudentUnion/Image/PhotoGallery/newadmin/caption.png" />
</div>
<div>
<asp:TextBox runat="server" ID="photodescriptionTextBox" Width="263px" Height="95" TextMode="MultiLine"
Text='<%# Bind("PhotoDescription") %>'/>
</div>.....................................

View 3 Replies

Forms Data Controls :: The GridView "GridView1" Fired Event Sorting Which Wasn't Handled

Mar 23, 2010

I googled and found this post : [URL] I have never had this problem b4. I just started a new job, do i need a service pack update or something?

DataTable dt;
DbCommand cmd = GenericDataAccess.CreateCommand_SP("rptPlannedActivity");
GenericDataAccess.AddParameter(cmd, "@Outstanding", DbType.Int16, 1);
GenericDataAccess.AddParameter(cmd, "@Period", DbType.Int16, 45);
dt = GenericDataAccess.ExecuteSelectCommand(cmd);
GridView1.DataSource = dt ;
GridView1.DataBind();

View 3 Replies

DataSource Controls :: DataAdapter - Issue An INSERT Command Without SELECT Command?

Jan 6, 2010

I want to issue an INSERT command for an SQL Server table using DataAdapter without first issuing a SELECT command. Could anybody send me lines of code to handle this? Also how do i manage INSERT into selective table columns (I have 10 columns but i only want to update 2 of them)?

View 2 Replies

Forms Data Controls :: Gridview Row Selection W/out Using Select Command?

Feb 13, 2010

I have a gridview bound to a dataset and I do not want to display the id column or the select hyperlink. How can I have a user click anywhere in a row and have the application behave as if they clicked the standard select hyperlink. the one or two approaches I have seen on blogs have not been successful for me. maybe I was missing a piece

View 4 Replies

Forms Data Controls :: Cannot Use FindControl For GridView Auto Generate Edit Command Button

Jul 23, 2010

My GridView uses auto generate Edit & Delete command button. And then program the insert button. I want to do something when users click the Edit button so I wrote something like this:

[Code]....

When click the Insert button in the Footer, the program works fine. But when trying to click the auto generate Edit button, the following statement failed with the exception stated in the code above:

first_name = gvAgent.SelectedRow.FindControl("txtEditFName")

View 14 Replies

Forms Data Controls :: GridView With Template Field With Command Name=Select

Nov 18, 2010

[Code]....

This is my Grid view source basically i want as soon as i click on Select Button , the corrsponding Row Data get's redirected to another Page with the Data I know how to redirect to another page with query string only thing is that where and how i can store the data my .cs source

[Code]....

View 5 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved