StudentDeletePage.aspx.cs
Dosyayı İndir
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data;
using System.Data.SqlClient;
namespace WebProject
{
public partial class StudentDeletePage : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string studentIdString = Request["StudentId"];
string connectionString = "server=localhost;DataBase=CourseDatabase;uid=sa;pwd=godoro";
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
String sql = "delete from Student where StudentId=" + studentIdString;
SqlCommand command = new SqlCommand(sql, connection);
int affectedRowCount = command.ExecuteNonQuery();
if (affectedRowCount >= 0) {
MessageLabel.Text = "Öğrenci başarıyla silinmiştir";
} else {
MessageLabel.Text = "Öğrenci silerken hata oluştu";
}
connection.Close();
}
protected void CancelButton_Click(object sender, EventArgs e)
{
Response.Redirect("Default.aspx");
}
}
}
Dosyayı İndir