Hello I use this code as a stored procedure to delete row of the table:
ALTER PROCEDURE dbo.DeleteRowMaterialTyp
(
@CisloParam varchar(MAX) /* hodnota v tabulke, ktora nam identifikuje riadok, ktory sa ma zmazat */
)
AS
Delete From MaterialTyp Where Cislo = @CisloParam
RETURN
And this is code where I call this procedure:
EtiketyLINQDataContext EtiketyData = new EtiketyLINQDataContext();
string CurrentRowCellParam = LINQdataGridView.CurrentRow.Cells[0].Value.ToString();
EtiketyData.DeleteRowMaterialTyp(CurrentRowCellParam);
It's quite strange to me, because when I execute this DeleteRowMaterialTyp stored procedure, it deletes, also when I use deletion in running application, deletion works again, i can see it on datagridview, but when I come back to the sql environment and manually make selection of the datas, I can see, that nothing has been deleted. Where is the problem? Shall I do something additional between sql database and linq class dbml?