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.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?