Hi,
In a page i placed a grid called gridview1 and bound it with data from the DB. I bounded the data from DB from the code behind file. Then added an imagebutton in the itemtemplete for deleting a row.The function for deleting the row was done by using C# in the code behind file. How can i call the delete function from the code-behind file to this imagebutton's click event.

My code as follows. But it is not calling the delete function.


<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowDeleting="GridView1_RowDeleting1">
<Columns>
<asp:BoundField DataField="Title_drawings" HeaderText="Title_drawings" SortExpression="Title_drawings" />
<asp:BoundField DataField="Type_drawings" HeaderText="Type_drawings" SortExpression="Type_drawings" />
<asp:BoundField DataField="filename" HeaderText="filename" SortExpression="filename" />
<asp:BoundField DataField="Date_upload" HeaderText="Date_upload" SortExpression="Date_upload" />
<asp:BoundField DataField="Comments" HeaderText="Comments" SortExpression="Comments" />
<asp:TemplateField>
<ItemTemplate>
<asp:ImageButton ID="deleterow" runat="server" CommandName="Delete" ImageUrl="delete1.gif"/>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>

Code-behind file

public partial class _Default : System.Web.UI.Page
{
SqlConnection sqlcon = new SqlConnection("Data Source=SYSTEM-3\\SQLEXPRESS;Initial Catalog=project_mgt;Integrated Security=True");
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand();


public void display()
{
ds.Dispose();
ds.Clear();
SqlParameter[] @param = new SqlParameter[1];
@param[0] = new SqlParameter("@PID", "1");
SqlDataAdapter sqladapter = new SqlDataAdapter("select title_drawings,type_drawings,filename,Date_upload, comments from drawing_details where Project_ID=@PID", sqlcon);
for (int i = 0; i <= param.Length - 1; i++)
{
sqladapter.SelectCommand.Parameters.Add(@param[i]);
}
if (param.Length >= 1)
{
sqladapter.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
else
GridView1.Dispose();
}


protected void Page_Load(object sender, EventArgs e)
{

display();

}


protected void GridView1_RowDeleting1(object sender, GridViewDeleteEventArgs e)
{
string s = GridView1.Rows[e.RowIndex].Cells[1].Text;
cmd.CommandText = "delete from drawing_details where Title_drawings='" + s + "'";
cmd.Connection = sqlcon;
sqlcon.Open();
cmd.ExecuteNonQuery();
sqlcon.Close();
}
}

__________________
--Kirubhaa. Born to win--

My problem is, i want an icon to be displayed on each and every row of the grid.
While clicking this icon the row must want to be deleted.

__________________
--Kirubhaa. Born to win--

Hi Kirubha,

I have attached the sample website that contains the datagrid and you can edit and delete the row using this sample.

Hope this helps....

Attached Files

datagrid.zip (3.3 KB, 5 views)

__________________
S.Balasubramanian
Nothing is impossible

But i want a picture in the place of the command "Delete".

__________________
--Kirubhaa. Born to win--

I already have this code for deleting. But while using the imagebutton, it is not working. I want an image in the palce of the "Delete" command.

__________________
--Kirubhaa. Born to win--

Hi Kirubha,

Use imagebutton instead of using Button.

<asp:ImageButton id="ImageButton1" runat="server"
ImageUrl="url" />

__________________
S.Balasubramanian
Nothing is impossible

Thank you balu,
I did it.

__________________
--Kirubhaa. Born to win--