Hello friends,
I was trying to write a little application with DataGrid and ‘Delete’ button, quering a authors table from pubs database on SQL Server. An html code looks like:
<%@ Page Language=“C#” AutoEventWireup=“true” CodeFile=“Default.aspx.cs” Inherits=“_Default” %>
There is also C3 code behind it:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
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;
public partial class _Default : System.Web.UI.Page
{
String myConnString = “Server=(LOCAL);Initial Catalog=pubs;User ID=;Password=;Connection Timeout=25;Integrated Security=SSPI”;
SqlConnection myConn;
SqlDataReader myDataReader;
protected void Page_Load(object sender, EventArgs e)
{
ShowDataGrid();
}
public void ShowDataGrid()
{
SqlConnection myConn = new SqlConnection(myConnString);
SqlCommand myCommand = new SqlCommand("SELECT * FROM AUTHORS", myConn);
try
{
myConn.Open();
myDataReader = myCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
sDataBind();
}
finally
{
myConn.Close();
}
}
public void sDataBind()
{
if (!IsPostBack)
DataGrid1.DataSource=myDataReader;
DataGrid1.DataBind();
}
protected void DataGrid1_Delete(object source, DataGridCommandEventArgs E)
{
SqlCommand myCommand;
String SQLQuery;
SqlConnection myConn = new SqlConnection(myConnString);
SQLQuery = "DELETE FROM authors WHERE au_id=" + DataGrid1.DataKeys[E.Item.ItemIndex] + ";";
Response.Write(SQLQuery);
myCommand = new SqlCommand(SQLQuery, myConn);
try
{
myConn.Open();
myCommand.ExecuteNonQuery();
}
finally
{
myConn.Close();
}
ShowDataGrid();
}
}
When I push a ‘Delete’ button I receivea blank page, just nothing. And a record is not deleted.
Please help what a problem there may be?