මචන්ලා .. මට ASP.NET page එකක තියන Datagrid එකක Delete button එකෙන් මම ලියපු Function එකක් call කරන්න ඕන.. කොහොමද ඒක කරන්නේ...
මේක තමයි function එක
<script language="C#" runat="server">
public void DataGrid1_Delete(object sender, System.EventArgs e)
{
string name = Session["UserName"].ToString();
string strConnect = "Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=" + Server.MapPath(".\\db\\forum.mdb");
string strSelectName = "SELECT PostCreateName FROM Postings WHERE TopicID=" + Request.QueryString["ID"] + " ";
string deletequery = "Delete FROM Postings WHERE TopicID=" + Request.QueryString["ID"] + " ";
if (name==strSelectName)
{
OleDbConnection objConnect = new OleDbConnection(strConnect);
objConnect.Open();
OleDbCommand objCommand = new OleDbCommand(deletequery, objConnect);
objCommand.ExecuteNonQuery();
objConnect.Close();
}
}
</script>
මේක datagrid එකේ delete link එක click කලාම call වෙන්න ඕන...
මේක තමයි function එක
<script language="C#" runat="server">
public void DataGrid1_Delete(object sender, System.EventArgs e)
{
string name = Session["UserName"].ToString();
string strConnect = "Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=" + Server.MapPath(".\\db\\forum.mdb");
string strSelectName = "SELECT PostCreateName FROM Postings WHERE TopicID=" + Request.QueryString["ID"] + " ";
string deletequery = "Delete FROM Postings WHERE TopicID=" + Request.QueryString["ID"] + " ";
if (name==strSelectName)
{
OleDbConnection objConnect = new OleDbConnection(strConnect);
objConnect.Open();
OleDbCommand objCommand = new OleDbCommand(deletequery, objConnect);
objCommand.ExecuteNonQuery();
objConnect.Close();
}
}
</script>
මේක datagrid එකේ delete link එක click කලාම call වෙන්න ඕන...