public void UpdateKeyword(BALKeyword obj)
{
query = "update Keyword set KeywordName='" + obj.KeywordName + "',CategoryId=" + obj.CategoryId+" where KeywordId="+obj.KeywordId;
SqlCommand cmd = new SqlCommand(query,con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void DeleteKeyword(BALKeyword obj)
{
query = "delete from Keyword where KeywordId=" + obj.KeywordId;
SqlCommand cmd = new SqlCommand(query,con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void InsertKeyword(BALKeyword obj)
{
query = "insert into Keyword(KeywordName,CategoryId) values('" + obj.KeywordName + "'," + obj.CategoryId + ")";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public DataSet SelectKeywordByCategoryID(BALKeyword obj)
{
query = "select * from Keyword k inner join Category c on k.CategoryId=c.CategoryId where k.CategoryId="+obj.CategoryId;
//query="select * from Keyword ";
DataSet ds = new DataSet();
SqlDataAdapter adp = new SqlDataAdapter(query, con);
adp.Fill(ds);
return ds;
}
