Exemplos de Dal SqlHelper.ExecuteNonQuery em C# (CSharp)

Exemplo n.º 1

        public static int DeletePoInspectItem(string pi_id)
        {
            string sql = @"delete from [mg_PointInspection_Item] where [ID]=" + pi_id + "";

            return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnString, CommandType.Text, sql, null));
        }

Exemplo n.º 2

Arquivo: mg_FlowLine1DAL.cs Projeto: ElcoTeam/Magna_ZJK

        public static int DeleteFlowLine1(string fl_id)
        {
            string sql = @"delete from [mg_FlowLine] where [fl_id]=" + fl_id + "";

            return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnString, CommandType.Text, sql, null));
        }